id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc
90,MySQL 5+ issue: mysql_* vs. mysqli_*,dartar,unassigned,"MySQL 5+ isn't supported as it requires PHP to use the mysqli extension instead of plain old mysql. I hoped there would be a single file to change this, but there seems to be no database abstraction in this project at all.

-- DavidCarrington

I do not have access to a MySQL 5 server for testing. And judging by the feedback that I see here on Wikka, most other Wikka admins are using older versions of MySQL.  However, I do like progress, so I looked at the documentation for the mysqli extension.  I don't see any major issue here.  It looks like the function calls are the same, they just have a different name.  Instead of calling mysql_connect, you call mysqli_connect.  Instead of calling mysql_query, you call mysqli_query.  So on and so forth.

It seems that we would just have to do a simple version check and call ""mysql"" functions for older versions, and ""mysqli"" functions for newer versions.
Please correct me if I'm missing something.  -- JsnX 26 Nov 2004

I'm running MySQL 5 fine with the mysql_* functions.  When you compile PHP, it's your choice to compile the mysql_* or mysqli_* functions.  I chose to compile it with mysql_*, which is working fine for me.  --BarkerJr

Related tickets: #171
",defect,closed,normal,1.3.3,core,1.1.6.1,normal,invalid,database,