Member Avatar for smgeshi

Hi all,

I want to develop a search functionality in my php website. My requirement is as below..

I have a text field for entering the required key word.After enter my search keyword and hit the "search" button, it should list all the data with respect to the entered item.

Eg:If i enter the word "hospital" in the text field and hit search button, then it should list the names of all hospitals in that country..
How can I implement it..

Thanks in advance
AlAyam

  • 4 Contributors
  • 4 Replies
  • 102 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by OsaMasw
Member Avatar for Webville312

If that is not what you want to implement, then try creating yours, and then let us know where you get stuck ...

Member Avatar for OsaMasw

THIS is the simple way to search and you can develope it

<?php
$word = $_POST['NAME_OF_TEXTBOX']; // dont forget to protect those inputs
$sql = "SELECT * FROM YOUR_DATABASE WHERE YOUR_COLOUMN LIKE '%".$word."%' LIMIT ANY_NUMBER";
$run = mysql_query($sql);
if (mysql_num_rows($run) > 0 ) {
while ($data = mysql_fetch_assoc($run)) {
echo $data['YOUR_COLOUMN'];
}
}else {
echo "No result";
}
?>
Edited by OsaMasw
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.