Re: Upload script with user admin

That's cool. How do you then delete and edit that image? Will in article 20020201170537.67588.qmail@pb1.pair.com, Lerp at joe@coastaldestination.com wrote on 2/1/2002 5:07 PM: > Hi there, here's a bit of code to get you started. It includes a form that > allows uploads, and the code to process the upload on the receiving page. > Basically, you have a form that allows an upload of a file on one page, and > some code on the receiving page to insert a path to that file in the > database and store the newly uploaded file in a directory on the webserver. > Of course you'll have to ensure that you have the proper write and read > permissions on that folder. There are a few 'print' lines sprinkled > throughout the code. For debugging you might want to un-comment them to see > how everything is working. > > Hoe this helps you out! > Joe/Lerp :) > > > Here's a common form that allows you to upload a file (say an image or any > type of file for that matter) to the > db > > <form action='upload.php' method='post' > enctype='multipart/form-data'> > <input type='hidden' name='MAX_FILE_SIZE' value='25000'> > <P><font color='#ffffff' face='verdana' size=1>Upload > Photo:</font><input > type='file' name='userfile'><input type='submit' > value='Upload!!!'></form></p> > > ################################end of upload form > ############################################################## > > > ############################start of upload process to db > ################################################################ > <?php > > > #$userfile is the file being uploaded > > > > > //print $userfile . "<BR>"; > //print $userfile_name . "<BR>"; > > //determine file size -- if too big ( greater 50kb) then redirect > $siz = filesize($userfile); > //print $siz; > > $ext = substr($userfile_name, -4); > > > // if the file not of type 'jpg' then redraw out upload form > if($ext != ".jpg"){ > print "<font face='verdana' size='2' > class='text_size_9'>The photo you > attempted to upload was of the wrong file type. Please ensure that the file > type is a 'jpg'.</font>"; > print "<form method='POST' action='photoupload2.php' > enctype='multipart/form-data'><input type='file' > name='userfile' size='15' > style='font-family: Verdana; font-size: 8pt;'><input type='submit' > name='sub > mit' value='Upload' style='font-family: Verdana; font-size: > 8pt;'>"; > print "</form>"; > print "</td></tr></table>"; > print "<table width='470' cellspacing='10' > cellpadding='10' border='0'>"; > print "<tr><td height=30></td><td > height=30></td></tr>"; > print "<tr><td align=left><form name='forma' method='' > action='photos.php'><input type='submit' name='submit' > value='&laquo;&nbsp;Photos' style='background-color: #FFFFFF; > font-family: > verdana; font-weight: bold; color: #363C70; font-size: > 10pt;'></form></td><td></td></tr>"; > print "</table></td>"; > print "<td width='1' bgcolor='#FFFFFF' > height='341'><img > src='images/pixel_transparent.gif' width='1' height='1' > border='0' > alt=''></td>"; > print "<td width='245' bgcolor='#363C70' align='center' > valign='top' > height='341'>"; > print "<table cellspacing='0' cellpadding='0' > border='0'>"; > print "<tr> <td></td></tr><tr>"; > print "<td bgcolor='#FFFFFF'><img > src='images/pixel_transparent.gif' > width='1' height='1' border='0' > alt=''></td></tr></table>"; > print "<table cellspacing='0' cellpadding='5' > border='0'><tr>"; > print "<td><img src='images/bullet_quick_tips_small.gif' > width='17' > height='17' border='0' alt=''></td>"; > print "<td><font face='verdana' size='1' > class='text_size_8'> <a > href='contact.php' class='link_white_02'>Send us some > feedback!</a></font></td>"; > print "</tr></table></td></tr></table>"; > > exit; > } > > if ($siz >= 51200){ > > //redraw upload form > print "<font face='verdana' size='2' > class='text_size_9'>The photo you > attempted to upload was too large in file size. Please ensure that the file > size does not exceed 50kb.</font>"; > print "<form method='POST' action='photoupload2.php' > enctype='multipart/form-data'><input type='file' > name='userfile' size='15' > style='font-family: Verdana; font-size: 8pt;'><input type='submit' > name='submit' value='Upload' style='font-family: Verdana; font-size: > 8pt;'>"; > print "</form>"; > > } > elseif ($siz < 51200) > { > > $timestamp = time(); > $userfile_name = $timestamp.$userfile_name ; > > // copy the file being posted -- remember to escape backslashes!!! > if(copy($userfile, "/ez/golfPHP/pics/". $userfile_name)){ > print "<font face='verdana' size='2' > class='text_size_9'>Your photo has > been uploaded and is viewable in the photo gallery.</font><br><br>" ; > } > else > { > print "<font face='verdana' size='2' > class='text_size_9'>A problem was > encountered during your photo upload.</font><br>"; > } > > $patharola = "pics/". $userfile_name; > //print $patharola; > > $caption = "No Caption."; > > // insert path into database here > file://connect to db > $connectionToDBid = odbc_connect("golf", "joegolf", "joegolf"); > > //create query statement > $sqlr = "INSERT INTO PHOTO (golferid, photo, caption, datesubmitted) VALUES > ('$sesgolferid' , '$patharola', '$caption', > '$todaysdate' )"; > //execute the sql statement (query) on the connection made > $resultset = odbc_do($connectionToDBid, $sqlr); > > //grab the photoid from db > $sqlid = "SELECT @@IDENTITY AS NewId"; > $napid = odbc_do($connectionToDBid, $sqlid); > $photoid = odbc_result($napid, 1); > > //print "Photo Id is: " . $photoid . "<BR>"; > > // close the connection > odbc_close($connectionToDBid); > > > > ?> > > ################################end of insert to db process > ################################################## > > > > > > > > > "Artisthotel" <jens@artisthotel.com> wrote in message > news:20020201163223.35401.qmail@pb1.pair.com... >> Hi, >> >> I need an upload script that lets predefined users log in and upload > files. >> Does such a script exist? >> >> Regards >> JEns >> >> > >