The 5th Annual China PHP Conference

SQLite3::openBlob

(PHP 5 >= 5.3.0, PHP 7)

SQLite3::openBlobOpens a stream resource to read a BLOB

Description

public resource SQLite3::open ( string $table , string $column , int $rowid [, string $dbname = "main" ] )

Opens a stream resource to read a BLOB, which would be selected by:

SELECT column FROM dbname.table WHERE rowid = rowid

Parameters

table

The table name.

column

The column name.

rowid

The row ID.

dbname

The symbolic name of the DB

Return Values

Returns a stream resource, or FALSE on failure.

Examples

Example #1 SQLite3::openBlob() example

<?php
$conn 
= new SQLite3(':memory:');
$conn->exec('CREATE TABLE test (text text)');
$conn->exec("INSERT INTO test VALUES ('Lorem ipsum')");
$stream $conn->openBlob('test''text'1);
echo 
stream_get_contents($stream);
fclose($stream); // mandatory, otherwise the next line would fail
$conn->close();
?>

The above example will output:

Lorem ipsum

add a note add a note

User Contributed Notes

There are no user contributed notes for this page.
To Top