Jump to content

  2. →
  3. →

Photo

Consulta Com Filtros E Grid Php

Started By rogeriodias, 03/11/2011, 16:33

  • Faça o login para participar
2 replies to this topic

#1 rogeriodias

rogeriodias

    Turista

  • Usuários
  • 37 posts
  • Sexo:Masculino
  • Localidade:Belo Horizonte-MG
  • Interesses:Programação, Música, Carros

Posted 03/11/2011, 16:33

Amigos, boa tarde, quero desenvolver uma página de busca no banco de dados utilizando alguns filtros e uma grid que receberá o resultado da busca.
Abaixo segue o código com os filtros que pretendo utilizar, mas não estou sabendo ativa-los para buscar os dados e jogar na grid.

<?php
session_start();
if (!isset($_SESSION["login"])  ||  !isset($_SESSION["senha"]) || ($_SESSION["nivel"] <> 2))
{
header("location: ../../../formulario.php");	
exit;
}
include_once "../../../include/config.php";
$consulta=mysql_query("SELECT * FROM ordem order by ordem.id"); 
?>
<link rel="stylesheet" type="text/css" href="../../../css-geral.css"/>
<link type="stylesheet" type="text/css" href="/calendar/calendar-win2k-1.css" />
<title>Consulta</title>
<style type="text/css">
body {
	background-color: #f2f5f7;
}
</style>
<body class="pleno"><center>
<body style="margin:0px;">
<td align="center">&nbsp;</td>

<p>&nbsp;</p></td>
<form method="post" name="form" id="form" action="consulta.php">
  
  <input type="hidden" name="form_name" id="form_form_name" value="form"/>
<input type="hidden" name="codPessoaPrestador" id="form_codPessoaPrestador" value=""/>
<input type="hidden" name="codPessoa" id="form_codPessoa" value=""/>
<table width="70%" align="center" class="form" id="form-form">
<tr>
  <td>
<table align="left" class="fields" id="form-fields">
<tr class="fields">
<td width="139" align="left" class="fields"><label for="form_numeroOs"><span class="grid">Número</span></label>
  <span class="grid">&nbsp;</span></td>
<td align="left" colspan="3"><input name="numeroOs" type="text" class="campo2" id="form_numeroOs" style="text-align:left;" onKeyPress="javascript:return integerFilter(event);" value="" size="10" maxlength="10"/></td>
</tr>
<tr class="fields">
  
  <td class="fields" align="left"><label for="form_codPosicao"><span class="grid">Posição</span></label>
    <span class="grid">&nbsp;</span></td>
  <td align="left" colspan="3"><select name="codPosicao" size="1" class="estiloform_posicao" id="form_codPosicao"><option value="0">Selecione...</option><?php
include_once "../../../include/config.php";
$consulta2=mysql_query("SELECT * FROM posicao order by nome ASC"); 
while ($dados2 = mysql_fetch_array($consulta2)) {
echo("<option value='".$dados2['nome']."'>".$dados2['nome']."</option>");
}
?></select></td>
  
</tr>
<tr class="fields">
  <td class="fields" align="left"><label for="form_nomeRazao"><span class="grid">Cliente</span></label>
    <span class="grid">&nbsp;</span></td>
  <td align="left" colspan="3"><input name="nomeRazao" type="text" class="campo4" id="form_nomeRazao" onBlur="limpaPessoa(this);" value="" size="40" maxlength="100" autocomplete="off"/><div class="auto_complete" id="form_nomeRazao_auto_complete_div"/></td>
</tr>
<tr class="range-line date">
<td class="range-line date" align="left"><label for="dataAberturaInicial_field"><span class="grid">Data de Abertura</span></label>
  <span class="grid">&nbsp;</span></td>
<td width="160" align="left"><input name="dataAberturaInicial" type="text" class="campo3" id="dataAberturaInicial_field" value="" size="10" maxlength="10"/><img align="top" style="cursor:hand" src="imagens/calendar_1.4.gif" id="dataAberturaInicial_field-button"  alt="Calendário" title="Calendário" class="v-middle"/></td>
<td width="14" align="left" class="fields"><label for="dataAberturaFinal_field"></label>&nbsp;</td>
<td width="149" align="left"><input name="dataAberturaFinal" type="text" class="campo3" id="dataAberturaFinal_field" value="" size="10" maxlength="10"/><img align="top" style="cursor:hand" src="imagens/calendar_1.4.gif" id="dataAberturaFinal_field-button"  alt="Calendário" title="Calendário"/></td>
</tr>
<tr class="fields">
<td class="fields" align="left"><label for="dataBaixaInicial_field"><span class="grid">Data de Baixa</span></label>
  <span class="grid">&nbsp;</span></td>
<td align="left"><input name="dataBaixaInicial" type="text" class="campo3" id="dataBaixaInicial_field" value="" size="10" maxlength="10"/><img align="top" style="cursor:hand" src="imagens/calendar_1.4.gif" id="dataBaixaInicial_field-button"  alt="Calendário" title="Calendário"/></td>

<td class="fields" align="left"><label for="dataBaixaFinal_field"></label>&nbsp;</td>
<td align="left"><input name="dataBaixaFinal" type="text" class="campo3" id="dataBaixaFinal_field" value="" size="10" maxlength="10"/><img align="top" style="cursor:hand" src="imagens/calendar_1.4.gif" id="dataBaixaFinal_field-button"  alt="Calendário" title="Calendário"/></td>
</tr>
<tr class="fields">
  <td class="fields" align="left"><label for="form_codTecnicoResponsavel"><span class="grid">Técnico</span></label>
    <span class="grid">&nbsp;</span></td>
  <td align="left" colspan="3"><select name="codTecnicoResponsavel" size="1" class="estiloform8" id="form_codTecnicoResponsavel"><option value="0">Selecione...</option><?php
include_once "../../../include/config.php";
$consulta2=mysql_query("SELECT * FROM usuarios order by nome ASC"); 
while ($dados2 = mysql_fetch_array($consulta2)) {
echo("<option value='".$dados2['nome']."'>".$dados2['nome']."</option>");
}
?></select></td>
  
</tr>
<tr class="fields">
  <td class="fields" align="left"><label for="form_observacao" class="grid">Observação</label>&nbsp;</td>
  <td align="left" colspan="3"><textarea name="observacao" cols="50" rows="3" class="estiloform7" id="form_observacao" style="resize: none;"></textarea></td>
  
</tr>
<tr class="fields">
<td class="fields" align="left"><label for="form_defeito"><span class="grid">Serviço</span></label>
  <span class="grid">&nbsp;</span></td>
<td align="left" colspan="3"><input name="defeito" type="text" class="campo" id="form_defeito" value="" size="20"/></td>
</tr>
<tr class="fields">
  <td class="fields" align="left"><label for="form_numeroAtendimento" class="grid">Número do Atendimento</label>&nbsp;</td>
  <td align="left" colspan="3"><input name="numeroAtendimento" type="text" class="campo2" id="form_numeroAtendimento" style="text-align:right;display:block;" onKeyPress="javascript:return integerFilter(event);" value="" size="6" maxlength="6"/></td>
</tr>

<tr class="fields">
<td class="fields" align="left"><label for="form_codAparelhoOpcional1" class="grid">Tipo de Atendimento</label>&nbsp;</td>
<td align="left" colspan="3"><select name="codAparelhoOpcional1" size="1" class="campo3" id="form_codAparelhoOpcional1"><option value="0">Selecione...</option><?php
include_once "../../../include/config.php";
$consulta2=mysql_query("SELECT * FROM atendimento order by nome ASC"); 
while ($dados2 = mysql_fetch_array($consulta2)) {
echo("<option value='".$dados2['nome']."'>".$dados2['nome']."</option>");
}
?></select></td>
</tr>
<tr class="fields">
<td class="fields" colspan="4">
<fieldset id="form_fsBaixa">
<legend class="grid" id="form_fsBaixa-legend">Situação</legend>
<table class="fields" id="form_fsBaixa-fields">
<tr class="fields">
<td class="fields" align="left"><label for="form_aberto" class="grid">Aberta</label>&nbsp;</td>

<td align="left"><input type="checkbox" name="aberto" id="form_aberto" checked="checked" style="margin:0px 30px 0px 0px;"/></td>
<td class="fields" align="left"><label for="form_baixado" class="grid">Baixada</label>&nbsp;</td>
<td align="left"><input type="checkbox" name="baixado" id="form_baixado" style="margin:0px 30px 0px 0px;"/></td>
</tr>
</table>
</fieldset>
</td>
</tr>
</table>
</td></tr>
<tr><td align="left">
<table id="form-buttons">
<tr class="buttons"><td class="buttons"><input name="pesquisa" type="submit" class="grid" id="form_pesquisa" value="Consulta"/></td><td class="buttons"><input name="relatorioPdf" type="submit" class="grid" id="form_relatorioPdf" value="Imprime"/></td><td class="buttons"><input name="Novo" type="submit" class="grid" id="form_Novo" value="Nova O.S."/></td></tr>
</table>
</td></tr>
</table>
</form>
  <table width="70%" border="1" cellpadding="0" cellspacing="0" bordercolor="#000000" class="bordasimples">
    <tr>
     <td bgcolor="#4B87C2"><div align="left" class="tabelas"><strong>&nbsp;N&uacute;mero</strong></div></td>
     <td height="25" bgcolor="#4B87C2"><div align="left" class="tabelas"><strong>&nbsp;Abertura</strong></div></td>
     <td bgcolor="#4B87C2"><div align="left" class="tabelas"><strong>&nbsp;Cliente</strong></div></td>
     <td bgcolor="#4B87C2"><div align="left" class="tabelas"><strong>&nbsp;Servi&ccedil;o</strong></div></td>
     <td bgcolor="#4B87C2"><div align="left" class="tabelas"><strong>&nbsp;Agente</strong></div></td>
     <td colspan="2" align="center" valign="middle" bgcolor="#4B87C2"><div align="center" class="tabelas"><strong>A&ccedil;&otilde;es</strong></div></td>
   </tr>
   <?php
  while($l = mysql_fetch_array($consulta)) {
  $id = $l["id"];
  $data = $l["datafinal"];
  $cliente = $l["cliente"];
  $descricao = $l["descricao"];
  $tecnico = $l["tecnico"];
  echo "
  		<tr>
		    <td height='23px' style='font-family:Lucida Sans Unicode, Lucida Grande, sans-serif; font-size:11px;'><font class=grid>&nbsp; $id</td>
			<td height='23px' style='font-family:Lucida Sans Unicode, Lucida Grande, sans-serif; font-size:11px;'><font class=grid>&nbsp; $data</td>
			<td height='23px' style='font-family:Lucida Sans Unicode, Lucida Grande, sans-serif; font-size:11px;'><font class=grid>&nbsp; $cliente </td>
			<td height='23px' style='font-family:Lucida Sans Unicode, Lucida Grande, sans-serif; font-size:11px;'><font class=grid>&nbsp; $descricao </td>
			<td height='23px' style='font-family:Lucida Sans Unicode, Lucida Grande, sans-serif; font-size:11px;'><font class=grid>&nbsp; $tecnico </td>
			<td><div align=center valign=top><a href=\"layout/visualizar.php?id=$id\"target=_blank><img src=\"../../../imagens/ico_lupa.gif\" /></a></td><td><div align=center valign=top><a href=\"layout/imprimir.php?id=$id\" target=_blank><img src=\"../../../imagens/icone_impressora.gif\" /></a></div></td>
		</tr>\n";
}
@mysql_close();
?>
 </table>
 <table width="70%" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <th width="48" scope="col">&nbsp;</th>
    <th width="606" scope="col"></th>
    <th width="95" scope="col">&nbsp;</th>

    <th width="86" scope="col">&nbsp;</th>
  </tr>
  <tr>
    <td><a href="index.php" style="border:none; text-decoration:none;">
      <input name="button2" type="reset" value="Voltar" style="font-family:Verdana, Geneva, sans-serif; font-size:10px">
    </a></td>
    <td><a href="/admin/index.php" style="border:none; text-decoration:none;">
      <input name="button" type="reset" value="Principal" style="cursor:pointer; font-family:Verdana, Geneva, sans-serif; font-size:10px">
    </a></td>

    <td align="left" valign="bottom">&nbsp;</td>
    <td align="left" valign="bottom">&nbsp;</td>
  </tr>
</table>
</center>
<a href="../../index.php"><br />
<center>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
</center>
</a>

Me ajudem!
Abraços!

#2 rogeriodias

rogeriodias

    Turista

  • Usuários
  • 37 posts
  • Sexo:Masculino
  • Localidade:Belo Horizonte-MG
  • Interesses:Programação, Música, Carros

Posted 07/11/2011, 14:12

Alguém? :blink:

#3 Miguceamma

Miguceamma

    MiguPenjisse

  • Usuários
  • 13201 posts

Posted 29/10/2017, 12:43

Online Pharmacy Slimex Pharmacy Shop Buy Cialis Amoxicillin And Dogs viagra Order Cheapest Flagyl In Salem
Voltar para PHP


1 user(s) are reading this topic

0 membro(s), 1 visitante(s) e 0 membros anônimo(s)

  1. Fórum WMO
  2. → Desenvolvimento
  3. → PHP
  4. Privacy Policy
  5. Regras ·
IPB Skin By Virteq