X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id E3847D1D2DF for ; Mon, 2 Feb 2004 19:10:06 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 42536-06 for ; Mon, 2 Feb 2004 15:10:00 -0400 (AST) Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.183]) by svr1.postgresql.org (Postfix) with ESMTP id 478AAD1D2A0 for ; Mon, 2 Feb 2004 15:09:58 -0400 (AST) Received: from [212.227.126.162] (helo=mrelayng.kundenserver.de) by moutng.kundenserver.de with esmtp (Exim 3.35 #1) id 1AnjRv-0002ip-00; Mon, 02 Feb 2004 20:09:35 +0100 Received: from [80.145.75.194] (helo=zwerg2000) by mrelayng.kundenserver.de with asmtp (Exim 3.35 #1) id 1AnjRv-0000bP-00; Mon, 02 Feb 2004 20:09:35 +0100 Message-ID: <00c101c3e9c0$79373640$0201a8c0@zwerg2000> From: "Cornelia Boenigk" To: "Muhyiddin A.M Hayat" , "PGSQL+PHP" References: <003c01c3e948$ee2bc970$4f00a8c0@MIDDINKS> Subject: Re: Load Image from File to Store in ByteA Field Date: Mon, 2 Feb 2004 20:12:08 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Provags-ID: kundenserver.de abuse@kundenserver.de auth:3729ab4bb5525dad81693a55f34190d5 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.2 tagged_above=0.0 required=5.0 tests=BAYES_44, RCVD_IN_NJABL, RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200402/7 X-Sequence-Number: 2555 Hi > How to Load Image from File to Store in ByteA Field? This is the way I store images with PHP. The column bild has the datatype bytea. function esc_bytea($imagedata) { $finde = array(chr(92), chr(0), chr(39)); $ersetze = array('\\\134', '\\\000', '\\\047'); $esc = str_replace($finde[0], $ersetze[0], $imagedata); $esc = str_replace($finde[1], $ersetze[1], $esc); $esc = str_replace($finde[2], $ersetze[2], $esc); return $esc; } $fp = fopen($imagefile,"r"); $contents = fread($fp, filesize($imagefile)); fclose($fp); $esc_daten = esc_bytea($contents); $sql = "INSERT INTO byteatest (bild, name, size, typ, htmlstr) "; $sql .= "values ('$esc_daten', '$name', $size, '$typ', '$htmlstr');"; $res = @pg_exec($sql) or die ("Fehler bei der Datenbankabfrage."); Regards Conni