Re: Can't get PHP PDO LOB working with PostgreSQL (WRONG CODE)

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/

In response to

Browse pgsql-php by date

  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