PHP MySQL Limit Data Selections

MySQL provides a LIMIT clause that is used to specify the number of records to return. Returning a large number of records can impact on performance. This feature is very … Read more


The order by clause is used to fetch data in ascending order or descending order on the basis of column. The ORDER BY clause sorts the records in ascending order … Read more

PHP MySQL Select Query

In this tutorial you’ll learn how to select records from a MySQL table using PHP. The SELECT statement is used to select data from one or more tables. SELECT statement … Read more

PHP MySQL Delete Record

The DELETE statement is used to delete records from a table. In this tutorial you’ll learn how to delete records from a MySQL table using PHP. DELETE statement syntax The … Read more

PHP MySQL Update Data

The UPDATE statement is used to update existing records in a table. This statement is typically used in conjugation with the¬†WHERE¬†clause to apply the changes to only those records that … Read more

PHP MySQL Insert Data

The INSERT INTO statement is used to add new records to a MySQL table. Now that you’ve understood how to create database and tables in MySQL. In this tutorial you … Read more

PHP MySQL Create Table

mysqli_query() function is used to create table in PHP. What is a table? A database table has its own unique name. Table consists of columns and rows. A table has … Read more

PHP MySQL Create Database

A database consists of one or more tables. The CREATE DATABASE statement is used to create a database in MySQL. It Is very easy to create a new MySQL database. … Read more

PHP MySQLi Connect

If you want to access data from MySQLi database, first you need to make connection with server. PHP 5 and later can work with a MySQL database using: MySQLi extension … Read more