|
|
Posted by Jerry Stuckle on 05/09/07 22:49
christopher_board@yahoo.co.uk wrote:
> On 7 May, 23:38, Daniele <"dankan775{["@]}yahoo.it> wrote:
>> christopher_bo...@yahoo.co.uk wrote:
>>> On 7 May, 23:14, Jerry Stuckle <jstuck...@attglobal.net> wrote:
>>>> christopher_bo...@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.
>>>> jstuck...@attglobal.net
>>>> ==================- Hide quoted text -
>>>> - Show quoted text -
>>> Hi. There isn't actually heading called MySQL but it does have Active
>>> Persistent Links 0. The things that you mentioned are not
>>> shown in phpinfo();.
>>> Thanks very much for your help in this matter
>> Check the php.ini( find path with phpinfo()
>> find and replace for php_mysql.dll
>> make sure it is enable
>>
>> example:
>> with ";" in front of the extention is disable
>> ;extension=php_msql.dll ( disable)
>> extension=php_mysql.dll ( enable )
>>
>> hope it work- Hide quoted text -
>>
>> - Show quoted text -
>
> Hi. I have enabled extension=php_mysql.dll and when I go onto
> phpinfo(); it then comes up with an error that says
>
> PHP Warning: PHP Startup: Unable to load dynamic library './
> php_msql.dll' - The specified module could not be found. in Unknown on
> line 0 PHP Warning: PHP Startup: Unable to load dynamic library './
> php_mysql.dll' - The specified module could not be found. in Unknown
> on line 0.
>
> What can I try now
>
Do you have the libmysql.dll installed in a directory in your PATH
statement?
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|