When you need to create duplicate/clone of mysql record in codeigniter this article will be a very useful. This can be used when you need to create a copy of high details of record. Just send 3 parameters to do this.
Continue reading CodeIgniter create duplicate MySQL record
How can you create a MySQL Database backup using PHP.If you think the database is too large as GB how do you get a fastest backup?In this post will describes how to create a MySQL Database backup/dump quickly instead of using phpmyadmin access using PHP.Also you can save your time to get backup.
Continue reading Create / Export MySQL Database backup using PHP
How can I import MySQL database using PHP? Also if you have to import large size of MySQL dump, how do you import it easily? In this article is describing how to import MySQL database using PHP.In this method you can save your time instead of you import sql file in the phpmyadmin or database software.As my personal experience I tested this script using 2.125GB large database dump file. Continue reading Import a MySQL database using PHP
If you want to get database tables sizes using MySQL you can do it as follows.
MySQL system database called information_schema. It has right information for those who want to get DB table real size.
First of all you must go to the MySQL “information_schema” and get “schema name” of the database from the “SCHEMATA” table. Continue reading How can I get database table sizes?
How to access disable or prevent sql injections using php.This is a most important topic when you are creating a web site or web applications.So in this articles is describing how to prevent sql injections using php. Continue reading PHP prevent SQL Injections