|
|
Posted by David on 07/07/06 21:43
On Fri, 07 Jul 2006 18:02:00 +0100, Joaquim Amado Lopes
<jal-2005@jalopes.net.> wrote:
>Greetings.
>
>On Fri, 07 Jul 2006 10:40:53 +0200, David <dgold1958@yahoo.de> wrote:
>[snip]
>> Can you connect to the MySQL server from the command line, since you
>>installed the updated software? There should be an extra icon on your
>>desktop for this called "MySQL Command Line Client." You will
>>automatically be prompted for the password that you assigned to root
>>when you installed MySQL 5.x.
>>
>I can connect to MySQL using the Command LIne CLient, MySQL
>Administrator or Query Browser.
>
>[snip]
>>Also, the URL for the error messages is:
>>http://dev.mysql.com/doc/refman/5.0/en/error-messages-client.html.
>>
>The problem seems to be with PHP, not MySQL.
>
>The error message is ""cannot load MySQL extension, please check PHP
>Configuration". It seems is can't find the DLL files.
>
>Is there something I should check in the PHP config file?
>Files that need to be placed in certain directories?
In your /php/ext directory there should be a file: php_mysqlidll.
You need to modify your php.ini file. Look for the line that has:
extension=php_mysql.dll
Make sure that it is uncommented (no semicolon) and change it to
read:
extension=php_mysqli.dll
note: the change is adding an "i" to the mysql portion
Restart your apache server. I don't know where you keep the php.ini
file. Make sure it is in c:\windows.
>I appreciate your help as I'm to start a new project and can't do it
>without MySQL.
Note that the mysqli functions are slightly different than the
mysqli functions. Instead of "echo mysql_query()", for example, you
would use "echo mysqli_query()". Also, some things are backwards from
mysql--mysqli_db_connect($link,$database) instead of
mysql_db_connect($database,$link).
>Thank you,
>Joaquim Amado Lopes
David
Navigation:
[Reply to this message]
|