Friday, November 04, 2005

Compiling PHP 5 with mysql and mysqli

This blog post has moved. Please find it at:


Andrew Gilfrin said...

Hi Markus,

I was asked, in response to my blog, if you actually have to use MySQLi with 5.0. The suggestion was that you could run it against the standard mysql functions. I'm sure I read that this was not possible and certainly not when trying to use call to access a stored procedure.

Do you know if it's possible to connect to MySQL 5.0 with the PHP mysql functions only?

I might test this over the weekend on my windows box.

Markus Popp said...

Hi Andrew,

it is actually possible to connect to MySQL 5.0 using the mysql functions. It's only necessary to set the user passwords with the old_password option. db4free does that, so it shouldn't be a problem to connect to a db4free database without MySQLi.

But as you have expected, stored procedures are very limited. As far as I know, it's not possible to retrieve a result set from a stored procedure. However, it might be possible to do modifications of the data inside a stored procedure that's called with the mysql functions, but I'm not absolutely sure about that.

So it is possible to use MySQL 5 without MySQLi, but unfortunately only with some limitations.

See you,