網頁文章 網頁文章

203.64.42.73/mobilehtml/10179508/20160419.php 

 

<html>

<head><title>10179508</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","10179508",

                       "10179508","test");

        

$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>