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 have to be set explicitly in application or in PHP configuration file (php.ini, for global used) … [Read more...] about How to Set Time Zone in PHP and MySQL
Mysql
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 'TRUNCATE TABLE' statement. About TRUNCATE Statement For an InnoDB table before version 5.0.3, … [Read more...] about How to Empty All Tables in a MySQL Database with PHP
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 (normally in C:/xampp/mysql/bin directory) and search for the following lines: # Comment … [Read more...] about How to Enable MySQL InnoDB Storage Engine on XAMPP
Recent Comments