From: | Chris Smith <csmith(at)squiz(dot)net> |
---|---|
To: | "Zhidian Du" <duzhidian(at)hotmail(dot)com>, pgsql-php(at)postgresql(dot)org |
Subject: | Re: Are these steps correct and standard way to upload |
Date: | 2002-11-08 04:45:54 |
Message-ID: | 5.1.0.14.0.20021108154207.03192b70@cooee.squiz.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php |
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 ...../>
From | Date | Subject | |
---|---|---|---|
Next Message | Steven Lee | 2002-11-08 05:52:23 | Last URL |
Previous Message | Zhidian Du | 2002-11-08 04:32:00 | Are these steps correct and standard way to upload images into a table? |