Page 1 of 1

were do u put a search engine script on a html table

Posted: Wed Jan 06, 2010 9:24 am
by balamberas
i need some help with this script. its working fine but what do i do if i want to insert it within a html script. I have tried to but it between the <head> tags but dont get the result i want, pls help.

Code: Select all

 
<?php 
 
include ('connect.php'); 
 
error_reporting(E_ALL); 
ini_set('display_errors', '1'); 
 
$submit = $_GET['submit']; 
$search = $_GET['search']; 
$x=0; 
$construct=''; 
$foundnum=0;  
 
if (!$submit) 
   
  echo "you didnt submit a keyword.";  
 
else 
 
{ 
 
if (strlen($search)<=2) 
 
   echo "search term to short."; 
 else  
{ 
  echo " You searched for <b>$search</b><hr size='1'>"; 
 
  //connect to our database 
 
 $search_exploded = explode(" ",$search); 
 
 
 foreach($search_exploded as $search_each) 
 
{ 
 
// construct query 
 
$x++; 
if ($x==1) 
    $construct .= " location LIKE '%$search_each%'";  
    else 
    $construct .= " OR location LIKE '%$search_each%'"; 
     
      } 
 
   // echo out construct 
   
 $construct = "SELECT * FROM flats WHERE $construct"; 
 $run = mysql_query($construct); 
 $foundnum = mysql_num_rows($run); 
 
 
if ($foundnum==0) 
  echo "No results found."; 
else 
{ 
   echo "$foundnum result found!<p>"; 
 
 while ($runrows = mysql_fetch_assoc($run)) 
 
{ 
 
// get data 
 
   $select = $runrows['type']; 
   $title = $runrows['title']; 
   $location = $runrows['location']; 
   $rent = $runrows['rent']; 
   $description = $runrows['description']; 
   $contactEmail = $runrows['contactEmail']; 
   $number = $runrows['number']; 
 
echo " 
 
    $title 
    <br> 
    $select 
    <br> 
    $rent 
    <br> 
    $location 
    <br> 
    $description 
    <br> 
    $contactEmail 
    <br> 
    $number 
   <hr>"; 
 
}      
 
 
      } 
    } 
  } 
 
 
?>
 

Re: were do u put a search engine script on a html table

Posted: Wed Jan 06, 2010 12:23 pm
by abushahin
hey you need to have a form, i think you have there's some errors with your select statement, it needs to be = rather than just the variable name, too much code to look at, try this