Export MySQL database records to a CSV file

phpcsvexport

In this tutorial, we are going to see how to export MySQL database records to a CSV file. Few days before we have seen about how to read from a CSV file. After connecting to the database, we have to fetch MySQL table records. These database results should be formatted as CSV string with proper delimiters and […]

PHP Database Backup Client for MySQL

PHP-Database-Backup-Client-for-MySQL

There are various database clients available in the market, for example, SQLyog, HeidiSQL, phpMyAdmin and more. These are popular database clients. In this tutorial, we are going to create our own client interface for taking database backup. This will be a series of articles and in future, I will be enhancing it and eventually building […]

How to Backup MySQL Database using PHP

How-to-Backup-MySQL-Database-using-PHP

Dynamically creating database backup via program will be hand in many a situations. We can schedule the backup process periodically by using CRON jobs. Taking the database backup using PHP programming is easy. In this tutorial, we are going to learn how to backup MySQL database with a simple core PHP code. First, I get […]

Check Uncheck All Checkbox using jQuery

Check-Uncheck-All-Checkbox-using-jQuery

In this tutorial, we are going to see how to check or uncheck group of checkboxes using jQuery. We can use this feature in various scenarios like selecting multiple records to perform database update or delete. In this tutorial we have a simple example with less code for obtaining this feature using jQuery. We have […]

MySQL Left Join

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.

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: An Introduction

MySQL-JOINs

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, […]

MySQL Fetch using 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 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 […]

Getting Checkbox Values in jQuery

getting-checkbox-values-in-jquery

In HTML Form, the dropdown, checkbox type fields have an array of value. In this post, we are going to see how to get the array of selected values from these form fields using jQuery. In this example, we are using jQuery each() to get each checked value in an array. Then this array values […]

Update/Delete Multiple Rows using PHP

Update-Delete-Multiple-Rows

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 […]

Ajax Pagination with Tabular Records using PHP and jQuery

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 […]