View Full Version : adding data into mysql database + image/thumb handling

The Diabolical
12-07-2010, 05:57 PM

What I'm trying to do is have users upload their event information into a database which would include a flyer. I don't want the image file to go into the database (other than the filename) rather I'd like it to be dropped into a directory. In the same script I'd like to dynamically generate a thumbnail. I have the two scripts and separately they work fine, but I can't get them to work together.

I'm guessing the conflict because the thumbnail script is using $_POST and the mysql script is using $_SESSION. If so how can I modify them to both use $_SESSION?

The thumbnail script is goes from line 1 - 146 and the mysql portion is the rest.

The results of processing this look something like this.

INSERT INTO td_events (eventgenre_sel, eventname, eventvenue, eventdate, eventgenre, eventprice, eventpromoter, eventflyer) VALUES ('12', 'spooky times', 'Ironwood Stage & Grill', '2010-12-17 22:36:00', 'DNB', '5000', 'me', '174366-1.jpg')

code (http://pastie.org/1355893)

12-07-2010, 06:14 PM
Can you describe the symptoms of the problem? Where is the script going wrong? What is the feedback you are getting from the script?

The Diabolical
12-07-2010, 09:48 PM
Ah sorry.

The image the user uploads isn't put into the specified directory. The thumbnail from that image is not created either.

As far as feedback goes, I don't get any errors. I just get the confirmation that the data has been dropped into the database.

You can try it at http://www.postmorebills.ca/user_registration.php