Jump to content


Terenight

Member Since 06/02/2004
Offline Last Active 10/10/2007, 16:05
-----

Posts I've Made

In Topic: Busca No Bd

25/09/2007, 10:40

Amigo vou colocar as duas páginas para vê se vc consegue entender melhor


busca.php

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><title>Rosangela Administradora</title><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><script language="JavaScript" type="text/JavaScript"><!--function MM_preloadImages() { //v3.0  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();	var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)	if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}}//--></script></head><body bgcolor="824F2A" text="#FFFFFF" link="#FFFFFF" vlink="#CCCCCC" alink="#CCCCCC" leftmargin="0" topmargin="0" rightmargin="0"><div align="center">  <table width="90%" border="0">	<tr>	  <td><div align="center">		  <div align="left"> </div>		  <div align="center"></div>		  <div align="left"></div>		  <div align="left"></div>		  <div align="left"></div>		  <table width="780" border="0" cellspacing="0">			<tr> 			  <td width="471">&nbsp;</td>			  <td width="377">&nbsp;</td>			</tr>			<tr> 			  <td colspan="2"><div align="left"><font color="#FFFFFF" size="2" face="Verdana, Arial, Helvetica, sans-serif">Qualquer 				  d&uacute;vida sobre o im&oacute;v&eacute;l ou nossa empresa 				  ou ainda sobre nossas formas de negocia&ccedil;&atilde;o, entre 				  em contato conosco e esclareceremos tudo que for poss&iacute;vel. 				  Para isso <a href="cont.htm">clique aqui</a>. 				  <?//import_request_variables( "Pg", "_" );//$var = $_btnEnviar;//echo $var;//if ( isset( $var ) ) {  $con = mysql_connect( "localhost","roadm_user","pass" ) or die ('Não foi possível conectar ao servidor ' . mysql_error() );//  $con = mysql_connect( "localhost","root","311203" ) or die ('Não foi possível conectar ao servidor ' . mysql_error() );  mysql_select_db( "roadm_rosangela" ) or die ('Não foi possível conectar à tabela ' . mysql_error() );  $sql_select = 'select * from imovel';  $result = mysql_query( "$sql_select" ) or die( 'Não foi possível abrir dados ' . mysql_error() );  $row = mysql_fetch_array( $result );	?>				  <br>				  <br>				  </font></div></td>			</tr>			<tr> 			  <td colspan="2"><form name="form1" method="post" action="buscar.php">				  <table border="0" align="center" cellpadding="0" cellspacing="0">					<!--DWLayoutTable-->					<tr> 					  <td width="35" height="25">&nbsp;</td>					  <td width="200" rowspan="11" valign="top"><div align="justify">						  <p><font face="Verdana, Arial, Helvetica, sans-serif"><br>							<br>							Selecione os dados para encontrar o im&oacute;vel 							que voc&ecirc; procura.</font></p>						  <table width="100%" border="0" cellspacing="0" cellpadding="0">							<tr> 							  <td><div align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Busca 								  por n&ordm; do Im&oacute;vel:</font></div></td>							</tr>							<tr> 							  <td><div align="center"> 								  <input name="numero" type="text" size="13">								</div></td>							</tr>							<tr> 							  <td><div align="center"> 								  <input type="submit" name="Submit2" value="Buscar">								</div></td>							</tr>						  </table>						  <p>&nbsp;</p>						</div></td>					  <td width="34" valign="top"><!--DWLayoutEmptyCell-->&nbsp;</td>					  <td width="85" valign="top" bgcolor="#6D4323"> <div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Cidade</font> 						</div></td>					  <td width="10" valign="top" bgcolor="#6D4323"><!--DWLayoutEmptyCell-->&nbsp;</td>					  <td width="200" bgcolor="#6D4323"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> 						<select name="cbxcidade">						  <option value="0" selected>&lt;----------TODOS----------&gt;</option>						  <?		  $sql_cidade = 'select * from cidade';		  $result_cidade = mysql_query( "$sql_cidade" ) or die( 'Não foi possível abrir dados ' . mysql_error() );		  while ( $row_cidade = mysql_fetch_array( $result_cidade ) ) {				?>						  <option value="<? echo $row_cidade["IdCidade"] ?>"><? echo $row_cidade["NmCidade"] ?> 						  <? 		  } 		  mysql_free_result( $result_cidade );		  		?>						</select>						</font></td>					</tr>					<tr> 					  <td height="21"> 					  <td valign="top"><!--DWLayoutEmptyCell-->&nbsp;</td>					  <td valign="top" bgcolor="#6D4323"> <div align="right"></div></td>					  <td valign="top" bgcolor="#6D4323"><!--DWLayoutEmptyCell-->&nbsp;</td>					  <td width="200" bgcolor="#6D4323"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">&nbsp;</font></td>					</tr>					<tr> 					  <td height="25">&nbsp;</td>					  <td valign="top"><!--DWLayoutEmptyCell-->&nbsp;</td>					  <td valign="top" bgcolor="#6D4323"> <div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Neg&oacute;cio 						  </font> </div></td>					  <td valign="top" bgcolor="#6D4323"><!--DWLayoutEmptyCell-->&nbsp;</td>					  <td width="200" bgcolor="#6D4323"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> 						<select name="cbxnegocio">						  <option value="0">&lt;----------TODOS----------&gt;</option>						  <?		  $sql_negocio = 'select * from negocio';		  $result_negocio = mysql_query( "$sql_negocio" ) or die( 'Não foi possível abrir dados ' . mysql_error() );		  while ( $row_negocio = mysql_fetch_array( $result_negocio ) ) {				?>						  <option value="<? echo $row_negocio["IdNegocio"] ?>"><? echo $row_negocio["NmNegocio"] ?> 						  <? 		  } 		  mysql_free_result( $result_negocio );		  		?>						</select>						</font></td>					</tr>					<tr> 					  <td height="21">&nbsp;</td>					  <td valign="top"><!--DWLayoutEmptyCell-->&nbsp;</td>					  <td valign="top" bgcolor="#6D4323"> <div align="right"></div></td>					  <td valign="top" bgcolor="#6D4323"><!--DWLayoutEmptyCell-->&nbsp;</td>					  <td width="200" bgcolor="#6D4323"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">&nbsp;</font></td>					</tr>					<tr> 					  <td height="25">&nbsp;</td>					  <td valign="top"><!--DWLayoutEmptyCell-->&nbsp;</td>					  <td valign="top" bgcolor="#6D4323"> <div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Tipo</font> 						</div></td>					  <td valign="top" bgcolor="#6D4323"><!--DWLayoutEmptyCell-->&nbsp;</td>					  <td width="200" bgcolor="#6D4323"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> 						<select name="cbxtipoimovel">						  <option value="0">&lt;----------TODOS----------&gt;</option>						  <?		  $sql_tpimovel = 'select * from tpimovel';		  $result_tpimovel = mysql_query( "$sql_tpimovel" ) or die( 'Não foi possível abrir dados ' . mysql_error() );		  while ( $row_tpimovel = mysql_fetch_array( $result_tpimovel ) ) {				?>						  <option value="<? echo $row_tpimovel["IdTpImovel"] ?>"><? echo $row_tpimovel["NmTpImovel"] ?> 						  <? 		  } 		  mysql_free_result( $result_tpimovel );		  		?>						</select>						</font></td>					</tr>					<tr> 					  <td height="21">&nbsp;</td>					  <td valign="top"><!--DWLayoutEmptyCell-->&nbsp;</td>					  <td valign="top" bgcolor="#6D4323"><!--DWLayoutEmptyCell-->&nbsp;</td>					  <td valign="top" bgcolor="#6D4323"><!--DWLayoutEmptyCell-->&nbsp;</td>					  <td bgcolor="#6D4323"><!--DWLayoutEmptyCell-->&nbsp;</td>					</tr>					<tr> 					  <td height="21">&nbsp;</td>					  <td valign="top"><!--DWLayoutEmptyCell-->&nbsp;</td>					  <td valign="top" bgcolor="#6D4323"><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Quartos</font></div></td>					  <td valign="top" bgcolor="#6D4323"><!--DWLayoutEmptyCell-->&nbsp;</td>					  <td bgcolor="#6D4323"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> 						<select name="cbxnrqtos" id="select2">						  <option value="0">&lt;----------TODOS----------&gt;</option>						  <option value="1">1 quarto</option>						  <option value="2">2 quartos</option>						  <option value="3">3 quartos</option>						  <option value="4">4 quartos</option>						  <option value="5">Acima de 4 quartos</option>						</select>						</font></td>					</tr>					<tr> 					  <td height="21">&nbsp;</td>					  <td valign="top"><!--DWLayoutEmptyCell-->&nbsp;</td>					  <td valign="top" bgcolor="#6D4323"> <div align="right"></div></td>					  <td valign="top" bgcolor="#6D4323"><!--DWLayoutEmptyCell-->&nbsp;</td>					  <td width="200" bgcolor="#6D4323"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">&nbsp;</font></td>					</tr>					<tr> 					  <td height="25">&nbsp;</td>					  <td rowspan="3" valign="top"><!--DWLayoutEmptyCell-->&nbsp;</td>					  <td valign="top" bgcolor="#6D4323"> <div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Valor</font> 						</div></td>					  <td valign="top" bgcolor="#6D4323"><!--DWLayoutEmptyCell-->&nbsp;</td>					  <td width="200" bgcolor="#6D4323"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> 						<select name="cbxvalor">						  <option value="0">&lt;----------TODOS----------&gt;</option>						  <option value="1">R$ 30.000 a R$ 50.000</option>						  <option value="2">R$ 50.000 a R$ 100.000</option>						  <option value="3">R$ 100.000 a R$ 200.000</option>						  <option value="4">R$ 200.000 a R$ 500.000</option>						  <option value="5">Acima de R$ 500.000</option>						</select>						</font></td>					</tr>					<tr> 					  <td height="21">&nbsp;</td>					  <td colspan="2" valign="top" bgcolor="#6D4323"><!--DWLayoutEmptyCell-->&nbsp;</td>					  <td width="200" bgcolor="#6D4323">&nbsp;</td>					</tr>					<tr> 					  <td height="26">&nbsp;</td>					  <td colspan="2" valign="top" bgcolor="#6D4323"><!--DWLayoutEmptyCell-->&nbsp;</td>					  <td width="200" bgcolor="#6D4323"> <input type="submit" name="Submit" value="Localizar"></td>					</tr>				  </table>				  <div align="center"></div>				</form></td>			</tr>			<tr> 			  <td colspan="2"><div align="center"><font color="#CCCCCC" size="1" face="Verdana, Arial, Helvetica, sans-serif">Copyright 				  2004 - ROSANGELA ADMINISTRADORA DE IM&Oacute;VEIS- Todos os 				  Direitos Reservados<font color="824F2A">...................................</font> 				  By T-Design</font></div></td>			</tr>		  </table>		  <p>&nbsp;</p>		</div>		<div align="center"></div>		<div align="center"></div>		<div align="center"></div></td>	</tr>  </table></div></body></html>

buscar.php


IPB Skin By Virteq