Migrate DB code from MySQL to MySQL*i* or PDO - Githubissues

open-classifieds / OpenClassifieds

OLD REPO! DO not clone/Download. Only here for historical reasons. Version 1.X

https://yclas.com

12 stars 7 forks source link

Migrate DB code from MySQL to MySQLi or PDO #23

Open emanwebdev opened 11 years ago

emanwebdev commented 11 years ago

As the MySQL extension is now being deprecated

The MySqli extension is now widely available on virtually all hosts

On the othersite, it's recommended to 'skip the middle man' so to speak and migrate from the MySQL extension to PDO rather than to MySQLi

Read "Choosing an API" for a Feature Comparison chart http://www.php.net/manual/en/mysqlinfo.api.choosing.php

Overall benefits for OC:

Prepared Statements to sanitize users' inputs
Multiple Statements (PDO API only)
Transactions

It looks than for SELECT as used in OC, MySQLi is slighty faster than PDO

http://wooptoo.com/blog/pdo-vs-mysqli-performance-comparison/ http://jnrbsn.com/2010/06/mysqli-vs-pdo-benchmarks http://we-love-php.blogspot.ch/2012/07/mysql-or-mysqli-or-pdo.html http://we-love-php.blogspot.ch/2012/08/mysqli-prepared-statements.html

neo22s commented 11 years ago

We will use the ORM from kohana so we should not worry :dancer: