From 04d6d5ca99ebfd1cebb8ce06618fb3811fc1a8aa Mon Sep 17 00:00:00 2001
From: Charles <sircharlesaze@gmail.com>
Date: Thu, 9 Jan 2020 10:55:03 +0100
Subject: phpmyadmin working

---
 srcs/phpmyadmin/db_multi_table_query.php | 51 ++++++++++++++++++++++++++++++++
 1 file changed, 51 insertions(+)
 create mode 100644 srcs/phpmyadmin/db_multi_table_query.php

(limited to 'srcs/phpmyadmin/db_multi_table_query.php')

diff --git a/srcs/phpmyadmin/db_multi_table_query.php b/srcs/phpmyadmin/db_multi_table_query.php
new file mode 100644
index 0000000..c624e85
--- /dev/null
+++ b/srcs/phpmyadmin/db_multi_table_query.php
@@ -0,0 +1,51 @@
+<?php
+/* vim: set expandtab sw=4 ts=4 sts=4: */
+/**
+ * Handles database multi-table querying
+ *
+ * @package PhpMyAdmin
+ */
+declare(strict_types=1);
+
+use PhpMyAdmin\Controllers\Database\MultiTableQueryController;
+use PhpMyAdmin\DatabaseInterface;
+use PhpMyAdmin\Response;
+use PhpMyAdmin\Template;
+
+if (! defined('ROOT_PATH')) {
+    define('ROOT_PATH', __DIR__ . DIRECTORY_SEPARATOR);
+}
+
+require_once ROOT_PATH . 'libraries/common.inc.php';
+
+/** @var Response $response */
+$response = $containerBuilder->get(Response::class);
+
+/** @var DatabaseInterface $dbi */
+$dbi = $containerBuilder->get(DatabaseInterface::class);
+
+/** @var MultiTableQueryController $controller */
+$controller = $containerBuilder->get(MultiTableQueryController::class);
+
+/** @var Template $template */
+$template = $containerBuilder->get('template');
+
+if (isset($_POST['sql_query'])) {
+    $controller->displayResults([
+        'sql_query' => $_POST['sql_query'],
+        'db' => $_REQUEST['db'] ?? null,
+    ]);
+} elseif (isset($_GET['tables'])) {
+    $response->addJSON($controller->table([
+        'tables' => $_GET['tables'],
+        'db' => $_REQUEST['db'] ?? null,
+    ]));
+} else {
+    $header = $response->getHeader();
+    $scripts = $header->getScripts();
+    $scripts->addFile('vendor/jquery/jquery.md5.js');
+    $scripts->addFile('database/multi_table_query.js');
+    $scripts->addFile('database/query_generator.js');
+
+    $response->addHTML($controller->index($template));
+}
-- 
cgit