mysql搜索数据时如何显示空值错误信息

Question

我的网站上有 mysql 关键字搜索，效果很好。问题是当有人搜索我未添加的关键字时，结果页面上没有显示任何内容。我不想显示任何内容，而是希望显示“未找到结果”消息。我不完全理解如何执行此操作或将代码放置在哪里。我想代码会看起来像这样

If($row_record['image']?="")
{echo row
}else
echo "<p>no results we're found</p>"
}

我知道这段代码是错误的我对此仍然陌生，但我想它会看起来像那样。这是我的结果页面上的所有代码，以便您更好地理解，提前致谢。

<?php
#   BuildNav for Dreamweaver MX v0.2
#              10-02-2002
#   Alessandro Crugnola [TMM]
#   sephiroth: [email protected]
#   http://www.sephiroth.it
#   
#   Function for navigation build ::
function buildNavigation($pageNum_Recordset1,$totalPages_Recordset1,$prev_Recordset1,$next_Recordset1,$separator=" | ",$max_links=10, $show_page=true)
{
                GLOBAL $maxRows_Recordset1,$totalRows_Recordset1;
    $pagesArray = ""; $firstArray = ""; $lastArray = "";
    if($max_links<2)$max_links=2;
    if($pageNum_Recordset1<=$totalPages_Recordset1 && $pageNum_Recordset1>=0)
    {
        if ($pageNum_Recordset1 > ceil($max_links/2))
        {
            $fgp = $pageNum_Recordset1 - ceil($max_links/2) > 0 ? $pageNum_Recordset1 - ceil($max_links/2) : 1;
            $egp = $pageNum_Recordset1 + ceil($max_links/2);
            if ($egp >= $totalPages_Recordset1)
            {
                $egp = $totalPages_Recordset1+1;
                $fgp = $totalPages_Recordset1 - ($max_links-1) > 0 ? $totalPages_Recordset1  - ($max_links-1) : 1;
            }
        }
        else {
            $fgp = 0;
            $egp = $totalPages_Recordset1 >= $max_links ? $max_links : $totalPages_Recordset1+1;
        }
        if($totalPages_Recordset1 >= 1) {
            #   ------------------------
            #   Searching for $_GET vars
            #   ------------------------
            $_get_vars = '';            
            if(!empty($_GET) || !empty($HTTP_GET_VARS)){
                $_GET = empty($_GET) ? $HTTP_GET_VARS : $_GET;
                foreach ($_GET as $_get_name => $_get_value) {
                    if ($_get_name != "pageNum_Recordset1") {
                        $_get_vars .= "&$_get_name=$_get_value";
                    }
                }
            }
            $successivo = $pageNum_Recordset1+1;
            $precedente = $pageNum_Recordset1-1;
            $firstArray = ($pageNum_Recordset1 > 0) ? "<a href=\"$_SERVER[PHP_SELF]?pageNum_Recordset1=$precedente$_get_vars\">$prev_Recordset1</a>" :  "$prev_Recordset1";
            # ----------------------
            # page numbers
            # ----------------------
            for($a = $fgp+1; $a <= $egp; $a++){
                $theNext = $a-1;
                if($show_page)
                {
                    $textLink = $a;
                } else {
                    $min_l = (($a-1)*$maxRows_Recordset1) + 1;
                    $max_l = ($a*$maxRows_Recordset1 >= $totalRows_Recordset1) ? $totalRows_Recordset1 : ($a*$maxRows_Recordset1);
                    $textLink = "$min_l - $max_l";
                }
                $_ss_k = floor($theNext/26);
                if ($theNext != $pageNum_Recordset1)
                {
                    $pagesArray .= "<a href=\"$_SERVER[PHP_SELF]?pageNum_Recordset1=$theNext$_get_vars\">";
                    $pagesArray .= "$textLink</a>" . ($theNext < $egp-1 ? $separator : "");
                } else {
                    $pagesArray .= "$textLink"  . ($theNext < $egp-1 ? $separator : "");
                }
            }
            $theNext = $pageNum_Recordset1+1;
            $offset_end = $totalPages_Recordset1;
            $lastArray = ($pageNum_Recordset1 < $totalPages_Recordset1) ? "<a href=\"$_SERVER[PHP_SELF]?pageNum_Recordset1=$successivo$_get_vars\">$next_Recordset1</a>" : "$next_Recordset1";
        }
    }
    return array($firstArray,$pagesArray,$lastArray);
}
?>
<?php require_once('Connections/theconnect.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$maxRows_Recordset1 = 5;
$pageNum_Recordset1 = 0;
if (isset($_GET['pageNum_Recordset1'])) {
  $pageNum_Recordset1 = $_GET['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;

$colname_Recordset1 = "-1";
if (isset($_GET['textfield'])) {
  $colname_Recordset1 = $_GET['textfield'];
}
mysql_select_db($database_theconnect, $theconnect);
$query_Recordset1 = sprintf("SELECT *  FROM abstract  WHERE keyword LIKE %s OR id  LIKE %s  UNION ALL SELECT *  FROM cartoons  WHERE keyword LIKE %s OR id  LIKE %s  UNION ALL  SELECT *  FROM cute   WHERE keyword LIKE %s OR id  LIKE %s  UNION ALL  SELECT * FROM fashion  WHERE keyword LIKE %s OR id  LIKE %s  UNION ALL  SELECT * FROM forguys  WHERE keyword LIKE %s OR id  LIKE %s  UNION ALL  SELECT *  FROM hiphop  WHERE keyword LIKE %s OR id  LIKE %s  UNION ALL  SELECT *  FROM movies WHERE keyword LIKE %s OR id  LIKE %s  UNION ALL  SELECT *  FROM other  WHERE keyword LIKE %s OR id  LIKE %s  UNION ALL  SELECT *  FROM pop  WHERE keyword LIKE %s OR id  LIKE %s  UNION ALL  SELECT *  FROM quotes  WHERE keyword LIKE %s OR id  LIKE %s  UNION ALL SELECT * FROM rnb WHERE keyword LIKE %s OR id  LIKE %s  UNION ALL SELECT * FROM random WHERE keyword LIKE %s OR id  LIKE %s  UNION ALL SELECT * FROM rock WHERE keyword LIKE %s OR id  LIKE %s  UNION ALL SELECT * FROM sports WHERE keyword LIKE %s OR id  LIKE %s  ", GetSQLValueString("%" . $colname_Recordset1 . "%", "text"),GetSQLValueString("%" . $colname_Recordset1 . "%", "text"),GetSQLValueString("%" . $colname_Recordset1 . "%", "text"),GetSQLValueString("%" . $colname_Recordset1 . "%", "text"),GetSQLValueString("%" . $colname_Recordset1 . "%", "text"),GetSQLValueString("%" . $colname_Recordset1 . "%", "text"),GetSQLValueString("%" . $colname_Recordset1 . "%", "text"),GetSQLValueString("%" . $colname_Recordset1 . "%", "text"),GetSQLValueString("%" . $colname_Recordset1 . "%", "text"),GetSQLValueString("%" . $colname_Recordset1 . "%", "text"),GetSQLValueString("%" . $colname_Recordset1 . "%", "text"),GetSQLValueString("%" . $colname_Recordset1 . "%", "text"),GetSQLValueString("%" . $colname_Recordset1 . "%", "text"),GetSQLValueString("%" . $colname_Recordset1 . "%", "text"),GetSQLValueString("%" . $colname_Recordset1 . "%", "text"),GetSQLValueString("%" . $colname_Recordset1 . "%", "text"),GetSQLValueString("%" . $colname_Recordset1 . "%", "text"),GetSQLValueString("%" . $colname_Recordset1 . "%", "text"),GetSQLValueString("%" . $colname_Recordset1 . "%", "text"),GetSQLValueString("%" . $colname_Recordset1 . "%", "text"),GetSQLValueString("%" . $colname_Recordset1 . "%", "text"),GetSQLValueString("%" . $colname_Recordset1 . "%", "text"),GetSQLValueString("%" . $colname_Recordset1 . "%", "text"),GetSQLValueString("%" . $colname_Recordset1 . "%", "text"),GetSQLValueString("%" . $colname_Recordset1 . "%", "text"),GetSQLValueString("%" . $colname_Recordset1 . "%", "text"),GetSQLValueString("%" . $colname_Recordset1 . "%", "text"),GetSQLValueString("%" . $colname_Recordset1 . "%", "text"));
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $theconnect) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);

if (isset($_GET['totalRows_Recordset1'])) {
  $totalRows_Recordset1 = $_GET['totalRows_Recordset1'];
} else {
  $all_Recordset1 = mysql_query($query_Recordset1);
  $totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="description" content="do this later"/>
<meta name="keywords" content="words and phrases for my site"/>
<title>mysite</title>
<style type="text/css">
body {
    margin-top: -3px;
    margin-bottom: -3px;
    background-image: url(images/bg.png);
    background-repeat: repeat;
}
</style>
<link href="css/style.css" rel="stylesheet" type="text/css" />
<script type="text/xml">
<!--
<oa:widgets>
  <oa:widget wid="2149022" binding="#OAWidget" />
</oa:widgets>
-->
</script>
</head>

<body>
<div id="shadow">
  <table width="910" border="0" align="center">
    <tr>
      <td bgcolor="#FFFFFF"><div id="header">
        <form id="form1" name="form1" method="get" action="results.php">
          <div id="headlinksR">
            <?php require_once('includes/header_nav.php'); ?>
          </div>
          <span class="searchbar">
            <input name="textfield" type="text" class="tfield_position" id="textfield" value="" />
            <input name="button" type="submit" class="search" id="button" value="Search!" />
            </span>
        </form>
        <?php require_once('includes/logo.php'); ?>
      </div>
        <div id="bodywrap">
          <div id="content">
            <div id="bannerad">
              <?php require_once('includes/banner_ad.php'); ?>
            </div>
            <div class="Csepbar">do this later</div>
            <div id="centerhold">
              <div id="adhold">
                <?php require_once('includes/center_ad.php'); ?>
              </div>
              <div id="fbapi">
                <?php require_once('includes/fb_api.php'); ?>
              </div>
            </div>
            <div class="Csepbar"> Results!</div>
            <div id="covers">
              <table align="center" cellspacing="5">
                <?php do { ?>
                <tr>
                  <td class="text"><div id="coverlike">
                    <script type="text/javascript">
// BeginOAWidget_Instance_2149022: #OAWidget

    var urlToLike = 'view.php?id=<?php echo $row_Recordset1['id']; ?>&image=<?php echo $row_Recordset1['image']; ?>';
    if (urlToLike == '') {
            urlToLike = window.location.href;
      }
      urlToLike = encodeURIComponent(urlToLike);

      var font = encodeURIComponent('arial');


document.write ('<iframe src="http://www.facebook.com/widgets/like.php?locale=en_US&amp;href='+urlToLike+'&amp;layout=button_count&amp;show_faces=true&amp;width=50&amp;height=20&amp;action=like&amp;font='+font+'&amp;colorscheme=light" scrolling="no" frameborder="0" allowTransparency="true" style="border:hidden; border-color:#ffffff; overflow:hidden; width:50; height:20"></iframe>')


// EndOAWidget_Instance_2149022
                      </script>
                  </div>
                    <div id="cname"><?php echo $row_Recordset1['name']; ?></div></td>
                </tr>
                <tr>
                  <td><img src="<?php echo $row_Recordset1['image']; ?>" alt="facebook cover" width="500" height="200" /></td>
                </tr>
                <tr>
                  <td><a href="view.php?id=<?php echo $row_Recordset1['id']; ?>&amp;image=<?php echo $row_Recordset1['image']; ?>"><img src="images/bar_bg.png" alt="Facebook Covers" width="500" height="30" border="0" /></a></td>
                </tr>
                <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
              </table>
            </div>
            <div id="pagination"><span class="pagination">
              <?php 
# variable declaration
$prev_Recordset1 = "« previous";
$next_Recordset1 = "next »";
$separator = " | ";
$max_links = 5;
$pages_navigation_Recordset1 = buildNavigation($pageNum_Recordset1,$totalPages_Recordset1,$prev_Recordset1,$next_Recordset1,$separator,$max_links,true); 

print $pages_navigation_Recordset1[0]; 
?>
              <?php print $pages_navigation_Recordset1[1]; ?> <?php print $pages_navigation_Recordset1[2]; ?></span></div>
          </div>
          <div id="sidenav">
            <div id="fb_like">
              <?php require_once('includes/fb_like.php'); ?>
            </div>
            <div class="sepbar">
              <p class="sepbarT">Categories</p>
            </div>
            <?php require_once('includes/side_nav.php'); ?>
            <div class="sepbar">
              <p span class="sepbarT">Sponsored By</p>
            </div>
            <div id="sidenavad">
              <?php require_once('includes/side_ad.php'); ?>
            </div>
          </div>
        </div>
        <div id="footer">
          <?php require_once('includes/footer.php'); ?>
        </div></td>
    </tr>
  </table>
</div>
<script type="text/javascript">
var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
</script>
<script type="text/javascript">
var pageTracker = _gat._getTracker("UA-27886561-1");
pageTracker._initData();
pageTracker._trackPageview();
</script>
</body>
</html>
<?php
mysql_free_result($Recordset1);
?>

Answer 1

您将需要使用mysql_num_rows。
例如。

$query = mysql_query('SELECT `col` FROM `tbl` WHERE `cond`');

if (mysql_num_rows($query) <= 0) {
   // no results
   echo 'No results found.';
} else {
   do {
    // output
   } while($res = mysql_fetch_assoc($query));
}

请参阅： http://php.net/manual/en/function.mysql -num-rows.php

Answer 2

或者您可以将 sql 结果放入数组或列表中并检查 null 或大小。
顺便说一下，如果数据库中有超过 100000 条记录，你的搜索 sql 将会非常慢。