MYSQL

This tutorial tackles on how to restore MySQL database using PHP. Usually we restore backup database using phpMyAdmin however, if you want to use PHP to restore back up sql database, this tutorial will surely help you on how to achieve that.

This tutorial tackles on how to back up MySQL database using PHP with MySQLi OOP extension. There are several ways on how to backup our MySQL database and if your hosting your site, there are CRON jobs where we can schedule back up of our database. In this tutorial however, we are going to backup our database using PHP.

This tutorial tackles on how to delete multiple rows using jquery. jQuery is a javascript library that provides excellent ui and makes you use javascript easily. In this tutorial, we are also gonna be using jquery to check all checkbox via one main checkbox.

This tutorial tackles on how to get the average of one column in mysql database using PHP. There are instance that we wanted to get the average of one column for reporting purposes like average sales, expenses etc. Normally, we get the sum of the column then we divide it by number of rows but actually there is a sql function that determines the average of one column.

This tutorial tackles on how to create an auto complete search using jQuery with PHP and MySQLi OOP. If you wanted to add an auto suggest on your search app, this tutorial will surely help you out. With the help of jQuery, we can dynamically make a POST request without refreshing the page.

This tutorial tackles on how to create a dynamic dropdown menu using PHP with MySQLi-OOP and Bootstrap 4. Currently, the latest version of Bootstrap is 4 and has several changes from the later version. We are going to use Bootstrap 4's nav tag to create our menu where we put dynamic content in the dropdown.

This tutorial tackles on how to check the availability of email using jQuery and PHP with MySQLi-OOP. In user registration, we don't want that multiple users have the same email or in short we want the email to be unique to each user. To do so, we use validations to validate an email then we check if the email already exist.

This tutorial tackles on how to create a filter between two dates using jQuery with PHP/MySQLi without page refresh. We will be going to display our table then after the filter, the filtered table will be displayed. jQuery is a javascript library that makes you use javascript easily.

This tutorial tackles on how to create a simple Area Chart using Google Chart API with PHP and MySQLi extension OOP. Charts primary provides a statistical presentation of data within our application or systems. Google Chart API is a web service created by Google that provides graphical chart for data supplied by the user.

This tutorial tackles on how to hash password using PHP's password_hash() function. password hash(), as per official site description, creates a password hash. This function expects two parameters, the password that you want to hash, then the algorithm that you want to use to hash the password. You can then use password_verify() function to check for the hashed password.