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']));
27 $result = $query->exec($work_db);
28 } catch (Exception
$e) {
29 die("ERREUR SQL:". $e->getMessage());
33 $rows = $result->fetchAll(PDO
::FETCH_ASSOC
);
34 $columns = columnNames($rows[0]);
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
}
47 if (count($rows) < 1) {
48 echo "<tr><th>Empty</th></tr>";
51 foreach ($columns as $c) {
55 foreach ($rows as $r) {
57 foreach ($r as $value) {
58 echo "<td>$value</td>";