Posted inCode base

Convert PHP ext/mysql to MySQLi

Learn how to convert PHP mysql functions to PHP MySQLi extension. The old ext/mysql extension is deprecated as of PHP 5.5.0 and therefore it's a must to migrate away from using it and towards MySQLi or PHP Data Object (PDO). This post will show you how.
04/02/2015Posted inCode base
Posted inCode base

Optimize all MySQL tables with PHP/MySQLi multi_query

PHP script to make your MySQL database smaller, leaner and faster! The PHP MySQLi extension supports multiple queries, which are concatenated by a semicolon, with mysqli->multi_query. We use this to optimize all MySQL tables, in a single multi-query statement. Neat! Optimizing MySQL tables is important to keep tables small and fast. This boosts MySQL, PHP and website performance and we all love that, don't we?
23/04/2014Posted inCode base