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.

Server side pagination in php

Pagination has two types

pagination (Server side pagination) in php

1.  Server Side Pagination
2. Client Side Pagination

In this tutorial we will learn server side pagination technique. To select from these two’s that which one is the best approach, then it’s totally depend on number of rows. Server side pagination technique used when number of rows is more.

Now let’s start example step by step.