Thanks Joe! This is exactly what I was looking for. Little tweaking and I was off and running.
Thanks again Jen Downey "Lerp" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi Jen, here's some code I posted up in the general ng for storing in db and > retrieving images from db for display on your page. > It's recommended that you stay away from storing actual images in the db. If > you are storing a path the code below might help you out. It select a > firstname, and > an image according to an id. You'll have to change the "youridentityfield" > and "youridentity" values to suit your needs. > > > > > > ##################################### display image from db > ##################################################### > #connect to db > $connectionToDBid = odbc_connect("ceo34deesnr43ipits", "joeyscode", > "joeyscode"); > > > // sql statement > $sqlb = "SELECT imagepath, firstname FROM IMAGES WHERE youridentityfield =" > . $youridentity; > > # execute the query > $resultset = odbc_do($connectionToDBid, $sqlb); > > $image = odbc_result($resultset,1); > $firstname = odbc_result($resultset,2); > > print "<br><br><br><div align='center'>"; > print "<table width='400' border=0 cellpadding=2>" ; > print "<tr><td align='left'>" ; > print "<font color='#ffffff' face='verdana'><h4>" . "Welcome back " . > $firstname . "</h4></font>"; > print "</td></tr>"; > print "<tr><td align='center'>" ; > print "<img src='" . $image."' align='center' border='0'><br>"; > print "</td></tr>"; > print "</table>"; > > # close the db connection here > > ##################################### end of display image from db > ##################################################### > > > > #################################photo upload form > #################################################################### > > Here's a common form that allows you to upload a file (say an image) to the > db > > <form action='upload.php' method='post' enctype='multipart/form-data'> > <input type='hidden' name='MAX_FILE_SIZE' value='102400'> > <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 photo upload form > ############################################################## > > > ############################start of upload process to db > ################################################################ > <?php > > # $userfile is the file being uploaded > > > # print $userfile . "<BR>"; > # print $userfile_name . "<BR>"; > > #use a time stamp plus the original file name to uniquely name the image > before storing in db to prevent two files with the same name > > $timestamp = time(); > $userfile_name = $timestamp.$userfile_name ; > > // copy the file being posted -- remember to escape backslashes!!! > if(copy($userfile, "/ez/codesnipits/consultant/tempimages/". > $userfile_name)){ > print "<font face='Verdana, Arial, Helvetica, sans-serif' color='#663399' > size='2'>Your picture has been uploaded successfully and has been made > available for > online users to view.</font><br><br><br>" ; > } > else > { > print "<font face='Verdana, Arial, Helvetica, sans-serif' > color='#663399'>Error encountered during resume upload process.</font><br>"; > } > > $patharola = "tempimages/". $userfile_name; > > // insert path into database here > # connect to db > $connectionToDBid = odbc_connect("cdefc5onwesulertt", "joeyscon", > "joeyscon"); > > session_register("consultantid"); > $consultantid = $consultantid; > > # create query statement -- update image field in db using path > $sqlr = "UPDATE CONSULTANT SET image= '$patharola' WHERE consultantid=" . > $consultantid; > # execute the sql statement (query) on the connection made > $resultset = odbc_do($connectionToDBid, $sqlr); > > > ?> > > ################################end of image to db process > ################################################## > > > Hope this helps you out :) > > Cheers Joe :) > > > > > > > > "Jennifer Downey" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > If anyone knows of one, would someone please point me towards a good > > tutorial on storing images in a database then fetching them out again. > > > > I would really appreciate it and thanks in advance! > > > > Jen Downey > > > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
