(PHP 5 < 5.4.0, PECL sqlite >= 1.0.0)
sqlite_fetch_array -- SQLiteResult::fetch -- SQLiteUnbuffered::fetch — Fetches the next row from a result set as an array
$result
[, int $result_type = SQLITE_BOTH
[, bool $decode_binary = TRUE
]] ) : array��������� (method):
$result_type = SQLITE_BOTH
[, bool $decode_binary = TRUE
]] ) : array$result_type = SQLITE_BOTH
[, bool $decode_binary = TRUE
]] ) : array
Fetches the next row from the given result handle.
If there are no more rows, returns FALSE, otherwise returns an
associative array representing the row data.
resultThe SQLite result resource. This parameter is not required when using the object-oriented method.
result_type��ѡ�� result_type
�������ܳ������Ҿ������ص�������α�������ʹ��
SQLITE_ASSOC ������ع����������������ֶΣ�����
SQLITE_NUM ���������ֵ������SQLITE_BOTH
��ͬʱ���ع�������ֵ������SQLITE_BOTH �Ǵ˺�����Ĭ��ֵ��
decode_binary��
decode_binary ��������Ϊ TRUE��Ĭ��ֵ��ʱ��PHP �������Щ��
sqlite_escape_string()
�����Ķ��������ݡ�ͨ��Ӧ������ֵΪ��Ĭ��ֵ������Ҫ������ʹ�� SQLlite ��Ӧ�ó����������ݽ�����
Returns an array of the next row from a result set; FALSE if the
next position is beyond the final row.
��
SQLITE_ASSOC �� SQLITE_BOTH
���ص����������� sqlite.assoc_case
����ѡ���ֵ������Сд��
Example #1 Procedural example
<?php
$dbhandle = sqlite_open('sqlitedb');
$query = sqlite_query($dbhandle, 'SELECT name, email FROM users LIMIT 25');
while ($entry = sqlite_fetch_array($query, SQLITE_ASSOC)) {
echo 'Name: ' . $entry['name'] . ' E-mail: ' . $entry['email'];
}
?>
Example #2 Object-oriented example
<?php
$dbhandle = new SQLiteDatabase('sqlitedb');
$query = $dbhandle->query('SELECT name, email FROM users LIMIT 25'); // buffered result set
$query = $dbhandle->unbufferedQuery('SELECT name, email FROM users LIMIT 25'); // unbuffered result set
while ($entry = $query->fetch(SQLITE_ASSOC)) {
echo 'Name: ' . $entry['name'] . ' E-mail: ' . $entry['email'];
}
?>