Throws an error (mysql_num_rows() expects parameter 1). Categories of goods on the site. How to fix?

M

mazzad0x2018-04-16 18:55:32

PHP

mazzad0x, 2018-04-16 18:55:32

spoiler

<?php
  include("include/db_connect.php");
    include("functions/functions.php");
    session_start();
    include("include/auth_cookie.php");

$go = clear_string($_GET["go"]);
    
    switch ($go) {

      case "tshirt":     
      $query_aystopper= " WHERE visible = '1' AND Type = '1'";
        $name_aystopper = "Футболки";
      break;

      case "sweatshirts":
      $query_aystopper= " WHERE visible = '1' AND Type = '2'";
        $name_aystopper = "Толстовки";
      break;

      case "trousers":
      $query_aystopper= " WHERE visible = '1' AND Type = '3'";
        $name_aystopper = "Брюки";
      break;
        
        case "mousepad":
      $query_aystopper= " WHERE visible = '1' AND Type = '4'";
        $name_aystopper = "Коврики";
      break;
        
        case "pendant":
      $query_aystopper= " WHERE visible = '1' AND Type = '5'";
        $name_aystopper = "Брелки";
      break;
        
        case "glass":
      $query_aystopper= " WHERE visible = '1' AND Type = '6'";
        $name_aystopper = "Кружки";
      break;
        
        case "phonecovers":
      $query_aystopper= " WHERE visible = '1' AND Type = '7'";
        $name_aystopper = "Чехлы";
      break;
        
      default:
        $query_aystopper = "";  
      break;
} 

$sorting = $_GET["sort"];

switch ($sorting){
    case 'price-asc';
    $sorting = 'price ASC';
    $sort_name = 'От дешевых к дорогим';
    break;

    case 'price-desc';
    $sorting = 'price DESC';
    $sort_name = 'От дорогих к дешевым';
    break;

    case 'popular';
    $sorting = 'count DESC';
    $sort_name = 'Популярное';
    break;

    case 'news';
    $sorting = 'datetime DESC';
    $sort_name = 'Новинки';
    break;

    case 'title';
    $sorting = 'title';
    $sort_name = 'От А до Я';
    break;

    default:
    $sorting = 'products_id DESC';
    $sort_name = 'Нет сортировки';
    break;
}
?>
<!DOCTYPE html>

<head>
  <meta http-equiv="content-type" content="text/html; charset=utf-8" />
    <link href="css/reset.css" rel="stylesheet" type="text/css" />
    <link href="css/style.css" rel="stylesheet" type="text/css" />
    <script type="text/javascript" src="/js/jquery-1.8.2.min.js"></script>
    <script type="text/javascript" src="/js/jquery-migrate-1.4.1.min.js"></script>
    <script type="text/javascript" src="/js/shop-script.js"></script>
    <script type="text/javascript" src="/js/jquery.cookie.min.js"></script>
    
    <script type="text/javascript" src="/js/jquery.form.js"></script>
    <script type="text/javascript" src="/js/jquery.validate.js"></script>
  <script type="text/javascript" src="/js/TextChange.js"></script>
    <title>Сувениры и игровая аттрибутика из CSGO</title>
</head>
<body>

<div id="block-line"></div>

<div id="block-body">

<?php
    include("include/block-header.php");
?>

<?php
    include("include/top-menu.php");
?>

<div id="block-content">

<div id="block-sorting">
<p id="nav-breadcrumbs"><a href="index.php">Главная страница</a> \ <span>Все товары</span></p>
<ul id="options-list">
<li>Вид:</li>
<li><img id="style-grid" src="/images/icon-grid.png"/></li>
<li><img id="style-list" src="/images/icon-list.png"/></li>
<li>Сортировать:</li>
<li><a id="select-sort"><?php echo $sort_name ?></a>
<ul id="sorting-list">
<li><a href="index.php?sort=price-asc">От дешевых к дорогим</a></li>
<li><a href="index.php?sort=price-desc">От дорогих к дешевым</a></li>
<li><a href="index.php?sort=popular">Популярное</a></li>
<li><a href="index.php?sort=news">Новинки</a></li>
<li><a href="index.php?sort=title">От А до Я</a></li>
</ul>
</li>
</ul>
</div>

<ul id="block-tovar-grid">
    <?php

    $num = 6; // Количество товаров на вывод
    $page = (int)$_GET['page'];

    $count = mysql_query("SELECT COUNT(*) FROM table_products $query_aystopper",$link);
    $temp = mysql_fetch_array($count);

    if ($temp[0] > 0){
        $tempcount = $temp[0];

        // Находим общее число страниц
        $total = (($tempcount - 1) / $num) +1;
        $total = intval($total);

        $page = intval($page);

        if(empty($page) or $page < 0) $page = 1;
            if($page > $total) $page = $total;

            // Вычисляем начиная с какого номера
            // Следует выводить товары
            $start = $page * $num - $num;

            $qury_start_num = " LIMIT $start, $num";
    }

     $result = mysql_query("SELECT * FROM table_products $query_aystopper ORDER BY $sorting $qury_start_num",$link);
     if (mysql_num_rows($result) > 0 )
      {
       $row = mysql_fetch_array($result);

       do
       {

        if ($row["image"] != "" && file_exists("./uploads_images/".$row["image"]))
        {
        $img_path = './uploads_images/'.$row["image"];
        $max_width = 200;
        $max_height = 200;
        list($width, $height) = getimagesize($img_path);
        $ratioh = $max_height/$height;
        $ratiow = $max_width/$width;
        $ratio = min($ratioh, $ratiow);
        $width = intval($ratio*$width);
        $height = intval($ratio*$height);
        }else
        {
        $img_path = "/images/no_images.png";
        $width = 110;
        $height = 200;
        }

        echo '

        <li>
         <div class="block-images-grid">
          <img src="'.$img_path.'" width ="'.$width.'" height = "'.$height.'" />
         </div>
         <p class="style-title-grid"> <a href="">'.$row["title"].'</a></p>
         <ul class="reviews-and-counts-grid">
         <li><img src="/images/eye-icon.png" /><p>0</p></li>
         <li><img src="/images/comment-icon.png" /><p>0</p></li>
         </ul>
         <a class="add-cart-style-grid"></a>
         <p class="style-price-grid"><strong>'.$row["price"].'</strong> руб.</p>
         <div class="mini-features">
         '.$row["mini_features"].'
         </div>
        </li>
        ';

       }

       while ($row = mysql_fetch_array($result));
      }
    ?>

   </ul>


 <ul id="block-tovar-list">
    <?PHP
     $result = mysql_query("SELECT * FROM table_products WHERE $query_aystopper ORDER BY $sorting $qury_start_num",$link);
     if (mysql_num_rows($result) > 0 )
      {
       $row = mysql_fetch_array($result);

       do
       {

        if ($row["image"] != "" && file_exists("./uploads_images/".$row["image"]))
        {
        $img_path = './uploads_images/'.$row["image"];
        $max_width = 150;
        $max_height = 150;
        list($width, $height) = getimagesize($img_path);
        $ratioh = $max_height/$height;
        $ratiow = $max_width/$width;
        $ratio = min($ratioh, $ratiow);
        $width = intval($ratio*$width);
        $height = intval($ratio*$height);
        }else
        {
        $img_path = "/images/noimages80x70.png";
        $width = 80;
        $height = 70;
        }

        echo '

        <li>
         <div class="block-images-list">
          <img src="'.$img_path.'" width ="'.$width.'" height = "'.$height.'" />
         </div>

         <ul class="reviews-and-counts-list">
         <li><img src="/images/eye-icon.png" /><p>0</p></li>
         <li><img src="/images/comment-icon.png" /><p>0</p></li>
         </ul>

         <p class="style-title-list"> <a href="">'.$row["title"].'</a></p>

         <a class="add-cart-style-list"></a>
         <p class="style-price-list"><strong>'.$row["price"].'</strong> руб.</p>
         <div class="style-text-list">
         '.$row["mini_description"].'
         </div>
        </li>
        ';

       }

       while ($row = mysql_fetch_array($result));
      }

echo '</ul>';

if ($page != 1){ $pstr_prev = '<li><a class="pstr-prev" href="index.php?page='.($page - 1).'">&lt;</a></li>';}
if ($page != $total) $pstr_next = '<li><a class="pstr-next" href="index.php?page='.($page + 1).'">&gt;</a></li>';


// Формируем ссылки со страницами
if($page - 5 > 0) $page5left = '<li><a href="index.php?page='.($page - 5).'">'.($page - 5).'</a></li>';
if($page - 4 > 0) $page4left = '<li><a href="index.php?page='.($page - 4).'">'.($page - 4).'</a></li>';
if($page - 3 > 0) $page3left = '<li><a href="index.php?page='.($page - 3).'">'.($page - 3).'</a></li>';
if($page - 2 > 0) $page2left = '<li><a href="index.php?page='.($page - 2).'">'.($page - 2).'</a></li>';
if($page - 1 > 0) $page1left = '<li><a href="index.php?page='.($page - 1).'">'.($page - 1).'</a></li>';

if($page + 5 <= $total) $page5right = '<li><a href="index.php?page='.($page + 5).'">'.($page + 5).'</a></li>';
if($page + 4 <= $total) $page4right = '<li><a href="index.php?page='.($page + 4).'">'.($page + 4).'</a></li>';
if($page + 3 <= $total) $page3right = '<li><a href="index.php?page='.($page + 3).'">'.($page + 3).'</a></li>';
if($page + 2 <= $total) $page2right = '<li><a href="index.php?page='.($page + 2).'">'.($page + 2).'</a></li>';
if($page + 1 <= $total) $page1right = '<li><a href="index.php?page='.($page + 1).'">'.($page + 1).'</a></li>';

if ($page+5 < $total)
{
    $strtotal = '<li><p class="nav-point">...</p></li><li><a href="index.php?page='.$total.'">'.$total.'</a></li>';
}else
{
    $strtotal = "";
}

if ($total > 1)
{
    echo '
    <div class="pstrnav">
    <ul>
    ';
    echo $pstr_prev.$page5left.$page4left.$page3left.$page2left.$page1left."<li><a class='pstr-active' href='index.php?page=".$page."'>".$page."</a></li>".$page1right.$page2right.$page3right.$page4right.$page5right.$strtotal.$pstr_next;
    echo '
    </ul>
    </div>
    ';
}
    ?>



</div>


<?php
    include("include/block-footer.php");
?>
</ul>

</div>

</body>
</html>

Actually I wanted to make a conclusion of goods from the database by category. I found a video tutorial where the guy made a conclusion of the popular / sales, etc., just remade his request for his own, but that's bad luck, it started to give an error.
(Warning
: mysql_num_rows() expects parameter 1 to be resource, boolean given in
D:\OpenServer\OSPanel\domains\localhost\view_aystopper.php
on line
221)
221 lines - if (mysql_num_rows($result) > 0 )

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

M

mazzad0x, 2018-04-16
@mazzad0x

Initially, I took the index page, transferred everything from there and added a couple of lines. Namely:

spoiler

$go = clear_string($_GET["go"]);
switch ($go) {
case "tshirt":
$query_aystopper= " WHERE visible = '1' AND Type = '1'";
$name_aystopper = "Футболки";
break;
case "sweatshirts":
$query_aystopper= " WHERE visible = '1' AND Type = '2'";
$name_aystopper = "Толстовки";
break;
case "trousers":
$query_aystopper= " WHERE visible = '1' AND Type = '3'";
$name_aystopper = "Брюки";
break;
case "mousepad":
$query_aystopper= " WHERE visible = '1' AND Type = '4'";
$name_aystopper = "Коврики";
break;
case "pendant":
$query_aystopper= " WHERE visible = '1' AND Type = '5'";
$name_aystopper = "Брелки";
break;
case "glass":
$query_aystopper= " WHERE visible = '1' AND Type = '6'";
$name_aystopper = "Кружки";
break;
case "phonecovers":
$query_aystopper= " WHERE visible = '1' AND Type = '7'";
$name_aystopper = "Чехлы";
break;
default:
$query_aystopper = "";
break;
}

and changed a couple of lines like this:

spoiler

$result = mysql_query("SELECT * FROM table_products WHERE $query_aystopper ORDER BY $sorting $qury_start_num",$link);