CODEWITHSUNDEEP
phpmysqlimageuploadfilenames
Eds
Eds

Reputation: 575

upload image, then put file path into a form

I just need a bit of advice on what direction to go with something I am creating.

It is a simple php based webpage for our sports and social members in our office, allowing them to create, edit, view and delete events for all members to see. Events like day trips, bbq's and all kinds of things like that.

So far I have it all working as I would like, other than one thing, being the event logos.

At present, the events are all stored in a mysql database, in one table, with a column for every aspect of the event; time, date, price, venue etc etc.

I also have two columns for the event logos, one for the venue logo, and one for the general event logo.

What I need advice on, is the best way to create a page that allows a user to upload an image to the server, browse the images already uploaded, select one, and have it's file path entered into a text input when creating the event.

Could someone offer their suggestions on the best way to go about this, or offer an alternative method for selecting and inputting a logo for the event?

Thanks

Upvotes: 0

Views: 567

Answers (3)

Eds
Eds

Reputation: 575

I ended up storing the images in the database itself.

Saved some hassle on the file path side of things.

Upvotes: 0

Martin Vrkljan
Martin Vrkljan

Reputation: 879

The Uploadify jQuery plugin works really well for batch and/or AJAX uploads. The way I'd handle your situation would be this:

  1. Show all images on the same page with the form, and give each image a related radio button with the image path as the button's value, so the user simply checks the image they want to use,
  2. If the user wants to upload images, use the Uploadify plugin and it's AJAX callback functions to dynamically populate the existing list of radio buttons.

The comment I made on your question, asking wether you store images (or their file paths) was because I think it would be much easier (and cleaner) for you to retrieve a list of uploaded images by querying a database. Personally, I don't store images in a database, only their file paths, and use PHP to handle any images that need to be deleted or moved. It's easier to assing images to other entities (especially in many-to-many relationships) that way.

If you don't want to store images' data in a separate table, I guess you'd have to use PHP file system functions to get a list of files already uploaded (glob comes to mind, although there could be better functions or this).

EDIT:

There is also a very good AJAX file browser plugin - ckFinder, but I have very little experience with it and can't really comment on its workflow, but if you find it to be a more elegant solution, you should try it out.

Upvotes: 1

sohaan
sohaan

Reputation: 647

if i could understand your question you want to associate the image with the event i.e tag the image with the event right ?? you can use jquery's attr() function to grab the src of img and put it in input field

Upvotes: 0

Related Questions