Best unofficial Apache Server developers community

Answers

Displaying message when no results found in PHP MySQL search

⇧

⇩

138 views

I have a PHP search script which queries a MySQL database. Currently, when no results are displayed the script shows and error. How can I make it display a message like "No Results were found" when nothing is returned?

My PHP script is:

<?php

mysql_connect("localhost","username","password");
mysql_select_db("database");

if(!empty($_GET['q'])){
$query=mysql_real_escape_string(trim($_GET['q']));
$searchSQL="SELECT * FROM links WHERE `title` LIKE '%{$query}%'  LIMIT 8";
$searchResult=mysql_query($searchSQL);

while ($row=mysql_fetch_assoc($searchResult)){
    $results[]="<div class='webresult'><div class='title'><a href='{$row['url']}'>{$row['title']}</a></div><div class='desc'>{$row['description']}</div><div class='url'>{$row['url']}</div></div>";
}

echo implode($results);
}

?>

php mysql html sql

asked June 25, 2011 2:18 pm CDT

Callum Whyte

posted via StackOverflow

3 Answers

Newest Most Voted

⇧

⇩

if (empty($results)) { 
    echo 'No results found'; 
}

answered June 25, 2011 2:23 pm CDT

Sjoerd

⇧

⇩

You could also use the function mysql_num_rows, which will tell you the number of rows returned by your query.

$rows = mysql_num_rows($searchResult);
if($rows <= 0){
    /* Code if there are no rows */
}
else{
    /* More than one row has been found */
}

answered June 25, 2011 2:23 pm CDT

D Franks

⇧

⇩

if (mysql_num_rows($searchResult) == 0) {
   echo "some error message"; 
} else { 
  ... process data
}

answered June 25, 2011 2:23 pm CDT

Scott

Your answer

Similar discussion threads

Using Hibernate results in No message body writer found
January 10, 2011 04:35:31 PM
I have recently started using CXF to create a restful service that returns JSON output. Having first created a simple Hello World service to ensure my configuration was correct I then went on to elaborate the service. My next step was to return a…

Displaying results from MongoDb queries
November 15, 2010 12:40:57 PM
I am a .net developer who is pretty new to mongodb. I come from the rdbms world and I am... well spoiled by how you can manipulate data from a db query in C#. Because of Mongodb's document style, we have drastically changed the structure of how…

Re-Indexing results in invalid search results, when mappings are changed in a live system and re-app
November 17, 2010 02:32:29 PM
Hi I see the following issue with the current trunk build of ES. Scenario:

mysql module is not found
March 1, 2011 04:29:13 PM
hello list! could someone please offer an opinion as to why the mysql module I am attempting to include is not found? ## error [ro### @pdb1 ~]# puppetd --test err: Could not retrieve catalog from remote server: Error 400 on SERVER: Could not find…

Created: (HDFS-1609) rmr command is not displaying any error message when a path contains wildcard c
February 3, 2011 09:49:24 AM
rmr command is not displaying any error message when a path contains wildcard characters and does not exist.

Updated] (HIVE-867) Add add UDFs found in mysql
April 5, 2011 04:43:44 PM
[ https://issues.apache.org/jira/browse/HIVE-867?page=com.atlassian.jira .plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-867:

Outer query returning results not found in subquery
February 10, 2011 01:18:03 PM
Hi, I have a query that when executed stand-alone returns different results than when it's a subquery. At first I wasn't sure if it was just me, so I submitted a question to Stackoverflow with some detail and someone else replied that they could…

Ordered search results in Mongodb?
May 5, 2011 02:24:18 PM
Am doing a simple tag search using mongodb with data being stored in a list. Entity A {_id:...,tags : ['a','b','f']} Entity B {_id:...,tags : ['g','a','v']} Entity C {_id:...,tags : ['a','c','e']} Entity D {_id:...,tags : ['c','s','e']} Entity E…

Riak search providers no results
June 10, 2011 06:46:26 PM
I have a question for a first time riak search user. I installed riak search the wiki, added a pre commit index hook, created a bucket and inserted a key. The item in the bucket is a large json data set. It is here at: http://pastie.org/2049993…

Getting position of document in search results
April 13, 2011 02:59:19 AM
Hello. I use elasticsearch for search (java API) and would like to achieve following functionality: Having document id and query criteria (query, filters and sort specification) I'd like to get position of document with this id in search results of…

Getting the shared node path in search results
June 1, 2011 08:40:24 AM
Hi, I have a scenario for shared nodes. I have two users, foo and bar with their respective home folders /home/foo and /home/bar similar to what we have in a typical unix env. I have a document /home/foo/work/task1/sample.doc. However, I have a…

How to post a message in ActiveMQ from MySQL
July 7, 2010 12:45:33 AM
I want to post a message in ActiveMQ Queue on change in a table in MySQL. If the ActiveMQ is also persisted in MySQL database then is there a way to write a message in the Queue using SQL. We want to trigger a message whenever there is any…

Java API search returns no results... (JUnit test)
February 4, 2011 09:26:41 AM
Hi, I'm using Java API in a JUnit test to evaluate elasticsearch. Problem is I can't get any search results... getting document by id works fine but I see that the fields are not populated...even after explicitly mapping one the fields. is…

Updated: (MRM-1344) multiple versions appear in search results
June 16, 2011 09:49:32 PM
[ http://jira.codehaus.org/browse/MRM-1344?page=com.atlassian.jira.plugi n.system.issuetabpanels:all-tabpanel ] Greg Michael Meneses updated MRM-1344:

Commented: (MRM-1344) multiple versions appear in search results
June 17, 2011 06:28:39 AM
[ http://jira.codehaus.org/browse/MRM-1344?page=com.atlassian.jira.plugi n.system.issuetabpanels:comment-tabpanel&focusedCommentId=270646#c omment-270646 ] Maria Odea Ching commented on MRM-1344:

specifying fields in a search using the Java API results in no source being returned
April 6, 2011 07:46:20 AM
Hi, I am trying to search an index using the Java API, but only retrieve certain fields from it. I think I have encountered a situation where if one tries to specify any fields, using SearchRequestBuilder.addFields(), the source always comes back…

Updated: (MRM-1344) multiple versions appear in search results
June 17, 2011 07:58:17 AM
[ http://jira.codehaus.org/browse/MRM-1344?page=com.atlassian.jira.plugi n.system.issuetabpanels:all-tabpanel ] Greg Michael Meneses updated MRM-1344:

Wrong results when using Java search, correct when REST
January 31, 2011 05:25:00 AM
Hello, I'm using 0.15.0-SNAPSHOT. I'm getting different results when querying ES using JAVA/REST api. Correct results return when using the REST. I tried different things, all returned the same. Can you please explain what Am I doing wrong? For…

Re: Java API search returns no results... (JUnit test)
February 4, 2011 09:22:46 AM
Problem was how I created the mapping, jsonBuilder... creating it as a string and putting it the same way works fine...

Re: Java API search returns no results... (JUnit test)
February 4, 2011 09:22:47 AM
OK I don't get results since I don't have fields. Is this the correct way of mapping the document I've indexed?

Questions and Answers are licensed under cc-wiki license.

Displaying message when no results found in PHP MySQL search

3 Answers

Your answer

Join with account you already have