sqlite_seek
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.
sqlite_single_query
SQLiteDatabase->singleQuery
(PHP 5, PECL sqlite >= 1.0.1)
sqlite_single_query -- SQLiteDatabase->singleQuery — クエリを実行し、単一カラムもしくは先頭レコードの値に対する配列を返す
説明
array sqlite_single_query
( resource $db
, string $query
[, bool $first_row_only
[, bool $decode_binary
]] )
オブジェクト指向言語型スタイル (メソッド):
SQLiteDatabase
array singleQuery
( string $query
[, bool $first_row_only
[, bool $decode_binary
]] )
警告
この関数は、 現在のところ詳細な情報はありません。引数のリストのみが 記述されています。
add a note
User Contributed Notessqlite_single_query
oohall AT gmail DOT comMERCIAL
11-Apr-2008 08:38
11-Apr-2008 08:38
franp at free dot fr
27-Sep-2004 03:42
27-Sep-2004 03: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);
?>