How to add a "No results found" message using PHP?

Question

I am currently building a website that relies on pulling information from my localhost database through a search bar. I currently have it displaying all the information correctly, but when a search doesn't match anything in my database then it just shows nothing, how do I change this to "No results found" or something of the sort? My code is:

<?php

    require_once 'connect.php';

    if(isset($_GET['keywords'])){

        $keywords = $db->escape_string($_GET['keywords']);  

        $query = $db->query("
                        SELECT movie, game
                        FROM movies
                        WHERE movie LIKE '%{$keywords}%'
                     ");
?>

<!doctype html>
<html>
<head>
    <meta charset="UTF-8">
    <title>Example</title>
    <link rel="stylesheet" type="text/css" href="styles.css">
</head>

<body>
    <h1><a href="index.php">Test</a></h1>
    <div class="search">
        <form action="search.php" method="get">
            <input name="keywords" type="text" placeholder="Type something!" autocomplete="off" size="40">
            <input type="submit" value="Search!">
        </form>
    </div>
<br />
<?php

    if($query->num_rows){
        while($r = $query->fetch_object()){
        ?>
    <div class="movie"> <a><?php echo $r->movie; ?></a> </div><br />
    <div class="result"> <a><?php echo $r->game; ?></a> </div><br />
</body>
</html>
<?php
    }
}

}

Sorry for pasting literally the full page, but I don't even know where to start as I'm a PHP noob.

if($query->num_rows){...}else{echo "NO RESULT FOUND";}

Farhan
– Farhan

2015-12-16 19:23:52 +00:00
Commented Dec 16, 2015 at 19:23 — Farhan
– Farhan, Commented Dec 16, 2015 at 19:23

Mi-Creativity · Accepted Answer · 2015-12-16 19:38:45Z

if($query->num_rows){..} condition will be true if query result have more then 0 results, so just use else part to print message that no result(s) found

<?php

    require_once 'connect.php';

    if(isset($_GET['keywords'])){

    $keywords = $db->escape_string($_GET['keywords']);  

    $query = $db->query("
    SELECT movie, game
    FROM movies
    WHERE movie LIKE '%{$keywords}%'
    ");
    ?>

    <!doctype html>
    <html>
    <head>
    <meta charset="UTF-8">
    <title>Example</title>
    <link rel="stylesheet" type="text/css" href="styles.css">
    </head>

    <body>
    <h1><a href="index.php">Test</a></h1>
    <div class="search">
      <form action="search.php" method="get">
        <input name="keywords" type="text" placeholder="Type something!" autocomplete="off" size="40">
        <input type="submit" value="Search!">
      </form>
    </div>
    <br />
    <?php

    if($query->num_rows){
        while($r = $query->fetch_object()){
            ?>
    <div class="movie"> <a><?php echo $r->movie; ?></a> </div><br />
    <div class="result"> <a><?php echo $r->game; ?></a> </div><br />
    </body>
    </html>
    <?php
        }
    }
    else{
        echo "No Result Found!";
        }

    }

Nana Partykar · Accepted Answer · 2015-12-16 19:46:51Z

0

<?php

require_once 'connect.php';

if(isset($_GET['keywords']))
{
    $keywords = $db->escape_string($_GET['keywords']);  
    $query = $db->query("SELECT movie, game FROM movies WHERE movie LIKE '%{$keywords}%'");
    ?>
    <!doctype html>
    <html>
    <head>
    <meta charset="UTF-8">
    <title>Example</title>
    <link rel="stylesheet" type="text/css" href="styles.css">
    </head>
    <body>
    <h1><a href="index.php">Test</a></h1>
    <div class="search">
        <form action="search.php" method="get">
          <input name="keywords" type="text" placeholder="Type something!" autocomplete="off" size="40">
          <input type="submit" value="Search!">
        </form>
    </div>
    <br />
    <?php
    if($query->num_rows)
    {
        while($r = $query->fetch_object())
        {
        ?>
        <div class="movie"> <a><?php echo $r->movie; ?></a> </div><br />
        <div class="result"> <a><?php echo $r->game; ?></a> </div><br />
        <?}
    }
    else {?>
     <div class="noResult">No Results Found</div>
    <?}?>
    </body>
    </html>
<?php }?>

styles.css (Here, using this class name, whatever property you want you can set. I gave few. Example.)

.noResult{
color: #800000;
font-size:14 px;
}

edited Dec 16, 2015 at 19:46

answered Dec 16, 2015 at 19:27

Nana Partykar

10.5k10 gold badges50 silver badges79 bronze badges

2 Comments

DavidDuffy95 Over a year ago

How would I go about stylising the "No results found" in CSS? What should I put inside a div?

Nana Partykar Over a year ago

I've updated my answer. Please have a look. You need to create one <div></div> in page. See my answer. @DavidDuffy95

Santy · Accepted Answer · 2015-12-16 19:34:46Z

0

to fit with your opening and closing tags you can use:

if($query->num_rows){
    while($r = $query->fetch_object()){
    ?>
<div class="movie"> <a><?php echo $r->movie; ?></a> </div><br />
<div class="result"> <a><?php echo $r->game; ?></a> </div><br />

<?php
    } 
} else {
    ?>
        <div>No results</div>
    <?php
}
?>
</body>
</html>

do keep the /body and /html tags after any output.

answered Dec 16, 2015 at 19:34

Santy

3872 silver badges7 bronze badges

1 Comment

DavidDuffy95 Over a year ago

I get a Syntax error when I do this. Any ideas why?

Collectives™ on Stack Overflow

How to add a "No results found" message using PHP?

3 Answers 3

Comments

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related