<?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()) {
<?php
session_start();
if (isset($_SESSION['razon'])) {
} else {
header("Location: index.php");
}
?>
<?php
require "../../model/PDO_Pagination.php";
require '../../model/db.php';
$pagination = new PDO_Pagination($PDO);
$search = null;
if (isset($_REQUEST["search"]) && $_REQUEST["search"] != "") {
$search = htmlspecialchars($_REQUEST["search"]);
$pagination->param = "&search={$search}";
$pagination->rowCount("SELECT * FROM mantecorre WHERE ordenTrabajo LIKE '%{$search}%' ");
$pagination->config(3, 5);
$sql = "SELECT * FROM mantecorre WHERE ordenTrabajo LIKE '%{$search}%' ORDER BY id ASC LIMIT {$pagination->start_row}, {$pagination->max_rows}";
$query = $PDO->prepare($sql);
$query->execute();
$model = array();
while ($rows = $query->fetch()) {
$model[] = $rows;
}
} else {
$pagination->rowCount("SELECT T1.id, T2.razon, T3.descripcion, T4.detalle, T5.nombre, T1.ordenTrabajo, T1.horometro, T1.autorizado, T1.fechainicio, T1.fechafin, T1.entregaequipo, T1.proximomante, T1.comentario\nFROM mantepre T1\ninner join usuario T2 ON T1.usuario_id = T2.id\ninner join equipo T3 ON T1.equipo_id = T3.id\ninner join frecuenciainterv T4 ON T1.empleado_id = T4.id\ninner join empleado T5 ON T1.empleado_id = T5.id");
$pagination->config(3, 5);
$sql = "SELECT T1.id, T2.razon, T3.descripcion, T4.detalle, T5.nombre, T1.ordenTrabajo, T1.horometro, T1.autorizado, T1.fechainicio, T1.fechafin, T1.entregaequipo, T1.proximomante, T1.comentario\nFROM mantepre T1\ninner join usuario T2 ON T1.usuario_id = T2.id\ninner join equipo T3 ON T1.equipo_id = T3.id\ninner join frecuenciainterv T4 ON T1.empleado_id = T4.id\ninner join empleado T5 ON T1.empleado_id = T5.id\nORDER BY id ASC LIMIT {$pagination->start_row}, {$pagination->max_rows}";
$query = $PDO->prepare($sql);
