SHOW:
|
|
- or go back to the newest paste.
| 1 | <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> | |
| 2 | <html xmlns="http://www.w3.org/1999/xhtml"> | |
| 3 | <head> | |
| 4 | <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> | |
| 5 | <title>Resultados - Eliz Imoveis</title> | |
| 6 | <style type="text/css"> | |
| 7 | .tabela {
| |
| 8 | background-color: #009999; | |
| 9 | font-family: Arial, Helvetica, sans-serif; | |
| 10 | font-size: 12px; | |
| 11 | color: #38322E; | |
| 12 | } | |
| 13 | .backgroundtabela {
| |
| 14 | color: #000000; | |
| 15 | background-color: #e6f2ff; | |
| 16 | font-family: Arial, Helvetica, sans-serif; | |
| 17 | font-size: 12px; | |
| 18 | text-align: center; | |
| 19 | } | |
| 20 | .distribuicao {
| |
| 21 | font-weight: bold; | |
| 22 | color: #544D5B; | |
| 23 | } | |
| 24 | .backgroundtabela tr td {
| |
| 25 | font-weight: normal; | |
| 26 | text-align: left; | |
| 27 | } | |
| 28 | </style></head> | |
| 29 | ||
| 30 | <body> | |
| 31 | <p> | |
| 32 | <?php | |
| 33 | ||
| 34 | $conecta = mysql_connect("mysql5.000webhost.com","a6553151_eliz","agua123");
| |
| 35 | mysql_select_db("a6553151_elizdb");
| |
| 36 | ||
| 37 | - | $criterio = $_POST['acao']; |
| 37 | + | $criterio = $_POST['campo_busca']; |
| 38 | - | $query = mysql_query("SELECT * FROM tabelas WHERE tabelas.nome LIKE '%$linhaImovel%'");
|
| 38 | + | $query = mysql_query("SELECT * FROM tabelas WHERE tabelas.nome LIKE '%$criterio%'");
|
| 39 | $nr_linhas = mysql_num_rows($query); | |
| 40 | ||
| 41 | ?> | |
| 42 | <?php for($i=0;$i<$nr_linhas;$i++){ $campo = mysql_fetch_assoc($query); ?>
| |
| 43 | <table width="491" height="76" border="1"> | |
| 44 | <tr> | |
| 45 | <td width="56" align="center" class="tabela">Código</td> | |
| 46 | <td width="122" align="center" class="tabela">Bairro</td> | |
| 47 | <td width="91" align="center" class="tabela">Valor de Venda</td> | |
| 48 | <td width="91" align="center" class="tabela">Valor de Locação</td> | |
| 49 | <td width="91" align="center" class="tabela">Valor de Condominio</td> | |
| 50 | </tr> | |
| 51 | <tr> | |
| 52 | <td class="backgroundtabela"><?php echo $campo['codigo']; ?></td> | |
| 53 | <td class="backgroundtabela"><?php echo $campo['bairro']; ?></td> | |
| 54 | <td class="backgroundtabela">R$ <?php echo number_format($campo['valor_venda'],3,",","."); ?></td> | |
| 55 | <td class="backgroundtabela">R$ <?php echo number_format($campo['valor_locacao'],3,",","."); ?></td> | |
| 56 | <td class="backgroundtabela">R$ <?php echo number_format($campo['valor_condominio'],3,",","."); ?></td> | |
| 57 | </tr> | |
| 58 | <tr> | |
| 59 | <td><div align="center" class="tabela">Tipo</div></td> | |
| 60 | <td><div align="center" class="tabela">Construtora</div></td> | |
| 61 | <td><div align="center" class="tabela">Domitórios</div></td> | |
| 62 | <td><div align="center" class="tabela">Suites</div></td> | |
| 63 | <td><div align="center" class="tabela">Vagas</div></td> | |
| 64 | </tr> | |
| 65 | <tr class="backgroundtabela"> | |
| 66 | <td><?php echo $campo['tipo']; ?></td> | |
| 67 | <td><?php echo $campo['construtora']; ?></td> | |
| 68 | <td><?php echo $campo['dormitorios']; ?></td> | |
| 69 | <td><?php echo $campo['suites']; ?></td> | |
| 70 | <td><?php echo $campo['vagas']; ?></td> | |
| 71 | </tr> | |
| 72 | <tr> | |
| 73 | <p> </p> | |
| 74 | </table> | |
| 75 | <table width="491" border="1" class="backgroundtabela"> | |
| 76 | <tr> | |
| 77 | <td height="71"><span class="distribuicao">Distribuição</span>:<?php echo $campo['distribuicao']; ?></td> | |
| 78 | </tr> | |
| 79 | <tr> | |
| 80 | <td height="78"><span class="distribuicao">Destaques</span>:<?php echo $campo['destaques']; ?></td> | |
| 81 | </tr> | |
| 82 | </table> | |
| 83 | <table width="491" border="1"> | |
| 84 | <tr> | |
| 85 | <th width="70" class="tabela" scope="row">Endereço</th> | |
| 86 | <td width="406" class="backgroundtabela"><?php echo $campo['local']; ?></td> | |
| 87 | </tr> | |
| 88 | <?php } ?> | |
| 89 | </table> | |
| 90 | <p><a href="index.php">Voltar e fazer outra busca</a></p> | |
| 91 | </body> | |
| 92 | </html> |
