PHP Classes

File: mostraTabelas.php

Recommend this page to a friend!
  Classes of Diego Gomes Araujo   GetClass   mostraTabelas.php   Download  
File: mostraTabelas.php
Role: Application script
Content type: text/plain
Description: Interface do Gerador
Class: GetClass
Generate classes to access database records
Author: By
Last change:
Date: 16 years ago
Size: 10,413 bytes
 

Contents

Class file image Download
<?php include("classes/Gerador.php"); session_start(); $gerador = new Gerador(); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>GetClass</title> <link href="css/css.css" rel="stylesheet" type="text/css" /> </head> <script language="javascript"> // função para selecionar todos os users function check(count) { var elem = document.formTabelas.elements; if(count == 0) { for(i=0;i<elem.length;i++) { var x = elem[i]; if(x.name == "tabelas[]") { x.checked = true; } } } else { for(i=0;i<elem.length;i++) { var x = elem[i]; if(x.name == "tabelas[]") { x.checked = false; } } } } </script> <body> <table width="98%" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td><img src="imagens/quadrado_branco.jpg" width="10" height="10" /></td> <td><img src="imagens/quadrado_branco.jpg" width="10" height="10" /></td> <td><img src="imagens/quadrado_branco.jpg" width="10" height="10" /></td> </tr> <tr> <td width="1%" align="left" valign="top" background="imagens/layout pg/fundo_topo.jpg"><img src="imagens/layout pg/topo_esquerdo.jpg" width="13" height="110" /></td> <td width="98%" align="left" valign="top" background="imagens/layout pg/fundo_topo.jpg"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="4%">&nbsp;</td> <td width="63%" align="left" valign="top"><img src="imagens/layout pg/logo.jpg" width="237" height="110" /></td> <td width="33%">&nbsp;</td> </tr> </table></td> <td width="1%" align="right" valign="top" background="imagens/layout pg/fundo_topo.jpg"><img src="imagens/layout pg/topo_direito.jpg" width="13" height="110" /></td> </tr> <tr> <td height="32" align="left" valign="top" background="imagens/layout pg/fundo_menu.jpg" bgcolor="#EEEEEE"><img src="imagens/layout pg/borda_esquerda_menu.jpg" width="13" height="32" /></td> <td height="32" align="center" valign="top" background="imagens/layout pg/fundo_menu.jpg" bgcolor="#EEEEEE"> </td> <td height="32" align="right" valign="top" background="imagens/layout pg/fundo_menu.jpg" bgcolor="#EEEEEE"><img src="imagens/layout pg/borda_menu_direito.jpg" width="13" height="32" /></td> </tr> <tr> <td align="left" valign="top" background="imagens/layout pg/borda_esquerda.jpg" bgcolor="#EEEEEE">&nbsp;</td> <td align="right" valign="top" bgcolor="#EEEEEE">&nbsp;</td> <td align="left" valign="top" background="imagens/layout pg/borda_direita.jpg" bgcolor="#EEEEEE">&nbsp;</td> </tr> <tr> <td align="left" valign="top" background="imagens/layout pg/borda_esquerda.jpg" bgcolor="#EEEEEE">&nbsp;</td> <td align="left" valign="top" bgcolor="#EEEEEE"> <form id="formTabelas" name="formTabelas" method="post" action="gerarClasses.php"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="1%" align="left" valign="top" bgcolor="#FFFFFF"><img src="imagens/layout pg/conto_superior_esquerdo.jpg" width="15" height="5" /></td> <td width="98%" align="left" valign="top" background="imagens/layout pg/linha_superior.jpg" bgcolor="#FFFFFF"><img src="imagens/layout pg/linha_superior.jpg" width="22" height="5" /></td> <td width="1%" align="left" valign="top" bgcolor="#FFFFFF"><img src="imagens/layout pg/conto_superior_direito.jpg" width="14" height="5" /></td> </tr> <tr> <td align="left" valign="top" background="imagens/layout pg/linha_esquerda.jpg" bgcolor="#FFFFFF">&nbsp;</td> <td align="right" valign="top" bgcolor="#FFFFFF"><a href="index2.php"><img src="imagens/bt_voltar.jpg" alt="Voltar" width="40" height="40" border="0" /></a></td> <td align="right" valign="top" background="imagens/layout pg/linha_direita.jpg" bgcolor="#FFFFFF">&nbsp;</td> </tr> <tr> <td align="left" valign="top" background="imagens/layout pg/linha_esquerda.jpg" bgcolor="#FFFFFF">&nbsp;</td> <td align="center" valign="top" bgcolor="#FFFFFF"> <table width="421" border="0" cellspacing="1" cellpadding="0"> <tr> <td colspan="2" class="pretoNegrito12">Prefixo dos métodos gerados.</td> </tr> <tr> <td colspan="2" align="left" valign="top">Os prefixos são os nomes que irão identificar qual é a função do método referente a tabela. <span class="vermelhoSimples"><strong>Ex:</strong> prefixo + nome tabela + () == retornaTbl_getClass().<br /> <strong>O nome dos prefixos é opcional.</strong></span> </td> </tr> <tr> <td width="80">Retorno:</td> <td width="338" class="cinzaEscuro"><label> <input name="retorno" type="text" class="formTexto" id="retorno" size="30" /> </label> &nbsp; Padrão: <span class="vermelhoSimples11">retorna</span></td> </tr> <tr> <td>Inseção:</td> <td class="cinzaEscuro"><label> <input name="insercao" type="text" class="formTexto" id="insercao" size="30" /> </label> &nbsp; Padrão: <span class="vermelhoSimples11">inserir</span></td> </tr> <tr> <td>Atualização:</td> <td class="cinzaEscuro"><label> <input name="atualizacao" type="text" class="formTexto" id="atualizacao" size="30" /> </label> &nbsp; Padrão: <span class="vermelhoSimples11">atualiza</span></td> </tr> <tr> <td>Remoção:</td> <td class="cinzaEscuro"><label> <input name="deletacao" type="text" class="formTexto" id="deletacao" size="30" /> </label> &nbsp; Padrão: <span class="vermelhoSimples11">deleta</span></td> </tr> <tr> <td>Contagem:</td> <td class="cinzaEscuro"><label> <input name="contagem" type="text" class="formTexto" id="contagem" size="30" /> </label>&nbsp; Padrão: <span class="vermelhoSimples11">retornaQuantidadeRegistros</span></td> </tr> </table> </td> <td align="right" valign="top" background="imagens/layout pg/linha_direita.jpg" bgcolor="#FFFFFF">&nbsp;</td> </tr> <tr> <td align="left" valign="top" background="imagens/layout pg/linha_esquerda.jpg" bgcolor="#FFFFFF">&nbsp;</td> <td align="center" valign="top" bgcolor="#FFFFFF" class="creditos">&nbsp;</td> <td align="right" valign="top" background="imagens/layout pg/linha_direita.jpg" bgcolor="#FFFFFF">&nbsp;</td> </tr> <tr> <td align="left" valign="top" background="imagens/layout pg/linha_esquerda.jpg" bgcolor="#FFFFFF">&nbsp;</td> <td align="center" valign="top" bgcolor="#FFFFFF"> <table width="421" border="0" cellspacing="2" cellpadding="0"> <tr> <td colspan="2" align="left" valign="top" class="pretoNegrito12">Selecione as tabelas que você deseja mapear.</td> </tr> <tr> <td colspan="2" align="left" valign="top"><a href="#" class="linkAbusado" onclick="check(0)">Marcar todos</a> <span class="linkAbusado">/</span> <a href="#" class="linkAbusado" onclick="check(1)">Desmarcar Todos</a></td> </tr> <?php foreach($gerador->selecionaTBLs() as $tabela) {?> <tr> <td width="34" align="center" valign="top"><label> <input type="checkbox" value="<?php echo $tabela->getTabela();?>" name="tabelas[]" id="tabelas[]" /> </label></td> <td width="359" align="left" valign="middle"><?php echo $_POST['banco'].".".$gerador->retornaSchemaTable($tabela->getTabela());?></td> </tr> <?php }?> <tr> <td colspan="2" align="center" valign="top"><label> <input name="banco" type="hidden" id="banco" value="<?php echo $_POST['banco'];?>" /> <input name="Submit" type="submit" class="formButton" id="button" value="Gerar Classes" /> </label></td> </tr> </table> </td> <td align="right" valign="top" background="imagens/layout pg/linha_direita.jpg" bgcolor="#FFFFFF">&nbsp;</td> </tr> <tr> <td align="left" valign="top" bgcolor="#FFFFFF"><img src="imagens/layout pg/conto_inferior_esquerdo.jpg" width="15" height="6" /></td> <td align="left" valign="top" background="imagens/layout pg/linha_inferior.jpg" bgcolor="#FFFFFF"><img src="imagens/layout pg/linha_inferior.jpg" width="22" height="6" /></td> <td align="left" valign="top" bgcolor="#FFFFFF"><img src="imagens/layout pg/conto_inferior_direito.jpg" width="14" height="6" /></td> </tr> </table> </form> </td> <td align="left" valign="top" background="imagens/layout pg/borda_direita.jpg" bgcolor="#EEEEEE">&nbsp;</td> </tr> <tr> <td align="left" valign="top" background="imagens/layout pg/borda_esquerda.jpg" bgcolor="#EEEEEE">&nbsp;</td> <td align="left" valign="top" bgcolor="#EEEEEE">&nbsp;</td> <td align="left" valign="top" background="imagens/layout pg/borda_direita.jpg" bgcolor="#EEEEEE">&nbsp;</td> </tr> <tr> <td align="left" valign="top" background="imagens/layout pg/fundo_fundo.jpg"><img src="imagens/layout pg/fundo_esquerdo.jpg" width="13" height="46" /></td> <td align="center" valign="middle" background="imagens/layout pg/fundo_fundo.jpg" class="creditos"><?php echo $gerador->getCopyright();?></td> <td align="right" valign="top" background="imagens/layout pg/fundo_fundo.jpg"><img src="imagens/layout pg/fundo_direito.jpg" width="13" height="46" /></td> </tr> <tr> <td><img src="imagens/quadrado_branco.jpg" width="10" height="10" /></td> <td><img src="imagens/quadrado_branco.jpg" width="10" height="10" /></td> <td><img src="imagens/quadrado_branco.jpg" width="10" height="10" /></td> </tr> </table> </body> </html>