session_start(); include "../includes/include_configuracao.php"; include "../includes/include_verifica_usuario.php"; include "../includes/include_conexao.php"; include "../includes/include_cabecalho.php"; include "../includes/include_funcoes.php"; include "ini.php"; $regsporpag = $registros_pagina; $pagina = $_GET["pagina"]; $ordem = $_GET["ordem"]; $sentido = $_GET["sentido"]; $palavrachave = $_GET["palavrachave"]; if ($pagina == "") {$pagina = "1";} if ($ordem == "") {$ordem = "Pro_Codigo";} if ($sentido == "") {$sentido = "desc";} $inicio = (intval($pagina) * $regsporpag) - $regsporpag; $sql = "SELECT * FROM produtos as P inner join categorias as C on P.Cod_Categoria = C.Cod_Categoria"; if ($palavrachave != "") { $sql .= "and (Pro_Nome like '%".$palavrachave."%' or Pro_Desc like '%".$palavrachave."%' or Cat_Titulo like '%".$palavrachave."%' or Pro_Codigo like '%".$palavrachave."%') "; } $rs_total = mysql_query($sql); $total_registros = mysql_num_rows($rs_total); $sql .= " order by ".$ordem." ".$sentido." limit ".$inicio.",".$regsporpag; $rs_pro = mysql_query($sql); $total_paginas = ceil($total_registros / $regsporpag); if ($total_paginas == 0) {$total_paginas = 1;} ?>
|
||||||||||||||||||||||||