Search Problem

yash87 · October 11, 2010

Hi,

Can I know how to resolve this problem?

Notice: Undefined variable: x in C:\wamp\www\i-document\search.php on line 39

Notice: Undefined variable: construct in C:\wamp\www\i-document\search.php on line 41

1 results found!

Thankz.


<html>
<body>
   <form id="form1" method="GET" action="search.php">
        <table width="446" height="135" border="1" align="center">
          <tr>
            <td height="31" colspan="2" align="center" valign="middle" bgcolor="#990000"><span class="style1 style2">Search :</span></td>
          </tr>
          <tr>
            <td width="374" height="96" align="center" valign="middle" bgcolor="#990000"><span class="style1 style2">
              <label>
              <div align="left">Keyword :
                <input name="search" type="text" id="search" size="40" />
              </div>
              </label>
            </span>
            <td width="56" align="center" valign="middle" bgcolor="#990000">
              <div align="left">
                <input type = "submit" name="submit" value="search" />
            </div></td>
          </tr>
        </table>
      </form>
</body>
</html>



[b][u]search.php[/u][/b]

<html>
<title>Search</title>

</head>

<body><br /><br />
<div class="MySearch"></div><br />
<?php

//Get data


$button = $_GET['submit'];
$search = $_GET['search'];

if (!$button)
   echo "You didn't submit a keyword.";
else
{
   if (strlen($search)<=1)
      echo "Search term too short";
   else
   {
      echo "You searched for <b>$search</b><hr size='1'>";

      //connect to database
      mysql_connect("localhost","root","");
      mysql_select_db("idoc");

             
            //explode search term
            $search_exploded = explode(" ",$search);

            foreach($search_exploded as $search_each);
            {

                //Construct Query

                $x++;
                if ($x==1)
                   $construct .= "file_name LIKE '%$search_each%'";
                else
                   $construct .= " OR file_name LIKE '%$search_each%'";

            }

     

      //echo out construct

     $construct = "SELECT * FROM document WHERE $construct";
     $run = mysql_query($construct);

     $foundnum = mysql_num_rows($run);

     if ($foundnum==0)
        echo "No results found";
     else
     {
        echo "$foundnum results found!<p>";

        while ($runrows = mysql_fetch_assoc($run))
        {
         //Get data
         $ref = $runrows['file_ref'];
     $filename = $runrows['file_name'];
	 $owner = $runrows['owner'];
         $url = $runrows['url'];
         echo "
        <table>
	<tr>
		 <td> $ref </td>
		 <td> $filename </td>
		 <td> $owner </td>
		 <td><a href='$url'>$url</a></td>

	</tr> 
	</table>
         ";
        }

     }


   }
}

?>

anups · October 11, 2010

define these 2 variables at the top of the page of just before you need it

eg

$x = 0;
$construct = "";

Sign In

Search Problem

Recommended Posts

yash87

Link to comment

Share on other sites

anups

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information