How to put value to blank array inside foreach loop php

Question

I am using query in foreach loop (according to userType) and after query in foreach loop i am getting following result

Array
(
    [0] => Array
        (
            [bookingId] => 1
            [userId] => 102
            [status] => paid
        }
    [0] => Array
        (
            [bookingId] => 3
            [userId] => 102
            [status] => paid
        }       
    [0] => Array
        (
            [bookingId] => 5
            [userId] => 102
            [status] => paid
        }
...     
        
}

Now i want all result outside foreach loop so i tried with following code but not working,showing me single record istead of multiple

I tried with following code but not working for me

$record=array();
    foreach ($result as $key => $row)
    {
            $query= // mysql query
            $rows = $query->result_array();
            $record['bookingId']=$rows['0']['bookingId'];
            $record['userId']=$rows['0']['userId'];
            $record['status']=$rows['0']['status'];
    }
echo "<pre>";print_R($record);

One recommendation is that you should try and reduce the SQL queries so that you don't execute a query inside the loop. — Nigel Ren
– Nigel Ren, Commented Jul 14, 2020 at 7:08
If you just say not working, we cannot understand much. Are you getting any error with your approach? If so, please post that error. Otherwise, mention the expected output and the output which you are getting with your approach. — Puspam
– Puspam, Commented Jul 14, 2020 at 7:13

Юрий · Accepted Answer · 2020-07-14 07:11:04Z

1

Don't you rewrite the value in the array every time?

$record = array();
foreach ($result as $key => $row) {
    $query = // mysql query
    $rows = $query->result_array();
    $record[] = [
        'bookingId' => $rows['0']['bookingId'],
        'userId' => $rows['0']['userId'],
        'status' => $rows['0']['status'],
    ];
}
echo "<pre>";
print_R($record);

answered Jul 14, 2020 at 7:11

Юрий

944 bronze badges

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

Comments

Amit Merchant · Accepted Answer · 2020-07-14 07:13:19Z

0

You need to use it something like this.

$record = array();

foreach ($result as $key => $row)
{
      $query = // mysql query
      $rows = $query->result_array();
      $record[]['bookingId'] = $rows['0']['bookingId'];
      $record[]['userId'] = $rows['0']['userId'];
      $record[]['status'] = $rows['0']['status'];
}

echo "<pre>";print_R($record);

Basically, you're missing updating the index of the array.

edited Jul 14, 2020 at 7:13

answered Jul 14, 2020 at 7:08

Amit Merchant

1,0436 silver badges21 bronze badges

Collectives™ on Stack Overflow

How to put value to blank array inside foreach loop php

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related