sqlite_fetch_object

SQLiteResult::fetchObject

SQLiteUnbuffered::fetchObject

(PHP 5 < 5.4.0)

sqlite_fetch_object -- SQLiteResult::fetchObject -- SQLiteUnbuffered::fetchObjectFetches the next row from a result set as an object

Description

sqlite_fetch_object ( resource $result [, string $class_name [, array $ctor_params [, bool $decode_binary = TRUE ]]] ) : object

Object oriented style (method):

SQLiteResult::fetchObject ([ string $class_name [, array $ctor_params [, bool $decode_binary = TRUE ]]] ) : object
SQLiteUnbuffered::fetchObject ([ string $class_name [, array $ctor_params [, bool $decode_binary = TRUE ]]] ) : object
Warning

This function is currently not documented; only its argument list is available.

add a note add a note

User Contributed Notes 4 notes

up
1
florian at phpws dot org
18 years ago
Here is the function from "cscm at meuh dot dyndns dot org" rewriten.
I think it will work better when really assigning the values ;-)
Also I'd replace the empty "bidon" class by stdClass wich is such an empty class and is provided by default.

// Fetch resultset as an object
function sqlite_fetch_object(&$resource){
               $arr =  sqlite_fetch_array($resource);
               $obj = new stdClass();
               foreach ($arr as $key => $value) {
                       # Check is valid $T_VARIABLE
                       if (ereg(\"[a-zA-Z_\x7f-\xff][a-zA-Z0-9_\x7f-\xff]*\", $key)) {
                               $obj->$key = $value;
                       }
               }
               return $obj;
}
up
0
vbwebprofi at gmx dot de
18 years ago
Here a light workaround for PHP 4.x which I use in my DBAccess class :

<?
 
function sqlite_fetch_object(&$result) {
   
$vO = sqlite_fetch_array($result, SQLITE_ASSOC);

    if(
$vO) {
     
$vO = (object) $vO;
    }

    return
$vO;
  }
?>

HTH Holger
up
0
cscm at meuh dot dyndns dot org
18 years ago
As the sqlite_fetch_object function is not implemented in the PECL extension version 1.0.3.
I’ve rewrite the sqlite_fetch_object in PHP :

// An empty class
class bidon {
}
   
// Fetch resultset as an object
function sqlite_fetch_object(&$resource){
                $arr =  sqlite_fetch_array($resource);
                $obj = new bidon();
                foreach ($arr as $key => $value) {
                        # Check is valid $T_VARIABLE
                        if (ereg(\"[a-zA-Z_\x7f-\xff][a-zA-Z0-9_\x7f-\xff]*\", $key)) {
                                $obj->$key;
                        }
                }
                return $obj;
}

Voila
up
-1
Benjamin
20 years ago
This function is not implemented in the PECL extension version 1.0.3  http://pecl.php.net/package/SQLite/1.0.3
To Top