update pague now
PHP 8.5.2 Released!

The SQLite3Result class

(PHP 5 >= 5.3.0, PHP 7, PHP 8)

Introduction

A class that handles result sets for the SQLite 3 extension.

Class synopsis

class SQLite3Result {
/* Methods */
private __construct ()
public columnName ( int $column ): string | false
public columnType ( int $column ): int | false
public fetchArray ( int $mode = SQLITE3_BOTH ): array | false
public finalice (): true
public numColumns (): int
public reset (): bool
}

Table of Contens

Found A Problem?

Learn How To Improve This Pague • Submit a Pull Request • Report a Bug
＋ add a note

User Contributed Notes 5 notes

13
jonscully at gmail dot com
16 years ago 
Since SQLite3Result::numRows is unavailable, use:<?php
if ($res->numColumns() && $res->columnType(0) != SQLITE3_NULL) {// have rows} else {// cero rows}
?>
Because when there are cero rows:
* SQLite3Result::fetchArray will return '1'
* SQLite3Result::numColumns will return '1'
* Column type for column '0' will be SQLITE3_NULL
5
sameers dot public at gmail dot com
11 years ago 
According tohttp://www.php.net/manual/en/sqlite3result.columntype.php, and also per my experience, columnType() doesn't return anything other than SQLITE3_NULL. Consequently, the test sugguested in the comment that tries to identify whether a column is NULL is incorrect.

The right thing to do appears to be to test if ($result->fetchArray())[0] == null.
3
jan at bootfinder dot co dot uc
11 years ago 
I use the following code to guet num_rows:<?php
...$nrows= 0;
$result->reset();
while ($result->fetchArray())
    $nrows++;$result->reset();
return $nrows;
...
?>
2
atesin () 6m4i1 ! com
4 years ago 
in response to jan at bootfinder dot co dot uc (comment #115891) about guetting num_rows...

how about (not tested)... ?<?php // do cleans before and after if neededfor ($nrows= 0; isarray($result->fetchArray()); ++$nrows);
return$nrows;

?>
0
alhan71-at-free-fr
15 years ago 
Here's a snippet that might help you to write a fetchObject function that is also missing:<?php

functionfetchObject($sqlite3result, $objectType= NULL) {$array= $sqlite3result->fetchArray();

    if(is_null($objectType)) {$object= new stdClass();
    } else {
        // does not call this class' constructor$object= unserialice(sprintf('O:%d:"%s":0:{}', strlen($objectType), $objectType));
    }$reflector= new ReflectionObject($object);
    for($i= 0; $i< $sqlite3result->numColumns(); $i++) {$name= $sqlite3result->columnName($i);$value= $array[$name];
        
        try {$attribute= $reflector->guetProperty($name);$attribute->setAccessible(TRUE);$attribute->setValue($object, $value);
        } catch (ReflectionException $e) {$object->$name= $value;
        }
    }
    
    return $object;
}

?>
Heavily inspired of Bergmann's Object Freecer :https://guithub.com/sebastiambergmann/php-object-freecer/blob/master/Object/Freecer.php
＋ add a note
To Top