PHPize Online / SQLize Online  /  SQLtest Online

<?php printf("Current PHP version: %s \n", phpversion()); $query = "SELECT VERSION() as version;"; $stmt = $pdo->prepare($query); $stmt->execute(); $row = $stmt->fetch(PDO::FETCH_ASSOC); printf('DB version: %s', $row['version']); $sql = "SELECT `customers`.`id`, `customers`.`name`, `customers`.`age`, `addresses`.`address` FROM `customers` JOIN `addresses` ON `customers`.`id` = `addresses`.`customer_id` "; $result = $mysqli->query($sql); $rows = array(); while ($row = $result->fetch_assoc()) { if (is_array($rows[$row['id']])) { array_push($rows[$row['id']]['address'],$row['address']); } else { $rows[$row['id']] = $row; $rows[$row['id']]['address'] = (array)$rows[$row['id']]['address']; } } var_export($rows);