The MySQL Optimize Table command will effectively de-fragment a mysql table; it’s useful for tables which are frequently updated and/or rows are deleted. Optimizing will will help with overall performance….
This is another one of those quite specific pieces of code, so I doubt many people will need it. I think the code is quite useful, so I thought i’d…
I’m quickly going to demonstrate how to escape special characters in a string for all POST/GET variables safe for a MySQL INSERT query when passing values from a HTML form….
Someone asked me the other day how to display the existing tables in their database with a PHP script. The query itself is pretty simple, but people seem to get…
Learning & sharing
This section is dedicated to MySQL & PHP, for both our own uses and for others to learn from. Sharing is caring.
Please feel free to contribute to our blog posts; perhaps even teach us a few tricks of your own. We'd love to hear your thoughts.