prepared statements - pontikis.net

Dynamically Bind Params in Prepared Statements with MySQLi

Post author:Christos Pontikis
Post published:October 13, 2013
Post category:Database Administration
Reading time:4 min(s) read

Prepared statements must be used in application development with databases. There are two main reasons: performance: parameterized queries with prepared statements reduces the database load, reusing access plans that were…

Pointing device

How to Create a jquery-ui Autocomplete Step by Step

Post author:Christos Pontikis
Post published:July 18, 2013
Post category:Web Development
Reading time:9 min(s) read

Autocomplete is one of the most important parts of modern rich web interface. Actually, you can create an autocomplete, using an AJAX call to build a list (server side) and…

Billiards

How to Use PHP Improved MySQLi extension (and Why You Should)

Post author:Christos Pontikis
Post published:March 29, 2013
Post category:Database Administration
Reading time:8 min(s) read

PHP supports MySQL using a PHP extension. Thousands or millions projects have been written worldwide using PHP and MySQL. PHP team announced plans to deprecate MySQL extension in mid 2011.…