Tag

php coding

Browsing

Live search in PHP and Mysql using Jquery

This tutorials is to know how to integrate live search in php and MySQL using jquery. Searching is one of the most required feature in web sites and if it will be live searching it will show you fast result on page. In this tutorial we will create a database and a table insert records and start searching in it.

Demo       |

This is a very simple script which has 2 files. One is an HTML (index.php) file with a Search input box and the second is a PHP (do_search.php) file that has a regular MySQL connect(db.php) and a select statement to get the data from database. This script also has a Loading message shown while the data is being pulled from MySQL. Please note that live search might use more resources from your server. It might result in server overload / slowness if your infrastructure is limited.

Step1 : Setup your database and table in MySQL
Before you run this script make sure you have created a database and table in MySQL. Below is the sample sql command to create a database, table, and insert some dummy rows.

Step 2: Index page for search form. 
Create the live form for searching.

Step 3: Creating a do search for getting data from database.
Create the mysql query for getting the data from table using like” options.

Step 4: jquery code for get the search value and pass to do_seach page. 
Using the jquery you can get the search word and pass to the next page using variable and post method.

Step 4: Add css code fro your design.

You can now demo the script and get the live code., That’s it enjoy the code. Please subscribe. 

Hello Developers, For Previous session we learned only login form using with session and database, Here We are going to full Registration form with sample coding.

Php registration form with email verification

Step 1:
First Create Config file for database connection named as config.php
Please Check previous link for creating DB and Table

Step 2 :

Create register page named as register.php with verification code in php

 

Php Registration Form with email verification - Full codingStep 3:
Create as Css File for design named as style.css

 

Step 4: Create email activation page named as activation.php

Step 5: Create login.php page

 

Php Registration Form with email verificationStep 6: Create logout.php page

 

Step 7: Create main.php for home page

Great You learned it easily, download the full source code and enjoy the coding.

Click here to download full code – Php coding for registration with emial verifiaction

Alternative download link