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 to […]
MySQL JOINs 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, […]
PHP provides a huge list of MySQL functions to access the database from the front end. Among those functions, we are going to discuss 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 PHP, MySQL fetches results can […]
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 selecting multiple rows for applying update/delete operations. For selecting multiple rows, we are going to use checkbox input for submitting selected […]
Pagination 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. This configured […]
In this tutorial, we are going to access the MySQL database from PHP. Accessing MySQL from PHP is very simple and easy to implement. PHP contains MySQLi class functions to connect and access the database. Some of those are used in this article. prepare() – To prepare query statement object fetch_row() – To read row […]
In this tutorial, we are going to see an example program to learn how to do database CRUD operations using PHP and MySQL. CRUD tends to Create, Read, Update and Delete operations with database table records. In the previous tutorial, we have seen how to access MySQL database via PHP. In this example, we are […]
In this tutorial, we are going to access MySQL database from PHP. Accessing MySQL from PHP is very simple and easy to implement. PHP contains built-in functions to connect the MySQL database and to access the data. Those functions are, mysqli_connect – To connect the database by using the specified configuration. mysqli_query – To execute […]
Autocomplete feature is used to provide the auto suggestion for users while entering input. In this tutorial, we are going to suggest country names for the users based on the keyword they entered into the input field by using jQuery AJAX. jQuery Autocomplete function is called on the key-up event of the input field. This […]
In today’s tutorial, I’m going to show you, how to Pass Data with Ajax to a PHP file and process it. Using this method, you can retrieve data from a database, and run other PHP scripts using the values of the forms and fields.