網頁文章 網頁文章

<!-- 程式範例：Ch13-3-1.php -->

<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="c" >

 

<?

 

$names[] = "#ffff00";

 

$names[] = "#00ffff";

 

$flag=0;

 

$link = mysqli_connect("localhost","10179504",

 

                       "10179504","10179504");

 

$sql = "SELECT * FROM jqm_products where price>500";

 

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>

 

</body>

 

 </html>