PHP Search Script not working

Question

I am trying to run a simple PHP search script that will show look through my mySQL database and present the results on a separate page that I've created. When I run the code, my results don't show up. Can someone please help me?? This is the code that i'm currently using:

<?php

    error_reporting(E_A`enter code here`LL);
    ini_set('display_errors', 1);

        $k = $_GET['k'];
        $terms = explode(" ", $k);
        $query = "SELECT * FROM search WHERE ";

        $i = 0;
        foreach ($terms as $each){
            $i++; 

            if ($i == 1) 
            {
                $query .= "keywords LIKE '%$each%' ";
            }           
            else
            {
                $query .= "OR keywords LIKE '%$each%' ";
            }   
    }

        // connect
        mysql_connect("josetogbecom.fatcowmysql.com","username","password");
        mysql_select_db("gff_hff6a144eg");

        $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 "<h2><a href='$link'>$title</a></h2>
                $description<br /><br />";
            }   

        }
        else 
        {
            echo "No Search Results Were Found for \"<b>$k<b>\"";
        }


        // disconnect
        mysql_close();

    ?>

Thanks in advance!

You have a username and password in clear text! Edit it, quick! — dwjv
– dwjv, Commented Apr 24, 2014 at 15:15
error_reporting(E_Aenter code hereLL); this is wrong, should be error_reporting(E_ALL);. — user997172
– user997172, Commented Apr 24, 2014 at 15:34

Rubensito · Accepted Answer · 2014-04-24 15:18:44Z

1

Check if your $i counter var is set to $i=0 before foreach loop

answered Apr 24, 2014 at 15:18

Rubensito

1026 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user997172 · Accepted Answer · 2014-04-24 15:23:23Z

1

Bug at this line:

echo "No Search Results Were Found for \"<b>$k<b>/"";

Should be:

echo "No Search Results Were Found for \"<b>$k<b>\"";

Bug at this line:

mysql close();

Should be:

mysql_close();

Bug at this line:

$i++;

You should always initialize your variables, like this:

$i = 0;
foreach ($terms as $each){
    $i++;

    if ($i == 1)
        $query .= "keywords LIKE '$each%' ";
    else
        $query .= "OR keywords LIKE '$each%' ";
}

If the script still doesn't work after correcting these two bugs, add to the beginning of the script these 2 lines and tell us what you see:

error_reporting(E_ALL);
ini_set('display_errors', 1);

answered Apr 24, 2014 at 15:23

user997172

6 Comments

user3417199 Over a year ago

Thanks! but the search results are still not appearing!

user997172 Over a year ago

@user3417199 If still nothing than add those last two lines right after <?php and tell us what you see.

user3417199 Over a year ago

this is what I see: 0){ while ($row = mysql_fetch_assoc($query)){ $id = $row['id']; $title = $row['title']; $description = $row['description']; $keywords = $row['keywords']; $link = $row['link']; echo " $title $description "; } } else { echo "No Search Results Were Found for \"$k\""; } // disconnect mysql_close(); ?>

user3417199 Over a year ago

My script worked! I just wanted to thank you all for helping and being patient!

user997172 Over a year ago

@user3417199 No problem, thats what this site is for.

|

Collectives™ on Stack Overflow

PHP Search Script not working

2 Answers 2

Comments

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related