sqlite_fetch_object

SQLiteResult::fetchObject

SQLiteUnbuffered::fetchObject

(PHP 5 < 5.4.0)

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

Description

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

Object oriented style (method):

object 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 ]]] )

Warning

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

User Contributed Notes

florian at phpws dot org

9 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;
}

vbwebprofi at gmx dot de

10 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

cscm at meuh dot dyndns dot org

10 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

Benjamin

11 years ago


This function is not implemented in the PECL extension version 1.0.3  http://pecl.php.net/package/SQLite/1.0.3