Edit Report a Bug

SQLite3Result::finalize

(PHP 5 >= 5.3.0, PHP 7)

SQLite3Result::finalize — Closes the result set

설명

public bool SQLite3Result::finalize ( void )

Closes the result set.

인수

이 함수는 인수가 없습니다.

반환값

Returns TRUE.

add a note

User Contributed Notes 1 note

down

-2

Anonymous ¶

8 years ago


A simple example using finalize().



// Open the database connection

$db = new SQLite3('database.db');



// Prepare a query for execution

$query = $db->prepare('SELECT user_id FROM users WHERE username=:username');

$query->bindValue(':username', $_COOKIE['username'], SQLITE3_TEXT);



// Execute the query

$result = $query->execute();



// Store the result of the query

$id = $result->fetchArray(SQLITE3_NUM)[0];



// Close the result set and database connection

$result->finalize();

$db->close();



Of course you should be more careful and clean your cookie, etc.

add a note