synestergates788 / OctaORM

OctaORM.php

Spacing +216 added lines, -216 removed lines

@@ -1,5 +1,5 @@ 
 <?php
-class OctaORM{
+class OctaORM {
 
     protected $redbean;
     protected $db_field;
@@ -29,19 +29,19 @@ 
     var $num_rows;
     var $result;
 
-    public function __construct($db){
+    public function __construct($db) {
         include_once('RedBean.php');
         $this->redbean = new R();
         $this->db_field = $db;
 
-        if(!$this->redbean->testConnection()){
+        if (!$this->redbean->testConnection()) {
             $conn = $this->initiate_database_connection($db);
             $this->redbean->setup($conn);
-            $this->redbean->useFeatureSet( 'novice/latest' );
+            $this->redbean->useFeatureSet('novice/latest');
         }
     }
 
-    public function initiate_database_connection($db){
+    public function initiate_database_connection($db) {
         $DB_HOST = $db['hostname'];
         $DB_USERNAME = $db['username'];
         $DB_PASSWORD = $db['password'];
@@ -53,24 +53,24 @@ 
 
         $DB_con->exec("CREATE DATABASE IF NOT EXISTS $DB_NAME;");
 
-        $DB_con = new PDO("mysql:host={$DB_HOST};dbname={$DB_NAME}",$DB_USERNAME,$DB_PASSWORD);
+        $DB_con = new PDO("mysql:host={$DB_HOST};dbname={$DB_NAME}", $DB_USERNAME, $DB_PASSWORD);
         $DB_con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
         return $DB_con;
     }
 
-    public function insert_id(){
+    public function insert_id() {
         return $this->last_id;
     }
 
-    public function last_query(){
+    public function last_query() {
         return $this->last_query;
     }
 
-    public function insert($array,$table){
+    public function insert($array, $table) {
         $data = $this->redbean->dispense($table);
 
-        if($array){
-            foreach($array as $key=>$row){
+        if ($array) {
+            foreach ($array as $key=>$row) {
                 $data->$key = $row;
             }
         }
@@ -79,28 +79,28 @@ 
         return ($this->last_id) ? true : false;
     }
 
-    public function insert_batch($array,$table){
+    public function insert_batch($array, $table) {
         $data = array();
 
-        if($array){
-            foreach($array as $key_ib=>$row_ib){
+        if ($array) {
+            foreach ($array as $key_ib=>$row_ib) {
 
-                $data[$key_ib]=$this->redbean->dispense($table);
+                $data[$key_ib] = $this->redbean->dispense($table);
                 $table_fields = [];
                 $table_fields_val = [];
 
-                if($row_ib){
-                    foreach($row_ib as $row=>$val){
+                if ($row_ib) {
+                    foreach ($row_ib as $row=>$val) {
                         $table_fields[] = $row;
                         $table_fields_val[] = $val;
                     }
 
-                    if($table_fields && $table_fields_val){
-                        foreach($table_fields as $key=>$row){
+                    if ($table_fields && $table_fields_val) {
+                        foreach ($table_fields as $key=>$row) {
                             $data[$key_ib]->$row = $table_fields_val[$key];
                         }
 
-                    }else{
+                    } else {
                         return false;
                     }
                 }
@@ -111,11 +111,11 @@ 
         return ($result) ? true : false;
     }
 
-    public function update($table,$array,$id){
+    public function update($table, $array, $id) {
         $data = $this->redbean->load($table, $id);
 
-        if($array){
-            foreach($array as $key=>$row){
+        if ($array) {
+            foreach ($array as $key=>$row) {
                 $data->$key = $row;
             }
         }
@@ -124,33 +124,33 @@ 
         return ($result) ? true : false;
     }
 
-    public function update_batch($table,$array,$where){
-        if($array){
-            foreach($array as $key_ub=>$row_ub){
+    public function update_batch($table, $array, $where) {
+        if ($array) {
+            foreach ($array as $key_ub=>$row_ub) {
                 $where_key = '';
                 $table_fields = [];
                 $table_fields_val = [];
 
-                if($row_ub){
-                    foreach($row_ub as $row=>$val){
+                if ($row_ub) {
+                    foreach ($row_ub as $row=>$val) {
 
-                        if($row === $where){
+                        if ($row === $where) {
                             $where_key = $val;
                         }
 
-                        if($row !== $where){
+                        if ($row !== $where) {
                             $table_fields[] = $row;
                             $table_fields_val[] = $val;
                         }
                     }
 
                     $data = $this->redbean->load($table, $where_key);
-                    if($table_fields && $table_fields_val){
-                        foreach($table_fields as $key=>$row){
+                    if ($table_fields && $table_fields_val) {
+                        foreach ($table_fields as $key=>$row) {
                             $data->$row = $table_fields_val[$key];
                         }
 
-                    }else{
+                    } else {
                         return false;
                     }
 
@@ -162,32 +162,32 @@ 
         return true;
     }
 
-    public function delete($table,$id){
-        if(is_array($id)){
-            if($id){
-                foreach($id as $key=>$row){
-                    $this->redbean->trash($table,$row);
+    public function delete($table, $id) {
+        if (is_array($id)) {
+            if ($id) {
+                foreach ($id as $key=>$row) {
+                    $this->redbean->trash($table, $row);
                 }
 
                 return true;
             }
 
-        }else{
-            $this->redbean->trash($table,$id);
+        } else {
+            $this->redbean->trash($table, $id);
             return true;
         }
     }
 
-    public function delete_all($table){
+    public function delete_all($table) {
         $result = $this->redbean->wipe($table);
         return ($result) ? true : false;
     }
 
-    public function select($data){
+    public function select($data) {
         $reset = [];
-        if($data){
-            foreach($data as $key=>$row){
-                array_push($reset,$row);
+        if ($data) {
+            foreach ($data as $key=>$row) {
+                array_push($reset, $row);
             }
         }
 
@@ -195,25 +195,25 @@ 
         return $this->select;
     }
 
-    public function where($data=null,$match=null){
+    public function where($data = null, $match = null) {
         $tmp_where = '';
         $arr_check = false;
-        if($data){
-            if(is_array($data)){
+        if ($data) {
+            if (is_array($data)) {
                 end($data);
                 $last_element = key($data);
 
-                if($data){
+                if ($data) {
                     $arr_check = true;
-                    foreach($data as $key=>$row){
-                        if($key == $last_element){
+                    foreach ($data as $key=>$row) {
+                        if ($key == $last_element) {
                             $tmp_where .= $key."='".$row."'";
-                        }else{
+                        } else {
                             $tmp_where .= $key."='".$row."' AND ";
                         }
                     }
                 }
-            }else{
+            } else {
                 $arr_check = false;
                 $tmp_where = "WHERE ".$data."='".$match."'";
             }
@@ -222,25 +222,25 @@ 
         $this->where = ($arr_check) ? "WHERE ".$tmp_where : $tmp_where;
     }
 
-    public function or_where($data=null,$match=null){
+    public function or_where($data = null, $match = null) {
         $tmp_or_where = '';
         $arr_check = false;
-        if($data){
-            if(is_array($data)){
+        if ($data) {
+            if (is_array($data)) {
                 end($data);
                 $last_element = key($data);
                 $arr_check = true;
 
-                if($data){
-                    foreach($data as $key=>$row){
-                        if($key == $last_element){
+                if ($data) {
+                    foreach ($data as $key=>$row) {
+                        if ($key == $last_element) {
                             $tmp_or_where .= $key."='".$row."'";
-                        }else{
+                        } else {
                             $tmp_or_where .= $key."='".$row."' AND ";
                         }
                     }
                 }
-            }else{
+            } else {
                 $arr_check = false;
                 $tmp_or_where = "OR ".$data."='".$match."'";
             }
@@ -249,14 +249,14 @@ 
         $this->or_where = ($arr_check) ? "OR ".$tmp_or_where : $tmp_or_where;
     }
 
-    public function where_in($field,$data){
+    public function where_in($field, $data) {
         $where_in_fields = '';
         $last_key = end(array_keys($data));
-        if($data){
-            foreach($data as $key=>$row){
-                if($key == $last_key){
+        if ($data) {
+            foreach ($data as $key=>$row) {
+                if ($key == $last_key) {
                     $where_in_fields .= $row;
-                }else{
+                } else {
                     $where_in_fields .= $row.",";
                 }
             }
@@ -265,14 +265,14 @@ 
         $this->where_in = 'WHERE '.$field.' IN ('.$where_in_fields.')';
     }
 
-    public function or_where_in($field,$data){
+    public function or_where_in($field, $data) {
         $where_in_fields = '';
         $last_key = end(array_keys($data));
-        if($data){
-            foreach($data as $key=>$row){
-                if($key == $last_key){
+        if ($data) {
+            foreach ($data as $key=>$row) {
+                if ($key == $last_key) {
                     $where_in_fields .= $row;
-                }else{
+                } else {
                     $where_in_fields .= $row.",";
                 }
             }
@@ -281,14 +281,14 @@ 
         $this->or_where_in = 'OR '.$field.' IN ('.$where_in_fields.')';
     }
 
-    public function where_not_in($field,$data){
+    public function where_not_in($field, $data) {
         $where_in_fields = '';
         $last_key = end(array_keys($data));
-        if($data){
-            foreach($data as $key=>$row){
-                if($key == $last_key){
+        if ($data) {
+            foreach ($data as $key=>$row) {
+                if ($key == $last_key) {
                     $where_in_fields .= $row;
-                }else{
+                } else {
                     $where_in_fields .= $row.",";
                 }
             }
@@ -297,14 +297,14 @@ 
         $this->where_not_in = 'WHERE '.$field.' NOT IN ('.$where_in_fields.')';
     }
 
-    public function or_where_not_in($field,$data){
+    public function or_where_not_in($field, $data) {
         $where_in_fields = '';
         $last_key = end(array_keys($data));
-        if($data){
-            foreach($data as $key=>$row){
-                if($key == $last_key){
+        if ($data) {
+            foreach ($data as $key=>$row) {
+                if ($key == $last_key) {
                     $where_in_fields .= $row;
-                }else{
+                } else {
                     $where_in_fields .= $row.",";
                 }
             }
@@ -313,25 +313,25 @@ 
         $this->or_where_not_in = 'OR '.$field.' NOT IN ('.$where_in_fields.')';
     }
 
-    public function like($data=null,$match=null){
+    public function like($data = null, $match = null) {
         $tmp_like = '';
         $arr_check = false;
-        if($data){
-            if(is_array($data)){
+        if ($data) {
+            if (is_array($data)) {
                 end($data);
                 $last_element = key($data);
 
-                if($data){
+                if ($data) {
                     $arr_check = true;
-                    foreach($data as $key=>$row){
-                        if($key == $last_element){
+                    foreach ($data as $key=>$row) {
+                        if ($key == $last_element) {
                             $tmp_like .= $key." LIKE '%".$row."%'";
-                        }else{
+                        } else {
                             $tmp_like .= $key." LIKE '%".$row."%' AND ";
                         }
                     }
                 }
-            }else{
+            } else {
                 $arr_check = false;
                 $tmp_like = "WHERE ".$data." LIKE '%".$match."%'";
             }
@@ -341,23 +341,23 @@ 
         $this->like = ($arr_check == false) ? $tmp_like : "WHERE ".$tmp_like;
     }
 
-    public function or_like($data=null,$match=null){
+    public function or_like($data = null, $match = null) {
         $tmp_or_like = '';
-        if($data){
-            if(is_array($data)){
+        if ($data) {
+            if (is_array($data)) {
                 end($data);
                 $last_element = key($data);
 
-                if($data){
-                    foreach($data as $key=>$row){
-                        if($key == $last_element){
+                if ($data) {
+                    foreach ($data as $key=>$row) {
+                        if ($key == $last_element) {
                             $tmp_or_like .= "OR ".$key." LIKE '%".$row."%'";
-                        }else{
+                        } else {
                             $tmp_or_like .= "OR ".$key." LIKE '%".$row."%' AND ";
                         }
                     }
                 }
-            }else{
+            } else {
                 $tmp_or_like = "OR ".$data." LIKE '%".$match."%'";
             }
         }
@@ -365,25 +365,25 @@ 
         $this->or_like = $tmp_or_like;
     }
 
-    public function not_like($data=null,$match=null){
+    public function not_like($data = null, $match = null) {
         $tmp_like = '';
         $arr_check = false;
-        if($data){
-            if(is_array($data)){
+        if ($data) {
+            if (is_array($data)) {
                 end($data);
                 $last_element = key($data);
 
-                if($data){
+                if ($data) {
                     $arr_check = true;
-                    foreach($data as $key=>$row){
-                        if($key == $last_element){
+                    foreach ($data as $key=>$row) {
+                        if ($key == $last_element) {
                             $tmp_like .= $key." NOT LIKE '%".$row."%'";
-                        }else{
+                        } else {
                             $tmp_like .= $key." NOT LIKE '%".$row."%' AND ";
                         }
                     }
                 }
-            }else{
+            } else {
                 $arr_check = false;
                 $tmp_like = "WHERE ".$data." NOT LIKE '%".$match."%'";
             }
@@ -393,23 +393,23 @@ 
         $this->like = ($arr_check == false) ? $tmp_like : "WHERE ".$tmp_like;
     }
 
-    public function or_not_like($data=null,$match=null){
+    public function or_not_like($data = null, $match = null) {
         $tmp_or_like = '';
-        if($data){
-            if(is_array($data)){
+        if ($data) {
+            if (is_array($data)) {
                 end($data);
                 $last_element = key($data);
 
-                if($data){
-                    foreach($data as $key=>$row){
-                        if($key == $last_element){
+                if ($data) {
+                    foreach ($data as $key=>$row) {
+                        if ($key == $last_element) {
                             $tmp_or_like .= "OR ".$key." NOT LIKE '%".$row."%'";
-                        }else{
+                        } else {
                             $tmp_or_like .= "OR ".$key." NOT LIKE '%".$row."%' AND ";
                         }
                     }
                 }
-            }else{
+            } else {
                 $tmp_or_like = "OR ".$data." NOT LIKE '%".$match."%'";
             }
         }
@@ -417,25 +417,25 @@ 
         $this->or_like = $tmp_or_like;
     }
 
-    public function order_by($field,$sort){
+    public function order_by($field, $sort) {
         $this->order_by = $field.' '.$sort;
     }
 
-    public function join($table,$joint,$join_type="INNER"){
+    public function join($table, $joint, $join_type = "INNER") {
         $this->join = $join_type.' JOIN '.$table.' ON '.$joint;
     }
 
-    public function group_by($field){
+    public function group_by($field) {
         $this->group_by = 'GROUP BY '.$field;
     }
 
-    public function get($table=null,$limit=null,$offset=null){
+    public function get($table = null, $limit = null, $offset = null) {
         $this->table = $table;
         $this->limit = $limit;
         $this->offset = $offset;
     }
 
-    public function clear_global_var(){
+    public function clear_global_var() {
         $this->select = '';
         $this->where = '';
         $this->or_where = '';
@@ -458,10 +458,10 @@ 
         $this->result = '';
     }
 
-    public function row(){
+    public function row() {
         /*init var*/
         $result = [];
-        $select = ($this->select) ? implode(',',$this->select) : '*';
+        $select = ($this->select) ? implode(',', $this->select) : '*';
         $order_by = ($this->order_by) ? 'ORDER BY '.$this->order_by : '';
         $join = ($this->join) ? $this->join : '';
         $group_by = ($this->group_by) ? $this->group_by : '';
@@ -485,8 +485,8 @@ 
         $this->row = "SELECT {$select} FROM {$table} {$join} {$where} {$or_where} {$where_in} {$or_where_in} {$where_not_in} {$or_where_not_in} {$like} {$or_like} {$not_like} {$or_not_like} {$group_by} {$order_by} {$limit} {$offset}";
         $this->last_query = $this->row;
         $data = $this->redbean->getRow($this->row);
-        if($data){
-            foreach($data as $key=>$row){
+        if ($data) {
+            foreach ($data as $key=>$row) {
                 $result[$key] = $row;
             }
         }
@@ -498,10 +498,10 @@ 
         return $result;
     }
 
-    public function num_rows(){
+    public function num_rows() {
         /*init var*/
-        $result = 0;#array();
-        $select = ($this->select) ? implode(',',$this->select) : '*';
+        $result = 0; #array();
+        $select = ($this->select) ? implode(',', $this->select) : '*';
         $order_by = ($this->order_by) ? 'ORDER BY '.$this->order_by : '';
         $join = ($this->join) ? $this->join : '';
         $group_by = ($this->group_by) ? $this->group_by : '';
@@ -534,10 +534,10 @@ 
         return $result;
     }
 
-    public function result(){
+    public function result() {
         /*init var*/
         $result = array();
-        $select = ($this->select) ? implode(',',$this->select) : '*';
+        $select = ($this->select) ? implode(',', $this->select) : '*';
         $order_by = ($this->order_by) ? 'ORDER BY '.$this->order_by : '';
         $join = ($this->join) ? $this->join : '';
         $group_by = ($this->group_by) ? $this->group_by : '';
@@ -563,9 +563,9 @@ 
         $this->result = "SELECT {$select} FROM {$table} {$join} {$where} {$or_where} {$where_in} {$or_where_in} {$where_not_in} {$or_where_not_in} {$like} {$or_like} {$not_like} {$or_not_like} {$group_by} {$order_by} {$limit} {$offset}";
         $this->last_query = $this->result;
         $data = $this->redbean->getAll($this->result);
-        if($data){
-            foreach($data as $key=>$row){
-                $result[$key] = (object)$row;
+        if ($data) {
+            foreach ($data as $key=>$row) {
+                $result[$key] = (object) $row;
             }
         }
 
@@ -577,166 +577,166 @@ 
     }
 
     /*Database*/
-    public function wipe($beanType){
+    public function wipe($beanType) {
         $result = $this->redbean->wipe($beanType);
         return ($result) ? $result : false;
     }
 
-    public function dispense($data){
+    public function dispense($data) {
         $result = $this->redbean->dispense($data);
         return ($result) ? true : false;
     }
 
-    public function store($data){
+    public function store($data) {
         $result = $this->redbean->store($data);
         return ($result) ? true : false;
     }
 
-    public function inspect($data){
-        if($data){
-            if(is_array($data)){
+    public function inspect($data) {
+        if ($data) {
+            if (is_array($data)) {
 
                 $result = array();
-                foreach($data as $key=>$row){
-                    $result[$key]=$this->redbean->inspect($row);
+                foreach ($data as $key=>$row) {
+                    $result[$key] = $this->redbean->inspect($row);
                 }
 
                 return ($result) ? $result : false;
 
-            }else{
+            } else {
                 $this->redbean->inspect($data);
                 return true;
             }
         }
     }
 
-    public function get_all_tables(){
+    public function get_all_tables() {
         $result = $this->redbean->inspect();
         return ($result) ? $result : false;
     }
 
-    public function add_database($db_name,$hostname,$user_name,$password,$frozen=null){
-        $result = $this->redbean->addDatabase($db_name, $hostname, $user_name, $password, $frozen );
+    public function add_database($db_name, $hostname, $user_name, $password, $frozen = null) {
+        $result = $this->redbean->addDatabase($db_name, $hostname, $user_name, $password, $frozen);
         return ($result) ? true : false;
     }
 
-    public function select_database($db_name){
+    public function select_database($db_name) {
         $result = $this->redbean->selectDatabase($db_name);
         return ($result) ? true : false;
     }
 
-    public function set_database(){
+    public function set_database() {
         $result = $this->redbean->selectDatabase('default');
         return ($result) ? true : false;
     }
 
-    public function begin(){
+    public function begin() {
         $result = $this->redbean->begin();
         return ($result) ? true : false;
     }
 
-    public function commit(){
+    public function commit() {
         $result = $this->redbean->commit();
         return ($result) ? true : false;
     }
 
-    public function roll_back(){
+    public function roll_back() {
         $result = $this->redbean->rollback();
         return ($result) ? true : false;
     }
 
-    public function reset_query_count(){
+    public function reset_query_count() {
         $result = $this->redbean->resetQueryCount();
         return ($result) ? true : false;
     }
 
-    public function get_query_count(){
+    public function get_query_count() {
         $result = $this->redbean->getQueryCount();
         return ($result) ? $result : false;
     }
 
-    public function start_logging(){
+    public function start_logging() {
         $result = $this->redbean->startLogging();
         return ($result) ? true : false;
     }
 
-    public function get_logs(){
+    public function get_logs() {
         $result = $this->redbean->getLogs();
         return ($result) ? $result : false;
     }
 
     /*querying*/
-    public function exec($data){
+    public function exec($data) {
         $result = $this->redbean->exec($data);
         return ($result) ? $result : false;
     }
 
-    public function get_all($table){
+    public function get_all($table) {
         $result = $this->redbean->getAll($table);
         return ($result) ? $result : false;
     }
 
-    public function get_row($data){
+    public function get_row($data) {
         $result = $this->redbean->getRow($data);
         return ($result) ? $result : false;
     }
 
-    public function get_column($data){
+    public function get_column($data) {
         $result = $this->redbean->getCol($data);
         return ($result) ? $result : false;
     }
 
-    public function get_cell($data){
+    public function get_cell($data) {
         $result = $this->redbean->getCell($data);
         return ($result) ? $result : false;
     }
 
-    public function get_assoc($data){
+    public function get_assoc($data) {
         $result = $this->redbean->getAssoc($data);
         return ($result) ? $result : false;
     }
 
-    public function get_inserted_id(){
+    public function get_inserted_id() {
         $result = $this->redbean->getInsertID();
         return ($result) ? $result : false;
     }
 
-    public function convert_to_beans($type,$rows,$metamask=null){
-        $result = $this->redbean->convertToBeans( $type, $rows, $metamask );
+    public function convert_to_beans($type, $rows, $metamask = null) {
+        $result = $this->redbean->convertToBeans($type, $rows, $metamask);
         return ($result) ? $result : false;
     }
 
     /*Data Tools*/
     /*this will return an html data*/
-    public function get_look($sql, $bindings = array(), $keys = array( 'selected', 'id', 'name' ), $template = '<option %s value="%s">%s</option>', $filter = 'trim', $glue = '' ){
-        $result = $this->redbean->getLook()->look($sql,$bindings,$keys,$template,$filter,$glue);
+    public function get_look($sql, $bindings = array(), $keys = array('selected', 'id', 'name'), $template = '<option %s value="%s">%s</option>', $filter = 'trim', $glue = '') {
+        $result = $this->redbean->getLook()->look($sql, $bindings, $keys, $template, $filter, $glue);
         return ($result) ? $result : false;
     }
 
-    public function match_up($type, $sql, $bindings = array(), $onFoundDo = NULL, $onNotFoundDo = NULL, &$bean = NULL){
+    public function match_up($type, $sql, $bindings = array(), $onFoundDo = NULL, $onNotFoundDo = NULL, &$bean = NULL) {
         $result = $this->redbean->matchUp($type, $sql, $bindings, $onFoundDo, $onNotFoundDo, $bean);
         return ($result) ? $result : false;
     }
 
-    public function csv($sql, $id = array(), $bindings = array()){
-        $result = $this->redbean->csv($sql,$id,$bindings);
+    public function csv($sql, $id = array(), $bindings = array()) {
+        $result = $this->redbean->csv($sql, $id, $bindings);
         return ($result) ? true : false;
     }
 
-    public function find_all($table){
+    public function find_all($table) {
         $result = $this->redbean->findAll($table);
         return ($result) ? $result : false;
     }
 
-    public function find($type,$sql,$bindings){
-        $result = $this->redbean->find($type,$sql,$bindings);
+    public function find($type, $sql, $bindings) {
+        $result = $this->redbean->find($type, $sql, $bindings);
         return ($result) ? $result : false;
     }
 
-    public function csv_result(){
+    public function csv_result() {
         /*init var*/
         $result = array();
-        $select = ($this->select) ? implode(',',$this->select) : '*';
+        $select = ($this->select) ? implode(',', $this->select) : '*';
         $order_by = ($this->order_by) ? 'ORDER BY '.$this->order_by : '';
         $join = ($this->join) ? $this->join : '';
         $group_by = ($this->group_by) ? $this->group_by : '';
@@ -758,9 +758,9 @@ 
 
         $this->last_query = "SELECT {$select} FROM {$table} {$join} {$where} {$or_where} {$where_in} {$or_where_in} {$where_not_in} {$or_where_not_in} {$like} {$or_like} {$not_like} {$or_not_like} {$group_by} {$order_by} {$limit}";
         $data = $this->redbean->csv("SELECT {$select} FROM {$table} {$join} {$where} {$or_where} {$where_in} {$or_where_in} {$where_not_in} {$or_where_not_in} {$like} {$or_like} {$not_like} {$or_not_like} {$group_by} {$order_by} {$limit}");
-        if($data){
-            foreach($data as $key=>$row){
-                $result[$key] = (object)$row;
+        if ($data) {
+            foreach ($data as $key=>$row) {
+                $result[$key] = (object) $row;
             }
         }
 
@@ -772,157 +772,157 @@ 
     }
 
     /*Fluid and Frozen*/
-    public function freeze($data=null){
-        if($data){
-            if(is_array($data)){
-                if($data){
+    public function freeze($data = null) {
+        if ($data) {
+            if (is_array($data)) {
+                if ($data) {
 
                     $data = array();
-                    foreach($data as $key=>$row){
+                    foreach ($data as $key=>$row) {
                         $data[$key] = $row;
                     }
 
                     $this->redbean->freeze($data);
                 }
             }
-        }else{
+        } else {
             $this->redbean->freeze(TRUE);
         }
         return true;
     }
 
     /*Debugging*/
-    public function fancy_debug($toggle = TRUE){
+    public function fancy_debug($toggle = TRUE) {
         $result = $this->redbean->fancyDebug($toggle);
         return ($result) ? $result : false;
     }
 
     /*value "true", "false"*/
-    public function debug($tf = TRUE, $mode = 0){
-        $result = $this->redbean->debug($tf,$mode);
+    public function debug($tf = TRUE, $mode = 0) {
+        $result = $this->redbean->debug($tf, $mode);
         return ($result) ? $result : false;
     }
 
-    public function dump($data){
+    public function dump($data) {
         $result = $this->redbean->dump($data);
         return ($result) ? $result : false;
     }
 
-    public function test_connection(){
+    public function test_connection() {
         $result = $this->redbean->testConnection();
         return ($result) ? $result : false;
     }
 
     /*Aliases*/
-    public function load($oodb, $types, $id){
+    public function load($oodb, $types, $id) {
         $result = $this->redbean->load($oodb, $types, $id);
         return ($result) ? $result : false;
     }
 
-    public function fetch_as($type){
+    public function fetch_as($type) {
         $result = $this->redbean->fetchAs($type);
         return ($result) ? $result : false;
     }
 
-    public function alias($alias_name){
+    public function alias($alias_name) {
         $result = $this->redbean->alias($alias_name);
         return ($result) ? $result : false;
     }
 
     /*Count*/
-    public function count(){
+    public function count() {
         $result = $this->redbean->count();
         return ($result) ? $result : false;
     }
 
-    public function count_own($type){
+    public function count_own($type) {
         $result = $this->redbean->countOwn($type);
         return ($result) ? $result : false;
     }
 
-    public function count_shared($type){
+    public function count_shared($type) {
         $result = $this->redbean->countOwn($type);
         return ($result) ? $result : false;
     }
 
     /*Labels, Enums, Tags*/
-    public function dispense_labels($type,$labels){
-        $result = $this->redbean->dispenseLabels($type,$labels);
+    public function dispense_labels($type, $labels) {
+        $result = $this->redbean->dispenseLabels($type, $labels);
         return ($result) ? $result : false;
     }
 
-    public function gather_labels($beans){
+    public function gather_labels($beans) {
         $result = $this->redbean->gatherLabels($beans);
         return ($result) ? $result : false;
     }
 
-    public function enum($enum){
+    public function enum($enum) {
         $result = $this->redbean->enum($enum);
         return ($result) ? $result : false;
     }
 
-    public function tag($bean, $tagList){
+    public function tag($bean, $tagList) {
         $result = $this->redbean->tag($bean, $tagList);
         return ($result) ? $result : false;
     }
 
-    public function add_tag($bean, $tagList){
+    public function add_tag($bean, $tagList) {
         $result = $this->redbean->addTags($bean, $tagList);
         return ($result) ? $result : false;
     }
 
-    public function tagged($beanType,$tagList,$sql='',$bindings=array()){
-        $result = $this->redbean->addTags($beanType,$tagList,$sql,$bindings);
+    public function tagged($beanType, $tagList, $sql = '', $bindings = array()) {
+        $result = $this->redbean->addTags($beanType, $tagList, $sql, $bindings);
         return ($result) ? $result : false;
     }
 
-    public function untag($bean,$tagList){
-        $result = $this->redbean->untag($bean,$tagList);
+    public function untag($bean, $tagList) {
+        $result = $this->redbean->untag($bean, $tagList);
         return ($result) ? $result : false;
     }
 
-    public function tagged_all($beanType,$tagList,$sql='',$bindings=array()){
-        $result = $this->redbean->taggedAll($beanType,$tagList,$sql,$bindings);
+    public function tagged_all($beanType, $tagList, $sql = '', $bindings = array()) {
+        $result = $this->redbean->taggedAll($beanType, $tagList, $sql, $bindings);
         return ($result) ? $result : false;
     }
 
-    public function count_tagged_all($beanType,$tagList,$sql='',$bindings=array()){
-        $result = $this->redbean->countTaggedAll($beanType,$tagList,$sql,$bindings);
+    public function count_tagged_all($beanType, $tagList, $sql = '', $bindings = array()) {
+        $result = $this->redbean->countTaggedAll($beanType, $tagList, $sql, $bindings);
         return ($result) ? $result : false;
     }
 
-    public function count_tagged($beanType,$tagList,$sql='',$bindings=array()){
-        $result = $this->redbean->countTagged($beanType,$tagList,$sql,$bindings);
+    public function count_tagged($beanType, $tagList, $sql = '', $bindings = array()) {
+        $result = $this->redbean->countTagged($beanType, $tagList, $sql, $bindings);
         return ($result) ? $result : false;
     }
 
-    public function has_tag($bean,$tags,$all=FALSE){
-        $result = $this->redbean->hasTag($bean,$tags,$all);
+    public function has_tag($bean, $tags, $all = FALSE) {
+        $result = $this->redbean->hasTag($bean, $tags, $all);
         return ($result) ? $result : false;
     }
 
     /*Import and Export*/
-    public function import($array, $selection = FALSE, $notrim = FALSE){
-        $result = $this->redbean->import($array,$selection,$notrim);
+    public function import($array, $selection = FALSE, $notrim = FALSE) {
+        $result = $this->redbean->import($array, $selection, $notrim);
         return ($result) ? $result : false;
     }
 
-    public function import_row($row){
+    public function import_row($row) {
         $result = $this->redbean->importRow($row);
         return ($result) ? $result : false;
     }
 
-    public function export($meta = FALSE, $parents = FALSE, $onlyMe = FALSE, $filters = array()){
-        $result = $this->redbean->export($meta,$parents,$onlyMe,$filters);
+    public function export($meta = FALSE, $parents = FALSE, $onlyMe = FALSE, $filters = array()) {
+        $result = $this->redbean->export($meta, $parents, $onlyMe, $filters);
         return ($result) ? $result : false;
     }
 
-    public function export_all($beans, $parents = FALSE, $filters = array()){
-        $result = $this->redbean->exportAll($beans,$parents,$filters);
+    public function export_all($beans, $parents = FALSE, $filters = array()) {
+        $result = $this->redbean->exportAll($beans, $parents, $filters);
         return ($result) ? $result : false;
     }
 
-    public function import_from($sourceBean){
+    public function import_from($sourceBean) {
         $result = $this->redbean->importFrom($sourceBean);
         return ($result) ? $result : false;
     }