SQLite3Result 类
(PHP 5 >= 5.3.0, PHP 7, PHP 8)
简介
处理 SQLite 3 扩展返回结果集的类。
类摘要
class SQLite3Result
{
/* 方法 */
}目录
- SQLite3Result::columnName — Returns the name of the nth column
- SQLite3Result::columnType — Returns the type of the nth column
- SQLite3Result::__construct — Constructs an SQLite3Result
- SQLite3Result::fetchArray — Fetches a result row as an associative or numerically indexed array or both
- SQLite3Result::finalize — Closes the result set
- SQLite3Result::numColumns — Returns the number of columns in the result set
- SQLite3Result::reset — Resets the result set back to the first row
add a note
User Contributed Notes 6 notes
jonscully at gmail dot com ¶
12 years ago
Since SQLite3Result::numRows is unavailable, use:
<?php
if ($res->numColumns() && $res->columnType(0) != SQLITE3_NULL) {
// have rows
} else {
// zero rows
}
?>
Because when there are zero rows:
* SQLite3Result::fetchArray will return '1'
* SQLite3Result::numColumns will return '1'
* Column type for column '0' will be SQLITE3_NULL
sameers dot public at gmail dot com ¶
8 years ago
According to http://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 suggested 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.
jan at bootfinder dot co dot uk ¶
7 years ago
I use the following code to get num_rows:
<?php
...
$nrows = 0;
$result->reset();
while ($result->fetchArray())
$nrows++;
$result->reset();
return $nrows;
...
?>
atesin () 6m4i1 ! com ¶
1 year ago
in response to jan at bootfinder dot co dot uk (comment #115891) about getting num_rows...
how about (not tested)... ?
<?php // do cleans before and after if needed
for ( $nrows = 0; isarray($result->fetchArray()); ++$nrows );
return $nrows;
?>
alan71-at-free-fr ¶
11 years ago
Here's a snippet that might help you to write a fetchObject function that is also missing:
<?php
function fetchObject($sqlite3result, $objectType = NULL) {
$array = $sqlite3result->fetchArray();
if(is_null($objectType)) {
$object = new stdClass();
} else {
// does not call this class' constructor
$object = unserialize(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->getProperty($name);
$attribute->setAccessible(TRUE);
$attribute->setValue($object, $value);
} catch (ReflectionException $e) {
$object->$name = $value;
}
}
return $object;
}
?>
Heavily inspired of Bergmann's Object Freezer :
https://github.com/sebastianbergmann/php-object-freezer/blob/master/Object/Freezer.php
claudiu at virtuamagic dot com ¶
12 years ago
fetchArray() will return bool(false) in case of 0 rows.