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";}'),
(45, 16, 12, 'a:3:{i:0;s:2:"23";i:1;s:3:"615";i:2;s:3:"918";}'),
(42, 52, 143, 'a:2:{i:0;s:3:"918";i:1;s:3:"125";}');
<?php
$query = "SELECT * FROM Users WHERE field_id= 52;";
$stmt = $pdo->prepare($query);
$stmt->execute();
$users = $stmt->fetchAll(PDO::FETCH_ASSOC);
//Unserialize and join user arrays
$count_users = array_reduce(
$users,
function($res, $u) {
return array_merge($res, unserialize($u['Value']));
},
[]
);
//Print count values
print_r(array_count_values($count_users));