Re: [PHP] Re: large object problem
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]
Re: [PHP] Re: large object problem
Hello, David H wrote: 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? Sure, the problem is that you think that $img contains the contents of the uploaded file but in fact it contains just the name of the temporary file to which the uploaded file was copied. You need to open that temporary file and read its contents to store the BLOB. Regards, Manuel Lemos 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]
[PHP] Re: large object problem
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]
