改变
sizeof()
到
$stmtSel->num_rows
$connSel = OpenCon();
$sqlSel = 'SELECT * FROM sitecomments';
if($stmtSel = $connSel -> prepare($sqlSel)){
$q_resultSel = $stmtSel -> execute();
$stmtSel ->store_result();
if($stmtSel->num_rows>0){
$result = $q_resultSel->get_result();
while ($row = $result->fetch_array(MYSQLI_NUM)){
echo $row['username']."<br><br>".$row['comment'];
}
}
}
else{
echo '<i>No comments yet</i>';
}