Manuel,
Thanks for the comment. I am able to load the output
correctly, if I do a import directly from the server.
I am only having trouble with the upload code. Any
idea from the code below?
Thanks,
David
--- Manuel Lemos <[EMAIL PROTECTED]> wrote:
> Hello,
>
> David H wrote:
> >
> > Hi all,
> >
> > I am trying to findout what is wrong with this
> script
> > can anyone help?
> >
> > $dbconn = pg_connect ("cnnection string")
> >
> or die (
> "Error: ".pg_errormessage
> > ($dbconn)) ;
> >
> > pg_exec ($dbconn, "begin") ;
> > $oid = pg_locreate ($dbconn) ;
> > $fd = pg_loopen ($dbconn, $oid, "w") ;
> > pg_lowrite ( $fd, $img ) ;
> > pg_loclose ( $fd ) ;
> > $strqry = "INSERT INTO tblImg ( myname,
> mytype,
> > myimg, myfilesize ) VALUES ( '$img_name',
> '$img_type',
> > '$oid', $img_size )";
> > $result = pg_exec ( $dbconn, $strqry ) ;
> > pg_exec ($dbconn, "commit") ;
> > pg_exec ($dbconn, "end") ;
> >
> > The output that I am getting is this
> >
> > /tmp/phpQPUyx2
> >
> > by pg_loreadall function.
>
> Similarly, you need to do pg_loopen on a OID
> returned by a select query.
>
> Anyway, if you want to try something that works with
> easier to
> understand interface, maybe you would like to try
> Metabase which is a
> database abstraction PHP package that provides a
> single and portable
> interface to BLOBs that supports PostgreSQL among
> many other databases.
>
> Metabase is free and you may download it from here:
>
>
http://phpclasses.UpperDesign.com/browse.html/package/20
>
> Regards,
> Manuel Lemos
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> For additional commands, e-mail:
> [EMAIL PROTECTED]
> To contact the list administrators, e-mail:
> [EMAIL PROTECTED]
>
__________________________________________________
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
