<!-- 程式範例:Ch13-3-1.php -->
<html>
<head><title>查詢資料表的記錄資料</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Ch7_5_2.htm</title>
<link rel="stylesheet" href="../jquery.mobile.min.css">
<script src="../jquery-1.6.4.min.js"></script>
<script src="../jquery.mobile.min.js"></script>
</head>
<body>
<div data-role="page" id="home">
<div data-role="header">
<h1>Ch7_5_2</h1>
</div>
<div data-role="content">
<ul data-role="listview" data-inset="false" data-theme="e" >
<?
$link = mysqli_connect("localhost","10179524",
"10179524","test");
//****第一段顯示**** 第一段顯示*****第一段顯示******第一段顯示*****第一段顯示******第一段顯示***//
//$sql = "SELECT * FROM category ";
$sql = "SELECT * FROM jqm_category where c_id=1";
$result = mysqli_query($link, $sql) ;
//echo $total_fields = mysqli_num_fields($result);
$row = mysqli_fetch_assoc($result);
echo "<li data-role=\"list-divider\">";
echo $row["c_name"]."產品展示區";echo "</li>";
$sql = "SELECT * FROM jqm_products where category=1";
if ( $result = mysqli_query($link, $sql) )
{
while( $row = mysqli_fetch_assoc($result) )
{
echo "<li>". "<img src=".$row["id"].".png height=80 width=80>".$row["name"]."<span class=\"ui-li-aside\">"."NT$".$row["price"]."</span></li>";
}
}
//****第二段顯示**** 第二段顯示*****第二段顯示******第二段顯示*****第二段顯示******第二段顯示***//
$sql = "SELECT * FROM jqm_category where c_id=2";
$result = mysqli_query($link, $sql) ;
//echo $total_fields = mysqli_num_fields($result);
$row = mysqli_fetch_assoc($result);
echo "<li data-role=\"list-divider\">";
echo $row["c_name"]."產品展示區";echo "</li>";
if ( $result = mysqli_query($link, $sql) )
{
while( $row = mysqli_fetch_assoc($result) )
{
echo "<li>". "<img src=".$row["id"].".png height=80 width=80>".$row["name"]."<span class=\"ui-li-aside\">"."NT$".$row["price"]."</span></li>";
}
}
$sql = "SELECT * FROM jqm_products where category=2";
//****第三段顯示**** 第三段顯示*****第三段顯示******第三段顯示*****第三段顯示******第三段顯示***//
$sql = "SELECT * FROM jqm_category where c_id=3";
$result = mysqli_query($link, $sql) ;
//echo $total_fields = mysqli_num_fields($result);
$row = mysqli_fetch_assoc($result);
echo "<li data-role=\"list-divider\">";
echo $row["c_name"]."產品展示區";echo "</li>";
$sql = "SELECT * FROM jqm_products where category=3";
if ( $result = mysqli_query($link, $sql) )
{
while( $row = mysqli_fetch_assoc($result) )
{
echo "<li>". "<img src=".$row["id"].".png height=80 width=80>".$row["name"]."<span class=\"ui-li-aside\">"."NT$".$row["price"]."</span></li>";
}
}
mysqli_free_result($result);
mysqli_close($link);
?>
</ul>
</div>
</div>
</body>
</html>