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/libraries/classes/ParseAnalyze.php | 84 ++++++++++++++++++++++
 1 file changed, 84 insertions(+)
 create mode 100644 srcs/phpmyadmin/libraries/classes/ParseAnalyze.php

(limited to 'srcs/phpmyadmin/libraries/classes/ParseAnalyze.php')

diff --git a/srcs/phpmyadmin/libraries/classes/ParseAnalyze.php b/srcs/phpmyadmin/libraries/classes/ParseAnalyze.php
new file mode 100644
index 0000000..8fa8ff2
--- /dev/null
+++ b/srcs/phpmyadmin/libraries/classes/ParseAnalyze.php
@@ -0,0 +1,84 @@
+<?php
+/* vim: set expandtab sw=4 ts=4 sts=4: */
+/**
+ * Parse and analyse a SQL query
+ *
+ * @package PhpMyAdmin
+ */
+declare(strict_types=1);
+
+namespace PhpMyAdmin;
+
+use PhpMyAdmin\Response;
+use PhpMyAdmin\SqlParser\Utils\Query;
+
+/**
+ * PhpMyAdmin\ParseAnalyze class
+ *
+ * @package PhpMyAdmin
+ */
+class ParseAnalyze
+{
+    /**
+     * Calls the parser on a query
+     *
+     * @param string $sql_query the query to parse
+     * @param string $db        the current database
+     *
+     * @return array
+     *
+     * @access  public
+     */
+    public static function sqlQuery($sql_query, $db)
+    {
+        global $reload;
+        // @todo: move to returned results (also in all the calling chain)
+        $GLOBALS['unparsed_sql'] = $sql_query;
+
+        // Get details about the SQL query.
+        $analyzed_sql_results = Query::getAll($sql_query);
+
+        extract($analyzed_sql_results);
+        $table = '';
+
+        // If the targeted table (and database) are different than the ones that is
+        // currently browsed, edit `$db` and `$table` to match them so other elements
+        // (page headers, links, navigation panel) can be updated properly.
+        if (! empty($analyzed_sql_results['select_tables'])) {
+            // Previous table and database name is stored to check if it changed.
+            $prev_db = $db;
+
+            if (count($analyzed_sql_results['select_tables']) > 1) {
+
+                /**
+                 * @todo if there are more than one table name in the Select:
+                 * - do not extract the first table name
+                 * - do not show a table name in the page header
+                 * - do not display the sub-pages links)
+                 */
+                $table = '';
+            } else {
+                $table = $analyzed_sql_results['select_tables'][0][0];
+                if (! empty($analyzed_sql_results['select_tables'][0][1])) {
+                    $db = $analyzed_sql_results['select_tables'][0][1];
+                }
+            }
+            // There is no point checking if a reload is required if we already decided
+            // to reload. Also, no reload is required for AJAX requests.
+            $response = Response::getInstance();
+            if (empty($reload) && ! $response->isAjax()) {
+                // NOTE: Database names are case-insensitive.
+                $reload  = strcasecmp($db, $prev_db) != 0;
+            }
+
+            // Updating the array.
+            $analyzed_sql_results['reload'] = $reload;
+        }
+
+        return [
+            $analyzed_sql_results,
+            $db,
+            $table,
+        ];
+    }
+}
-- 
cgit