<?php
require "PDO_Pagination.php";
/* Config Connection */
$root = 'root';
$password = '******';
$host = 'localhost';
$dbname = 'dbname';
$connection = new PDO("mysql:host={$host};dbname={$dbname};", $root, $password);
$pagination = new PDO_Pagination($connection);
$search = null;
if (isset($_REQUEST["search"]) && $_REQUEST["search"] != "") {
$search = htmlspecialchars($_REQUEST["search"]);
$pagination->param = "&search={$search}";
$pagination->rowCount("SELECT * FROM products WHERE category LIKE '%{$search}%' OR description LIKE '%{$search}%' OR name LIKE '%{$search}%'");
$pagination->config(3, 5);
$sql = "SELECT * FROM products WHERE category LIKE '%{$search}%' OR description LIKE '%{$search}%' OR name LIKE '%{$search}%' ORDER BY id_product ASC LIMIT {$pagination->start_row}, {$pagination->max_rows}";
$query = $connection->prepare($sql);
$query->execute();
$model = array();
while ($rows = $query->fetch()) {
$model[] = $rows;
}
} else {
$pagination->rowCount("SELECT * FROM products");
$pagination->config(3, 5);
$sql = "SELECT * FROM products ORDER BY id_product ASC LIMIT {$pagination->start_row}, {$pagination->max_rows}";
$query = $connection->prepare($sql);
$query->execute();
$model = array();
while ($rows = $query->fetch()) {
