Hi! Could we please enable some services and cookies to improve your experience and our website?

PHPize Online / SQLize Online  /  SQLtest Online

A A A
Login    Share code      Blog   FAQ

Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code

Copy Format Clear
CREATE TABLE items ( id int, name varchar(64) ); INSERT INTO items VALUES (1, 'Cube'), (2, 'Pyramide'); CREATE TABLE values_color ( item_id int, value varchar(64) ); INSERT INTO values_color VALUES (1, 'Red'), (1, 'Yellow'), (2, 'Green'), (2, 'Blue'); CREATE TABLE values_base_color ( item_id int, value varchar(64) ); INSERT INTO values_base_color VALUES (1, 'Black'), (2, 'Gray'), (2, 'Brown');

Stuck with a problem? Got Error? Ask AI support!

Copy Clear
Copy Format Clear
<?php use Carbon\Carbon; $now = Carbon::now()->format('d/m/Y'); printf("Today is %s\nCurrent PHP version: %s \n\n", $now, phpversion()); $query = " SELECT items.*, GROUP_CONCAT(DISTINCT values_color.value) colors, GROUP_CONCAT(DISTINCT values_base_color.value) base_colors FROM items LEFT JOIN values_color ON values_color.item_id = items.id LEFT JOIN values_base_color ON values_base_color.item_id = items.id GROUP BY items.id, items.name ;"; // get DB version using PDO $stmt = $pdo->prepare($query); $stmt->execute(); $items = $stmt->fetchAll(PDO::FETCH_ASSOC); print_r($items);
Copy Clear