<html>
<head><title>查詢資料表的記錄資料</title></head>
<body>
<table border=1>
<?
$color[0] = "#7fffd4";
$color[1] = "#f0e68c";
$i=0;
$link = mysqli_connect("localhost","10079537",
"10079537","10079537");
$sql = "SELECT * FROM jqm_products";
if ( $result = mysqli_query($link, $sql) ) {
while( $row = mysqli_fetch_assoc($result) ){
if ($i==0) {
echo "<td bgcolor=".$color[0].">".$row["name"]."</td>". "<td bgcolor=".$color[0].">".$row["price"]."</td>"."<tr>";
$i=1;
} else {
echo "<td bgcolor=".$color[1].">".$row["name"]."</td>". "<td bgcolor=".$color[1].">".$row["price"]."</td>"."<tr>";
$i=0;
}
}
mysqli_free_result($result);
}
mysqli_close($link);
?>
</table>
</body>
</html>
