MySQL & PHP problem

[Odie]

I have decided to try my hand at web design for no other reason than to be able to do it.

I’m using Dreamweaver CS3, IIS, MySQL server 5 and PHP 5.2.55. My testing server is localhost. All the above is new to me so I’m learning as I go along. First I had another version of MySQL installed and it worked OK but now when I want to work with a database I created earlier, I get an error from Dreamweaver “Your PHP server doesn’t have the MySQL module loaded or you can’t use the mysql_p()connect function.”

Can somebody please talk me through this.

[Odie]

Come on guys, there must be somebody who can help me with this.

[Raymond]

Sorry Odie. I have no experience with Dreamweaver. I use Frontpage (I sound so lame) :P

[Odie]

Thanks Ray but I think the problem is between MySQL and PHP.

[Raymond]

Are you using WOS portable?
http://www.raymond.cc/blog/archives/2008/01/17/portable-local-webserver-with-apache-sql-php-and-applications-for-windows/

[Odie]

I tried WOS when you discussed it on the blog but I could not get Apache to start. I then downloaded USB Webserver. As it was at the very beginning of my attempt to learn this, I was a bit overwhelmed by Apache, PHP, MySQL and the like so I thought in order to make it a bit simpler for myself to create a testing server with IIS. I was so involved with everything that I never even thought about using the USB sever again, until you mentioned it now.

Anyway, at least now I have an idea on how to work with PHPMyAdmin in order to create a database so I have re-installed USB Webserver and will take it from the beginning and see how it goes.

OK the USB Webserver is up and PHP, Apache & MySQL is running. I have created a database called MyData on the server and a page Test.php. The test page loads fine in my browser BUT ...

When I try to create a connection between the page and the database Dreamweaver gives me this error:

"A server timeout has occured. Here are the possible reasons.
1. Please make sure that the web server is up and running.
2. Please verify that the ODBC DSN exists on the testing server."

Where do I go wrong?

[Raymond]

Can you tell me what the are the information that you use to connect? Like the IP address, username, password and etc..

[bernard]

I have decided to try my hand at web design for no other reason than to be able to do it.

I’m using Dreamweaver CS3, IIS, MySQL server 5 and PHP 5.2.55. My testing server is localhost. All the above is new to me so I’m learning as I go along. First I had another version of MySQL installed and it worked OK but now when I want to work with a database I created earlier, I get an error from Dreamweaver “Your PHP server doesn’t have the MySQL module loaded or you can’t use the mysql_p()connect function.”

Can somebody please talk me through this.

it appers that your mysql extension is disabled, try to enable it on php.ini file
you can locate your php.ini by looking on the php configuration page.

here is how to create / show php configuration.
create a file eg: info.php
then write this code :

<?php
    phpinfo();
?>

put this file in your document root and direct your browser to this file (eg : http://localhost/info.php)

[Odie]

Hi Ray

IP - 127.0.0.1:8080
user - root
Password - usbw

bernard

The settings for MySQL in PHP.ini is:

mysql.allow_persistent = On
mysql.max_links = -1
mysql.default_port = {mysqlp}
mysql.connect_timeout = 60
mysql.trace_mode = Off

EUREKA !!!!

MySQL connects on 3307 and not on 8080 :D

Thanks guys

[mumbaki21]

Hey Odie guy, why not try to use XAMMP, its free to use and less the hassle of installing three different sofwares attentively... I've been using it for years and it doesn't failed any of my requirements.