Форум программистов [Powered by Invision Power Board]

Код

 function showTables($base){
      $this->saveDB($base);
      mysql_query("USE $base");
       $result = mysql_query("SHOW TABLES FROM ".$base);
       if($result){
        $i = 0;
        $cnt = mysql_num_rows($result);
        echo"<span class='line'>Select table:</span>";
        echo "<select class='line' id='select_table'>";
    while ($i < $cnt) {
    $table_name = mysql_table_name($result, $i);
    echo "<option id='table' class='line' value='".$table_name."'>".$table_name. "</option><br/>";
    $i++;
}//while
echo "</select><input type='submit' id='submit_table' value='Submit table' class='line'>";
echo "<script type='text/javascript'>

      $('#submit_table').click(function(){
     $.post('gateKeeper.php', {table:$('#select_table option:selected').val()}, function(text) {
       // format and output result
       $('#table_description').html(
         text

       );
     });
   });
   </script>";
        }//if result
        mysql_free_result($result);
   }//showTables

//С файлами работает с сессиями нет
private function saveDB($base){
      /* $file  = fopen('base','wb');
       fwrite($file, $base);
       fclose($file);*/
      session_start();
      $_SESSION['base'] = $base;
      echo $_SESSION['base'];
   }//saveDB

   private function getDB(){
       /*if(file_exists('base')&& is_readable('base')){
           $file = fopen('base', 'rb');
           $content = file_get_contents('base');
           if($content){return $content;}//if

       }//if*/
      return $_SESSION['base'];
   }//getDB


 public function displayColumn($column){
       //if(is_array($column)&& isset ($column)){$separated = implode(",", $column);}//if
       $table = $this->getTable();//почти эдентичная getDB();
       $base = $this->getDB();
       mysql_query("USE $base");
       echo "The columns passed: ".$column;
       $result = mysql_query("SELECT $column FROM $table");
       if($result){           
           $i = 0;
           $cnt = mysql_num_rows($result);
           echo "<table class='result_table'>";
           while($i<$cnt){
           echo "<tr>";
       $row = mysql_fetch_row($result);
       foreach ($row as $key=>$value){
          echo"<td>".$value."</td>";}//foreach
           $i++;
           echo "</tr>";
       }//while
       echo "</table>";
       mysql_free_result($result);
   }//if
   else{echo "The result was empty";}
   }//displayColumn