logo logo
How to Set Time Zone in PHP and MySQL

How to Set Time Zone in PHP and MySQL

Sometimes when working with PHP-MySQL application, we have to explicitly set the time zone in our application in order to match the client’s time zone. Since PHP 5.3, time zone setting is mandatory and...
How to Empty All Tables in a MySQL Database with PHP

How to Empty All Tables in a MySQL Database with PHP

This is a simple PHP script to empty all tables in a MySQL database. This script first will list all tables in a database using ‘SHOW TABLES‘ statement then it will empty  each table using...
How to Enable MySQL InnoDB Storage Engine on XAMPP

How to Enable MySQL InnoDB Storage Engine on XAMPP

InnoDB is one of MySQL storage engines, it supports transactions, row-level locking, and foreign-keys. However, by default, InnoDB is not enabled by XAMPP. To enable it, locate the my.cnf configuration file...
bottom