網頁文章 javax.portlet.title.56

網頁文章 javax.portlet.title.56

 <!-- 程式範例: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>mobile</h1>
  </div>
  <div data-role="content">
  <ul data-role="listview" data-inset="false"  data-theme="e" >
<?
$a=0;
$color=b;
$link = mysqli_connect("localhost","10179524",
                       "10179524","test");
        
$sql = "SELECT * FROM jqm_products where price>500";
 
if ( $result = mysqli_query($link, $sql) ) { 
    
    while( $row = mysqli_fetch_assoc($result) )
   { 
   
    echo "<li data-theme=\"".$color."\">". "<a  href=http://www.kimo.com.tw>".$row["name"].":".$row["manufacturer"]."</a>"."<span class=\"ui-li-aside\">"."NT$".$row["price"]."</span></li>";
if($color=='b')
$color ='c';
else 
$color = 'b';
   }
 
  
   mysqli_free_result($result); 
mysqli_close($link);  
?>
</ul>  
</div>
 
</body>
</html>
 
網站地圖 網站地圖