ENTRY BOX TO INSERT DATA INTO A DB TABLE - PHP MYSQL

Job ID: 37812085

Budget: $30 – $250 USD

Example suppose i have a list of names
Joe
Peter
Tim
Anne
Loretta

i want to paste them into a text box in the same way above in a vertical fashion 1 per line then press submit

after pressing submit these will be entered into a DB (table) called clients

the table structure will have 2 columns table name is clients

client_id client_name


after pressing submit on the example above i wil then check to see the data has been inserted correctly and it should look as follows

client_id client_name
1 Joe
2 Peter
3 Tim
4 Anne
5 Loretta

then suppose i run it again and i want to add

Penelope
Victor

then after submitting my table should look like

client_id client_name
1 Joe
2 Peter
3 Tim
4 Anne
5 Loretta
6 Penelope
7 Victor

- so its creating the id on the fly using auto increment
- we only enter names in the text box
- we did 5 on first submission then 2.
- Name Repeats (client_name) are possible/allowed so dont worry for this unless i say it must be unique.