Jump to content
Latest News: (loading..)
Sign in to follow this  
Parikesit

[Contribution] MySQLi Extension for OsC 2.X

Recommended Posts

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

Share this post


Link to post
Share on other sites

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 by Parikesit

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×