PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
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');
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);
Show:  
Copy Clear