Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on May 9th, 2012  |  syntax: None  |  size: 4.85 KB  |  hits: 19  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. <html>
  2. <head>
  3. <title>SISTEMA</title>
  4. </head>
  5. <body>
  6.  
  7. <?
  8. $db="";
  9. $usuario=" ";
  10. $password=" ";
  11. $host = "localhost";
  12. $connect = mysql_connect($host,$usuario,$password)or_die("Erro ao se conectar!");
  13. if ($connect){
  14.  $banco = mysql_select_db($db)or_die("Banco de dados não encontrado!");
  15. }
  16. ?>
  17.  
  18.  
  19.  
  20.  
  21.  
  22.  
  23. <?php
  24. function cria_select(){
  25. echo "<select name='clientes'>";
  26. $query = mysql_query("select id, nome from clientes order by nome";
  27. while($row=
  28. mysql_fetch_object($query)){
  29. echo '<option value="'.$row->id.'">';
  30. echo $row->nome.'</option>';
  31. }
  32. echo '</select>';
  33. }
  34. ?>
  35.  
  36. <form method="GET">
  37.             cria_select();     
  38. <input type="submit" value="Submeter"></p>
  39. </form>
  40.  
  41. <p>
  42.   <?php
  43. $id = $_GET("clientes");
  44.  
  45. $sql = "SELECT TOP 100 PERCENT RazaoSocial, NomeFantasia, Endereco, Bairro, Cidade, UF, Cep, Telefone_Fixo_01, Telefone_Fixo_02, Telefone_Fax, email,Responsavel, Seguradora, Telefone_Seguradora, Contato_01, Cargo_01, Tel01_Cargo_01, Tel02_Cargo_01, EMail_Cargo_01, Contato_02, Cargo_02,Tel01_Cargo_02, Tel02_Cargo_02, Email_Cargo_02, Contato_03, Cargo_03, Tel01_Cargo_03, Tel02_Cargo_03, Email_Contato_03,Procedimentos
  46.  
  47. FROM dbo.Tab_CadastroClientes
  48.  
  49. WHERE id == $id
  50.  
  51. ORDER BY NomeFantasia)";
  52.  
  53.  
  54. $query= mysql_query($sql);
  55. $dados = mysql_fetch_row($query);
  56. ?>
  57. </p>
  58. <table cellspacing="0" cellpadding="0">
  59.   <tr>
  60.     <td colspan="11" valign="middle" height="85">&nbsp;</td>
  61.   </tr>
  62.   <tr>
  63.     <td bgcolor="#00CCFF" colspan="11" valign="middle"><p align="center"><strong>DADOS DA EMPRESA</strong></td>
  64.   </tr>
  65.   <tr>
  66.     <td bgcolor="#FFFFCC" colspan="2" valign="middle"><strong> Razão Social:</strong></td>
  67.     <td colspan="9" bgcolor="#CCCCCC" valign="middle">&nbsp;</td>
  68.   </tr>
  69.   <tr>
  70.     <td bgcolor="#FFFFCC" colspan="2" valign="middle"><strong> Nome Fantasia:</strong></td>
  71.     <td colspan="9" bgcolor="#CCCCCC" valign="middle">&nbsp;</td>
  72.   </tr>
  73.   <tr>
  74.     <td bgcolor="#FFFFCC" colspan="2" valign="middle"><strong> Endereço:</strong></td>
  75.     <td colspan="4" bgcolor="#C0C0C0" valign="middle">&nbsp;</td>
  76.     <td width="110" bgcolor="#FFFFCC" valign="middle"><strong> Bairro:</strong></td>
  77.     <td bgcolor="#C0C0C0" colspan="2" valign="middle">&nbsp;</td>
  78.     <td width="106" valign="middle" bgcolor="#FFFFCC"><strong> Cidade:</strong></td>
  79.     <td width="470" bgcolor="#C0C0C0" valign="middle">&nbsp;</td>
  80.   </tr>
  81.   <tr>
  82.     <td bgcolor="#FFFFCC" colspan="2" valign="middle"><strong> Telefone:</strong></td>
  83.     <td width="29" bgcolor="#C0C0C0" valign="middle">&nbsp;</td>
  84.     <td width="64" valign="middle" bgcolor="#FFFFCC"><strong> Telefone:</strong></td>
  85.     <td bgcolor="#C0C0C0" colspan="2" valign="middle">&nbsp;</td>
  86.     <td width="110" bgcolor="#FFFFCC" valign="middle"><strong> E-Mail:</strong></td>
  87.     <td colspan="4" bgcolor="#C0C0C0" valign="middle">&nbsp;</td>
  88.   </tr>
  89.   <tr>
  90.     <td bgcolor="#FFFFCC" colspan="2" valign="middle"><strong> Responsável:</strong></td>
  91.     <td colspan="9" bgcolor="#C0C0C0" valign="middle">&nbsp;</td>
  92.   </tr>
  93.   <tr>
  94.     <td colspan="11" bgcolor="#00CCFF" valign="middle"><p align="center"><strong>CONTATOS DE    EMERGÊNCIA</strong></td>
  95.   </tr>
  96.   <tr>
  97.     <td width="90" bgcolor="#FFFFCC" valign="middle"><strong> Nome:</strong></td>
  98.     <td colspan="3" bgcolor="#C0C0C0" valign="middle">&nbsp;</td>
  99.     <td width="46" bgcolor="#FFFFCC" valign="middle" align="center"><strong> Cargo:</strong></td>
  100.     <td colspan="2" bgcolor="#C0C0C0" valign="middle">&nbsp;</td>
  101.     <td width="64" bgcolor="#FFFFCC" valign="middle" align="center"><strong> Telefone:</strong></td>
  102.     <td colspan="3" bgcolor="#C0C0C0" valign="middle">&nbsp;</td>
  103.   </tr>
  104.   <tr>
  105.     <td width="90" bgcolor="#FFFFCC" valign="middle"><strong> Nome:</strong></td>
  106.     <td colspan="3" bgcolor="#C0C0C0" valign="middle">&nbsp;</td>
  107.     <td width="46" bgcolor="#FFFFCC" valign="middle" align="center"><strong> Cargo:</strong></td>
  108.     <td colspan="2" bgcolor="#C0C0C0" valign="middle">&nbsp;</td>
  109.     <td width="64" bgcolor="#FFFFCC" valign="middle" align="center"><strong> Telefone:</strong></td>
  110.     <td colspan="3" bgcolor="#C0C0C0" valign="middle">&nbsp;</td>
  111.   </tr>
  112.   <tr>
  113.     <td width="90" bgcolor="#FFFFCC" valign="middle"><strong> Nome:</strong></td>
  114.     <td colspan="3" bgcolor="#C0C0C0" valign="middle">&nbsp;</td>
  115.     <td width="46" bgcolor="#FFFFCC" valign="middle" align="center"><strong> Cargo:</strong></td>
  116.     <td valign="middle" colspan="2" bgcolor="#C0C0C0">&nbsp;</td>
  117.     <td width="64" bgcolor="#FFFFCC" valign="middle" align="center"><strong> Telefone:</strong></td>
  118.     <td colspan="3" bgcolor="#C0C0C0" valign="middle">&nbsp;</td>
  119.   </tr>
  120.   <tr>
  121.     <td colspan="11" bgcolor="#00CCFF" valign="middle"><p align="center"><strong>PROCEDIMENTOS</strong></td>
  122.   </tr>
  123.   <tr>
  124.     <td colspan="11" valign="middle" bgcolor="#C0C0C0">&nbsp;</td>
  125.   </tr>
  126. </table>
  127. <p>&nbsp;</p>
  128. </body>
  129.  
  130.  
  131.  
  132. </html>
create a new version of this paste RAW Paste Data