PHP - Manual: SQLite3Result

2024-12-22

SQLite3Result::columnName »

« SQLite3Stmt::reset

SQLite3Result 类

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

简介

处理 SQLite 3 扩展返回结果集的类。

类摘要

class SQLite3Result {

/* 方法 */

public columnName(int $column): string|false

public columnType(int $column): int|false

public fetchArray(int $mode = SQLITE3_BOTH): array|false

public finalize(): bool

public numColumns(): int

public reset(): bool

}

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

down

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

down

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.

down

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;
...
?>

down

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;

?>

down

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

down

-15

claudiu at virtuamagic dot com ¶

12 years ago


fetchArray() will return bool(false) in case of 0 rows.

add a note

官方地址：https://www.php.net/manual/en/class.sqlite3result.php

有任何技术问题请点击这里网站运营推广招聘

IT PHP 编程语言 Linux 开发编程科技 Elasticsearch HTML/CSS/XML 网络数据库 JAVA 面试 NoSQL C/C++ Golang Git 算法操作系统正则表达式 Redis 互联网 MySql JavaScript 运维软件国际架构设计 Mac OS TCP/IP Excel Vim Windows Socket Oracle VR MongoDB Python 运营 MemCache 商业硬件电子娱乐设计 nginx 摄影游戏 WordPress HTTP 团建数码电器

php7 安装fileinfo扩展 preg_split — 通过一个正则表达式分隔字符串 php位值,解决 PHP 中 usort 在值相同时改变原始位置的问题 [PHP] inet_pton/inet_ntop IP地址转换函数 PHP 8.1 [鸟哥]PHP_INT_MIN 和 -9223372036854775808 ADORecordSet对象 adodb手册 opcache预加载 Composer的Packagist资源 array_multisort() 多字段排序 PHPMailer设置utf8 PHPMailer字符集CharSet PHP json解析（json_decode）页面工具 mysql面试题 [原创]诡异的php-fpm超时问题 php中几种注释规范纯php实现DES以及TripleDES加密算法 php 修改图片大小支持php7的性能采集扩展 PHP mkdir()写出来的权限与mode值不符合

略微加速

PHP官方手册 - 互联网笔记

SQLite3Result 类

简介

类摘要

目录

User Contributed Notes 6 notes