Re: Can't get PHP PDO LOB working with PostgreSQL (WRONG CODE) - Mailing list pgsql-php

From Chris
Subject Re: Can't get PHP PDO LOB working with PostgreSQL (WRONG CODE)
Date
Msg-id 48DC5DB6.2070706@gmail.com
Whole thread Raw
In response to Can't get PHP PDO LOB working with PostgreSQL (WRONG CODE)  (Rico Secada <coolzone@it.dk>)
List pgsql-php
> I don't know if the above is correct or if PostgreSQL has received the
> binary data correctly, maybe someone can confirm this for me please?

If it has an id, I suspect postgres got it just fine.

> $stmt = $pdo->prepare("SELECT blob_type, attachment FROM attachments
> WHERE id = :id LIMIT 1");
> $stmt->bindParam(':id', $_GET['id'], PDO::PARAM_STR);

See examples here:

http://au.php.net/manual/en/function.pdo-pgsqllobopen.php

about how to get it back.

--
Postgresql & php tutorials
http://www.designmagick.com/


pgsql-php by date:

Previous
From: Andrew McMillan
Date:
Subject: Re: Can't get PHP PDO LOB working with PostgreSQL (WRONG CODE)
Next
From: "A B"
Date:
Subject: Unknown: Cannot set connection to blocking mode in Unknown on line 0