I created a form to send images & text data to a web folder. Works fine Images uploaded to .../form99999/files but? metadate (Lmane, Fname, Email, etc) cannot be found.
If I SUBMIT to email, meta data arrives with links to images at .../form99999/files.
I have not tried to submit to mysql, because I am not sure how many fields to create in the table. Example is email shows new name of image file plus original file name. Would love to have table with meta data and the links to images stored in a folder in their original file type.
Help is appreciated.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Without your form, or without more information it is impossible to tell if you created a form that captures the information you are talking about. If you did everything right then the information is captured somewhere but again it is impossible to tell you what is wrong without more information. If you want more help please post your form number so I can get a copy if necessary and be more specific about what is wrong.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
After further experimentation, I have created a new form which uploads to MYSQL database.
I created a database on my ISP and then by running install.php it set the proper login to the database in the config.inc.php file.
My form has a mixture of Image upload fields and text fields. When I entered data into the form, a table was created in the database (all fields were created a TEXT fields).
When I did a SUBMIT, Only information from TEXT fields were uploaded to the new TABLE.
The data was place in the correct fields in MySQL, the "File" fields were empty, but the images were uploaded to the ISP folder ....../form99999/files/ folder.
the confirming email I receive show all the proper data and links to the images.
What I would to get is the imagefiles to uploaded to a folder (as is not the case) and the hyperlink or reference to those files in my database.
I am obviously missing something.
Thanks for your help.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
If you want to add original file names you could add more fields or you could change the single stored value to be a link to the stored file with a name of the original file.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The progress bar is possible but is not provided with the generated form and must be added as part of a custom modification. It's not simple and it's even harder to get working across browsers. Let me know if you find a good solution for this.
Echoing the results to the confirmation page is an easy modification to the generated form but again it's a custom modification and the instructions would be unique to your form. Without seeing your form I can not give you any specifics.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I created a form to send images & text data to a web folder. Works fine Images uploaded to .../form99999/files but? metadate (Lmane, Fname, Email, etc) cannot be found.
If I SUBMIT to email, meta data arrives with links to images at .../form99999/files.
I have not tried to submit to mysql, because I am not sure how many fields to create in the table. Example is email shows new name of image file plus original file name. Would love to have table with meta data and the links to images stored in a folder in their original file type.
Help is appreciated.
Without your form, or without more information it is impossible to tell if you created a form that captures the information you are talking about. If you did everything right then the information is captured somewhere but again it is impossible to tell you what is wrong without more information. If you want more help please post your form number so I can get a copy if necessary and be more specific about what is wrong.
After further experimentation, I have created a new form which uploads to MYSQL database.
I created a database on my ISP and then by running install.php it set the proper login to the database in the config.inc.php file.
My form has a mixture of Image upload fields and text fields. When I entered data into the form, a table was created in the database (all fields were created a TEXT fields).
When I did a SUBMIT, Only information from TEXT fields were uploaded to the new TABLE.
The data was place in the correct fields in MySQL, the "File" fields were empty, but the images were uploaded to the ISP folder ....../form99999/files/ folder.
the confirming email I receive show all the proper data and links to the images.
What I would to get is the imagefiles to uploaded to a folder (as is not the case) and the hyperlink or reference to those files in my database.
I am obviously missing something.
Thanks for your help.
I am obviously missing something. Without access to your form, there is nothing I can do for you. Will you provide the form number to me?
I am a bit cautious about giving someone access to my database, so I removed that info from the on line entry, the Form number is: 93101
Like I said, the connection to the database works on the version I uploaded to my site.
CAPTCHA security works fine also.
There are any number of ways you can handle this. For starters this line:
$query = "INSERT into `".$db_table."` (field_1,field_2,field_3,field_4,field_5,field_6,field_7,field_8) VALUES ('" . $_POST['field_1'] . "','" .$_POST['field_2'] . "','" .$_POST['field_3'] . "','" .$_POST['field_4'] . "','" . $_POST['field_5'] . "','" . $_POST['field_6'] . "','" . $_POST['field_7'] . "','" . $_POST['field_8'] . "')";
is attempting to store an image into your SQL which won't work.
Try changing the fist four to
$query = "INSERT into `".$db_table."` (field_1,field_2,field_3,field_4,field_5,field_6,field_7,field_8) VALUES ('" . $field_1_filename . "','" .$field_2_filename . "','" .$field_3_filename . "','" .$field_4_filename . "','" . $_POST['field_5'] . "','" . $_POST['field_6'] . "','" . $_POST['field_7'] . "','" . $_POST['field_8'] . "')";
If you want to add original file names you could add more fields or you could change the single stored value to be a link to the stored file with a name of the original file.
Great! I used your second option and it did place the "new" file names into the mysql table.
I did notice, that phpFormGenerator requested max. file size, but did not put it in the Form.html.
An nice item to add would be the types of files accepted option in those field options.
Hope I'm not asking to much, but is there a way:
1. have an upload progress screen showing % of upload completed.
2. to echo the file upload information into the Confirmaton Page
You have been most helpful and your work is appreciated.
The progress bar is possible but is not provided with the generated form and must be added as part of a custom modification. It's not simple and it's even harder to get working across browsers. Let me know if you find a good solution for this.
Echoing the results to the confirmation page is an easy modification to the generated form but again it's a custom modification and the instructions would be unique to your form. Without seeing your form I can not give you any specifics.