How to pass multiple columns to a variable in php

Question

I'm working on a project which requires more than one column contents to be passed to a php variable

I am able to select and pass one column content to the variable but failed on multiple columns

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

I expect more than one column content to be passed to the php variable

You are only assigning first_name. Why would you expect more? — alexherm
– alexherm, Commented Jul 29, 2019 at 16:26
Don't assume $_SESSION array to be safe, because it might not be the case on shared webhosting (with bad configurations) .. General rule when working with a database always always always always always always always always use prepared statements no exceptions — Raymond Nijland
– Raymond Nijland, Commented Jul 29, 2019 at 16:47

gmiley · Accepted Answer · 2019-07-29 16:31:26Z

1

You either need to use the variable as an array:

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

Or concatenate the values together into a single string:

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

edited Jul 29, 2019 at 16:31

answered Jul 29, 2019 at 16:29

gmiley

6,6041 gold badge15 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Maina David Over a year ago

Concatenating the values together into a string works! I appreciate

Collectives™ on Stack Overflow

How to pass multiple columns to a variable in php

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related