我正在嘗試計算收集的令牌總數(shù)，而不是mysql數(shù)據(jù)庫中的記錄數(shù)。雖然我已經(jīng)將SUM函數(shù)放在查詢中，但它仍然計算no。行數(shù)。<?php $conn = mysqli_connect(server, dbuser, dbpw, db); $query = " SELECT SUM(nooftokensused) FROM bidding WHERE biddedon >= DATE_FORMAT(CURRENT_DATE(), '%Y-01-01') GROUP BY biddingid"; $query_run = mysqli_query($conn, $query); $row = mysqli_num_rows($query_run); echo '<h1>'.$row.'</h1>';?>
2 回答
繁花如伊
TA貢獻2012條經(jīng)驗 獲得超12個贊
我已經(jīng)在我的代碼中添加了注釋。此外，您正在使用 ，您尚未將它們聲明為帶有符號的變量。mysqli_connect(server, dbuser, dbpw, db)$
<?php
//Make connection with DB
$con = mysqli_connect($server, $dbuser, $dbpw, $db);
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
exit();
}
$sql = "SELECT SUM(nooftokensused) as summ FROM bidding WHERE biddedon >= DATE_FORMAT(CURRENT_DATE(), '%Y-01-01') GROUP BY biddingid";
$result = mysqli_query($con, $sql);
if(mysqli_num_rows($result)>0)
{
// Associative array
$row = mysqli_fetch_assoc($result);
echo $row["summ"];
}
else
{
echo 0;
}
// Free result set
mysqli_free_result($result);
mysqli_close($con);
?>
慕俠2389804
TA貢獻1719條經(jīng)驗 獲得超6個贊
使用 mysqli_fetch_assoc（） 而不是 mysqli_num_rows（）。
<?php
$conn = mysqli_connect(server, dbuser, dbpw, db);
$query = " SELECT SUM(value_sum) AS nooftokensused FROM bidding WHERE biddedon >= DATE_FORMAT(CURRENT_DATE(), '%Y-01-01') GROUP BY biddingid";
$query_run = mysqli_query($conn, $query);
$row = mysqli_fetch_assoc($query_run);
echo '<h1>'.$row['nooftokensused'].'</h1>';
?>
- 2 回答
- 0 關(guān)注
- 121 瀏覽
添加回答
舉報
0/150
提交
取消