MYSQL

3 SQL Version of NorthWind Database

Submitted by nostradamus1566 on
A great way to learn database programming is to have a good sample database with lots of tables and appropriate relationships between them to work with. Queries can then be composed from within a variety of programming platforms, such as Java, PHP, Visual Basic 6, Visual Basic.Net, Visual C#, etc. NorthWind is a free sample database that Microsoft included with every version of Access going all

Online Leave Management System in PHP

Submitted by Alhassan Kamil on
This is a leave management software developed in PHP7 and Mysql. It has a simple but elegant user interface that's appealing. It has all the functionalities you'll need to have a leave management website. There are three levels of users of this webapp: admin, staff, and supervisor users. ADMIN LOGIN Username: admin Password: admin SUPERVISOR LOGIN Username: supervisor Password: 12345678 STAFF

Assign a New Search Box for Table Outside of DataTable

Submitted by nurhodelta_17 on
This tutorial tackles on how to create a new search box for table using datatable. By default, the search box in datatable plugin is located in the upper right corner of the table. To design this search box, there are several ways on how to do this. One of this ways is to create a new search box and assign it to our data tabled table.

How to Backup MySQL Database using PHP

Submitted by nurhodelta_17 on
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.

How to Get the Average of One Column in MySQL Database using PHP

Submitted by nurhodelta_17 on
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.

How to Create an Auto Complete Search using jQuery with PHP/MySQLi

Submitted by nurhodelta_17 on
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.

How to Create a Dynamic Dropdown Menu using PHP/MySQLi and Bootstrap 4

Submitted by nurhodelta_17 on
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.

How to Check Email Availability using jQuery and PHP/MySQLi

Submitted by nurhodelta_17 on
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.
Subscribe to MYSQL