Dreamweaver, PHP, MySQL, and Apache Web server
 

Has anyone ever used Dreamweaver along with PHP on an apache web server? I am having problems setting up a site and wondered if anyone encountered any problems.
I get an "unidentified error has occurred" when trying to connect to a MySQL database using PHP. I would greatly appreciate any help.

Yes i've done it.

Redhat 8
Apache 1.3
Php 4
Mysql 3.23.55

And using samba so i can map a windows drive DW will connect to !!!!!!

Yell if you have any more problems, don't know how far you've got.

I've gotten that far. I have mysql, apache, and PHP running. I did the <phpinfo?> tag to verify it's working and it does. It's when I try to connect to the database with DWMX that I get the unidentified error. I have searched Macromedias site and found a lot of complaints about the issue but no resolution. Please help me get this up. I am about ready to bash my machine into tiny little bits. Thanks for your time.

I'll look at my site settings when i get home, i'm at work at the moment, i work as tech support at a Uni.

Will post a reply tonight !!! :)

Edit :

UK Time !! lol

Great, thanks for the help.

After creating the page in Dreamweaver what does the php code that deals with connecting to the database look like? Unidentified errors are not much to go on but if you say it can not connect to the database then their is probably something wrong with that section of your php code.

I know unidentified error isn't much to go on, that's why people are really complaining on the Macromedia site. I can't get to the scripts right now, but I will get them to you tonight (US, EST). In any case, the macomedia article is http://www.macromedia.com/support/dreamweaver/ts/documents/unidentified_error_mysql.htm . I tried everything there and it doesn't work. I hope this gives you some background. I am about ready to throw my machine through the wall this is so fusterating. I have literally spent hours on this. I really appreiciate your help.

If you are accessing a mysql server from offsite, make sure you have granted access permissions in mysql to allow that. Most installs of mysql by default limit access to localhost.

PHP connection code
 

<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_adebook = "merlin";
$database_adebook = "adebook";
$username_adebook = "adeweb";
$password_adebook = "******";
$adebook = mysql_pconnect($hostname_adebook, $username_adebook, $password_adebook) or die(mysql_error());
?>

Thats the include file i used to connect, password hashed out for security reasons

Hey, thanks man, I'll give it a try. I had to upgrade due to a problem on my Linux server. Apparently there is a bug in Redhat. I will try your code though and see if it works. I apreciate it!

Dunno bout that m8, im on redhat 8 here as well, and it all works.

PS, you did give your machine access to mysql did'nt you??

yes I did. It seems to be Macromedia. I used Namo Web Editor and it connects. Namo is only a trial I downloaded to see what the problem was, I need to use Macromedia.
Once again thanks for your help. If you find out anything else let me know.

Ok sorry bout the delay, have had flu over here and it kicked me in the ass for a while.


I looked at my setup and assuming your mysql and php are working, and that your machine has access (have you used a graphical client like mysqlfront and checked????). I'm assuming you have but being thourough. I next went into dreamweaver and did the following to connect :

1) Define a site, this comprises the following :

Name it

Choose php and mysql as a server technology

Next set up your paths, mine point to w: which is a mapped drive to the redhat box with the html and apache on.

Next it asks how to connect, i do local lan and then point to w: again (w: for web lmao).

For the url i give it http://redhatserver/

I dont enable check in / out, but thats preference.

2) In DW XP (Important, allthough i've used 4 these instructions were for my XP setup) get the application tab up on the right, and then go to bindings, click the + button !!!

Choose recordset, and then follow these settings :

Name : Anything you want

Connection : Hot define and then fill in your details as follows :

name : name of your connection (anything)
mysqlserver : name of your server ie fred, or redhat
username : user with % access in mysql
password : obvious !!! see above user details
database : name of previously setup db

click ok

where it now said connection you should set it to the one you just setup above.

you should now be able to select a table from a dropdown list

this is now your connection working !!! or should be.


Your db, db user and tables MUST be presetup, DW-XP will not do this for you as far as i know..


Hope this helps more, let me know how you go on, this is turning into a vendetta now lol, i remember how i started, frustrated the hell outta me for ages hehhehe


Ade

Hey thanks for getting back.

I am using MySQLCC and can connect just fine. I have hard coded several PHP pages and haven't had any issues. I have recently downloaded Mambo Portal Server and I am running that with no problems. It seems to be Dreamweaver. I didyour setup as well. few changes :

I am using the I.P address for the MySQl server

I have used the %, localhost and I.P for the login ID (i.e. user@%, user@localhost, user@162.24.1.12 'my I.P')

My setup is pretty simple. I have a drived mapped to the server from my widws client. My remote site and test server are the same thing. My local site is on my HD.

Once again thanks for the help.

what do you mean by presetup?