How to add custom value to mysql fetch array

Question

I have an array fetched from mysql.

while ($row = $sql->fetch(PDO::FETCH_ASSOC)) {
    $array[] = $row;
}
var_dump($array);

It returns the values as below:

array (size=2)
  0 => 
    array (size=4)
      'itemId' => string '4' (length=1)
      'name' => string 'Ice Break' (length=9)
      'size' => string '500ml' (length=5)
      'supplier' => string 'Parmalat' (length=9)
  1 => 
    array (size=4)
      'itemId' => string '6' (length=1)
      'name' => string 'Red bull' (length=9)
      'size' => string '250ml' (length=5)
      'supplier' => string 'Red Bull' (length=9)

Now, I want to add a customised key and value to this array so that the result is as below:

array (size=2)
  0 => 
    array (size=5)
      'itemId' => string '4' (length=1)
      'name' => string 'Ice Break' (length=9)
      'size' => string '500ml' (length=5)
      'supplier' => string 'Parmalat' (length=8)
      'newName' => string 'Ice Break (500ml) (Parmalat)' (length=28)
  1 => 
    array (size=5)
      'itemId' => string '6' (length=1)
      'name' => string 'Red Bull' (length=8)
      'size' => string '250ml' (length=5)
      'supplier' => string 'Red Bull' (length=8)
      'newName' => string 'Red bull (250ml) (Red Bull)' (length=26)

I have tried this so far, but no luck:

while ($row = $sql->fetch(PDO::FETCH_ASSOC)) {
        $array[] = $row;
        $array['newName'] = $row["name"].' ('.$row["size"].') ('.$row["supplier"].')';
    }

Mike · Accepted Answer · 2016-09-11 06:12:36Z

1

You're close. Add it to $row and then append it to the array.

while ($row = $sql->fetch(PDO::FETCH_ASSOC)) {
    $row['newName'] = $row["name"].' ('.$row["size"].') ('.$row["supplier"].')';
    $array[] = $row;
}

answered Sep 11, 2016 at 6:12

Mike

24.5k14 gold badges84 silver badges93 bronze badges

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

Collectives™ on Stack Overflow

How to add custom value to mysql fetch array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related