Search option in gridview in php

Search Option

This tutorial is about search option in a grid. There are many searching techniques. Here I explain how to add search option in a grid when a grid has also server side pagination. It’s a simple and very easy way that I use.

When you using server side pagination first you must check it out that on which page your record is exist. Like in my example I want to search ID number “17”. And on per page I am displaying total 10 numbers of rows/records so it means ID number “17” exist on page 2.

Copy and paste this example code which is more understandable.

Step 1:

Create database like "tutorials" and then create table "BOOKS_TBL" with more then 10 record. below is the script of table and data.