PHPize Online / SQLize Online  /  SQLtest Online

<?php $db = &$pdo; $get_product = $db->prepare("SELECT * FROM products"); $get_product->execute(); while ($product_data = $get_product->fetch()) { $product_data_array[] = [ "name" => $product_data["name"], "price" => $product_data["price"], "status" => $product_data["status"], ]; } var_dump($product_data_array); $get_product = $db->prepare("SELECT * FROM products"); $get_product->execute(); $product_data_array = $get_product->fetchAll(PDO::FETCH_ASSOC); var_dump($product_data_array);