4 define('WARAQ_ROOT', '../../..');
5 require_once WARAQ_ROOT
.'/'. 'ini.php';
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'];
17 if (!$_SESSION['db_type'] or !$_GET['q']) {
18 header('Location: '. $bazdig->get('/console')->url
);
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']);
24 SqlCode
::set_db($history_db);
25 $query = new SqlCode(stripslashes($_GET['q']));
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
}
34 background
-color
: yellow
;
35 border
: 2px solid red
;
44 $result = $query->exec($work_db);
45 } catch (Exception
$e) {
46 die("<div id='error'><b>SQL ERROR</b> ". $e->getMessage() ."</div>");
52 $rows = $result->fetchAll(PDO
::FETCH_ASSOC
);
53 if (count($rows) < 1) {
54 die("<table><tr><th>Empty</th></tr></table>");
56 } catch (Exception
$e) {
57 die("<table><tr><th>Empty</th></tr></table>");
59 $columns = columnNames($rows[0]);
62 foreach ($columns as $c) {
66 foreach ($rows as $r) {
68 foreach ($r as $value) {
69 echo "<td>$value</td>";