示例#1
0
function index($columnas, $vista)
{
    extract(recoger_parametros($columnas));
    $params = compact('columnas', 'columna', 'criterio', 'orden', 'sentido');
    formulario_busqueda($params);
    $con = conectar();
    list($where, $pqp) = filtro($columnas, $columna, $criterio);
    $res = pg_query_params($con, "select *\n                                    from {$vista}\n                                   where {$where}\n                                order by {$orden} {$sentido}", $pqp);
    $params['res'] = $res;
    generar_resultado($params);
    ?>

    <a href="insertar.php"><input type="button" value="Insertar" /></a><?php 
}
示例#2
0
function index($columnas, $vista, $modulo, $bol = false)
{
    $res = pg_query("select * from {$vista}");
    $nfilas = pg_num_rows($res);
    $npags = ceil($nfilas / FPP);
    extract(recoger_parametros($columnas, $modulo, $npags));
    $params = compact('columnas', 'columna', 'criterio', 'orden', 'sentido', 'npag');
    formulario_busqueda($params);
    list($where, $pqp) = filtro($columnas, $columna, $criterio);
    $res = pg_query_params("select * from {$vista}\n                             where {$where}\n                          order by {$orden} {$sentido}\n                          limit " . FPP . "\n                          offset " . FPP . "*({$npag}-1)", $pqp);
    $params['npags'] = $npags;
    $params['res'] = $res;
    generar_resultado($params, $bol);
    if (!$bol) {
        ?>
        <a href="insertar.php"><input type="button" value="Insertar" /></a><?php 
    }
    if (es_admin()) {
        volver();
    }
}