noverkill/classified-ads-script — Issue #1: Sql query improvements
Author: noverkill
Created: 2011-12-08 21:25:32+00:00
State: open

Sql queries optimization.
Rewrite sql related codes using mysqli (MySQL improved extension) and prepared statements.

Reasons:
- prevent sql injections without escaping inputs
- prepared statements are quicker
- mysqli APIs are more secure, faster, and wellmaintained

references:
http://php.net/manual/en/mysqli.prepare.php
http://fossplanet.com/f6/%5Bphp%5D-pros-cons-using-mysqli-prepared-statments-71186/
http://php.net/manual/en/mysqli.overview.php