PHP & MySql functions needed (basic - medium)
Budget: $30 – $250 USD
Hello,
I'm in need of some PHP & MySQL, pretty basic function.
In the attached file, everything is detailed, including table structure, and down below a short description.
I need the functions to be working, tested, not just lines of code.
1. A basic form, with a textarea, and 2 static dropdowns
2. In the text area 30 product codes will be entered. (Line by line, so separated by 'enter'). And on form submit:
3. Search in a table, each entry from the textarea, where a variable from one of the dropdowns matches the value of a column. Then duplicate each row found, while updating one of the columns with the 2nd variable from the other dropdown
4. Get the number of affected(duplicated) rows for each entry
5. With the obtained results, and the same 2 variables from the dropdowns, search in another table for each entry(the same ones from the initial textarea), and update a column (based on the affected rows)
6. Based on the new value of the affected column, do some math, and update other columns with the stored variables from the dropdowns.
6. say in replay "yolo" so i know you've read the description
7. Show the results in a basic html table
thank you
I'm in need of some PHP & MySQL, pretty basic function.
In the attached file, everything is detailed, including table structure, and down below a short description.
I need the functions to be working, tested, not just lines of code.
1. A basic form, with a textarea, and 2 static dropdowns
2. In the text area 30 product codes will be entered. (Line by line, so separated by 'enter'). And on form submit:
3. Search in a table, each entry from the textarea, where a variable from one of the dropdowns matches the value of a column. Then duplicate each row found, while updating one of the columns with the 2nd variable from the other dropdown
4. Get the number of affected(duplicated) rows for each entry
5. With the obtained results, and the same 2 variables from the dropdowns, search in another table for each entry(the same ones from the initial textarea), and update a column (based on the affected rows)
6. Based on the new value of the affected column, do some math, and update other columns with the stored variables from the dropdowns.
6. say in replay "yolo" so i know you've read the description
7. Show the results in a basic html table
thank you