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

       public function run () {
          return $this->doSQL( );
+      }
       /**
-       * Simple function returns last inserted id on succes, false on
+       * Simple function returns last inserted id on success, false on
        * failure
+       *
        * @params string $query An insert query to execute
        * @return integer The insert id from this insert, if applicable
        */
       public function insert( $query ) {
          return $this->query( $query ) ? $this->insert_id : false;
+      }
+       /**
+        * A query with at least two columns in the result is converted to a
+        * key => value array. The first column is the key, the second is the value
+        * All other columns are ignored
+        */
+       public function queryToKeyedArray ( $query ) {
+          $return = array();
+         $result = $this->doSQL( $query, array( 'returnType' => 'array' ) );
+         foreach ( $result['returnData'] as $row ) {
+            $return[$row[0]] = $row[1];
+         }
+         return $return;
+      }
       /**
        * returns an array of the first column for each row returned from query
+       *
        * The query is run, then for each row returns, the first column
           //print "<pre>fields\n" . print_r( $fields, true ) . "\n</pre>"; die;
           $query = "insert into $tablename (" . implode( ',',array_keys($fields) );
           $query .= ") values (" . implode( ',', array_map( array($this, 'my_escape_string'), array_values( $fields ) ) );
           return "$query)";
        } // insertQuery
    } // class DBQuery
 /*

Subversion Repositories phpLibraryV2

(root)/head/DBQuery.class.php – Rev 43 → 44