Can not connect to MySql with PHP in Dreamweaver

i have no idea as to why the following change would have made this work, but all of the above that you mentioned were already done. the only other thing i ended up uncommenting in the windows extentions was mssql.dll, and after that it worked. i know i know...microsoft sql extensions should have nothing to do with mysql extensions, so go figure. at least it worked finally and i was able to test my code before moving it up to our production server. thanks for the help.

slw13 wrote:
> C:/php/php.ini
>
> that is where i have php installed and where the file is.

Good. That means that Windows is reading the correct configuration file.

In php.ini make sure that the value of extension_dir is set to this:

extension_dir = "C:\php\ext\"

In the Windows Extensions section, remove the semicolon from the
beginning of these lines:

;extension=php_mbstring.dll
;extension=php_mysql.dll

Add another line to the list like this:

extension=php_mysqli.dll

Save php.ini and restart your webserver. If you run phpinfo(), mysql and
mysqli should now appear in the list of extensions in the lower half of
the page.

--
David Powers
Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
http://foundationphp.com/

C:/php/php.ini

that is where i have php installed and where the file is.

Bongo_Bob wrote:
> I am working through the Training from the source Dreamweaver 8 with ASP,
> ColdFusion and PHP book and when I try to setup the database connection it
> fails with an erro that says "Your PHP server doesn't have the MySql module
> loaded or you can't use the mysql_(p)connect functions".

Pity you didn't use my book instead - it tells you what to do. Still,
I'm a nice guy, so...

You need to enable the MySQL and MySQLI extensions in PHP. Open php.ini,
and search for the section marked Windows extensions. Remove the
semicolon from the beginning of these lines:

;extension=php_mbstring.dll
;extension=php_mysql.dll

Add another line like this:

extension=php_mysqli.dll

Also make sure that the extension_dir setting in php.ini points to the
ext subfolder of your PHP folder. I have installed PHP in C:\php5, so
the setting looks like this:

extension_dir = "C:\php5\ext"

Save php.ini and restart Apache. Run phpinfo(), and check that mysql and
mysqli are listed in the PHP configuration (they're quite a long way down).

--
David Powers
Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
http://foundationphp.com/