danielgp / fk-scale-mysql

source/FKchange.php

Spacing +8 added lines, -8 removed lines

@@ -73,7 +73,7 @@ 
                 'style'                => 'color:blue;font-weight:bold;',
                 'includeOldColumnType' => true,
             ]);
-            $sReturn[]    = $this->recreateFKs($elToModify, $targetTableTextFlds);
+            $sReturn[] = $this->recreateFKs($elToModify, $targetTableTextFlds);
         } else {
             if (strlen($mConnection) === 0) {
                 $sReturn[] = '<p style="color:red;">Check if provided parameters are correct '
@@ -96,15 +96,15 @@ 
                 . '<input type="text" id="dbName" name="db" placeholder="database name" '
                 . $this->returnInputsCleaned('db', $inArray)
                 . 'size="30" maxlength="64" class="labell" />';
-        $sReturn[]           = '<label for="tblName">Table name to analyze:</label>'
+        $sReturn[] = '<label for="tblName">Table name to analyze:</label>'
                 . '<input type="text" id="tblName" name="tbl" placeholder="table name" '
                 . $this->returnInputsCleaned('tbl', $inArray)
                 . ' size="30" maxlength="64" class="labell" />';
-        $sReturn[]           = '<label for="fldName">Field name to analyze:</label>'
+        $sReturn[] = '<label for="fldName">Field name to analyze:</label>'
                 . '<input type="text" id="fldName" name="fld" placeholder="field name" '
                 . $this->returnInputsCleaned('fld', $inArray)
                 . ' size="30" maxlength="64" class="labell" />';
-        $sReturn[]           = '<label for="dataType">Data type to change to:</label>'
+        $sReturn[] = '<label for="dataType">Data type to change to:</label>'
                 . '<input type="text" id="dataType" name="dt" placeholder="valid data type" '
                 . $this->returnInputsCleaned('dt', $inArray)
                 . ' size="30" maxlength="64" class="labell" />';
@@ -124,7 +124,7 @@ 
                 . '<li>MySQL password used: <span style="' . $styleForMySQLparams . '">'
                 . 'cannot be disclosed due to security reasons</span></li>'
                 . '</ul></p>';
-        $thisPage            = filter_var($inArray['SuperGlobals']->server->get('PHP_SELF'), FILTER_SANITIZE_URL);
+        $thisPage = filter_var($inArray['SuperGlobals']->server->get('PHP_SELF'), FILTER_SANITIZE_URL);
         return '<form method="get" action="' . $thisPage . '">'
                 . implode('<br/>', $sReturn)
                 . '</form>';
@@ -160,7 +160,7 @@ 
     {
         $sReturn = [];
         foreach ($targetTableTextFlds as $key => $value) {
-            $sReturn[]                                    = $this->createDropForeignKey([
+            $sReturn[] = $this->createDropForeignKey([
                 'Database'       => $value['TABLE_SCHEMA'],
                 'Table'          => $value['TABLE_NAME'],
                 'ForeignKeyName' => $value['CONSTRAINT_NAME'],
@@ -197,7 +197,7 @@ 
             'REFERENCED_COLUMN_NAME'  => $elToModify['Column'],
             'REFERENCED_TABLE_NAME'   => 'NOT NULL',
         ];
-        $query              = $this->sQueryMySqlIndexes($additionalFeatures);
+        $query = $this->sQueryMySqlIndexes($additionalFeatures);
         return $this->setMySQLquery2Server($query, 'full_array_key_numbered')['result'];
     }
 
@@ -208,7 +208,7 @@ 
             'TABLE_NAME'   => $elToModify['Table'],
             'COLUMN_NAME'  => $elToModify['Column'],
         ];
-        $col           = $this->getMySQLlistColumns($colToIdentify);
+        $col = $this->getMySQLlistColumns($colToIdentify);
         return [
             'Database'    => $targetTableTextFlds[0]['REFERENCED_TABLE_SCHEMA'],
             'Table'       => $targetTableTextFlds[0]['REFERENCED_TABLE_NAME'],