bazdig/sql/exec/index.php

   1 <?php
   2         session_start();
   3
   4         if (!$_SESSION['db']) {
   5                 header('Location: '. $bazdig->get('/db')->url );
   6         }
   7
   8     define('WARAQ_ROOT', '../../..');
   9     require_once WARAQ_ROOT .'/'. 'ini.php';
  10
  11         require "code.php";
  12
  13         $history_db = new PDO("sqlite:". $bazdig->getparam('db')->file);
  14         $work_db = new PDO($_SESSION['db'], $_SESSION['db_user'], $_SESSION['db_password']);
  15
  16         SqlCode::set_db($history_db);
  17         $query = new SqlCode($_GET['q']);
  18         try {
  19                 $result = $query->exec($work_db);
  20         } catch (Exception $e) {
  21                 die($e->getMessage());
  22         }
  23
  24         $query->save();
  25         foreach ($result as $r) {
  26                 print_r($r);
  27         }