使用MySQL DB的MySQLI获取单行

Question

我正在尝试使用mysqli显示单行数据。查询是

$getfield = mysqli_query($con,"select name from as_users where user_id=34");
if (mysqli_num_rows($getfield) > 0) 
{
     while($rowpwd = mysqli_fetch_array($getfield))
        {
           echo $rowpwd['name'];
        }
}

如果我打印，我得到

echo '<pre>';
print_r(mysqli_fetch_array($getfield));
echo '</pre>';
Array
(
    [0] => abc
    [name] => abc
)

但是在while循环中获取名称不起作用。

任何帮助都将受到高度赞赏。

Answer 1

只需尝试一下：

$getfield = mysqli_query($con,"select name from as_users where user_id=34");
if (mysqli_num_rows($getfield) > 0) 
{
     $rowpwd = mysqli_fetch_array($getfield)['name'];
     echo $rowpwd;
}

或

$getfield = mysqli_query($con,"select name from as_users where user_id=34");
if (mysqli_num_rows($getfield) > 0) 
{
   $rowpwd = mysqli_fetch_array($getfield);
   echo $rowpwd['name'];
}

Answer 2

尝试以下：

$getfield = mysqli_query($con,"select name from as_users where user_id=34");
if (mysqli_num_rows($getfield) > 0) 
$whatYouWant = array();
{
     while($rowpwd = mysqli_fetch_array($getfield))
        {
           //echo $rowpwd['name'];
           $whatYouWant[] = $rowpwd['name'];
        }
}

echo '<pre>';
print_r($whatYouWant);
echo '</pre>';

Answer 3

更改：

mysqli_fetch_array

to：如果要行的键

mysqli_fetch_assoc 

to：如果您想要行

的索引

mysqli_fetch_row