Find the rows based on search string?

PHP
1

Hi all,
I have a page, with all the data presented like pagination collecting from the database…

Now i want to search/find by enabling a text box, based on the string entered in the text box, only that string matching rows should be display in that page…

How to implement it…
Give me ideas to do it…

2

If you are already getting your data from a MySQL database, all you need to do is add a form to the page with an input text box, and then use that input in your query to construct something resembling this:

SELECT * FROM table WHERE field LIKE ‘%string%’

% is the wildcard so the above query will look for anything that has the word string somewhere in field.

3

thank you for your reply…
I solved the problem…