PHP 5 (new) install doesnt connect to MySQL

phpnQQb

I'm having a perplexing situation.

To start off,

MySQL Version:

MySQL User:

PHP Version:

Connection Problem:

PHP Code with error:

It seems that PHP isn't connecting to MySQL. It's probably as simple as just a switch or setting. I'm new at this and just installed PHP. I know that the MySQL installation is good since our programmer is using .asp and has been using MySQL for about 2 months with no problems.

Any clue as to what I am doing wrong?

banzaimonkey

PHP5 does not include out-of-the-box integration with MySQL for some reason or another. You'll have to custom-install the PHP-MySQL module during installation, or set it up manually.

If you've installed the PHP manual (accessible from the Start Menu, if you have), you should be able to find the relevant installation information by going to Function Reference > MySQL Functions, and then reading the installation instructions for your platform (Windows).

Otherwise you can re-install PHP (technically you can "Change" your current installation) and include the MySQL extension during installation.

Roger_Ramjet

It does not include mysql functions because it has PDO which is preferable to the old mysql_connect etc. PDO is built-in from php 5.1 so is already available to you without re-install or re-configure. Might just as well go with it.

banzaimonkey

Ahh, that's good to know. In my case, however, my webhost is running PHP 4.4 (even though I develop in 5), so would those functions not be available to me. Older PHP software might want to use the older functions too, correct?

Roger_Ramjet

No, not before 5.0 because it needs core ver 5 features. Just have to install the mysql functions. That kind of thing is why I prefer to develop directly on the target system - even when it is same ver if you are hosted then no telling what little code breakers they have chosen to implement or omit.

rlee923

removed