bulton-fr / bfw-sql

src/class/SqlSelect.php

Doc Comments +3 added lines, -3 removed lines

@@ -143,10 +143,10 @@ 
     /**
      * Declare information for FROM part and column will be get for main table
      * 
-     * @param string|array $table   Table name.
+     * @param string $table   Table name.
      *  It can be an array if a table shortcut is declared.
      *  In array mode, the format is ['asValue' => 'tableName']
-     * @param string|array $columns (default: "*") Columns will be get for
+     * @param string $columns (default: "*") Columns will be get for
      *  the table declared in first argument
      * 
      * @return \BfwSql\SqlSelect
@@ -296,7 +296,7 @@ 
     /**
      * Add information about the LIMIT part in request
      * 
-     * @param array|integer $limit If it's a integer, the number of row to
+     * @param integer $limit If it's a integer, the number of row to
      *  return. If an array, the format is [numberToStart, numberOfRowToReturn]
      * 
      * @return \BfwSql\SqlSelect

Spacing +10 added lines, -10 removed lines

@@ -151,7 +151,7 @@ 
      * 
      * @return \BfwSql\SqlSelect
      */
-    public function from($table, $columns='*')
+    public function from($table, $columns = '*')
     {
         $this->from = $this->obtainTableInfos($table);
         
@@ -243,7 +243,7 @@ 
      * 
      * @return \BfwSql\SqlSelect
      */
-    public function join($table, $joinOn, $joinColumns='*')
+    public function join($table, $joinOn, $joinColumns = '*')
     {
         return $this->createJoin('join', $table, $joinOn, $joinColumns);
     }
@@ -259,7 +259,7 @@ 
      * 
      * @return \BfwSql\SqlSelect
      */
-    public function joinLeft($table, $joinOn, $joinColumns='*')
+    public function joinLeft($table, $joinOn, $joinColumns = '*')
     {
         return $this->createJoin('joinLeft', $table, $joinOn, $joinColumns);
     }
@@ -275,7 +275,7 @@ 
      * 
      * @return \BfwSql\SqlSelect
      */
-    public function joinRight($table, $joinOn, $joinColumns='*')
+    public function joinRight($table, $joinOn, $joinColumns = '*')
     {
         return $this->createJoin('joinRight', $table, $joinOn, $joinColumns);
     }
@@ -364,7 +364,7 @@ 
         $result  = [];
         $request = $this->execute(); //throw an Exception if error
         
-        while($row = $request->fetch($this->getPdoFetchType()))
+        while ($row = $request->fetch($this->getPdoFetchType()))
         {
             $result[] = $row;
         }
@@ -398,7 +398,7 @@ 
     protected function generateSelect()
     {
         $select = '';
-        foreach($this->select as $columnInfos)
+        foreach ($this->select as $columnInfos)
         {
             if ($select != '') {
                 $select .= ', ';
@@ -406,11 +406,11 @@ 
             
             $select .= $columnInfos->column;
             if ($columnInfos->shortcut !== null) {
-                $select. ' AS '.$columnInfos->shortcut;
+                $select.' AS '.$columnInfos->shortcut;
             }
         }
         
-        foreach($this->subQuery as $subQueryInfos)
+        foreach ($this->subQuery as $subQueryInfos)
         {
             if ($select != '') {
                 $select .= ', ';
@@ -461,7 +461,7 @@ 
             $joinSqlName = ' RIGHT JOIN ';
         }
 
-        foreach($this->{$joinProperty} as $joinInfos)
+        foreach ($this->{$joinProperty} as $joinInfos)
         {
             $join .= $joinSqlName.'`'.$joinInfos->tableName.'`';
             if ($joinInfos->shortcut !== null) {
@@ -509,7 +509,7 @@ 
         }
         
         $group = ' GROUP BY ';
-        foreach($this->group as $groupCondition)
+        foreach ($this->group as $groupCondition)
         {
             if ($group != ' GROUP BY ') {
                 $group .= ', ';

src/class/SqlConnect.php

Spacing +1 added lines, -1 removed lines

@@ -84,7 +84,7 @@
          * protected string.
          * So we remove this quote at the start and the end of the string.
          */
-        return substr($protectedString, 1, strlen($protectedString)-2);
+        return substr($protectedString, 1, strlen($protectedString) - 2);
     }
     
     /**

src/class/Sql.php

Spacing +8 added lines, -8 removed lines

@@ -64,7 +64,7 @@ 
      * 
      * @return integer
      */
-    public function getLastInsertedId($name=null)
+    public function getLastInsertedId($name = null)
     {
         return (int) $this->PDO->lastInsertId($name);
     }
@@ -84,7 +84,7 @@ 
         $table,
         $colId,
         $order,
-        $where=''
+        $where = ''
     ) {
         $req = $this->select()
                     ->from($table, $colId)
@@ -124,7 +124,7 @@ 
      * 
      * @return \BfwSql\SqlSelect
      */
-    public function select($type='array')
+    public function select($type = 'array')
     {
         return new SqlSelect($this->sqlConnect, $type);
     }
@@ -138,7 +138,7 @@ 
      * 
      * @return \BfwSql\SqlInsert
      */
-    public function insert($table, $columns=null)
+    public function insert($table, $columns = null)
     {
         return new SqlInsert($this->sqlConnect, $table, $columns);
     }
@@ -152,7 +152,7 @@ 
      * 
      * @return \BfwSql\SqlUpdate
      */
-    public function update($table, $columns=null)
+    public function update($table, $columns = null)
     {
         return new SqlUpdate($this->sqlConnect, $table, $columns);
     }
@@ -194,7 +194,7 @@ 
         }
         
         if ($res[$column] > 1) {
-            return $res[$column]-1;
+            return $res[$column] - 1;
         }
         
         $req2 = $this->select()
@@ -205,7 +205,7 @@ 
         $res2 = $req2->fetchRow();
         $req2->closeCursor();
 
-        return $res2[$column]+1;
+        return $res2[$column] + 1;
     }
     
     /**
@@ -224,7 +224,7 @@ 
         $req   = $this->sqlConnect->PDO->query($request);
         $error = $this->sqlConnect->PDO->errorInfo();
         
-        if(
+        if (
             !$req
             && $error[0] != null
             && $error[0] != '00000'

src/class/SqlObserver.php

Spacing +3 added lines, -3 removed lines

@@ -105,7 +105,7 @@ 
         $backtrace      = [];
         $backtraceInfos = debug_backtrace();
         
-        foreach($backtraceInfos as $trace)
+        foreach ($backtraceInfos as $trace)
         {
             $backtrace[] = $trace['file'].' : '.$trace['line'];
         }
@@ -164,7 +164,7 @@ 
         }
         
         $explainDatas = [];
-        foreach($explainFetchAll[0] as $explainKey => $explainValue) {
+        foreach ($explainFetchAll[0] as $explainKey => $explainValue) {
             if (is_numeric($explainValue)) {
                 continue;
             }
@@ -198,7 +198,7 @@ 
         }
         
         $statusDatas = [];
-        foreach($statusFetchAll as $statusRow) {
+        foreach ($statusFetchAll as $statusRow) {
             $statusKey   = $statusRow['Variable_name'];
             $statusValue = $statusRow['Value'];
 

src/class/SqlActions.php

Spacing +4 added lines, -4 removed lines

@@ -121,7 +121,7 @@ 
      */
     public function requestIsAssembled()
     {
-        if($this->assembledRequest == '')
+        if ($this->assembledRequest == '')
         {
             $this->assembleRequest();
         }
@@ -269,11 +269,11 @@ 
      * 
      * @return \BfwSql\SqlActions
      */
-    public function where($filter, $preparedFilters=null)
+    public function where($filter, $preparedFilters = null)
     {
         $this->where[] = $filter;
         
-        if(is_array($preparedFilters))
+        if (is_array($preparedFilters))
         {
             $this->addPreparedFilters($preparedFilters);
         }
@@ -290,7 +290,7 @@ 
      */
     protected function addPreparedFilters($preparedFilters)
     {
-        foreach($preparedFilters as $prepareKey => $prepareValue)
+        foreach ($preparedFilters as $prepareKey => $prepareValue)
         {
             $this->preparedRequestArgs[$prepareKey] = $prepareValue;
         }