MySQLi

Submitted by: 
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.
Submitted by: 
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.
Submitted by: 
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.
Submitted by: 
This tutorial tackles on how to delete table row using SweetAlert2 with PHP and MySQLi-OOP. Sweet Alert as per github description, is a beautiful, responsive, customizable and accessible replacement for javascript's popup boxes.
Submitted by: 
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.
Submitted by: 
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.
Submitted by: 
This tutorial tackles on how to create a JSON file from MySQL Database using PHP. JSON stands for JavaScript Object Notation and has an extension of .json which is a syntax for storing and exchanging data. JSON is a text, which is used in exchanging data between a browser and a server.
Submitted by: 
This source code will teach how to CRUD(create, read, update, delete) using the two MySQLi Extensions which are OOP and Procedural. Also included, the datatable library which is an extension that uses jquery to beautify and add functionality to HTML Table. Lastly, included is a PDF Generator using TCPDF library.
Submitted by: 
This tutorial tackles on how to create an XML file from MySQL database using PHP/MySQLi. XML stands for eXtensible Markup Language which is designed to store or transport data. This is usually used as a database substitute or if you wanted to free some space in your database.
Submitted by: 
This tutorial tackles on how to export MySQL database into .csv/CSV file using PHP/MySQLi. Usually, we export MySQL database using our phpMyAdmin and it is in .sql format but if you want it in CSV format, this tutorial will help you on how to achieve this. CSV stands for Comma-separated Values which is a simple file format used to store tabular data such as database.

Pages