How do i make a search bar that searches through my website?

Replace <input type="" value="Search" /> with <input type="submit" value="Search" />.

 

it was already <imput type="submit" value="Search" />

 

I meant replace <input type="" value="Search" /> with <input type="submit" value="Search" />.
Also remember to prevent sql injection.

 

now the search bar is just text again

 

Is it just me or does DP keep removing the word s-u-b-m-i-t (it did it again) from our messages? Add "or die(mysql_error())" and post the error.

 

here is where i put it

<form action="" method="get">
            <input type="text" name="kw" />
            <input type="" value="Search" />
                        
            </form>
            <?php
            or die(mysql_error())
            $keyword = $_GET['kw'];
            if(!empty($keyword)){
            require('connect.php');

            
            $query = "SELECT * FROM articles WHERE keywords LIKE '%$keyword%'";
            $result = mysql_query($query);
            
            while($row = mysql_fetch_array($result)) {
                echo ("<img src='arrow.gif'>"); echo "&nbsp;&nbsp;";
                echo '<a style="font-size: 20px" href="'. $row['url'] .'">'. $row['article_name'] .'</a>';
                echo "<br />";
            } 
            }
            ?>

PHP:

Parse error: syntax error, unexpected T_LOGICAL_OR in /home/motorbik/public_html/new 2.php on line 47

 

I meant like this:
$result = mysql_query($query) or die(mysql_error());

Do you see the word "s-u-b-m-i-t" without dashes in the first message of this page? --never mind I just realized that it was the ad blocker on this computer that removed the word submit.

 

yes this is what i see Replace <input type="" value="Search" /> with <input type="(S-U-B-M-I-T without dashes)" value="Search" />.

 

No error comes up... the search button is still just a text box tho

 

I tried it and it worked, maybe you just don't get any results with the keyword you tried?
Change the button back to: <input type="submit" value="Search" />

 

F**K ME thats annoying.... it wasnt working cos there was no keywords the same..... SORRY..

is there a way for the search bar to search multiple fields?

 

also, how do i have an error message that say "the keywords "keywords they type" did not match any results" if there was no match..

and i have another big question... once the other two questions are answered


Thanks

 

$countQuery = "SELECT count(article_id) as count FROM articles WHERE keywords LIKE '%$keyword%' OR description LIKE '%$keyword%'";
$countResult = mysql_query($queryQuery);
$countArray = mysql_fetch_array($countResult);
$count = $countArray['count'];

if($count>0){
echo $count. ' results found for the keyword ' .$keyword;
}
else{
echo 'No results found for the keyword ' .$keyword;
}

PHP:

SELECT * FROM articles WHERE keywords LIKE '%$keyword%' OR description LIKE '%$keyword%'

Code (markup):

Didn't test these but they should work.

 

i got this warning

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/motorbik/public_html/new 2.php on line 55

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/motorbik/public_html/new 2.php on line 65

This is the code

<?php
            
            $keyword = $_GET['kw'];
            if(!empty($keyword)){
            require('connect.php');

            
            $countQuery = "SELECT count(article_id) as count FROM articles WHERE keyword LIKE '%$keyword%' OR description LIKE '%$keyword%'";
$countResult = mysql_query($queryQuery);
$countArray = mysql_fetch_array($countResult);
$count = $countArray['count'];

if($count>0){
echo $count. ' results found for the keyword &nbsp;' .$keyword;
}
else{
echo 'No results found for the keyword' .$keyword;
}
            
            while($row = mysql_fetch_array($result)) {
                echo ("<img src='arrow.gif'>"); echo "&nbsp;&nbsp;";
                echo '<a style="font-size: 20px" href="'. $row['url'] .'">'. $row['article_name'] .'</a>';
                echo "<br />";
            } 
            }
            ?>

PHP:

 

1. error:
I didn't remember your field names correctly keyword should be keywords and description should be Description.
2. error:
You have to make 2 different queries to get the count and the results. So you shouldn't have removed anything from the code.

 

So how would i set it out?

 

<?php
            
            $keyword = $_GET['kw'];
            if(!empty($keyword)){
            require('connect.php');

            
            $countQuery = "SELECT count(article_id) as count FROM articles WHERE keywords LIKE '%$keyword%' OR Description LIKE '%$keyword%'";
$countResult = mysql_query($countQuery);
$countArray = mysql_fetch_array($countResult);
$count = $countArray['count'];

if($count>0){
echo $count. ' results found for the keyword &nbsp;' .$keyword;


            
$query = "SELECT * FROM articles WHERE keywords LIKE '%$keyword%' OR Description LIKE '%$keyword%'";
$result = mysql_query($query);

while($row = mysql_fetch_array($result)) {
	echo ("<img src='arrow.gif'>"); echo "&nbsp;&nbsp;";
	echo '<a style="font-size: 20px" href="'. $row['url'] .'">'. $row['article_name'] .'</a>';
	echo "<br />";
} 
}
else{
echo 'No results found for the keyword' .$keyword;
}


}
?>

PHP:

 

hehe, cheers it works perfectly now.

is there a way i can add the search bar next to the heading image, and the results show on the main area of the page

 

How would i make it that when someone searches something it goes to a new page called "search" for instant?

 

Sure, it works the same way as static html would.

Save the PHP code as search.php or something and change forms action attribute to search.php.