• 首页
  • vue
  • TypeScript
  • JavaScript
  • scss
  • css3
  • html5
  • php
  • MySQL
  • redis
  • jQuery
  • PDO::pgsqlLOBUnlink()

    (PHP 5 >= 5.1.2, PHP 7, PECL pdo_pgsql >= 1.0.2)

    Deletes the large object

    说明

    publicPDO::pgsqlLOBUnlink(string $oid): bool

    Deletes a large object from the database identified by OID.

    Note: This function must be called within a transaction.

    参数

    $oid

    A large object identifier

    返回值

    成功时返回TRUE,或者在失败时返回FALSE

    范例

    Example #1 A PDO::pgsqlLOBUnlink() example

    This example unlinks a large object from the database prior to deleting the row that references it from the blobs table we've been using in our PDO::pgsqlLOBCreate() and PDO::pgsqlLOBOpen() examples.

    <?php
    $db = new PDO('pgsql:dbname=test host=localhost', $user, $pass);
    $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $db->beginTransaction();
    $db->pgsqlLOBUnlink($oid);
    $stmt = $db->prepare("DELETE FROM BLOBS where ident = ?");
    $stmt->execute(array($some_id));
    $db->commit();
    ?>
    

    参见

    • PDO::pgsqlLOBOpen() Opens an existing large object stream
    • PDO::pgsqlLOBCreate() Creates a new large object