Make PHP Array From Dynamic Number of Columns Queried

Question

I have a query which converts item rows of a series of IDs in MySQL table to columns, so the result has variable number of columns (VC). The only items that are not dynamic are the ID, FirstName, LastName. I know the number of variable items (n), which is part of the query.

what I want to do is to have a loop inside PHP while to add these variable columns to the PHP array.

something like this:

$someArray = [];

while($row = $result -> fetch_assoc()) {

array_push($someArray,[ 

  'ID' => $row['EmployeeID'],
  'FName' => $row['FName'],
  'MName' => $row['MName'],
  'LName' => $row['LName'],

-------Loop here --------
  'VC1' => $row['VC1'],
  'VC2' => $row['VC2'],
  'VC3' => $row['VC3'],
  'VC4' => $row['VC4'],
  'VC5' => $row['VC5'],
  ..............
  'VCn' => $row['VCn']
-------------------------

]);
}

I tried with PHP loop and could not figure out how to do it. Thanks for any help in advance.

Show us the query, this sounds a little odd so it would help us understand the question — RiggsFolly
– RiggsFolly, Commented Sep 6, 2018 at 18:20

dWinder · Accepted Answer · 2018-09-06 17:36:15Z

2

If you know n you can use for loop:

for($i = 1;$i <= $n; $i++) {
    $key = "VC" .$i;
    $someArray[$key] = $row[$key];
}

However, if you pushing the entire array in it may be better do modify your SQL query and do just:

while($row = $result -> fetch_assoc())
    array_push($someArray, $row)

edited Sep 6, 2018 at 17:36

answered Sep 6, 2018 at 17:33

dWinder

11.7k3 gold badges27 silver badges40 bronze badges

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

2 Comments

Andreas Over a year ago

Undefined constant n, make it $n

Armanius Over a year ago

Thanks, it works after I saw your edited answer. thanks a lot.

Collectives™ on Stack Overflow

Make PHP Array From Dynamic Number of Columns Queried

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related