So I’ve been asked by a friend if I could help her with a php/sql database for a sim game site that she has. What she asked me is to set up what she refers to as a ‘show results database’. This database will include all information about ‘shows’ ran in the game. She wants the show results database to be displayed on individual competitor pages. I am able to do this. I’ve got this all written and completed.
However, what she also wants included is a php form that inserts into the database. Simple enough. Except, instead of doing it individually for each show (which contains ‘classes’ therefore entering each class seperately with the results, she wants a text area where she can copy and paste the results and be done.
My question is how would I go about creating a textarea form that will submit each line of data in that text area to a seperate row and correspond with the columns?
The columns go as follows:
show_id | show_name | class_name | competitor | place
So I would need data entered into a text area in this format:
Show 1
Class Name 1
1st Competitor A
2nd Competitor B
3rd Competitor C
4th Competitor D
To correctly enter into the row above and the table would than appear as such
show_id | show_name | class_name | competitor | place
1 | show 1 | class name 1 | competitor a | 1st
Any help on how I would go about doing this would be greatly appreciated!