View Single Post
  #5  
Old 08-23-2007, 12:00 PM
 
intel352 intel352 is offline
 

X-Wizard
  
Join Date: Dec 2005
Posts: 1,071
 

Default Re: Converted X-Cart 4.1.18 to use mysqli instead of mysql

Actually, performance varies based upon various conditions. Typically mysqli seems to perform about the same as mysql, but if you use Prepared Statements, you don't have to escape values, and there is a definite speed increase in MySQLi over MySQL

Additionally, MySQLi only auto-escapes strings used in a Prepared Statement. You still need to use mysqli_real_escape_string to sanitize your data otherwise:
http://www.php.net/manual/en/function.mysqli-real-escape-string.php
__________________
-Jon Langevin
WARNING: Unethical developer - NOT RECOMMENDED
See details here
Reply With Quote