I forgot to mention that all of the pics in my small app are renamed and are only 5 digits in length. So I always know I can count on the substr() and 5 digits/characters. Your situation is more than likely different than mine own, and you'll have to adjust the extraction of the file name to suit your needs.
HTH Joe :) Lerp <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Deleting and editing is accomplished by selecting out of the db the > appropriate record. So if you had a page that looped through 35 (for > example) records, and each record had a link that was created (<a > class='link_black_02' href='deletephotoconfirm.php?photoid=$photoid'>" . > "delete" . "</a>) -- use the querystring to pass the $photoid to a > confirmation page. On that confirmation page (I usually do this) create 2 > forms with one button in each. Both post/get to the processing page, one > button has a value (for example) 'dodelete' and the other form's button > 'dontdoit'. Then at the top of the processing page, figure out which button > was pressed and go from there. For editing the actual path for the image, > it is done the same old way, select the record according to an id, dump the > values you want changed into a form , edit and post/get it back up the same > way it was done the first time around. > > Hope this helps you out :) > > Joe/ Lerp :) > > ######################grab records from > db################################################################ > > $connectionToDB = odbc_connect("gdff", "jgdfoldff", "jdfdfgrf"); > $sqlp = "SELECT photoid, caption, datesubmitted FROM PHOTO WHERE > golferid='$sesgolferid'" . " ORDER BY datesubmitted DESC"; > $resultset = odbc_do($connectionToDB, $sqlp); > > //start table for display here > print "<table width='500' cellspacing='0' cellpadding='0' border='0'>"; > > print "<tr colspan='3'>"; > print "<td bgcolor='#363C70' colspan='3'><img > src='images/pixel_transparent.gif' width='1' height='5' border='0' > alt=''></td>"; > print "</tr>"; > > print "<tr>"; > print "<td bgcolor='#363C70' align='left' width='200'>"; > print "<font face='verdana' color='#FFFFFF' size='2' > class='text_size_9'>"; > print "<b>Caption</b>"; > print "</font>"; > print "</td>"; > print "<td bgcolor='#363C70' align='left' width='230'>"; > print "<font face='verdana' color='#FFFFFF' size='2' > class='text_size_9'>"; > print "<b>Date Submitted</b>"; > print "</font>"; > print "</td>"; > print "<td bgcolor='#363C70' align='left' width='70'>"; > print "<font face='verdana' color='#FFFFFF' size='2' > class='text_size_9'>"; > print "<b>Delete</b>"; > print "</font>"; > print "</td>"; > print "</tr>"; > > print "<tr>"; > print "<td bgcolor='#363C70' colspan='3'><img > src='images/pixel_transparent.gif' width='1' height='5' border='0' > alt=''></td>"; > print "</tr>"; > > print "<tr height='10'></td></td></tr>"; > > > while(odbc_fetch_row($resultset)){ > > $photoid = odbc_result($resultset,1); > $caption = odbc_result($resultset,2); > $datesubmitted = odbc_result($resultset,3); > > > //format the datesubmitted for display below > $month = substr($datesubmitted, 5, 2); > //print $month . "<BR>"; > $day = substr($datesubmitted, 8, 2); > //print $day . "<BR>"; > $year = substr($datesubmitted, 0, 4); > //print $year . "<BR>"; > > $dateinsecs = mktime(0,0,0,$month, $day, $year); > > > $formattedsubdate = date('F j Y',$dateinsecs); > //print $formattedsubdate; > > > file://display the records --create a link for > each############################### > print "<tr>"; > print "<td align='left' bgcolor='#ffffff' width='200'><b><font > face='verdana' color='#000000' size='2' class='text_size_9'>" . $caption . > "</font></b></td>" . "<td align='left' width='230' bgcolor='#ffffff'><font > face='verdana' color='#000000' size='2' class='text_size_9'>" . > $formattedsubdate . "</font></td>" . "<td align='left' width='70' > bgcolor='#ffffff'><font face='verdana' color='#000000' size='2'><b><a > class='link_black_02' href='deletephotoconfirm.php?photoid=$photoid'>" . > "delete" . "</a></b></font></td>"; > print "</tr>"; > print "<tr height='10'></td></td></tr>"; > } > > } > > > > // close the connection > odbc_close($connectionToDB); > > ##############end of display from > database####################################################### > > > > > ##############confirmation > page############################################################## > > > <div align='center'> > <table cellspacing="0" cellpadding="5" border="0" > > <tr> > <td align="center"> > > <form action="dodeletep.php" method="post"> > <input type="hidden" name="photoid" value="<?php echo $photoid; ?>"> > > <input type="hidden" name="dodelete" value="dodelete"> > <input type="Submit" name="submit" value=" Yes " > style="background-color: #FFFFFF; font-family: verdana; font-weight: bold; > color: #363C70; font-size: 10pt;"> > </form> > > </td> > <td align="center"> > > <form action="dodeletep.php" method="post"> > <input type="hidden" name="photoid" value="<?php echo $photoid; ?>"> > > <input type="hidden" name="dontdelete" value="dontdelete"> > <input type="Submit" name="submit" > value=" No " style="background-color: #FFFFFF; > font-family: verdana; font-weight: bold; color: #363C70; font-size: 10pt;"> > </form> > > </td> > </tr> > </table> > > </div> > > ################end of confirmation > page################################################### > > > ###############processing > page########################################################### > > <?php session_start(); ?> > <?php > > if (!isset($HTTP_SESSION_VARS["islogged"])){ > > header("Location:index.php"); > } > > if(isset($dodelete)){ > > //connect to db > $connectionToDB = odbc_connect("gfghf", "jofgh6lf", "hghdfg"); > > //determine which file to delete off of the server (and delete it) before > deleting it out of db > > $sqlphoto = "SELECT photo FROM PHOTO WHERE photoid='$photoid'"; > $deletephotoid = odbc_do($connectionToDB, $sqlphoto); > $pi = odbc_result($deletephotoid, 1); > > //print "Photo name is; " . $pi . "<BR>"; > $pi = trim($pi); > $pi = substr($pi,5); > > //print "File to be deleted is: " . $pi . "<br>"; > > //actual deletion of file off of server > unlink("pics/" . $pi); > > $sqldel = "DELETE FROM PHOTO WHERE photoid ='$photoid'"; > > odbc_do($connectionToDB, $sqldel); > } > else > { > header("Location:photos.php"); > } > > > // close the connection > odbc_close($connectionToDB); > ?> > > > > ###############end of processing > page########################################################### > > > > > > > > > > > "Will Hives" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > That's cool. > > > > How do you then delete and edit that image? > > > > Will > > > > > > > > > > > > > > > > > > > > in article [EMAIL PROTECTED], Lerp at > > [EMAIL PROTECTED] 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 > > > > > > > > > > > > > > > file://print $userfile . "<BR>"; > > > file://print $userfile_name . "<BR>"; > > > > > > file://determine file size -- if too big ( greater 50kb) then redirect > > > $siz = filesize($userfile); > > > file://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='« 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){ > > > > > > file://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; > > > file://print $patharola; > > > > > > $caption = "No Caption."; > > > > > > // insert path into database here > > > file://connect to db > > > $connectionToDBid = odbc_connect("golf", "joegolf", "joegolf"); > > > > > > file://create query statement > > > $sqlr = "INSERT INTO PHOTO (golferid, photo, caption, datesubmitted) > VALUES > > > ('$sesgolferid' , '$patharola', '$caption', '$todaysdate' )"; > > > file://execute the sql statement (query) on the connection made > > > $resultset = odbc_do($connectionToDBid, $sqlr); > > > > > > file://grab the photoid from db > > > $sqlid = "SELECT @@IDENTITY AS NewId"; > > > $napid = odbc_do($connectionToDBid, $sqlid); > > > $photoid = odbc_result($napid, 1); > > > > > > file://print "Photo Id is: " . $photoid . "<BR>"; > > > > > > // close the connection > > > odbc_close($connectionToDBid); > > > > > > > > > > > > ?> > > > > > > ################################end of insert to db process > > > ################################################## > > > > > > > > > > > > > > > > > > > > > > > > > > > "Artisthotel" <[EMAIL PROTECTED]> wrote in message > > > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > >> Hi, > > >> > > >> I need an upload script that lets predefined users log in and upload > > > files. > > >> Does such a script exist? > > >> > > >> Regards > > >> JEns > > >> > > >> > > > > > > > > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
