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.