Difference between MySQL and MySQLi
Basically there is no major difference between Mysql and Mysqli. Mysqli is nothing but an improved extension of Mysql. MySQLi: – The i stands for Improved. The MySQLi extension is …
Calculate size of databases from information schema
I was working on a project where i need to work with database, suddenly a query raise in my mind , that is database size… yes How to calculate databases …
Preventing SQL Injection:
SQL injection is one of the most common vulnerabilities in applications on the web today. This article will show you how to prevent SQL injection on your website using Prepared Statements in PHP.
Compare DATE string with string from DATETIME field in Mysql
If you want to select all rows where the DATE part of a DATETIME column matches a certain table. Best and easy possible way is use Mysql Date() fuction.