[Contribution] MySQLi Extension for OsC 2.X

[Parikesit]

Native MySQL extension is slightly faster than the improved MySQLi extension, but the latest more stable and have more features.

 

This addon simply replicate the default database function, so you don't have to worry that you need to edit many files. The installation process as easy as uploading a file (database_mysqli.php) and edit one line in application.top.php.

 

As a bonus, this addon add new tep_db_multi_query function (see: mysqli.multi-query.php), so now you can make multi query in one call.

 

Sample of using "tep_db_multi_query" can be found in the archive.

 

Download it here: http://addons.oscommerce.com/info/8168

 

Best,

@zaenal

[Parikesit]

Maybe, this can be a reason to make the choice:

 

The Plot to Kill PHP MySQL Extension

Author: Manuel Lemos

Posted on: 2011-07-15

Categories: PHP community, PHP opinions

 

"PHP core developers are planning to kill the PHP original MySQL extension."

 

If you are using MySQL in your PHP applications for a long time, this may seriously affect you.

 

Read this article to learn what this means in practice and what you can do about it.

Edited September 30, 2011 by Parikesit

[Guest]

Hi Parikesit,

 

This works fine for the catalog, but fails for the admin for some reason when I have tried it, (version 2.31). Any ideas?

 

Regards,

 

Ian

[Guest]

Hi Parikesit,

 

I found that by changing the last line in admin/includes/configure.php file from: define('STORE_SESSIONS', 'mysql');

 

to: define('STORE_SESSIONS', 'mysqli');

 

then this works. Hope this helps.

 

Regards,

 

Ian