How and When To Enable MySQL Logs
If you are a web developer, you need to refer to various log files, in order to debug your application or improve its performance. Logs is the best place to…
Dynamically Bind Params in Prepared Statements with MySQLi
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…
A Workaround for mysqldump Error 1449
Trying to dump mysql databases (especially after mysql 5.1), it is possible to get the error mysqldump: Got error: 1449: The user specified as a definer ('root'@'%') does not exist…
A Simple PHP Class to Create RSS Feed
RSS (Really Simple Syndication) is the use of an XML document in order to share content across the Internet. An RSS document, aka "feed" includes full or summarized text, plus…
How to Create a jquery-ui Autocomplete Step by Step
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…