QR Code QR Code

 

HTML 原始碼 HTML 原始碼

 <html>

<head><title>查詢資料表的記錄資料</title>
<meta 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","10079517",
                       "10079517","10079517");
        
$sql = "SELECT * FROM jqm_products where category=1";
 
echo "<li data-role=\"list-divider\">一區</li>";
 
if ( $result = mysqli_query($link, $sql) )
    
   while( $row = mysqli_fetch_assoc($result) )
      echo "<li>". "<img src=".$row["id"].".jpg height=80 width=80>".$row["name"]."<span class=\"ui-li-aside\">"."NT$".$row["price"]."</span></li>";
}    
}
 
 
 echo "<li data-role=\"list-divider\">二區</li>";
 
 $sql = "SELECT * FROM jqm_products where category=2";
 
if ( $result = mysqli_query($link, $sql) )
    
   while( $row = mysqli_fetch_assoc($result) )
      echo "<li>". "<img src=".$row["id"].".jpg height=80 width=80>".$row["name"]."<span class=\"ui-li-aside\">"."NT$".$row["price"]."</span></li>";
}    
}
   
$sql = "SELECT * FROM jqm_products where category=3";
 
echo "<li data-role=\"list-divider\">三區</li>";
 
if ( $result = mysqli_query($link, $sql) )
    
   while( $row = mysqli_fetch_assoc($result) )
      echo "<li>". "<img src=".$row["id"].".jpg height=80 width=80>".$row["name"]."<span class=\"ui-li-aside\">"."NT$".$row["price"]."</span></li>";
}    
}
 
$sql = "SELECT * FROM jqm_products where category=4";
 
echo "<li data-role=\"list-divider\">四區</li>";
 
if ( $result = mysqli_query($link, $sql) )
    
   while( $row = mysqli_fetch_assoc($result) )
      echo "<li>". "<img src=".$row["id"].".jpg 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>
eclipse 虛擬機 eclipse 虛擬機

 

QR code 產生器 QR code 產生器

 

手機執行畫面 手機執行畫面