MySQL Client API version 4.0.25 in PHP

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
stgma
Forum Newbie
Posts: 2
Joined: Tue Nov 01, 2005 11:44 pm

MySQL Client API version 4.0.25 in PHP

Post 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
Last edited by stgma on Wed Nov 02, 2005 12:21 am, edited 1 time in total.
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post 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.
stgma
Forum Newbie
Posts: 2
Joined: Tue Nov 01, 2005 11:44 pm

Post 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?
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post 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.
Post Reply