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 ?>
  27 <html>
  28 <head>
  29 <title><?php echo join($columns, ' '); ?></title>
  30 <style type="text/css">
  31         table tr td {border: solid 1px silver; padding: 10px}
  32         table tr th {border: solid 1px grey; padding: 10px}
  33         #error {
  34                 background-color: yellow;
  35                 border: 2px solid red;
  36                 padding: 10px;
  37                 margin: 10px;
  38         }
  39 </style>
  40 </head>
  41 <body>
  42 <?php
  43         try {
  44                 $result = $query->exec($work_db);
  45         } catch (Exception $e) {
  46                 die("<div id='error'><b>SQL ERROR</b> ". $e->getMessage() ."</div>");
  47         }
  48
  49         $query->save();
  50
  51         try {
  52                 $rows = $result->fetchAll(PDO::FETCH_ASSOC);
  53                 if (count($rows) < 1) {
  54                         die("<table><tr><th>Empty</th></tr></table>");
  55                 }
  56         } catch (Exception $e) {
  57                 die("<table><tr><th>Empty</th></tr></table>");
  58         }
  59         $columns = columnNames($rows[0]);
  60
  61         echo "<table><tr>";
  62         foreach ($columns as $c) {
  63                 echo "<th>$c</th>";
  64         }
  65         echo "</tr>";
  66         foreach ($rows as $r) {
  67                 echo "<tr>";
  68                 foreach ($r as $value) {
  69                         echo "<td>$value</td>";
  70                 }
  71                 echo "</tr>";
  72         }
  73         echo "</table>";
  74 ?>
  75 </body>
  76 </html>