<?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);