function get_product(ProductCategory $category) { $data = search_products($category, 0); $data_products = $data["Products"]; if (is_array($data_products)) { foreach ($data_products as $data_product) { if ($data_product["BestOffer"]["IsAvailable"]) { return new Product($data_product["Id"], $data_product["Name"], (double) $data_product["BestOffer"]["SalePrice"], $category, $data_product["Description"], $data_product["BestOffer"]["IsAvailable"]); } } } return null; }
<?php /*---------------------------------------------- ------------------------------------------------ -----------------SEARCH PRODUCTS---------------- ------------------------------------------------ ----------------------------------------------*/ function search_products($string) { // Search products in the DB containing a specific string. $array = array(); require $_SERVER['DOCUMENT_ROOT'] . '/e_commerce/sql/sql_connexion.php'; $request = $bdd->prepare("SELECT id, name FROM products WHERE name LIKE ?"); $request->execute(array('%' . $string . '%')); while ($fetch = $request->fetch()) { array_push($array, array($fetch['id'], $fetch['name'])); } return $array; } /*----------------------------------- ------------------------------------- -----------------MAIN---------------- ------------------------------------- -----------------------------------*/ if (isset($_POST['string'])) { echo json_encode(search_products($_POST['string'])); }