Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
<?php
$data = [
(object)array(
'order_price' => 1050,
'order_date' => '2022-02-03 07:27:37',
'order_status' => 2,
'order_room' => 'г. Ивантеевка',
'event_id' => 2905,
'event_date' => '2022-02-05 12:00:00',
'event_places' => 'a:1:{i:0;a:5:{s:1:"p";s:4:"1000";s:1:"t";s:12:"Партер";s:1:"i";s:5:"16:14";s:1:"r";s:2:"15";s:1:"n";s:2:"14";}}'
),
(object)array(
'order_price' => '3150',
'order_date' => '2022-02-03 12:34:40',
'order_status' => 2,
'order_room' => 'г. Ивантеевка',
'event_id' => 2905,
'event_date' => '2022-02-05 12:00:00',
'event_places' => 'a:2:{i:0;a:5:{s:1:"p";s:4:"1500";s:1:"t";s:12:"Партер";s:1:"i";s:4:"1:23";s:1:"r";s:1:"1";s:1:"n";s:2:"22";}i:1;a:5:{s:1:"p";s:4:"1500";s:1:"t";s:12:"Партер";s:1:"i";s:4:"1:24";s:1:"r";s:1:"1";s:1:"n";s:2:"23";}}'
)
];
$res = [];
foreach($data as $d) {
if (!isset($res[$d->order_room])) $res[$d->order_room] = [];
$places = unserialize($d->event_places);
foreach ($places as $p) {
if (!isset($res[$d->order_room][$p['p']])) $res[$d->order_room][$p['p']] = 1;
else $res[$d->order_room][$p['p']]++;
}
}
print_r($res);