| From: | Chris <dmagick(at)gmail(dot)com> |
|---|---|
| To: | Rico Secada <coolzone(at)it(dot)dk> |
| Cc: | pgsql-php(at)postgresql(dot)org |
| Subject: | Re: Can't get PHP PDO LOB working with PostgreSQL (WRONG CODE) |
| Date: | 2008-09-26 03:57:42 |
| Message-ID: | 48DC5DB6.2070706@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | A B | 2008-09-30 07:23:06 | Unknown: Cannot set connection to blocking mode in Unknown on line 0 |
| Previous Message | Rico Secada | 2008-09-25 21:37:29 | Re: Can't get PHP PDO LOB working with PostgreSQL |