PHP and Mysql search engine
Posted: Sun Jun 21, 2015 12:57 pm
Hello , I have a big problem with this error: Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp...
I think it is something to do with the sintax. Please anyone can help me with this?
My code looks like this:
I think it is something to do with the sintax. Please anyone can help me with this?
My code looks like this:
Code: Select all
<?php
require('connect.php');
$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' > </ br > ";
$search_exploded = explode ( " ", $search );
$x = 0;
foreach( $search_exploded as $search_each )
{
$x++; $construct = "";
if( $x == 1 ) $construct .="keywords LIKE '%$search_each%'";
else $construct .="AND keywords LIKE '%$search_each%'";
}
$construct = " SELECT * FROM video WHERE $construct ";
$run = mysql_query( $construct );
$foundnum = mysql_num_rows($run);
if ($foundnum == 0)
echo "Sorry, there are no matching result for <b> $search </b>. </br> </br>
1. Try more general words. for example: If you want to search 'how to create a website' then use general keyword like 'create' 'website' </br>
2. Try different words with similar meaning </br>
3. Please check your spelling";
else
{$row = mysql_fetch_assoc($foundnum);
// echo "$foundnum results found !<p>";
while( $runrows = mysql_fetch_assoc( $run ) )
{
$title = $runrows ['title'];
$desc = $runrows ['description'];
$url = $runrows ['url'];
echo "<a href='$url'> <b> $title </b> </a> <br> $desc <br> <a href='$url'> $url </a> <p>";
}
}
}
}
?>