PHP: sqlite_single_query - Manual

downloads | documentation | faq | getting help | mailing lists | reporting bugs | php.net sites | links | conferences | my php.net

search for in the

sqlite_udf_decode_binary sqlite_seek

Last updated: Fri, 26 Jan 2007

view this page in

# sqlite_single_query

(PHP 5)

sqlite_single_query -- Выполняет SQL зпрос и возвращает массив со значениями одного поля или первую запись

## Описание

mixed sqlite_single_query ( resource db, string query [, bool first_row_only [, bool decode_binary]] )

Внимание
К настоящему времени эта функция еще не была документирована; для ознакомления доступен только список аргументов.

add a note User Contributed Notes
sqlite_single_query
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);
?>`
add a note
sqlite_udf_decode_binary sqlite_seek

Last updated: Fri, 26 Jan 2007
show source | credits | stats | sitemap | contact | advertising | mirror sites
Copyright © 2001-2007 The PHP Group
All rights reserved.
This mirror generously provided by: Yahoo! Inc.
Last updated: Sat Mar 10 10:36:09 2007 PST