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

Discussion in 'Web Design and Development' started by balam, Jan 6, 2010.

  1. balam macrumors newbie

    Joined:
    Dec 14, 2009
    #1
    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.

    PHP:
    <?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>"
    ;
     
    }      
     
     
          }
        }
      }
     
     
    ?>
     
  2. Bostonaholic macrumors 6502

    Bostonaholic

    Joined:
    Aug 21, 2009
    Location:
    Columbus, Ohio
    #2
    First off, you can't just thrown php into html for it to work. Your php code will be included inside your <body> tags since your just echoing your results.

    Try something like this

    index.php
    PHP:
    <html>
        <head>
        ...
        </head>

        <body>
        ...
        <?php include(yourscript.php); ?>
        ...
        </body>
    </html>
    Then open index.php in a browser. Make sure your web server is setup to process php.
     

Share This Page