bazdig/sql/exec/index.php

   1 <?php
   2         session_start();
   3
   4     define('WARAQ_ROOT', '../../..');
   5     require_once WARAQ_ROOT .'/'. 'ini.php';
   6
   7         require "code.php";
   8
   9         if ($_GET['dbt']) {
  10                 $_SESSION['db_type'] = $_GET['dbt'];
  11                 $_SESSION['db_name'] = $_GET['dbn'];
  12                 $_SESSION['db_host'] = $_GET['dbh'];
  13                 $_SESSION['db_user'] = $_GET['dbu'];
  14                 $_SESSION['db_password'] = $_GET['dbp'];
  15         }
  16
  17         if (!$_SESSION['db_type'] or !$_GET['q']) {
  18                 header('Location: '. $bazdig->get('/console')->url );
  19         }
  20
  21         $history_db = new PDO("sqlite:". $bazdig->getparam('db')->file);
  22         $work_db = new BDB(array('type' => $_SESSION['db_type'], 'name' => $_SESSION['db_name'], 'host' => $_SESSION['db_host']), $_SESSION['db_user'], $_SESSION['db_password']);
  23
  24         SqlCode::set_db($history_db);
  25         $query = new SqlCode(stripslashes($_GET['q']));
  26         try {
  27                 $result = $query->exec($work_db);
  28         } catch (Exception $e) {
  29                 die("ERREUR SQL:". $e->getMessage());
  30         }
  31
  32         $query->save();
  33         $rows = $result->fetchAll(PDO::FETCH_ASSOC);
  34         $columns = columnNames($rows[0]);
  35 ?>
  36 <html>
  37 <head>
  38 <title><?php echo join($columns, ' '); ?></title>
  39 <style type="text/css">
  40         table tr td {border: solid 1px silver; padding: 10px}
  41         table tr th {border: solid 1px grey; padding: 10px}
  42 </style>
  43 </head>
  44 <body>
  45 <table>
  46 <?php
  47         if (count($rows) < 1) {
  48                 echo "<tr><th>Empty</th></tr>";
  49         } else {
  50                 echo "<tr>";
  51                 foreach ($columns as $c) {
  52                         echo "<th>$c</th>";
  53                 }
  54                 echo "</tr>";
  55                 foreach ($rows as $r) {
  56                         echo "<tr>";
  57                         foreach ($r as $value) {
  58                                 echo "<td>$value</td>";
  59                         }
  60                         echo "</tr>";
  61                 }
  62         }
  63 ?>
  64 </table>
  65 </body>
  66 </html>