<html>
<head><title>查詢資料表的記錄資料</title>
<meta charset="utf-8"/>
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>20150413.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>20150413</h1>
</div>
<div data-role="content">
<ul data-role="listview" data-inset="false" data-theme="c" >
<?
$names[] = "#ffff00";
$names[] = "#ff00ff";
$flag=0;
$link = mysqli_connect("localhost","10079533",
"10079533","10079533");
$sql = "SELECT * FROM jqm_products";
if ( $result = mysqli_query($link, $sql) ) {
while( $row = mysqli_fetch_assoc($result) )
{
echo "<li>"."<img src=".$row["id"].".png height=80 width=80>"."<a href=http://www.yahoo.com.tw>".$row["name"]."<span class=\"ui-li-aside\">"."NT$".$row["price"]."</span></li>";
}
mysqli_free_result($result);
}
mysqli_close($link);
?>
</ul>
</div>
</body>
</html>
