ENTRY BOX TO INSERT DATA INTO A DB TABLE - PHP MYSQL
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.
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.