You're welcome Jen :) Cheers, Joe :)
"Jennifer Downey" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 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
