(PHP 4 >= 4.2.0, PHP 5, PHP 7, PHP 8)
pg_lo_open — Open a large object
pg_lo_open() opens a large object in the database and returns an PgSql\Lob instance so that it can be manipulated.
Do not close the database connection before closing the PgSql\Lob instance.
To use the large object interface, it is necessary to enclose it within a transaction block.
Зауваження:
This function used to be called pg_loopen().
connectionПримірник
PgSql\Connection. Якщо параметр
connection не визначено, то виконується стандартне
з'єднання, тобто останнє, виконане функцією pg_connect()
або pg_pconnect().
Починаючи з PHP 8.1.0, використання стандартного з'єднання є застарілим.
oidThe OID of the large object in the database.
modeCan be either "r" for read-only, "w" for write only or "rw" for read and write.
| Версія | Опис |
|---|---|
| 8.1.0 | Returns an PgSql\Lob instance now; previously, a resource was returned. |
| 8.1.0 |
Тепер параметр connection має бути примірником
PgSql\Connection. Раніше очікувався resource.
|
Приклад #1 pg_lo_open() example
<?php
$database = pg_connect("dbname=jacarta");
pg_query($database, "begin");
$oid = pg_lo_create($database);
echo "$oid\n";
$handle = pg_lo_open($database, $oid, "w");
echo "$handle\n";
pg_lo_write($handle, "large object data");
pg_lo_close($handle);
pg_query($database, "commit");
?>Just for the record, a user must be a superuser (database owner) in order to invoke pg_lo_open() (though pg_lo_create() may be invoked...). This opens a gigantic security hole in the db. If a user is not a superuser, db will raise an error with message "Can't create Large Object.".
Thus, imho, one should use pg_escape_bytea() instead.