php - 如何将多列传递给php中的变量

Question

我正在开发一个项目，该项目需要将多个列内容传递给 php 变量

我能够选择一列内容并将其传递给变量，但在多列上失败

$myEMPNEM = "";

$sqlNEM = "SELECT first_name, middle_name, last_name, job_title FROM 
t_employees WHERE user_name = '" . $_SESSION["uname"] . "'";
$resultNEM = mysqli_query( $conn, $sqlNEM );
while($row = mysqli_fetch_array($resultNEM))
{
  $myEMPNEM = $row['first_name'];   
 }

我希望将不止一列内容传递给 php 变量

Answer 1

您需要将变量用作数组:

while($row = mysqli_fetch_array($resultNEM))
{
  $myEMPNEM = array($row['first_name'], $row['middle_name'], $row['last_name']);   
}

或者将这些值连接成一个字符串:

while($row = mysqli_fetch_array($resultNEM))
{
  $myEMPNEM = $row['first_name'] . " " . $row['middle_name'] . " " . $row['last_name'];
}