php教程

sqlite_single_query

SQLiteDatabase::singleQuery

(PHP 5 < 5.4.0, PECL sqlite >= 1.0.1)

sqlite_single_query -- SQLiteDatabase::singleQuery Executes a query and returns either an array for one single column or the value of the first row

说明

sqlite_single_query ( resource $db , string $query [, bool $first_row_only [, bool $decode_binary ]] ) : array

面向对象风格 (method):

public SQLiteDatabase::singleQuery ( string $query [, bool $first_row_only [, bool $decode_binary ]] ) : array
Warning

本函数还未编写文档,仅有参数列表。

User Contributed Notes

oohall AT gmail DOT comMERCIAL 10-Apr-2008 10:38
The previous note by franp at free dot fr appears to be incorrect, some cursory testing showed that DELETE FROM and INSERT INTO queries worked fine so other queries which do not return data should also work. However, if you're looking for a drop in replacement for sqlite_query(), try sqlite_unbuffered_query() as it appears to only execute the first query if more than one is given.
franp at free dot fr 26-Sep-2004 05:42
AFAIK, you cannot use sqlite-single-query for all kind of SQL queries.
If you are lazy and thought you could safely copy-paste your :
<?php $result = $db->sqlite-single-query($sSQL); ?>
straight from one query to the other, whatever is the query as long as it has only one line, you are wrong.

Apparently, sqlite-single-query is limited to queries that return data, that is to SELECT queries.

<?php
$sSQL 
= "DELETE FROM atoms WHERE ID = '8';";

// The following won't work :
$result = $db->singleQuery($sSQL);

// But the following will :
$result = $db->query($sSQL);
?>

CopyRight © 2008-2022 verySource.Com All Rights reserved. 京ICP备17048824号-1 京公网安备:11010502034788