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         echo "<tr>";
  48         foreach ($columns as $c) {
  49                 echo "<th>$c</th>";
  50         }
  51         echo "</tr>";
  52         foreach ($rows as $r) {
  53                 echo "<tr>";
  54                 foreach ($r as $value) {
  55                         echo "<td>$value</td>";
  56                 }
  57                 echo "</tr>";
  58         }
  59 ?>
  60 </table>
  61 </body>
  62 </html>