SQLite3::openBlob
SQLite3::openBlob
(PHP 5 >= 5.3.0, PHP 7)
SQLite3::openBlob — Opens 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
© 1997–2017 The PHP Documentation Group
Licensed under the Creative Commons Attribution License v3.0 or later.
https://secure.php.net/manual/en/sqlite3.openblob.php