What is left join – MySQL LEFT JOIN with Examples

The following query is used to apply left JOIN between the tbl_links and tbl_tags table with the use of tbl_links.tag_id and tbl_tags.tag_id.

MySQL Left Join is one of the methods used in joining the database tables as we have seen in the introduction of MySQL JOINs. In this tutorial, we are going to see an example to read data from more than one tables using Left JOIN. Also, we are going to see the possible use cases of where […]

MySQL Join Made Easy For Beginners: An Introduction


MySQL Join are used to read data by connecting two or more related tables. While joining MySQL tables, we need to specify the condition for the JOIN query with the use of ON or USING clause. The join conditions are written based on the common column name, data or indexes of the tables. In this tutorial, […]

How to fetch data from the database in PHP

fetch data from the database in PHP

PHP provides a huge list of MySQL functions to access the database from the front end. Among those functions, we are going to discuss MySQL Fetch using PHP . some of them that are used to fetch data from the database. Such functions differ with the type of results they are expected to return. In […]

How to Update Delete Multiple Rows Using PHP


We are well expertise with PHP CRUD operations by accessing MySQL via PHP logic. Yet, we have seen about how to update and delete table rows one at a time. This article deals with Update Delete Multiple Rows using PHP. For selecting multiple rows, we are going to use checkbox input for submitting selected rows […]

Make Pagination using Ajax with Jquery, PHP and MySQL

Pagination using Ajax feature is for limiting the number of results instead of loading all in a list page. Loading multiple records with pagination will increase efficiency to load result page by page. We have seen several examples for PHP pagination with database results. For the pagination functionality, a perpage result count will be configured. […]