Category: DataBase

DataBase

Autocomplete search filter display suggestion based on the user input e.g. listing all products which start with character ‘a’.

It makes easier for the user to search for an item from the list and select it from the suggestion list.

Require jQuery AJAX for implementing this.

Whenever the user enters a character send an AJAX request to fetch records with PHP and display the result.

In the demonstration, I show a textbox to search users. When an item selected from the suggestion list then fetch details of the selected users and display on the screen.

Make Autocomplete search with jQuery AJAX

AJAX DataBase JQuery PHP

Using login page registered users sign in to the website and manage its account.

On the user successful login attempt need to define $_SESSION.

This helps to detect the user is actually logged in or not when going to another web pages and it also helps to display content according to the user.

In this tutorial, I show how you can create a Login page with PHP and MySQL.

Create simple login page with PHP and MySQL

DataBase PHP

If you are allowing the user to login with their username and password then you have to make sure that every user has the unique username.

When the user goes for registration on your site check username either after form submits or check it with AJAX while entering.

In this tutorial, I am using jQuery AJAX to check username is available or not.

Check username availability with jQuery and AJAX

AJAX DataBase JQuery PHP