$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'];;
}