如何使用查询将查询中的产品显示在产品布局页面上 - How do i use a query to display products from a query onto a product layout page

How do i use a query to display products from a query onto a product layout page

本文关键字：查询布局显示何使用 | 更新日期: 2023-09-27

函数

product()用于名为products.php的页面。如何使从该搜索(耐克运动鞋(返回的每个产品都成为指向名为product.php的页面的可点击链接，并仅在product.php上的div上显示该产品信息？

/*
 * This function is used for products.php page,(search page)
 */
function product ()
{
    $get = mysql_query ("SELECT id, name, price, size, imgcover FROM products WHERE brand='nike'");
    if (mysql_num_rows($get) == FALSE)
        { echo " There are no products to be displayed!";}
    else
        { while ($get_row = mysql_fetch_assoc($get)){echo "<div id='productbox'><a href='product.php'>".$get_row['name'].'<br /> £'.$get_row['price']. '  UK'.$get_row['size']. '<br />' .$get_row['imgcover']. "</a></div>" ;} 
    }
}
/* The function productlayout () I am using for the product.php page and I am echoing this onto this page.  */
function productlayout ()
{
    $get = mysql_query ("SELECT id, name, price, size, buyfor, exfor, grade, brand, Basecolour,     imgcover FROM products WHERE id ='1'");
    if (mysql_num_rows($get) == FALSE)
        { echo " There are no products to be displayed!";}
    else
        { while ($get_row = mysql_fetch_assoc($get))
            { echo "<div id='layouttitle'>".$get_row['name']."</div>
                <br /> <div id='layoutprice'>£".$get_row['price']. "</div>
                <div id='layoutsize'>UK".$get_row['size']. "</div>
                <br /><div id='layoutgrade'>Condition  " .$get_row['grade']. "</div>
                <div id='layoutbrand'>" .$get_row['brand']. "</div>
                <div id='layoutbcolour'>Base Colour - " .$get_row['Basecolour']. "</div>
                <div id='givecash'>" .$get_row['buyfor']. "</div>
                <div id='giveexchange'>" .$get_row['exfor']. "</div>";
        } 
    }
}

任何帮助都会很棒，已经为此苦苦挣扎了一段时间了！

在函数中传递搜索参数并自定义它，如下所示

  function product ($product =NULL)
 {
 if(!empty($product)){
      $get = mysql_query ("SELECT id, name, price, size, imgcover FROM products
 WHERE brand='nike' AND `name` LIKE '%".$product."%'");
 }else{
 $get = mysql_query ("SELECT id, name, price, size, imgcover FROM products 
 WHERE brand='nike'");
 }
 if (mysql_num_rows($get) == FALSE)
 { echo " There are no products to be displayed!";}
 else
 {while ($get_row = mysql_fetch_assoc($get)){echo "<div id='productbox'><a href='product.php'>".$get_row['name'].'<br /> £'.$get_row['price']. '  UK'.$get_row['size']. '<br />' .$get_row['imgcover']. "</a></div>" ;} 
 }
 }

相同的if else块和参数，用于productlayout ($product)并在查询中使用它

请不要在新代码中使用mysql_*函数。它们不再维护并被正式弃用。看到红框了吗？请改为了解预准备语句，并使用 PDO 或 MySQLi - 本文将帮助您决定哪个语句。如果您选择PDO，这是一个很好的教程。