supernova-ws / SuperNova

includes/classes/DBStaticRecord.php

Spacing +8 added lines, -8 removed lines

@@ -45,11 +45,11 @@ 
             $result[] = 'NULL';
           break;
           default:
-            $string = (string)$fieldName;
+            $string = (string) $fieldName;
             if ($string == '') {
               throw new ExceptionDBFieldEmpty();
             }
-            $result[] = '`' . $string . '`';
+            $result[] = '`'.$string.'`';
         }
       }
     } else {
@@ -77,10 +77,10 @@ 
     if (!empty($fieldList)) {
       $user_record = static::$dbStatic->doquery(
         (
-          "SELECT {$fieldList}" .
-          " FROM {{" . static::$_table . "}}" .
-          (!empty($where) ? " WHERE {$where}" : '') .
-          (!empty($for_update) ? " FOR UPDATE" : '') .
+          "SELECT {$fieldList}".
+          " FROM {{".static::$_table."}}".
+          (!empty($where) ? " WHERE {$where}" : '').
+          (!empty($for_update) ? " FOR UPDATE" : '').
           ($returnFirst ? ' LIMIT 1' : '')
         ),
         $returnFirst
@@ -137,7 +137,7 @@ 
    */
   public static function getRecordById($recordId, $fieldList = '*', $forUpdate = false) {
 //    return static::getRecord(array(static::$_idField => $recordId), $fieldList, $forUpdate);
-    return static::getRecord(array(static::$_idField . '=' . $recordId), $fieldList, $forUpdate);
+    return static::getRecord(array(static::$_idField.'='.$recordId), $fieldList, $forUpdate);
   }
 
 
@@ -158,7 +158,7 @@ 
         DbSqlStatement::build(null, get_called_class())
           ->select()
           ->fields(static::$_idField)
-          ->where(array("`" . static::$_idField . "` IN (" . implode(',', $idList) . ")"))
+          ->where(array("`".static::$_idField."` IN (".implode(',', $idList).")"))
       );
     }
 

includes/classes/ExceptionDbSqlWhereNotAnArray.php

Spacing +1 added lines, -1 removed lines

@@ -1,5 +1,5 @@
 <?php
 
-class ExceptionDbSqlWhereNotAnArray extends Exception{
+class ExceptionDbSqlWhereNotAnArray extends Exception {
 
 }

includes/classes/DbSqlStatement.php

Spacing +11 added lines, -11 removed lines

@@ -166,7 +166,7 @@ 
   // TODO - fields should be escaped !!
   // TODO - $where should be validated and checked!
   public function where($where = array()) {
-    if(!is_array($where)) {
+    if (!is_array($where)) {
       throw new ExceptionDbSqlWhereNotAnArray();
     }
     $this->where = $where;
@@ -198,23 +198,23 @@ 
     $result = '';
     $result .= $this->stringEscape($this->operation);
 
-    $result .= ' ' . $this->selectFieldsToString($this->fields);
+    $result .= ' '.$this->selectFieldsToString($this->fields);
 
     $result .= ' FROM';
-    $result .= ' `{{' . $this->stringEscape($this->table) . '}}`';
-    $result .= !empty($this->alias) ? ' AS `' . $this->stringEscape($this->alias) . '`' : '';
+    $result .= ' `{{'.$this->stringEscape($this->table).'}}`';
+    $result .= !empty($this->alias) ? ' AS `'.$this->stringEscape($this->alias).'`' : '';
 
     // TODO - fields should be escaped !!
-    $result .= !empty($this->where) ? ' WHERE ' . implode(' AND ', $this->where) : '';
+    $result .= !empty($this->where) ? ' WHERE '.implode(' AND ', $this->where) : '';
 
     // TODO - fields should be escaped !!
-    $result .= !empty($this->group) ? ' GROUP BY ' . implode(',', $this->group) : '';
+    $result .= !empty($this->group) ? ' GROUP BY '.implode(',', $this->group) : '';
 
     // TODO - fields should be escaped !!
-    $result .= !empty($this->order) ? ' ORDER BY ' . implode(',', $this->order) : '';
+    $result .= !empty($this->order) ? ' ORDER BY '.implode(',', $this->order) : '';
 
     // TODO - fields should be escaped !!
-    $result .= !empty($this->limit) ? ' LIMIT ' . implode(',', $this->limit) : '';
+    $result .= !empty($this->limit) ? ' LIMIT '.implode(',', $this->limit) : '';
 
     // TODO - protect from double escape!
 
@@ -252,7 +252,7 @@ 
    */
   protected function processField($fieldName) {
     if (is_bool($fieldName)) {
-      $result = (string)intval($fieldName);
+      $result = (string) intval($fieldName);
     } elseif (is_null($fieldName)) {
       $result = 'NULL';
     } elseif ($fieldName === '*') {
@@ -270,7 +270,7 @@ 
    * @return string
    */
   protected function processFieldDefault($fieldName) {
-    $result = (string)$fieldName;
+    $result = (string) $fieldName;
     if (
       $result != ''
       &&
@@ -284,7 +284,7 @@ 
       !is_numeric($fieldName)
     ) {
       // Other should be formatted
-      $result = '`' . $this->stringEscape($result) . '`';
+      $result = '`'.$this->stringEscape($result).'`';
     }
 
     return $result;