我一直在獲取要使用mysqli返回的行數(shù)方面遇到麻煩。即使確實(shí)有一些結(jié)果，我每次都會(huì)得到0。if($stmt = $mysqli->prepare("SELECT id, title, visible, parent_id FROM content WHERE parent_id = ? ORDER BY page_order ASC;")){ $stmt->bind_param('s', $data->id); $stmt->execute(); $num_of_rows = $stmt->num_rows; $stmt->bind_result($child_id, $child_title, $child_visible, $child_parent); while($stmt->fetch()){ //code } echo($num_of_rows); $stmt->close();}為什么沒(méi)有顯示正確的數(shù)字？
3 回答
慕斯709654
TA貢獻(xiàn)1840條經(jīng)驗(yàn) 獲得超5個(gè)贊
您需要先調(diào)用MySqli_Stmt::store_result()num_rows查找：
if($stmt = $mysqli->prepare("SELECT id, title, visible, parent_id FROM content WHERE parent_id = ? ORDER BY page_order ASC;")){
$stmt->bind_param('s', $data->id);
$stmt->execute();
$stmt->store_result(); <-- This needs to be called here!
$num_of_rows = $stmt->num_rows;
$stmt->bind_result($child_id, $child_title, $child_visible, $child_parent);
while($stmt->fetch()){
//code
}
echo($num_of_rows);
$stmt->close();
}
請(qǐng)參閱上的文檔MySQLi_Stmt->num_rows，該文檔顯示在頁(yè)面頂部附近（在主要說(shuō)明區(qū)域中）...
萬(wàn)千封印
TA貢獻(xiàn)1891條經(jīng)驗(yàn) 獲得超3個(gè)贊
嘗試$num_of_rows在if（statement）之后-在bind_param之前設(shè)置您的權(quán)限...除非那會(huì)改變您的結(jié)果。沒(méi)有更多信息很難說(shuō)。
素胚勾勒不出你
TA貢獻(xiàn)1827條經(jīng)驗(yàn) 獲得超9個(gè)贊
您的查詢似乎出了點(diǎn)問(wèn)題。嘗試進(jìn)行直接查詢，例如if($stmt = $mysqli->query("SELECT id, title, visible, parent_id FROM content WHERE parent_id = YOURIDHERE ORDER BY page_order ASC;")){，看看是否仍然可以解決0個(gè)結(jié)果
添加回答
舉報(bào)
0/150
提交
取消