PHPize Online / SQLize Online  /  SQLtest Online

<?php $db = &$pdo; $userId = 10; //////////////// $sth = $db->prepare( "SELECT dishes.dish_id, dishes.name, dishes.date_create, json_arrayagg(image) images FROM `dishes` INNER JOIN `dish_images` ON dishes.dish_id = dish_images.dish_id WHERE `userId` = ? GROUP BY dishes.dish_id, dishes.name" ); $sth->execute([$userId]); $dishes = $sth->fetchAll(PDO::FETCH_ASSOC); foreach ($dishes as $key => $value) { $pics = $value["images"]; $pics = substr($pics, 1, -1); $pics = str_replace('"', "", $pics); $pics = str_replace(', ', ",", $pics); $pics_arr = explode(',', $pics); $dishes[$key]["images"] = $pics_arr; } $response = [ 'status' => true, 'message' => 'return user dishes', 'result' => $dishes, ]; echo json_encode(['data' => $response]); //return http_response_code(400);