Wednesday , 26 July 2017
Home » MySql


[CakePHP] How to close mysql connection


I am working with CakePHP project since last few days. I want to close the mysql connection for some reason. With Core PHP, you can close mysql connection by simply calling mysql function which is mysql_close() function. Are you looking for how to close mysql connection in CakePHP ? Read More »

[MySql] How to Prevent SQL Injection in PHP


If you are beginner in PHP and MySql OR you are not aware with SQL Injection while executing MySql Queries from PHP Code than you must know how to prevent SQL Injection in PHP. It is very important to take care of SQL Injection in your PHP code if you really cares for your client and his/her website security. Read More »

[MySql] SELECT statements have a different number of columns in UNION Query


I was working with website with millions of records where I need to use UNION SQL Query. I used the UNION SQL query and try to execute it but it shows me error message saying "The used SELECT statements have a different number of columns". Read More »

Fatal error: Maximum execution time of 300 seconds exceeded in phpmyadmin


I was working with Google API and I need to implement World's City and its population in Google Map. For that, I downloaded world's city and its population database and trying to import it into my local phpmyadmin. Database is with size of 33MB and when I try to import it via Import function, it throws me Fatal error: Maximum execution time of 300 seconds exceeded in \xampp\phpMyAdmin\libraries\import\sql.php on line 133 error. Read More »

[PHP] Import CSV in MySql using PHP


Are you looking to import csv file into MySql database or Import excel into mysql database using php script ? If yes than you are at right place. Import CSV into MySql using PHP, Import Excel into MySQL via PHP Script is easy to do. Just copy below php code and make necessary changes for MySql database and understand CSV fields. Read More »