Submit multiple rows to MySQL...

User 2755115 Photo


Guest
1 post

Good morning,

I'm trying to determine if there is a way to submit multiple rows of data from 1 form. Here's an example:

A form has FirstName, LastName, and FavColor1, FavColor2, FavColor 3 - is there a way to capture this data in one form via 5 input text fields but write 3 separate lines to MySQL, example:

FirstName, LastName, FavColor1
FirstName, LastName, FavColor2
FirstName, LastName, FavColor3

Thanks for your help,

Regards,
Aidan
User 187934 Photo


Senior Advisor
20,271 posts

Yes, you setup up your mysql insert inside a loop.:cool:
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com

Have something to add? We’d love to hear it!
You must have an account to participate. Please Sign In Here, then join the conversation.