PHP - 如何从 MySQL 查询中获取所有行
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/13785680/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
提示：将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间：2020-08-25 06:03:32 来源:igfitidea点击:
PHP - How to get all rows from a MySQL Query
提问by Michael King
This is my code:
这是我的代码：
if($login_check > 0) {
$results = mysql_query("SELECT * FROM messageInfo WHERE senderUsername='$username' UNION ALL SELECT * FROM messageInfo WHERE recieverUsername='$username';");
var_dump(mysql_fetch_assoc($results));
}
I'm getting only one row "var_dumped", when I should be getting two rows returned.
当我应该返回两行时，我只得到一行“var_dumped”。
回答by Peter Krejci
Try following code:
尝试以下代码：
$result = mysql_query("SELECT * FROM messageInfo WHERE senderUsername='$username' OR recieverUsername='$username'");
while ($row = mysql_fetch_assoc($result)) {
print_r($row);
}
I think that UNIONis not really needed in this query, ORstatement would be just enough.
我认为UNION在这个查询中并不是真正需要的，OR声明就足够了。
回答by Rizwan Gill
$sqlriz = "Select * FROM `tablename`";
$Rslt = mysqli_query($Conn,$sqlriz);
while($r=mysqli_fetch_object($Rslt))
{
$res[]=$r;
}
print_r($res);
