Location: PHPKode > scripts > Tables Properties Progress ODBC > tables-properties-progress-odbc/example.tables.php
<html>
 <head>
  <title>Odbc Progress Report</title>
 </head>
<body>
<? 
 include_once("tables.class.php");
 $tablasObj = new tables();
 $tables = $tablasObj->getTables();
 $tablasObj->getDSN();
 ?>
<form method="post"  enctype="multipart/form-data">
 <div align="center" >
  <table border="1" class="titulo"> 
  <tr>
   <td>Table : 
    <select name="table">
    <? 
    if(isset($_POST['prop'])){
 	 $table = $_POST['table'];
 	}

    foreach($tables as $name){
     if($table==$name){
       echo "<option value=\"$name\" SELECTED>$name</option>";
     }else{
      echo "<option value=\"$name\">$name</option>";	
     }
    }?>	
    </select>	
   </td>
   <td>
   <input type="submit" name="prop" value="Properties">
   </td>
  </tr>
  </table>
 </div>
 </form>
 <?
 if(isset($_POST['prop'])){
 	 $table = $_POST['table'];
 	 
 ?>
 <table border="1" align="center">
  <!---->
  <tr>
   <td><b>*** FIELDS ***</b></td>
  </tr>
  <tr>
   <td>
    <div style="overflow:auto;width:725px;height:170px">
    <?  echo $tablasObj->getFieldName($table); ?>
    </div>
   </td>
  </tr>
  
  <tr>
   <td><b>*** PRIMARY KEY ***</b></td>
  </tr>
  
  <tr>
   <td>
    <div style="overflow:auto;width:725px;height:170px">
    <? $tablasObj->displayRs($tablasObj->getPrimaryKey($table));?>
    </div>
   </td>
  </tr>
  
  <tr>
   <td>
   <b> *** INDEX ***</b>
   </td>
  </tr> 
  <tr>
   <td>
    <div style="overflow:auto;width:725px;height:170px">
     <? $tablasObj->displayRs($tablasObj->getIndex($table)); ?>
    </div>
   </td>
  </tr>
 </table>
 <? } ?>
</body>
</html>
Return current item: Tables Properties Progress ODBC