Search Engine

• • Reply

  17 years ago

  by RedSouljaz

  HeaVenMan

  , Indonesia

  Joined 18 years ago

  Hi, im very new in PHP. What i want to asked is where i can find a script to do a simple search engine by using php connect to the mySQL. for example i have list of music in my database, and i want to search by Song title, Artis, or price. Thanks
  H!

  Report abuse
• • Reply

  17 years ago

  by nzjonboy

  nzjonboy

  New Zealand, New Zealand

  Joined 19 years ago

  Hi RedSouljaz,
  

  
  You could build your own small search engine for this, like so
  

  
  Search.html
  

  
  

  Code:

  
  

  
  <form action="result.php" method="get">
  <input type="text" name="search"><br>
  <input type="radio" name="option" value="1" checked> All<br>
  <input type="radio" name="option" value="2"> Song<br>
  <input type="radio" name="option" value="3"> Artist<br>
  <input type="radio" name="option" value="4"> Price<br>
  <input type="submit" value="search">
  </form>
  

  
  

  
  

  
  result.php
  

  Code:

  
  

  
  //database connection code here
  

  
  switch $GET["option"] {
   case 1:
     sql = "select * from mytable where song like '%".$GET["search"]."%' and artist like '%".$GET["search"]."%' and price like '%".$GET["search"]."%' ";
     break;
   case 2:
     sql = "select * from mytable where song like '%".$GET["search"]."%' ";
     break;
   case 3:
     sql = "select * from mytable where artist like '%".$GET["search"]."%' ";
     break;
   case 4:
     sql = "select * from mytable where price like '%".$GET["search"]."%' ";
     break;
   default:
     sql = "select * from mytable where song like '%".$GET["search"]."%' and artist like '%".$GET["search"]."%' and price like '%".$GET["search"]."%' ";
     break;
  }
  

  
  // code to run query and show results on page....
  

  
  

  
  

  
  hope this helps
  

  
  

  Report abuse