php搜索引擎关键字不起作用

Question

When i would search for the keywords that i have specified in my database it will return everything from my database not just the corresponding links that have the keywords attached to the link. here is my code

        <?php
        $q = $_GET['q'];
        $terms = explode(" ", $q);
        $query = "SELECT * FROM search ";

        foreach ($terms as $each){
            $i=0;
            $i++;
                if ($i == 1)
                    $query .= "keywords LIKE '%$each%' ";
                else
                    $query .= "OR keywords LIKE '%$each%' ";

        }

        //connect
        mysql_connect("localhost", "root", "");
        mysql_select_db("search");

        $query = mysql_query("SELECT * FROM search");
        $numrows = mysql_num_rows($query);
        if ($numrows > 0){      

            while($row = mysql_fetch_assoc($query)){
                $id = $row['id'];
                $title = $row['title'];
                $description = $row['description'];
                $keywords = $row['keywords'];
                $link = $row['link'];

                echo "<h3><a href='$link'>$title</a></h3><h4>$link</h4>$description<br /><br />";
            }
        }
        else
            echo "<b>No Results Found</b><br><br>Suggestions:<br>
                Make sure all words are spelled correctly.<br>
                Try different keywords.<br>
                Try more general keywords.";

        //disconnect
        mysql_close();

    ?>

Answer 1

 <?php
    $q = $_GET['q'];
    $terms = explode(" ", $q);

    //connect
    mysql_connect("localhost", "root", "");
    mysql_select_db("search");

    $query = "SELECT * FROM search ";

    $i=1;
    foreach ($terms as $each){
        if ($i == 1) {
            $query .= "WHERE ";
            $query .= "keywords LIKE '" . mysql_real_escape_string("%" . $each . "%") . "' ";
        } else {
            $query .= "OR keywords LIKE '" . mysql_real_escape_string("%" . $each . "%") . "' ";
        }
        $i++;
    }

    $query = mysql_query($query);
    $numrows = mysql_num_rows($query);
    if ($numrows > 0){      

        while($row = mysql_fetch_assoc($query)){
            $id = $row['id'];
            $title = $row['title'];
            $description = $row['description'];
            $keywords = $row['keywords'];
            $link = $row['link'];

            echo "<h3><a href='$link'>$title</a></h3><h4>$link</h4>$description<br /><br />";
        }
    } else {
        echo "<b>No Results Found</b><br><br>Suggestions:<br>
            Make sure all words are spelled correctly.<br>
            Try different keywords.<br>
            Try more general keywords.";
    }
    //disconnect
    mysql_close();

?>

Fixes:

1) Removed second $query that was being defined. It selected all rows.

2) Moved initial $i declaration. It was being set back to 0 each loop.

3) Added WHERE

4) Moved $i++ after the if statement and set initial $i to 1.

5) Added mysql_real_escape_string so that data is escaped properly.

Recommendations:

I highly recommend taking a look at MySQLi (http://us2.php.net/mysqli) or PDO (http://us3.php.net/pdo)

Please let me know if this works or if you need further assistance.