SQL formatting with sql-formatter

Signed-off-by: Nisarg Jhaveri <nisargjhaveri@gmail.com>

1 files changed, 18 insertions, 0 deletions

diff --git a/db_sql_format.php b/db_sql_format.php
new file mode 100644
index 0000000000..a83e5273ee
--- /dev/null
+++ b/db_sql_format.php
@@ -0,0 +1,18 @@
+<?php
+/* vim: set expandtab sw=4 ts=4 sts=4: */
+/**
+ * Format SQL for SQL editors
+ *
+ * @package PhpMyAdmin
+ */
+
+require_once 'libraries/common.inc.php';
+require_once 'libraries/sql-formatter/lib/SqlFormatter.php';
+
+$query = isset($_POST['sql']) ? $_POST['sql'] : '';
+
+SqlFormatter::$tab = "\t";
+$query = SqlFormatter::format($query, false);
+
+$response = PMA_Response::getInstance();
+$response->addJSON("sql", $query);