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 Link to comment https://forums.phpfreaks.com/topic/41732-picture/ Share on other sites More sharing options...
artacus Posted March 8, 2007 Share Posted March 8, 2007 This isn't a mysql question. Link to comment https://forums.phpfreaks.com/topic/41732-picture/#findComment-202340 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? Link to comment https://forums.phpfreaks.com/topic/41732-picture/#findComment-202349 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. Link to comment https://forums.phpfreaks.com/topic/41732-picture/#findComment-202358 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? Link to comment https://forums.phpfreaks.com/topic/41732-picture/#findComment-202360 Share on other sites More sharing options...
fenway Posted March 8, 2007 Share Posted March 8, 2007 Not on this site, AFAIK. Link to comment https://forums.phpfreaks.com/topic/41732-picture/#findComment-202533 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. Link to comment https://forums.phpfreaks.com/topic/41732-picture/#findComment-202874 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.