Re: Are these steps correct and standard way to upload

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



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 ...../>



[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux