pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Chris Smith <csmith@squiz.net>
To: Zhidian Du <duzhidian@hotmail.com>
To: pgsql-php@postgresql.org
Subject: Re: Are these steps correct and standard way to upload
Date: Fri, 08 Nov 2002 15:45:54 +1100
Message-ID: <5.1.0.14.0.20021108154207.03192b70@cooee.squiz.net> (raw)
In-Reply-To: <F90HfqR77bieLYCT4aJ00000036@hotmail.com>

Hi,

>I check the posts about uploading images from browser.  No one give me a 
>whole procedure how to do it.  My friend told me I can upload binary/image 
>file using following steps:
>
>I want to know are these steps standard steps that insert images into a table?
>
>
>Step 1 upload it
><FORM METHOD=POST ACTION="" enctype="multipart/form-data">
><tr><td>upload </TD><TD><input type="file" name="pic" 
>size=40></td></tr></form>
>
><?
>         if($pic_name != '')
>         {
>         $len = strlen($pic_name)-4;
>         $ext = substr($pic_name,$len);
>         $ext = strtolower($ext);
>
>         $File="/www/pics/test".$ext;
>         exec("cp $pic $File");

Use the move_uploaded_image function in PHP. Safer and easier.

>         }
>
>
>?>
>
>Step 2 Read it
>$fd = fopen($img_name, "r");
>        while ($post_file = fread($fd, 4096))
>        {
>         $filestuff .= $post_file;
>        }
>        fclose($fd);
>
>
>Step 3 insert or update into the table using insert or update

Are you sure you want to keep the file in the database? It will bloat it 
out quite a bit (depending on the size and type of your files of course). 
Why need keep either a filename or filepath and just store the file itself 
on the machine ?

Anyway, check out the pg_lo_import function in the PHP manual for a 
starting point.


Chris

.....>> Open Source - Own it - Squiz.net ...../>
W: http://www.squiz.net/
.....>> Open Source - Own it - Squiz.net ...../>




view thread (3+ messages)  latest in thread

Message-ID: <5.1.0.14.0.20021108154207.03192b70@cooee.squiz.net>
Permalink:  ../5.1.0.14.0.20021108154207.03192b70@cooee.squiz.net/
Also on:    postgresql.org/message-id/5.1.0.14.0.20021108154207.03192b70@cooee.squiz.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: csmith@squiz.net, duzhidian@hotmail.com
  Subject: Re: Are these steps correct and standard way to upload
  In-Reply-To: <5.1.0.14.0.20021108154207.03192b70@cooee.squiz.net>
  References: <F90HfqR77bieLYCT4aJ00000036@hotmail.com> <5.1.0.14.0.20021108154207.03192b70@cooee.squiz.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox