Exemplos de paging::db em PHP

Exemplo n.º 1

Arquivo: catUsuario.php Projeto: nesmaster/lition

<?php

session_start();
//include_once("../include/db_mysqli.inc");
include_once "../include/template.inc";
include_once "../include/confGral.php";
require "../include/paging_class.php";
include_once "../include/acceso.class.php";
$usuario = new Acceso();
$t = new Template("../templates", "keep");
if ($usuario->havePerm("1", $_SESSION['sesArrPerms'])) {
    $paging = new paging(15, 5, "<< prev", "next >>", "(%%number%%) ");
    $paging->db("localhost", "nesoftwa_root", ";L9Nehbfaxts", "nesoftwa_LITION");
    // fffffffffffffffffffffffffffffffffffffffffffffffffffffff
    function explode_keyword($q)
    {
        //trim
        $q = trim($q);
        $q = preg_replace("/[\\s]+/", " ", $q);
        $mode = "AND ";
        $condition = $condition . "usuario like '%{$q}%' " . $mode;
        $condition = substr($condition, 0, -4);
        return $condition;
    }
    // fffffffffffffffffffffffffffffffffffffffffffffffffffffff
    function showForm($data = "", $msg = "")
    {
        global $t, $PHP_SELF, $paging, $db2;
        $t->set_file("page", "catUsuario.inc.html");
        $t->set_var(array("lnTupla" => "", "ACTION" => $PHP_SELF, "MENSAJE" => "", "NUEVO" => "<a href=\"javascript:ventanaNueva('catUsuarioCaptura.php?modo=nuevo',700,700)\">Nuevo</a>"));
        // ----------------------------------------------------------------

Exemplo n.º 2

Arquivo: invInSearch2.php Projeto: nesmaster/almartcon

<?php

session_start();
//include_once("../include/db_mysqli.inc");
include_once "../include/template.inc";
include_once "../include/confGral.php";
require "../include/paging_class.php";
include_once "../include/acceso.class.php";
$usuario = new Acceso();
$t = new Template("../templates", "keep");
$paging = new paging(15, 5, "<< prev", "next >>", "(%%number%%) ");
$paging->db("localhost", "nesoftwa_root", ";L9Nehbfaxts", "nesoftwa_ALMARTCON");
// Identificar si pertenece a una Naviera
$sesIdUsr = $_SESSION['sesIdUsuario'];
$idNaviera = getValueTable("id_naviera", "USUARIO", "id_usuario", $sesIdUsr);
if ($usuario->havePerm("1,3,4", $_SESSION['sesArrPerms'])) {
    // fffffffffffffffffffffffffffffffffffffffffffffffffffffff
    function explode_keyword($q)
    {
        //trim
        $q = trim($q);
        $q = preg_replace("/[\\s]+/", " ", $q);
        $mode = "AND ";
        if (!empty($q)) {
            $condition = $condition . " eir='{$q}' " . $mode;
        }
        //$condition= substr($condition,0,-4);
        return $condition;
    }
    // fffffffffffffffffffffffffffffffffffffffffffffffffffffff
    function explode_keyword2($q)

Exemplo n.º 3

Arquivo: logConsAereo.php Projeto: nesmaster/mopsapro

<?php

session_start();
//include_once("../include/db_mysqli.inc");
include_once "../include/template.inc";
include_once "../include/confGral.php";
require "../include/paging_class.php";
$t = new Template("../templates", "keep");
$paging = new paging(15, 5, "<< prev", "next >>", "(%%number%%) ");
$paging->db("localhost", "nesoftwa_root", ";L9Nehbfaxts", "nesoftwa_MOPSAPRO");
// Identificar si pertenece a una Naviera
$idUsr = $_SESSION['sesIdUsuario'];
$sesIdOficina = $_SESSION['sesIdOficina'];
// fffffffffffffffffffffffffffffffffffffffffffffffffffffff
function explode_keyword1($q)
{
    //trim
    $q = trim($q);
    $q = preg_replace("/[\\s]+/", " ", $q);
    $mode = "AND ";
    $condition = $condition . "posicion like '%{$q}%' " . $mode;
    //$condition= substr($condition,0,-4);
    return $condition;
}
// fffffffffffffffffffffffffffffffffffffffffffffffffffffff
function explode_keyword2($q)
{
    //trim
    $q = trim($q);
    //$q= preg_replace("/[\s]+/"," ",$q);
    $mode = "AND ";

Exemplo n.º 4

Arquivo: navInvInAr.php Projeto: nesmaster/trane

<?php

session_start();
//include_once("../include/db_mysqli.inc");
include_once "../include/template.inc";
include_once "../include/confGral.php";
require "../include/paging_class.php";
$t = new Template("../templates", "keep");
$paging = new paging(15, 5, "<< prev", "next >>", "(%%number%%) ");
$paging->db("localhost", "nesoftwa_root", ";L9Nehbfaxts", "nesoftwa_TRANE");
// Identificar si pertenece a una Naviera
$idUsr = $_SESSION['sesIdUsuario'];
$idNaviera = getValueTable("id_naviera", "USUARIO", "id_usuario", $idUsr);
if ($idUsr > 0 && $idNaviera) {
    // fffffffffffffffffffffffffffffffffffffffffffffffffffffff
    function explode_keyword($q)
    {
        //trim
        $q = trim($q);
        $q = str_replace("/[\\s]+/", " ", $q);
        $mode = "AND ";
        $condition = $condition . " eir like '%{$q}' " . $mode;
        //$condition= substr($condition,0,-4);
        return $condition;
    }
    // fffffffffffffffffffffffffffffffffffffffffffffffffffffff
    function explode_keyword2($q)
    {
        //trim
        $q = trim($q);
        $q = str_replace("/[\\s]+/", " ", $q);

Exemplo n.º 5

Arquivo: navInvGen13.php Projeto: nesmaster/anakosta

<?php

session_start();
//include_once("../include/db_mysqli.inc");
include_once "../include/template.inc";
include_once "../include/confGral.php";
require "../include/paging_class.php";
$t = new Template("../templates", "keep");
$paging = new paging(15, 5, "<< prev", "next >>", "(%%number%%) ");
$paging->db("localhost", "nesoftwa_root", ";L9Nehbfaxts", "nesoftwa_ANAKOSTA");
// Identificar si pertenece a una Naviera
$idUsr = $_SESSION['sesIdUsuario'];
$idNaviera = getValueTable("id_naviera", "USUARIO", "id_usuario", $idUsr);
// fffffffffffffffffffffffffffffffffffffffffffffffffffffff
function explode_keyword1($q)
{
    //trim
    $q = trim($q);
    $q = preg_replace("/[\\s]+/", " ", $q);
    $idConte = getValueTable("id_contenedor", "CONTENEDOR", "numero", $q);
    if (empty($idConte) && !empty($q)) {
        $idConte = '-';
    }
    $mode = "AND ";
    $condition = $condition . "i.id_contenedor like '{$idConte}%' " . $mode;
    //$condition= substr($condition,0,-4);
    return $condition;
}
// fffffffffffffffffffffffffffffffffffffffffffffffffffffff
function explode_keyword2($q)
{