Your PHP server doesn't have the MySQL module loaded or you can't use the mysql_(p)connect functions.

[AS9797]

I've just started using Dreamweaver and PHP and MySQL and i was following the article "Setting up a PHP development environment for Dreamweaver" and everything was going fine...just according to the writer, but in the end when i tried to connect the database in dreamweaver, it gave this error

"Your PHP server doesn't have the MySQL module loaded or you can't use the mysql_(p)connect functions."

ive tried to solve this problem by many ways but its not getting solved. kindly help me!!

[Newsgroup_User]

> I've just started using Dreamweaver and PHP and MySQL and i was following
> the
> article "Setting up a PHP development environment for Dreamweaver" and
> everything was going fine...just according to the writer, but in the end
> when i
> tried to connect the database in dreamweaver, it gave this error

Sounds like MySQL wasn't installed. The easiest way to install MySQL,
PHP and a web server is through WampServer
http://www.wampserver.com/en/index.php - installs everything you need.

[AS9797]

mysql is installed and is working. but the dreamweaver environment is giving this same error...dont know what to do!

[Newsgroup_User]

AS9797 escreveu:
> mysql is installed and is working. but the dreamweaver environment is giving this same error...dont know what to do!
----------
Execute the phpinfo() and verify if the extension mysql is activated.
If not, you must active it in your php.ini.
----
zerof

[AS9797]

phpinfo() is running fine. i checked the extension in php.ini and found that ";" was already removed.

whats next?

[Newsgroup_User]

AS9797 wrote:
> I've just started using Dreamweaver and PHP and MySQL and i was following the
> article "Setting up a PHP development environment for Dreamweaver" and
> everything was going fine...just according to the writer, but in the end when i
> tried to connect the database in dreamweaver, it gave this error
>
> "Your PHP server doesn't have the MySQL module loaded or you can't use the
> mysql_(p)connect functions."
>
> ive tried to solve this problem by many ways but its not getting solved.
> kindly help me!!
>
>
>
You may have earlier version of PHP, should be at least v4,
Try changing "mysql_pconnect" to "mysql_connect" in your connection script.

Mick

[AS9797]

the php version is 5.2.5 and the connection script has this line only

if (!function_exists('mysql_connect') || !function_exists('mysql_pconnect')

but it doesnt make any difference i guess!!

[Newsgroup_User]

AS9797 wrote:
> phpinfo() is running fine.

Yes, but is mysql listed among the extensions supported? It should be
roughly halfway down the page. Also check the value of Loaded
Configuration File (the seventh item from the top of the page generated
by phpinfo()). Does it point to the version of php.ini that you have
been checking?

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

[AS9797]

should i chk for the extensions supported in the php.ini file or the phpinfo page?

also loaded configuration file is listed as none in the phpinfo page... should i change it in php.ini?

[Newsgroup_User]

AS9797 wrote:
> should i chk for the extensions supported in the php.ini file or the phpinfo page?

What you see when you run phpinfo() tells you exactly how your server is
configured. What you see in php.ini tells you how you would *like* the
server to be configured. However, you can have every extension under the
sun enabled, but it won't make the slightest difference if your computer
fails to read php.ini when the web server starts up.

> also loaded configuration file is listed as none in the phpinfo page... should i change it in php.ini?

Loaded configuration file tells you that php.ini is *not* being read by
the computer. So you can change php.ini until you're blue in the face,
but it won't make any difference.

You don't say how you installed PHP, but it's obvious that the computer
can't find php.ini. That usually means that the PHP folder isn't in your
computer path. If you are using Windows, I suggest that you uninstall
your existing version of PHP, and follow the instructions here:

http://foundationphp.com/tutorials/php_installer.php

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

[KilltRoyWasHere]

Dreamweaver does not support mySQLi "i" or pdo_mysql you get that error when trying to connect to the DB when the version is :i:.... so you cannot use Dreamweaver with  mySQLi... natively but you can use and extension. I found DMX makes one that you can use with the modern PHP7 and mySQLi versions....

Here is the link to the extension: https://www.dmxzone.com/go/22072/dmxzone-database-connector-php