Re: How do I store a pic?

Kenneth, I store the path to the image in the table. I am unsure if you can actually write an image to a table. When the item is deleted, I run an "exec" command to remove the actual file. Here's some snippets: The actual html to create the upload file text box within a <form>: <INPUT type="file" name="picture" size=30> This is the code for the page that is called using the form action. I added a timestamp to the filename to avoid anyone accidentially overwriting a file. (and hacking - you know a picture of a naked lady where a picture of a garden rack is supposed to be): // Creates the image file with a timestamp $timestamp = time(); $image= $timestamp.$picture_name; exec("mv $picture /path/to/your/directory/$image"); The "exec" command is what you really want to pay attenetion to. Also, this example is assuming you are running Linux and MySQL. This is the delete routine that removes the file and the record from the table: //Remove File from server $sol_1 = "SELECT * FROM featured WHERE image = '$sell_record'"; $sol_result = myself_query($sol_1, $connection) or die ("SQL_RESULT"); $row = myself_fetch_array($sol_result) or die ("Couldn't execute $sol_1"); $image = $row["image"]; exec("rm $picture /path/to/your/directory/'$image'"); Please note that you must use the actual path to the directory, not the httpd path. I hope this helps you. Let me know..... Shane ----- Original Message ----- From: "Kenneth R Zink II" <Hellcat1@EV1.Net> To: "PHP" <php-general@lists.php.net> Sent: Friday, January 12, 2001 4:35 PM Subject: [PHP] How do I store a pic? > How do I store a jpg within a table? > > I want for a user to be able to pull a jpg from either their HD and store it > in a table with some other information for a classifieds section. That way > when the ad is deleted, the picture goes with it instead of remaining on my > HD. > > Kenneth R Zink II Hellcat1@S-Series.Org ICQ# 5095094 > '87 2.8L TBI GMC S-15 Ext. Cab (Hurricane) ...524 in the works !!! > http://www.s-series.org/htm/windstorm/project-windstorm.htm > '85 3.4L Carbed Chevy S-10 Blazer (FireStorm) ...Soon to be 3.4L SFI DIS !!! > http://www.s-series.org/htm/firestorm/firestorm.htm > Racing by the Grace of God!! > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >