如何存储值到变量后,while循环结束在php中,以便我可以在其他查询中使用该变量


How to store values to variable after while loop ends in php so that i can use that variables in other query?

$efind = $_SESSION['email'];
require('mysqli_connect.php');
$sql = "SELECT userid,fname,lname,email,phone,adds FROM userst where email ='$efind'";
$result = mysqli_query($dbcon, $sql);
while($row = mysqli_fetch_assoc($result))
{
    // What to write here ?
}

我想存储从循环中获取的userid, fname, lname, email, phone, adds,但当我回显变量时,它们没有任何值。

使用

 $sql = "SELECT userid,fname,lname,email,phone,adds FROM userst where email ='$efind'";
            $result = mysqli_query($dbcon, $sql);
            $firstName  = '';
            $lastName  = '';

            while($row = mysqli_fetch_assoc($result))
            {
                $firstName  = $row['fname'];
                $lastName  = $row['lname'];;
            }