lagdo / jaxon-dbadmin

src/DbAdmin/CommandAdmin.php

Braces +1 added lines, -2 removed lines

@@ -325,8 +325,7 @@
             try {
                 \ini_set('memory_limit', \max($this->util->iniBytes('memory_limit'),
                     2 * \strlen($queries) + \memory_get_usage() + 8e6));
-            }
-            catch(\Exception $e) {
+            } catch(\Exception $e) {
                 // Do nothing if the option is not modified.
             }
         }

Indentation +3 added lines, -3 removed lines

@@ -46,7 +46,7 @@ 
      * @param array $types
      *
      * @return string
-    */
+     */
     protected function values(array $row, array $blobs, array $types)
     {
         $values = [];
@@ -73,7 +73,7 @@ 
      * @param int $limit
      *
      * @return string
-    */
+     */
     private function message($statement, int $limit)
     {
         $numRows = $statement->rowCount();
@@ -95,7 +95,7 @@ 
      * @param int $limit
      *
      * @return array
-    */
+     */
     protected function select($statement, $limit = 0)
     {
         // No resultset

Spacing +2 added lines, -2 removed lines

@@ -196,7 +196,7 @@ 
                 \ini_set('memory_limit', \max($this->util->iniBytes('memory_limit'),
                     2 * \strlen($queries) + \memory_get_usage() + 8e6));
             }
-            catch(\Exception $e) {
+            catch (\Exception $e) {
                 // Do nothing if the option is not modified.
             }
         }
@@ -235,7 +235,7 @@ 
         if ($commands === 0) {
             $messages[] = $this->trans->lang('No commands to execute.');
         } elseif ($onlyErrors) {
-            $messages[] =  $this->trans->lang('%d query(s) executed OK.', $commands - $errors);
+            $messages[] = $this->trans->lang('%d query(s) executed OK.', $commands - $errors);
         }
 
         return ['results' => $this->results, 'messages' => $messages];

templates/views/bootstrap3/table/column.php

Spacing +30 added lines, -30 removed lines

@@ -1,4 +1,4 @@ 
-<?php if(isset($this->class)): ?>
+<?php if (isset($this->class)): ?>
         <div class="form-group row <?php echo $this->class ?>" data-index="<?php
             echo $this->index ?>" id="<?php echo sprintf('%s-%02d', $this->class, $this->index) ?>">
 <?php endif ?>
@@ -14,23 +14,23 @@ 
             </div>
             <label class="col-md-1 adminer-table-column-null" for="autoIncrementCol">
                 <input type="radio" name="autoIncrementCol" value="<?php echo ($this->index + 1) ?>" <?php
-                    if($this->field->autoIncrement): ?>checked <?php endif ?>/> AI
+                    if ($this->field->autoIncrement): ?>checked <?php endif ?>/> AI
                 <input type="checkbox" name="<?php echo $this->prefixFields ?>[primary]" <?php
-                    if($this->field->primary): ?>checked <?php endif ?>/>
+                    if ($this->field->primary): ?>checked <?php endif ?>/>
             </label>
             <div class="col-md-2 adminer-table-column-middle">
                 <select class="form-control" name="<?php
                     echo $this->prefixFields ?>[collation]" data-field="collation"<?php
-                    if($this->field->collationHidden): ?> readonly<?php endif ?>>
+                    if ($this->field->collationHidden): ?> readonly<?php endif ?>>
                     <option value="">(<?php echo $this->trans->lang('collation') ?>)</option>
-<?php foreach($this->collations as $group => $collations): ?>
-<?php if(is_string($collations)): ?>
-                    <option <?php if($this->field->collation === $collations): ?>selected<?php
+<?php foreach ($this->collations as $group => $collations): ?>
+<?php if (is_string($collations)): ?>
+                    <option <?php if ($this->field->collation === $collations): ?>selected<?php
                         endif ?>><?php echo $collations ?></option>
 <?php else: ?>
                     <optgroup label="<?php echo $group ?>">
-<?php foreach($collations as $collation): ?>
-                        <option <?php if($this->field->collation === $collation): ?>selected<?php
+<?php foreach ($collations as $collation): ?>
+                        <option <?php if ($this->field->collation === $collation): ?>selected<?php
                             endif ?>><?php echo $collation ?></option>
 <?php endforeach ?>
                     </optgroup>
@@ -39,13 +39,13 @@ 
                 </select>
             </div>
             <div class="col-md-2 adminer-table-column-middle">
-<?php if(true/*isset($this->field->onUpdate)*/): ?>
+<?php if (true/*isset($this->field->onUpdate)*/): ?>
                 <select class="form-control" name="<?php
                     echo $this->prefixFields ?>[onUpdate]" data-field="onUpdate"<?php
-                    if($this->field->onUpdateHidden): ?> readonly<?php endif ?>>
+                    if ($this->field->onUpdateHidden): ?> readonly<?php endif ?>>
                     <option value="">(<?php echo $this->trans->lang('ON UPDATE') ?>)</option>
-<?php foreach($this->options['onUpdate'] as $group => $option): ?>
-                    <option <?php if($this->field->onUpdate === $option): ?>selected<?php
+<?php foreach ($this->options['onUpdate'] as $group => $option): ?>
+                    <option <?php if ($this->field->onUpdate === $option): ?>selected<?php
                         endif ?>><?php echo $option ?></option>
 <?php endforeach ?>
                 </select>
@@ -62,10 +62,10 @@ 
             <div class="col-md-2 adminer-table-column-left second-line">
                 <select class="form-control" name="<?php
                     echo $this->prefixFields ?>[type]" data-field="type">
-<?php foreach($this->field->types as $group => $types): ?>
+<?php foreach ($this->field->types as $group => $types): ?>
                     <optgroup label="<?php echo $group ?>">
-<?php foreach($types as $type): ?>
-                        <option <?php if($this->field->type === $type): ?>selected<?php
+<?php foreach ($types as $type): ?>
+                        <option <?php if ($this->field->type === $type): ?>selected<?php
                             endif ?>><?php echo $type ?></option>
 <?php endforeach ?>
                     </optgroup>
@@ -76,35 +76,35 @@ 
                 <input class="form-control" name="<?php
                     echo $this->prefixFields ?>[length]" placeholder="<?php
                     echo $this->trans->lang('Length') ?>" data-field="length"<?php
-                    if($this->field->lengthRequired): ?> required<?php endif ?> value="<?php
+                    if ($this->field->lengthRequired): ?> required<?php endif ?> value="<?php
                     echo $this->field->length ?>" size="3">
             </div>
             <label class="col-md-1 adminer-table-column-null second-line">
                 <input type="checkbox" value="1" name="<?php
                     echo $this->prefixFields ?>[null]" data-field="null" <?php
-                    if($this->field->null): ?>checked <?php endif ?>/> Null
+                    if ($this->field->null): ?>checked <?php endif ?>/> Null
             </label>
             <div class="col-md-2 adminer-table-column-middle second-line">
                 <select class="form-control" name="<?php
                     echo $this->prefixFields ?>[unsigned]" data-field="unsigned"<?php
-                    if($this->field->unsignedHidden): ?> readonly<?php endif ?>>
+                    if ($this->field->unsignedHidden): ?> readonly<?php endif ?>>
                     <option value=""></option>
-<?php if($this->unsigned): ?>
-<?php foreach($this->unsigned as $option): ?>
-                    <option <?php if($this->field->unsigned === $option): ?>selected<?php
+<?php if ($this->unsigned): ?>
+<?php foreach ($this->unsigned as $option): ?>
+                    <option <?php if ($this->field->unsigned === $option): ?>selected<?php
                         endif ?>><?php echo $option ?></option>
 <?php endforeach ?>
 <?php endif ?>
                 </select>
             </div>
             <div class="col-md-2 adminer-table-column-middle second-line">
-<?php if(true/*$this->foreignKeys*/): ?>
+<?php if (true/*$this->foreignKeys*/): ?>
                 <select class="form-control" name="<?php
                     echo $this->prefixFields ?>[onDelete]" data-field="onDelete"<?php
-                    if($this->field->onDeleteHidden): ?> readonly<?php endif ?>>
+                    if ($this->field->onDeleteHidden): ?> readonly<?php endif ?>>
                     <option value="">(<?php echo $this->trans->lang('ON DELETE') ?>)</option>
-<?php foreach($this->options['onDelete'] as $option): ?>
-                    <option <?php if($this->field->onDelete === $option): ?>selected<?php
+<?php foreach ($this->options['onDelete'] as $option): ?>
+                    <option <?php if ($this->field->onDelete === $option): ?>selected<?php
                         endif ?>><?php echo $option ?></option>
 <?php endforeach ?>
                 </select>
@@ -115,7 +115,7 @@ 
                     <span class="input-group-addon">
                         <input type="checkbox" value="1" name="<?php
                             echo $this->prefixFields ?>[hasDefault]" data-field="hasDefault" <?php
-                            if($this->field->hasDefault): ?>checked <?php endif ?>/>
+                            if ($this->field->hasDefault): ?>checked <?php endif ?>/>
                     </span>
                     <input class="form-control" name="<?php
                         echo $this->prefixFields ?>[default]" data-field="default" value="<?php
@@ -130,12 +130,12 @@ 
                         <span class="caret"></span>
                     </button>
                     <ul class="dropdown-menu" data-index="<?php echo $this->index ?>">
-<?php if($this->support['move_col']): ?>
+<?php if ($this->support['move_col']): ?>
                         <li><a href="#" class="adminer-table-column-add"><span class="glyphicon glyphicon-plus" aria-hidden="true"></span></a></li>
                         <!-- <li><a href="#" class="adminer-table-column-up"><span class="glyphicon glyphicon-arrow-up" aria-hidden="true"></span></a></li>
                         <li><a href="#" class="adminer-table-column-down"><span class="glyphicon glyphicon-arrow-down" aria-hidden="true"></span></a></li> -->
 <?php endif ?>
-<?php if($this->support['drop_col']): ?>
+<?php if ($this->support['drop_col']): ?>
                         <li><a href="#" class="adminer-table-column-del"><span class="glyphicon glyphicon-remove" aria-hidden="true"></span></a></li>
 <?php endif ?>
                     </ul>
@@ -143,6 +143,6 @@ 
             </div>
             <!-- End second line -->
         </div></div>
-<?php if(isset($this->class)): ?>
+<?php if (isset($this->class)): ?>
         </div>
 <?php endif ?>

templates/views/bootstrap4/table/column.php

Spacing +30 added lines, -30 removed lines

@@ -1,4 +1,4 @@ 
-<?php if(isset($this->class)): ?>
+<?php if (isset($this->class)): ?>
         <div class="form-group row <?php echo $this->class ?>" data-index="<?php
             echo $this->index ?>" id="<?php echo sprintf('%s-%02d', $this->class, $this->index) ?>">
 <?php endif ?>
@@ -14,23 +14,23 @@ 
             </div>
             <label class="col-md-1 adminer-table-column-null" for="autoIncrementCol">
                 <input type="radio" name="autoIncrementCol" value="<?php echo ($this->index + 1) ?>" <?php
-                    if($this->field->autoIncrement): ?>checked <?php endif ?>/> AI
+                    if ($this->field->autoIncrement): ?>checked <?php endif ?>/> AI
                 <input type="checkbox" name="<?php echo $this->prefixFields ?>[primary]" <?php
-                    if($this->field->primary): ?>checked <?php endif ?>/>
+                    if ($this->field->primary): ?>checked <?php endif ?>/>
             </label>
             <div class="col-md-2 adminer-table-column-middle">
                 <select class="form-control" name="<?php
                     echo $this->prefixFields ?>[collation]" data-field="collation"<?php
-                    if($this->field->collationHidden): ?> readonly<?php endif ?>>
+                    if ($this->field->collationHidden): ?> readonly<?php endif ?>>
                     <option value="">(<?php echo $this->trans->lang('collation') ?>)</option>
-<?php foreach($this->collations as $group => $collations): ?>
-<?php if(is_string($collations)): ?>
-                    <option <?php if($this->field->collation === $collations): ?>selected<?php
+<?php foreach ($this->collations as $group => $collations): ?>
+<?php if (is_string($collations)): ?>
+                    <option <?php if ($this->field->collation === $collations): ?>selected<?php
                         endif ?>><?php echo $collations ?></option>
 <?php else: ?>
                     <optgroup label="<?php echo $group ?>">
-<?php foreach($collations as $collation): ?>
-                        <option <?php if($this->field->collation === $collation): ?>selected<?php
+<?php foreach ($collations as $collation): ?>
+                        <option <?php if ($this->field->collation === $collation): ?>selected<?php
                             endif ?>><?php echo $collation ?></option>
 <?php endforeach ?>
                     </optgroup>
@@ -39,13 +39,13 @@ 
                 </select>
             </div>
             <div class="col-md-2 adminer-table-column-middle">
-<?php if(true/*isset($this->field->onUpdate)*/): ?>
+<?php if (true/*isset($this->field->onUpdate)*/): ?>
                 <select class="form-control" name="<?php
                     echo $this->prefixFields ?>[onUpdate]" data-field="onUpdate"<?php
-                    if($this->field->onUpdateHidden): ?> readonly<?php endif ?>>
+                    if ($this->field->onUpdateHidden): ?> readonly<?php endif ?>>
                     <option value="">(<?php echo $this->trans->lang('ON UPDATE') ?>)</option>
-<?php foreach($this->options['onUpdate'] as $group => $option): ?>
-                    <option <?php if($this->field->onUpdate === $option): ?>selected<?php
+<?php foreach ($this->options['onUpdate'] as $group => $option): ?>
+                    <option <?php if ($this->field->onUpdate === $option): ?>selected<?php
                         endif ?>><?php echo $option ?></option>
 <?php endforeach ?>
                 </select>
@@ -62,10 +62,10 @@ 
             <div class="col-md-2 adminer-table-column-left second-line">
                 <select class="form-control" name="<?php
                     echo $this->prefixFields ?>[type]" data-field="type">
-<?php foreach($this->field->types as $group => $types): ?>
+<?php foreach ($this->field->types as $group => $types): ?>
                     <optgroup label="<?php echo $group ?>">
-<?php foreach($types as $type): ?>
-                        <option <?php if($this->field->type === $type): ?>selected<?php
+<?php foreach ($types as $type): ?>
+                        <option <?php if ($this->field->type === $type): ?>selected<?php
                             endif ?>><?php echo $type ?></option>
 <?php endforeach ?>
                     </optgroup>
@@ -76,35 +76,35 @@ 
                 <input class="form-control" name="<?php
                     echo $this->prefixFields ?>[length]" placeholder="<?php
                     echo $this->trans->lang('Length') ?>" data-field="length"<?php
-                    if($this->field->lengthRequired): ?> required<?php endif ?> value="<?php
+                    if ($this->field->lengthRequired): ?> required<?php endif ?> value="<?php
                     echo $this->field->length ?>" size="3">
             </div>
             <label class="col-md-1 adminer-table-column-null second-line">
                 <input type="checkbox" value="1" name="<?php
                     echo $this->prefixFields ?>[null]" data-field="null" <?php
-                    if($this->field->null): ?>checked <?php endif ?>/> Null
+                    if ($this->field->null): ?>checked <?php endif ?>/> Null
             </label>
             <div class="col-md-2 adminer-table-column-middle second-line">
                 <select class="form-control" name="<?php
                     echo $this->prefixFields ?>[unsigned]" data-field="unsigned"<?php
-                    if($this->field->unsignedHidden): ?> readonly<?php endif ?>>
+                    if ($this->field->unsignedHidden): ?> readonly<?php endif ?>>
                     <option value=""></option>
-<?php if($this->unsigned): ?>
-<?php foreach($this->unsigned as $option): ?>
-                    <option <?php if($this->field->unsigned === $option): ?>selected<?php
+<?php if ($this->unsigned): ?>
+<?php foreach ($this->unsigned as $option): ?>
+                    <option <?php if ($this->field->unsigned === $option): ?>selected<?php
                         endif ?>><?php echo $option ?></option>
 <?php endforeach ?>
 <?php endif ?>
                 </select>
             </div>
             <div class="col-md-2 adminer-table-column-middle second-line">
-<?php if(true/*$this->foreignKeys*/): ?>
+<?php if (true/*$this->foreignKeys*/): ?>
                 <select class="form-control" name="<?php
                     echo $this->prefixFields ?>[onDelete]" data-field="onDelete"<?php
-                    if($this->field->onDeleteHidden): ?> readonly<?php endif ?>>
+                    if ($this->field->onDeleteHidden): ?> readonly<?php endif ?>>
                     <option value="">(<?php echo $this->trans->lang('ON DELETE') ?>)</option>
-<?php foreach($this->options['onDelete'] as $option): ?>
-                    <option <?php if($this->field->onDelete === $option): ?>selected<?php
+<?php foreach ($this->options['onDelete'] as $option): ?>
+                    <option <?php if ($this->field->onDelete === $option): ?>selected<?php
                         endif ?>><?php echo $option ?></option>
 <?php endforeach ?>
                 </select>
@@ -116,7 +116,7 @@ 
                         <div class="input-group-text">
                             <input type="checkbox" value="1" name="<?php
                                 echo $this->prefixFields ?>[hasDefault]" data-field="hasDefault" <?php
-                                if($this->field->hasDefault): ?>checked <?php endif ?>/>
+                                if ($this->field->hasDefault): ?>checked <?php endif ?>/>
                         </div>
                     </div>
                     <input class="form-control" name="<?php
@@ -131,12 +131,12 @@ 
                         echo $this->index ?>" class="btn btn-primary dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
                     </button>
                     <div class="dropdown-menu" aria-labelledby="adminer-table-column-button-group-drop-<?php echo $this->index ?>">
-<?php if($this->support['move_col']): ?>
+<?php if ($this->support['move_col']): ?>
                         <a class="dropdown-item adminer-table-column-add" href="#"><i class="bi bi-plus"></i></a>
                         <!-- <a class="dropdown-item adminer-table-column-up" href="#"><i class="bi bi-arrow-up"></i></a>
                         <a class="dropdown-item adminer-table-column-down" href="#"><i class="bi bi-arrow-down"></i></a> -->
 <?php endif ?>
-<?php if($this->support['drop_col']): ?>
+<?php if ($this->support['drop_col']): ?>
                         <a class="dropdown-item adminer-table-column-del" href="#"><i class="bi bi-x"></i></a>
 <?php endif ?>
                     </div>
@@ -144,6 +144,6 @@ 
             </div>
             <!-- End second line -->
         </div></div>
-<?php if(isset($this->class)): ?>
+<?php if (isset($this->class)): ?>
         </div>
 <?php endif ?>

templates/views/bootstrap3/pagination/wrapper.php

Spacing +3 added lines, -3 removed lines

@@ -1,14 +1,14 @@
 <ul class="pagination">
 <?php
-    if(($this->prev))
+    if (($this->prev))
     {
         echo $this->prev;
     }
-    foreach($this->links as $link)
+    foreach ($this->links as $link)
     {
         echo $link;
     }
-    if(($this->next))
+    if (($this->next))
     {
         echo $this->next;
     }

templates/views/bootstrap4/pagination/wrapper.php

Spacing +3 added lines, -3 removed lines

@@ -1,15 +1,15 @@
 <nav aria-label="">
     <ul class="pagination">
 <?php
-    if(($this->prev))
+    if (($this->prev))
     {
         echo $this->prev;
     }
-    foreach($this->links as $link)
+    foreach ($this->links as $link)
     {
         echo $link;
     }
-    if(($this->next))
+    if (($this->next))
     {
         echo $this->next;
     }

src/Package.php

Spacing +2 added lines, -2 removed lines

@@ -201,7 +201,7 @@ 
     {
         $servers = $this->getConfig()->getOption('servers', []);
         $default = $this->getConfig()->getOption('default', '');
-        if(array_key_exists($default, $servers))
+        if (array_key_exists($default, $servers))
         {
             return $default;
         }
@@ -256,7 +256,7 @@ 
      */
     public function getReadyScript()
     {
-        if(!($server = $this->getDefaultServer()))
+        if (!($server = $this->getDefaultServer()))
         {
             return '';
         }

src/DbAdmin/Traits/TableSelectTrait.php

Indentation +1 added lines, -1 removed lines

@@ -261,7 +261,7 @@
      * @return TableSelectEntity
      */
     private function getSelectEntity(string $table, array $columns, array $fields, array $select,
-                                     array $group, array $where, array $order, array $unselected, int $limit, int $page): TableSelectEntity
+                                        array $group, array $where, array $order, array $unselected, int $limit, int $page): TableSelectEntity
     {
         $select2 = $select;
         $group2 = $group;

Spacing +4 added lines, -4 removed lines

@@ -25,7 +25,7 @@ 
     {
         return [
             'select' => $select,
-            'values' => (array)$options["columns"],
+            'values' => (array) $options["columns"],
             'columns' => $columns,
             'functions' => $this->driver->functions(),
             'grouping' => $this->driver->grouping(),
@@ -49,7 +49,7 @@ 
         }
         return [
             // 'where' => $where,
-            'values' => (array)$options["where"],
+            'values' => (array) $options["where"],
             'columns' => $columns,
             'indexes' => $indexes,
             'operators' => $this->driver->operators(),
@@ -68,8 +68,8 @@ 
     private function getSortingOptions(array $columns, array $options): array
     {
         $values = [];
-        $descs = (array)$options["desc"];
-        foreach ((array)$options["order"] as $key => $value) {
+        $descs = (array) $options["desc"];
+        foreach ((array) $options["order"] as $key => $value) {
             $values[] = [
                 'col' => $value,
                 'desc' => $descs[$key] ?? 0,

src/DbAdmin/TableSelectAdmin.php

Spacing +2 added lines, -2 removed lines

@@ -329,8 +329,8 @@
      */
     public function execSelect(string $table, array $queryOptions): array
     {
-        list(, $query, $select, $fields, , , $indexes, $where, $group, , $limit, $page,
-            $textLength, , $unselected) = $this->prepareSelect($table, $queryOptions);
+        list(, $query, $select, $fields,,, $indexes, $where, $group,, $limit, $page,
+            $textLength,, $unselected) = $this->prepareSelect($table, $queryOptions);
 
         list($rows, $duration) = $this->executeQuery($query, $page);
         if (!$rows) {

src/DbAdmin/TableAdmin.php

Spacing +3 added lines, -3 removed lines

@@ -218,14 +218,14 @@ 
                 $target .= '<b>' . $this->util->html($foreignKey->schema) . '</b>.';
             }
             $target = $this->util->html($foreignKey->table) .
-                '(' . implode(', ', array_map(function ($key) {
+                '(' . implode(', ', array_map(function($key) {
                     return $this->util->html($key);
                 }, $foreignKey->target)) . ')';
             $details[] = [
                 'name' => $this->util->html($name),
                 'source' => '<i>' . implode(
                     '</i>, <i>',
-                    array_map(function ($key) {
+                    array_map(function($key) {
                         return $this->util->html($key);
                     }, $foreignKey->source)
                 ) . '</i>',
@@ -369,7 +369,7 @@ 
     private function makeTableAttrs(array $values, string $table = '')
     {
         // From create.inc.php
-        $values['fields'] = (array)$values['fields'];
+        $values['fields'] = (array) $values['fields'];
         if ($values['autoIncrementCol']) {
             $values['fields'][$values['autoIncrementCol']]['autoIncrement'] = true;
         }