Page 1 of 1

MySQL Client API version 4.0.25 in PHP

Posted: Tue Nov 01, 2005 11:48 pm
by stgma
Hello

I have winXP Pro and run Apache/1.3.27 (Win32) PHP/4.4.0
I've installed MySQL 4.0.26-nt but when I do phpinfo() it gives me that PHP sees MySQL 3.23.49 Client API version. Is there a way to make it see MySQL 4.x.xx?
I've read that in linux you can recompile PHP with the 4.x.xx MySQL driver. Is there a solution for Windows? (I do not wish to switch to php5)


thanks

Posted: Wed Nov 02, 2005 12:19 am
by RobertGonzalez
It will see all MySQL versions up to 5 with that your current API Client version. If the issue you are having is related to new password encryption in MySQL 4.1+ then search the MySQL web site for NEW_PASSWORD and OLD_PASSWORD use in setting up users and passwords.

Posted: Wed Nov 02, 2005 12:23 am
by stgma
thanks for your info. So does the client API play any role on the set of mysql_ functions I have from PHP? Or is it the case that PHP will handle MySQL better ('better' is just an assumption.. I'm guessing here) than with previous MySQL client APIs?

Posted: Wed Nov 02, 2005 7:45 am
by RobertGonzalez
That client API is the standard API that packs with PHP. When you are looking at the mysql functions to use you might want to look at using mysqli functions. This requires that your PHP version supports or contains the MySQLi library (not the same as the API).

Browse the PHP manual for more information on MySQLi or MySQL functions.