In this tutorial, we will learn how to search employee records on the basis of their name, email, mobile number, and employee id in PHP from the database.

In this example, we will guide you a step-by-step procedure to search employee records.

Search employee data in PHP and MySQL will look as follows.

searchdata-1024x443.png 300w, 768w, 1536w, 1909w" alt="How-Search-Employee-data-from-Database-using-PHP" width="1024" height="443" />

Step1: First create a database with name “betdb” where employee data is stored.

Step2: Second is to create a table with the name “tblempdata” and insert the employee data.

Table Structure

Step3: Create a database connection file and save this file with the name “config.php”. Below is the code of the database connection.

Step4: Create a form with one field which is “search”.

Step 5: PHP code for fetching data from the database on the basis of the search.

Blog :

Here is the full code that we have written for this tutorial:

Download Script

How to Run the Script

1. Download the zip file

2. Extract the file and copy searchempdata folder

3.Paste inside root directory(for xampp xampp/htdocs, for wamp wamp/www, for lamp var/www/HTML)

4.Open PHPMyAdmin (http://localhost/phpmyadmin)

5. Create a database with the name betdb

6. Import betdb.sql file(given inside the zip package in the SQL file folder)

7. Run the script http://localhost/searchempdata

Website :

Votes: 0
E-mail me when people leave their comments –

Welcome to PHPGurukul. We are a web development team striving our best to provide you with an unusual experience with PHP. Some technologies never fade, and PHP is one of them. From the time it has been introduced, the demand for PHP Projects and PHP developers is growing since 1994. We are here to make your PHP journey more exciting and useful.

You need to be a member of Global Risk Community to add comments!

Join Global Risk Community

    About Us

    The GlobalRisk Community is a thriving community of risk managers and associated service providers. Our purpose is to foster business, networking and educational explorations among members. Our goal is to be the worlds premier Risk forum and contribute to better understanding of the complex world of risk.

    Business Partners

    For companies wanting to create a greater visibility for their products and services among their prospects in the Risk market: Send your business partnership request by filling in the form here!