<?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'");
$create_db_sql = "CREATE DATABASE IF NOT EXISTS T_DB";
mysqli_query($db_link,$create_db_sql);
$row = mysqli_fetch_row($result);
while($row_result[$i] = mysqli_fetch_array($result, MYSQL_ASSOC)){
$i++;
}
mysqli_close($db_link);
$sql_query = "SELECT `orderid`,`phone`,`name` FROM `orders` WHERE `finish`=0 ORDER BY `orderid` DESC";
$result = mysqli_query($sql_query);
$numrow = mysqli_num_rows($result);
$row_result = array();
?>
出來的樣子,下面的資料完全顯示不出來:
最右邊的銷售排行榜是空的:
用PHP5在夲機測試下,結果是這樣:
銷售排行榜要有排行:
一再修改不知道哪邊有問題,
有人可以指點一下嗎 謝謝.