include("db_conn.php");
include("db_func.php");
// 取出資料庫中與使用者搜尋字串相似的資料 BEGIN
$SQLStr = "SELECT product.*, class.* FROM product AS product LEFT JOIN class AS class ON product.c_id = class.c_id";
$SQLStr .= " WHERE product.p_name LIKE '%" . $search_str . "%' ";
$SQLStr .= "OR product.p_info LIKE '%" . $search_str . "%' ORDER BY product.c_id";
// 取出資料庫中與使用者搜尋字串相似的資料 END
$res = db_query($SQLStr);
if (db_num_rows($res)>0)
{
$num = db_num_rows($res);
// 呈現搜尋結果 BEGIN
echo "
| ";
echo "您查詢與" . $search_str . "有關的產品如下:(無紅字表示內文中有提及) |
";
while ($row = db_fetch_array($res))
{
// 判斷是否為某搜尋產品類別的第一筆產品
if ($tmp_cid != $row[c_id])
{
echo "
";
// 將 tmp_cid 指定為此產品的 c_id
$tmp_cid = $row[c_id];
$count = 0;
// 呈現類別名稱
echo "