How to upload form data to an SQL database in separate fields
-
My website is installed on phpMyAdmin, when I submit a form on my site, all of the fields are submitted into the huge_it_contact_submission table under the submission field. However, each part of the form is submitted to this one field and separated with a *()* delimiter, e.g. Martin Gray*()*[email protected]*()*Programming*()*15/02/2017*()*
Is there a way that I could manipulate the data to be entered into the database into a custom made table using SQL statements on my site? I would like a table named ‘CV Upload’ with fields such as “Name”, “Email”, and for each piece of data on the form to be uploaded to their respective fields.
Thank you.
- The topic ‘How to upload form data to an SQL database in separate fields’ is closed to new replies.