public function getProductsWithKeywordPagination($description, $firstLink, $perPage) { $sql = self::$connection->prepare("SELECT * FROM `products` WHERE `products`.`description` like '%$description%' OR `products`.`name` like '%$description%' LIMIT $firstLink, $perPage"); $sql->execute(); $items = array(); $items = $sql->get_result()->fetch_all(MYSQLI_ASSOC); return $items; }