Dreamweaver MySQL Connection
Posted 03 September 2004 - 05:29 PM
i was following the dreamweaver tutorial for php but i just can't get the connection working.
i've read every help i could find but nothing helps.
Dreamweaver MX 2004
Posted 09 September 2004 - 01:10 PM
In your testing server window in the site setup, make sure that you have simply http://www.yoursite.com as dreamweaver puts in something like http://ftp.yoursite.com/web or whatever your directory is (htdocs, www etc)
This one drove me mad for a while
Posted 09 September 2004 - 06:18 PM
Posted 09 November 2004 - 08:23 AM
I found this solution:
1) When I installed php, I downloaded the "Windows Installer" package. That actually didn't come with support for MySQL (oh, this took some time to figure allright ...)
2) What I needed was the files php_mysql.dll and libmysql.dll.
3) I downloaded the full php package, and copied out the dll files to \winnt\system32.
4) Uncomment the line extension=php_mysql.dll in php.ini.
5) Voilá, the test connection worked.
Posted 26 November 2004 - 02:19 AM
When i tried to connect from another computer in the local network to PHP, it works normally, it gave some troubles with ASP pages, but nothing to became crazy, it just change my MS Access databases permission. Well, now i can connect to PHP, but it wont let me connect to MySQL database. I can connect MySQl from ASP pages with MyODBC without problems, but my boss want to migrate his web page to PHP, any suggests???
Please, i have lost many brain cell with this!!!!!!!!!
Posted 10 January 2005 - 05:39 AM
i have the sample problem too
I read and read many forum and tried out varies suggestions and none of them work.
I am thinking may be design the php page with dmx and hand code the connection bit.
Posted 12 January 2005 - 05:28 AM
I use WAMP package and it works for me...
connect up straight away
Posted 04 February 2005 - 03:28 PM
1) In Dreamweaver, go to Sites/Manage Sites/Advanced, in “Testing Server,” be sure to configure URL prefix: http://localhost/ .... See Check the URL Prefix in the Site Definition at Macromedia.com. (Note that the URL prefix does not always need to point to http://localhost/. Right now, we are just using localhost as the troubleshooting web site. The important thing is for “URL prefix” to point to the document root address of whichever testing web site you are connecting to.)
2) Make sure that the MySql extension is activated in php.ini. Take the ; off the left side of the line in order to activate: extension=php_mysql.dll
3) Make sure that extension_dir = “c:\php\ext” is activated in php.ini, and that it points to the correct directory where php_mysql.dll is located.
For PHP5: extension_dir = “c:\php\ext”
For PHP4: extension_dir = “c:\php" Use this if you followed PHP4 installation instructions and copied all the extensions from c:\php\extensions to c:\php.
4) Make sure that PHP is working in Apache server. Does browsing to your http://localhost/phpinfo.php page display PHP graphics and data?
BLANK PAGES AND ERROR CODES IN DREAMWEAVER
The Dreamweaver Tutorial has you create PHP code on two pages: comments-view.php and comments-add.php. The problem is that after you complete the tutorial instructions, both pages display as blank pages in your Internet browser.
If you’re working on those pages in Dreamweaver, when you click on “Live Data View” you get the following error code:
The testing server did not execute any of the scripts in your document. Possible explanations include:
1) The testing server is not running.
2) The testing server ignores files with the ".php" file extension.
3) Your document does not contain any scripts.
This is caused by a parsing problem in PHP, i.e the PHP code hangs up and your Apache server gives you a blank page. The solution is to make a change in the php.ini file. Change short_open_tag = on to make it read: short_open_tag = off
Good luck. I hope this helps.
Posted 28 June 2005 - 03:35 PM
dreamweaver create a connection : here is the file:
$hostname_dbconnection = "localhost";
$database_dbconnection = "name_database";
$username_dbconnection = "user";
$password_dbconnection = "password";
$dbconnection = mysql_pconnect($hostname_dbconnection, $username_dbconnection, $password_dbconnection) or trigger_error(mysql_error(),E_USER_ERROR);
can you help me? I also modified the php.eni :
extension_dir = “d:\php\ext”
thanks, i'm getting crazy.....
Posted 21 July 2005 - 01:59 PM
I’ve found a solution for this problem
When you want to connect to your database be shore you are online.
In Internet explorer go to file menu and unchecked work offline.
When my Internet explorer is in offline mode I receive "An unidentified error has occured"
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users