Posted by Jerry Stuckle on 05/07/07 22:14

christopher_board@yahoo.co.uk wrote:
> On 7 May, 21:11, ZeldorBlat <zeldorb...@gmail.com> wrote:
>> On May 7, 3:59 pm, christopher_bo...@yahoo.co.uk wrote:
>>
>>
>>
>>
>>
>>> Hi all. I am trying to connect to a MySQL Database using PHP on a
>>> local machine using locahost. I am using the following code
>>> <?php
>>> $dbhost = 'localhost';
>>> $dbuser = 'root';
>>> $dbpass = 'password';
>>> $conn = mysql_connect($dbhost, $dbuser, $dbpass) or
>>> die ('Error connecting to mysql');
>>> $dbname = 'pmoneytest';
>>> mysql_select_db($dbname);
>>> ?>
>>> When I view the page it then comes up with an error that says
>>> PHP Fatal error: Call to undefined function mysql_connect() in C:
>>> \Inetpub\wwwroot\PHPTest\connection.php on line 6. I can't see what
>>> the problem is as I got the code from the Internet and it seems to be
>>> the same on all the different website that I look at.
>>> Thanks very much for your help and I look forward to hearing from you
>>> in the near future.
>> Make sure that you've enabled the MySQL extension in php.ini. You can
>> check this by running the following script and examining the output:
>>
>> <?php
>> phpinfo();
>> ?>- Hide quoted text -
>>
>> - Show quoted text -
>
> Hi. I have checked the phpinfo(); and MySQL seems to be ok as it is
> pointing to where the server is installed. But the internet page still
> doesn't work. Is there anything else that I can try.
>

Christopher,

Does phpinfo() have a mysql section? It will have items like:

Active Persistent Links 0
Active Links 0
Client API version 5.0.32
MYSQL_MODULE_TYPE external

and so on.

Your symptom is indicates that the mysql extension is not loaded in php.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]