I need some ideas and hopefully some link/source, etc. on how to attach images to a MYSQL database record.
Essentially I think what I want to mimic is a contact management system that will allow registered users the capability to add image(s) to a particular record in a MYSQL database. Using a thumbnail(s) or photo strip would be perfect if it would allow the user to click on the thumbnail and view a larger image.
I'm open to ideas here just remember that the user will need to attach the image(s) to a particular record in the DB. I'm using Dreamweaver so PHP, AJAX, etc. are possibilities...
Thanks.
NG,
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Thanks for the link.
Since the above process loads the actual image into the DB I'm a a bit concerned about file sizes. Can you do something similar using a link to the picture, also how would you handle multiple pictures?
Assuming I would like the user to be able to load 2-3 pictures how would that be achieved?
Thanks,
Hi,
I'd use a table to store the image names, say tbl_userImages, and whenever the user would upload an image,
> the file would be moved to a folder on the server (you must be familiar with php function like move_uploaded_file(); ..you can even look it up in the php manual if you're not sure about it).
> once the file is moved, an insert operation into tbl_userImages to keep track of the image and that data which would distinguish between which user uploaded the image (say, userId or anything that's unique in the user table)
> note that, if you're uploading on a remote web server, you need to have a folder created on the webserver with '777' level access to that folder.
Cheers!
I don't think the first option works as it doesn't seem to have an option for multiple pictures unless of course you know ahead of time how many you want to attach.
The second options seems realistic but I'm not sure about how to implement... how would I handle a user that would need to upload multiple pictures - all that I can find are tutorials on uploading a single picture?
NG,
I would say it would be limited to a max of 5 images... my thoughts are to allow the user to attach multiple images to their profile/record and after the upload somehow show a small image of the images they have uploaded maybe in a picture tab strip or something...
I can't imagine nobody's done this before so any help or insight you can shed would be greatly appreciated.
NG,
I'm totally overburdened with projects at the moment. So sorry that I am not able to post a helpful code from one of my proj's due to that.
But I've one link here which could help you out I'm sure. [please fix the spaces :) ]
http: / /www. phpeasystep.com/workshopvi
This will help I'm sure.
Cheers!
Oh! It takes url! Here's it again:
http://www.phpeasystep.com
Hi,
Usually, its better to store images on a folder, and just the image names on the database. I hope you're already aware of that. I'd give you an algorithm sort of thing here, you could write a routine yourself after this.
1. Have a folder created on the server (where your site is hosted).
2. Give 777 level access to that folder (remember not to use that folder for having files other than the uploaded ones there for security reasons)
3. On your action script, use check to see if there's a file attached before actually moving.
eg. if(is_uploaded_file($_FILE
{ move_uploaded_file($_FILES
mysql_query("INSERT INTO `filesTable` SET `fileName`='".$_FILES['<you
}
This should help.
Cheers!
Business Accounts
Answer for Membership
by: airtopPosted on 2009-04-09 at 14:00:41ID: 24111574
http://www.devarticles.com