僅供參考
只是不知為何輸出時 num of rows 出現在 資料後面?
<?php
$db_db_name = "testdb";
$db_host = "127.0.0.1";
$db_id = "root";
$db_pw = "xxxx";
$db_link = mysqli_connect($db_host,$db_id,$db_pw);
$db_open_sql=mysqli_select_db($db_link,$db_db_name);
mysqli_query($db_link,"SET NAMES 'UTF8'");
$sql_query = "SELECT `orderid`, `phone`, `name` FROM `orders` WHERE `finish`=0 ORDER BY `orderid` DESC";
$result = mysqli_query($db_link, $sql_query);
$numrow = mysqli_num_rows($result);
ob_end_clean();
echo "num of rows: " . $numrow . "
";
while ($row=mysqli_fetch_row($result)) {
echo "OrderID: " . $row[0]. " | Phone: " . $row[1]. " | Name: " . $row[2]. "
";
}
mysqli_close($db_link);
?>
紫色雙魚 wrote:
謝謝你詳細的程式,...(恕刪)
目前更改後的程式碼是這樣...
<?php
$db_db_name = "資料庫名子";
$db_host = "網域";
$db_id = "帳號";
$db_pw = "密碼";
$db_link = mysqli_connect($db_host,$db_id,$db_pw);
$db_open_sql=mysqli_select_db($db_link,$db_db_name);
mysqli_query($db_link,"SET NAMES 'UTF8'");
$sql_query = "SELECT `orderid`, `phone`, `name` FROM `orders` WHERE `finish`=0 ORDER BY `orderid` DESC";
$result = mysqli_query($db_link, $sql_query);
$row = mysqli_fetch_row($result);
$numrow = mysqli_num_rows($result);
while($row_result[$i] = mysqli_fetch_array($result, MYSQL_ASSOC)){
$i++;
}
mysqli_close($db_link);
?>
<html>
<div data-role="content">
<ul data-role="listview" data-inset="true" id="listOrder" data-filter="true" data-filter-placeholder="輸入訂單號碼、電話或姓名">
<?php for($i=0; $i<$numrow; $i++) { ?>
<li><a href='showorder.php?order=<?php echo $row_result[$i]["orderid"]; ?>' data-ajax='false'>
<?php echo $row_result[$i]["orderid"]; ?>
<?php echo $row_result[$i]["phone"]; ?>
<?php echo $row_result[$i]["name"]; ?>
</a></li>
<?php } ?>
</ul>
</div>
</html>
關閉廣告