Joe (And/Or others), We are storing the actual images in the DB. We did not want our pictures to be on our webserver. Instead we felt it would be better to keep them on the database server. In order to do this, they had to be stored in the database itself since the database server is not accesible by the web. (I.e. the only way to get stuff off of it via the web is to pull it out through the DB connection)
Now, You say that it is not recommended that we store our images in our database, can you give me a reasons why? Thanks, Zara -----Original Message----- From: Lerp [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 2:17 PM To: [EMAIL PROTECTED] Subject: [PHP] Re: Image Fields and PHP... Hi Zara, are you storing a path to the images in your db? Or the actual image? 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. If you are looking for an image upload script ##################################### 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 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 :) "Zara E Gonzalez" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Not sure if this is off topic for this list or not, but thought I > would try... > > I have a Linux server running Redhat 7.0, PHP 4.1.1, and freetds 0.53. > My Linux > server connects to a Win2k server running MSSQL 2000. > > Everything works wonderfully, except, I have an image field in one of > my tables > and I can't seem to find a way to pull it out without having PHP completely > freak out. (i.e. I get no error message at all just "page cannot be displayed") > > So I'm wondering, can you pull image fields out with PHP? > > If so, I'm guessing my limitation is freetds. If not, is there any way > to pull > an image out of a database using php? (i.e. store it in a different > type of > field not image.) > > Any help is appreciated, > > Thanks, > > Zara -- 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] -- 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]
