Retrieve parameters from $_POST in designer

Signed-off-by: Madhura Jayaratne <madhura.cj@gmail.com>

1 files changed, 39 insertions, 39 deletions

diff --git a/db_designer.php b/db_designer.php
index da9ea0a6d0..df9a866a23 100644
--- a/db_designer.php
+++ b/db_designer.php
@@ -18,17 +18,17 @@ $designerCommon = new Common();
 
 if (isset($_REQUEST['dialog'])) {
 
-    if ($_REQUEST['dialog'] == 'edit') {
+    if ($_GET['dialog'] == 'edit') {
         $html = $databaseDesigner->getHtmlForEditOrDeletePages($GLOBALS['db'], 'editPage');
-    } elseif ($_REQUEST['dialog'] == 'delete') {
+    } elseif ($_GET['dialog'] == 'delete') {
         $html = $databaseDesigner->getHtmlForEditOrDeletePages($GLOBALS['db'], 'deletePage');
-    } elseif ($_REQUEST['dialog'] == 'save_as') {
+    } elseif ($_GET['dialog'] == 'save_as') {
         $html = $databaseDesigner->getHtmlForPageSaveAs($GLOBALS['db']);
-    } elseif ($_REQUEST['dialog'] == 'export') {
+    } elseif ($_GET['dialog'] == 'export') {
         $html = $databaseDesigner->getHtmlForSchemaExport(
-            $GLOBALS['db'], $_REQUEST['selected_page']
+            $GLOBALS['db'], $_GET['selected_page']
         );
-    } elseif ($_REQUEST['dialog'] == 'add_table') {
+    } elseif ($_POST['dialog'] == 'add_table') {
         $script_display_field = $designerCommon->getTablesInfo();
         $required = $GLOBALS['db'] . '.' . $GLOBALS['table'];
         $tab_column = $designerCommon->getColumnsInfo();
@@ -56,50 +56,50 @@ if (isset($_REQUEST['dialog'])) {
     return;
 }
 
-if (isset($_REQUEST['operation'])) {
+if (isset($_POST['operation'])) {
 
-    if ($_REQUEST['operation'] == 'deletePage') {
-        $success = $designerCommon->deletePage($_REQUEST['selected_page']);
+    if ($_POST['operation'] == 'deletePage') {
+        $success = $designerCommon->deletePage($_POST['selected_page']);
         $response->setRequestStatus($success);
-    } elseif ($_REQUEST['operation'] == 'savePage') {
-        if ($_REQUEST['save_page'] == 'same') {
-            $page = $_REQUEST['selected_page'];
+    } elseif ($_POST['operation'] == 'savePage') {
+        if ($_POST['save_page'] == 'same') {
+            $page = $_POST['selected_page'];
         } else { // new
-            $page = $designerCommon->createNewPage($_REQUEST['selected_value'], $GLOBALS['db']);
+            $page = $designerCommon->createNewPage($_POST['selected_value'], $GLOBALS['db']);
             $response->addJSON('id', $page);
         }
         $success = $designerCommon->saveTablePositions($page);
         $response->setRequestStatus($success);
-    } elseif ($_REQUEST['operation'] == 'setDisplayField') {
+    } elseif ($_POST['operation'] == 'setDisplayField') {
         $designerCommon->saveDisplayField(
-            $_REQUEST['db'], $_REQUEST['table'], $_REQUEST['field']
+            $_POST['db'], $_POST['table'], $_POST['field']
         );
         $response->setRequestStatus(true);
-    } elseif ($_REQUEST['operation'] == 'addNewRelation') {
+    } elseif ($_POST['operation'] == 'addNewRelation') {
         list($success, $message) = $designerCommon->addNewRelation(
-            $_REQUEST['db'],
-            $_REQUEST['T1'],
-            $_REQUEST['F1'],
-            $_REQUEST['T2'],
-            $_REQUEST['F2'],
-            $_REQUEST['on_delete'],
-            $_REQUEST['on_update'],
-            $_REQUEST['DB1'],
-            $_REQUEST['DB2']
+            $_POST['db'],
+            $_POST['T1'],
+            $_POST['F1'],
+            $_POST['T2'],
+            $_POST['F2'],
+            $_POST['on_delete'],
+            $_POST['on_update'],
+            $_POST['DB1'],
+            $_POST['DB2']
         );
         $response->setRequestStatus($success);
         $response->addJSON('message', $message);
-    } elseif ($_REQUEST['operation'] == 'removeRelation') {
+    } elseif ($_POST['operation'] == 'removeRelation') {
         list($success, $message) = $designerCommon->removeRelation(
-            $_REQUEST['T1'],
-            $_REQUEST['F1'],
-            $_REQUEST['T2'],
-            $_REQUEST['F2']
+            $_POST['T1'],
+            $_POST['F1'],
+            $_POST['T2'],
+            $_POST['F2']
         );
         $response->setRequestStatus($success);
         $response->addJSON('message', $message);
-    } elseif ($_REQUEST['operation'] == 'save_setting_value') {
-        $success = $designerCommon->saveSetting($_REQUEST['index'], $_REQUEST['value']);
+    } elseif ($_POST['operation'] == 'save_setting_value') {
+        $success = $designerCommon->saveSetting($_POST['index'], $_POST['value']);
         $response->setRequestStatus($success);
     }
 
@@ -118,13 +118,13 @@ $classes_side_menu = $databaseDesigner->returnClassNamesFromMenuButtons();
 $display_page = -1;
 $selected_page = null;
 
-if (isset($_REQUEST['query'])) {
-    $display_page = $designerCommon->getDefaultPage($_REQUEST['db']);
+if (isset($_GET['query'])) {
+    $display_page = $designerCommon->getDefaultPage($_GET['db']);
 } else {
-    if (! empty($_REQUEST['page'])) {
-        $display_page = $_REQUEST['page'];
+    if (! empty($_GET['page'])) {
+        $display_page = $_GET['page'];
     } else {
-        $display_page = $designerCommon->getLoadingPage($_REQUEST['db']);
+        $display_page = $designerCommon->getLoadingPage($_GET['db']);
     }
 }
 if ($display_page != -1) {
@@ -173,7 +173,7 @@ $response->addHTML(
 );
 $response->addHTML(
     $databaseDesigner->getPageMenu(
-        isset($_REQUEST['query']),
+        isset($_GET['query']),
         $selected_page,
         $classes_side_menu
     )
@@ -203,7 +203,7 @@ $response->addHTML('<div id="designer_hint"></div>');
 $response->addHTML($databaseDesigner->getNewRelationPanel());
 $response->addHTML($databaseDesigner->getDeleteRelationPanel());
 
-if (isset($_REQUEST['query'])) {
+if (isset($_GET['query'])) {
     $response->addHTML($databaseDesigner->getOptionsPanel());
     $response->addHTML($databaseDesigner->getRenameToPanel());
     $response->addHTML($databaseDesigner->getHavingQueryPanel());