Category Archives: mysqli

Discuss MySQLi The MySQLi extension was introduced with PHP version 5.0.0 and the MySQL Native Driver was included in PHP version 5.3.0. i stands for improved in MySQLi and provides various functions to access the MySQL database and to manipulate the data records inside the MySQL database. You would require to call the MySQLi functions […]

MySQLi – Using Joins In the previous chapters, we were getting data from one table at a time. This is good enough for simple takes, but in most of the real world MySQL usages, you will often need to get data from multiple tables in a single query. You can use multiple tables in your […]

MySQLi – Delete Query If you want to delete a record from any MySQL table, then you can use the SQL command DELETE FROM. You can use this command at the mysql> prompt as well as in any script like PHP. Syntax The following code block has a generic SQL syntax of the DELETE command […]