php-mysqli_fetch_assoc只获取一行 - php mysqli_fetch_assoc only fetching one row

php mysqli_fetch_assoc only fetching one row

尝试在WP站点之外的WP数据库中工作。

$e = "SELECT `meta_value` FROM `wp_usermeta` WHERE `meta_key` = 'mls_email'";
$er = mysqli_query($wp,$e);
$ed = mysqli_fetch_assoc($er);

if(isset($_GET['test'])){
    print_r($ed);
}

当我print_r时，我只得到一个结果。如果我在控制台中运行查询，我会得到预期的结果。mysqli_fetch_assoc是否只获取一行？

它一次只取一行，所以你必须像这样循环它们：

$e = "SELECT `meta_value` 
       FROM  `wp_usermeta` 
       WHERE `meta_key` = 'mls_email'";
$er = mysqli_query($wp,$e);
while ( $ed = mysqli_fetch_assoc($er) )
{
   // loop through result set 
   print "<pre>" . print_r($ed,true) . "</pre>"; 
}

mysqli_fetch_assoc