Example #1
0
$where = "`" . $_GET['campo'] . "` LIKE '" . $_GET['pesquisa'] . "%'";
if ($_GET[pg] != '') {
    $limit = ($_GET[pg] - 1) * PG_MAX;
} else {
    $limit = 0;
    $_GET[pg] = 1;
}
$href = 'href=';
$onclick = 'onclick=';
if (checknivel('Dentista') || checknivel('Funcionario')) {
    $href = '';
    $onclick = '';
}
$sql = "SELECT * FROM `fornecedores` WHERE " . $where . " ORDER BY `nomefantasia` ASC";
$pacientes = new TFornecedores();
$lista = $pacientes->ListFornecedores($sql . ' LIMIT ' . $limit . ', ' . PG_MAX);
$total_regs = $pacientes->ListFornecedores($sql);
$par = "F0F0F0";
$impar = "F8F8F8";
for ($i = 0; $i < count($lista); $i++) {
    if ($i % 2 == 0) {
        $odev = $par;
    } else {
        $odev = $impar;
    }
    ?>
    <tr bgcolor="#<?php 
    echo $odev;
    ?>
" onmouseout="style.background='#<?php 
    echo $odev;