beav33 Posted March 8, 2007 Share Posted March 8, 2007 Know this prob stupid, but having trouble. I want to allow a user to upload a picture of their house for my real estate site. How do I design the colmn in the table with the rest of the house info. I have no clue, and no clue how to put conditions on the size. Thank you beav33 Quote Link to comment Share on other sites More sharing options...
artacus Posted March 8, 2007 Share Posted March 8, 2007 This isn't a mysql question. Quote Link to comment Share on other sites More sharing options...
beav33 Posted March 8, 2007 Author Share Posted March 8, 2007 It's not? Using phpmyadmin 2.6.3. I have a table that stores some info from users. Can I make a colmn to store pictures and if so, how or what is the sql. Beter? Quote Link to comment Share on other sites More sharing options...
artacus Posted March 8, 2007 Share Posted March 8, 2007 You typically just store the file name of the picture in mysql. Quote Link to comment Share on other sites More sharing options...
beav33 Posted March 8, 2007 Author Share Posted March 8, 2007 Ok, then you store the picture file on the server. Is there a tutorial on how to do this and retrieve the pic anywhere? Quote Link to comment Share on other sites More sharing options...
fenway Posted March 8, 2007 Share Posted March 8, 2007 Not on this site, AFAIK. Quote Link to comment Share on other sites More sharing options...
a2bardeals Posted March 8, 2007 Share Posted March 8, 2007 basically it sounds like what you want to do is incorporate a <input type=file> form element and then insert a column in your MySQL data for the path to the uploaded file. You can find out more about uploading files though a form here: http://www.faqs.org/rfcs/rfc1867.html it's a two page process. The first page is your form and where you input user data (name, address, and location of the file your wish to upload) and the sencond page which is the form action page which will copy() the uploaded file and insert the path to that file into your MySQL table. I hope this helps. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.