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

balamberas · #1 (**permalink**) 01-06-10, 10:39 AM

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 Code:


			


<?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>";

 

}      

 

 

      }

    }

  }

 

 

?>

ruteckycs · #2 (**permalink**) 01-06-10, 01:40 PM

I assume you create the form and database that 'feeds' this script.

Option1:
Put it where ever you want in the page (where you want the output to show) and rename the page to (pagename).php

Option2:
Save this as a .php and use an IFRAME to include it in the page

Option3:
Change .htaccess so that you can run php from within .html / .htm

job0107 · #3 (**permalink**) 01-06-10, 03:03 PM

Put it all on one page.
Something like this:

PHP Code:


			
<?php
if(!empty($_POST["submit"]))
{
 $search = empty($_POST['search']) ? "" : $_POST['search'];
 $x=0;
 $construct='';
 $foundnum=0;
 if(!$search){$msg = "You didnt submit a keyword.<p>";$c = "#f00";}
 else
 {
  if(strlen($search)<=2){$msg = "Search term to short.<p>";$c = "#f00";}
  else
  {
   $msg = "You searched for <b>$search</b><p>";
   $c = "#00f";
   $search_exploded = explode(" ",$search);
   foreach($search_exploded as $search_each)
   {
    $x++;
    if($x==1){$construct .= " location LIKE '%$search_each%'";}
    else{$construct .= " OR location LIKE '%$search_each%'";}
    }
   include ('connect.php');
   $construct = "SELECT * FROM flats WHERE $construct";
   $run = mysql_query($construct);
   $foundnum = mysql_num_rows($run);
   if($foundnum==0){$msg = "No results found.";}
   else
   {
    $msg2 = "$foundnum result found!<p>";
    $results = "";
    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'];
     $results .= "<table>
                   <tr>
                    <td>$title</td>
                   </tr>
                   <tr>
                    <td>$select</td>
                   </tr>
                   <tr>
                    <td>$rent</td>
                   </tr>
                   <tr>
                    <td>$location</td>
                   </tr>
                   <tr>
                    <td>$description</td>
                   </tr>
                   <tr>
                    <td>$contactEmail</td>
                   </tr>
                   <tr>
                    <td>$number</td>
                   </tr>
                   <tr>
                    <td><hr></td>
                   </tr>
                  </table>";
     }
    }
   }
  }
 }
?>
<html>
<head>
</head>
<body>
<div style='float:left;'>
 <div style="color:<?php echo $c; ?>;font-size:20px;"><b><?php echo $msg; ?></b></div>
 <form action="#" method="post">
  Input key word(s): <input type="text" name="search"><br />
  <input type="submit" name="submit" value="Submit">
 </form>
</div>
<div style="float:left;margin-left:30px;"><?php echo "<span style='color:#00f;'>$msg2</span><p>$results"; ?></div>
</body>
</html>

And make sure the page has a .php extension.

ruteckycs · #4 (**permalink**) 01-06-10, 03:43 PM

That is not correct, if you just put the code on top of the page in this way (even a .php page) then the output will be prior to the <html> <head> and <body> tags. The code should be inserted where the output is wanted.

and yes ... you can ensure that the page has a .php extension, however if it is an existing page then you might not want to change the page extension. In that case use one of the other options (see my original post)

job0107 · #5 (**permalink**) 01-06-10, 05:37 PM

Quote:

Originally Posted by ruteckycs

That is not correct, if you just put the code on top of the page in this way (even a .php page) then the output will be prior to the <html> <head> and <body> tags. The code should be inserted where the output is wanted.

and yes ... you can ensure that the page has a .php extension, however if it is an existing page then you might not want to change the page extension. In that case use one of the other options (see my original post)

I don't mean to rain on your parade,
but if you knew anything about PHP,
you would see that my code not only works,
but I can use the stored variables anywhere in my HTML.

End User · #6 (**permalink**) 01-06-10, 07:12 PM

Quote:

Originally Posted by ruteckycs

That is not correct, if you just put the code on top of the page in this way (even a .php page) then the output will be prior to the <html> <head> and <body> tags. The code should be inserted where the output is wanted.

Actually, all of Job0107's code runs before the page is printed, and the output is stored in the variable "$results". That variable could be placed anywhere in the page just by printing it out with <?php echo $results ?>.

I often do the same sort of thing when I want the result to be able to be moved around or placed in different areas. If you have a lot of code to run then it may delay the page output slightly, but it's better than printing out part of the page, then seeing a pause as the code runs, and then seeing the rest of the page appear.

wirehopper · #7 (**permalink**) 01-06-10, 08:41 PM

There are lots of different coding styles. I like job0107's approach, too.

job0107 · #8 (**permalink**) 01-06-10, 09:10 PM

Thank you, I am flattered.

ruteckycs · #9 (**permalink**) 01-06-10, 09:58 PM

Oh sorry Job, I do that as well. I didnt actually read your script. I had assumed that you just pasted the OP's code on top of a page.

But hey thanks for the smart *** comment .... if you knew anything ... glad to see that we have maturity in this forum .. especially from someone who is suppose to represent the forum community,

job0107 · #10 (**permalink**) 01-07-10, 08:05 AM

Quote:

Originally Posted by ruteckycs

Oh sorry Job, I do that as well. I didnt actually read your script. I had assumed that you just pasted the OP's code on top of a page.

But hey thanks for the smart *** comment .... if you knew anything ... glad to see that we have maturity in this forum .. especially from someone who is suppose to represent the forum community,

I am also sorry if I rattled your cage a little.
I do not have much tolerance for programmers that do not examine the code before speaking.
But I am working on that.