Inserting form info into MySQL database

[MikeG]

Hi all,

I would like to take the information I get from the filled in form, and store it into a MySQL database.

I alsready know I can't send the form info to two seperate php files, and so was wondering if anyone out there had done something similar, and if so, how did you do it without having to insert the database information and code into the html page of the form.

Anyone ?

Mike

[david_de]

See if this helps.

[MikeG]

Hi Dave,

If I am understanding the broader answer you supplied, you are suggesting I use a CSV file to write the data to from the form on submittion, and then use a php to re-read the information and write it to a MySQL Db ?

An interesting process if that is your suggestion.

Mike

[david_de]

I was not sure exactly what you needed and it sounded like CSV hence the link. The easy way might be to contact Russell using the information at the top of the form. It sounds like a speacialty thing his tech support subscription is very reasonable and he is a pretty good guy.

[MikeG]

Dave,

Am actually going to give your idea a shot first

It set my brain a working and although a bit roundabout, might actually give me what I need.

This php stuff is hot quite html, so I'm going slow.

Mike

[GeoBrooks]

Mike,

I'm using formmail to send a csv attachment. In the admin section of our website an admin person can upload the attachment to a php routine that parses the incoming data into as many as three mysql tables. If you'd like to see a copy of one guy's hacked solution, send me a private message with your email address.

George

[Derek Perkins]

I'm not worried about getting text data out into a CSV file, but I am having users submit a lot of image and video files. I'd like to have those inserted directly into a MySQL database so that I don't have to go through hundreds of submissions looking for information.

Can formemail upload all data types in MySQL, and if so, how?

George - I'd love to see what that other guy did to get it done. I'll send you a private message.