WebSVN – phpLibraryV2 – Diff – /head/DBQuery.class.php

             $this->parameters[ 'lastInsertKey' ] = $this->insert_id;
             $this->parameters[ 'error' ] = $errors;
          } // if select .. else
          return $this->parameters;
       }  // function doSQL
+      public function run () {
+         return $this->doSQL( );
+      }
       /*
        * function will return one and only one row, NOT as an array of array
        * but as a single row array
        * if more than one row is returned by query, error is set and function
       // function returns the first column of the first row of data returned from query
       // or null no value returned
       public function getOneDBValue( $sql = null ) {
          if ( isset( $sql ) )
             $this->parameters[ 'query' ] = $sql;
-         $save = $this->parameters[ 'useAssociativeArray' ];
+         $save = $this->parameters['returntype'];
-         $useAssociativeArray = false;
+         $this->parameters['returntype'] = 'array';
          $this->run();
-         $useAssociativeArray = $save;
+         $this->parameters['returntype'] = $save;
+//         print "<pre>" . print_r($this->parameters,true ) . "</pre>";
          return $this->parameters[ 'rowsAffected' ] ? $this->parameters[ 'returnData' ][0][0] : null;
+      }
       /*
        * function will attempt to make a constant ($value) safe for SQL depending on the type.
+      }
    } // class DBQuery
+/*
-   $db = new DBQuery( '127.0.0.1', 'camp', 'camp', 'camp' );
+ *    $db = new DBQuery( '127.0.0.1', 'camp', 'camp', 'camp' );
    if ($db->connect_error) {
        die('Connect Error (' . $db->connect_errno . ') '  . $db->connect_error);
+   }
    $result = $db->doSQL(
       print_r( $result );
+   }
 //   $return = $db->doSQL( "select device.device_id 'id',device.name 'name', device_type.name 'type' from device join device_type using (device_type_id) where device.removed_date is null and device_type.show_as_system = 'Y'" );
 //   print_r( $return );
 //   print_r( $db );
+*/
 ?>

Subversion Repositories phpLibraryV2

(root)/head/DBQuery.class.php – Rev 16 → 17