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
CREATE TABLE Users (
id int,
field_id int,
User_id int,
Value varchar(255)
);
INSERT INTO Users VALUES
(234, 52, 123, 'a:4:{i:0;s:3:"615";i:1;s:3:"619";i:2;s:3:"918";i:3;s:3:"570";}'),
(42, 52, 143, 'a:2:{i:0;s:4:"2372";i:1;s:3:"615";}');
<?php
$stmt = $pdo->query("SELECT * FROM Users WHERE field_id= 52") or die;
$users = $stmt->fetchAll(PDO::FETCH_ASSOC);
//Unserialize and join user arrays
$count_users = array_reduce(
$users,
function($res, $u) {
if(is_array($res)){
return array_merge($res, unserialize($u['Value']));}
},
[]
);
//Print count values
$array=array_count_values($count_users);
foreach ($array as $row) {
print_r($row);
}