Using PHP and MySQL, I have written an inventory program for work. It works well, but now they want me to add an "import" function. Rather than than ftping an Excel file to the server, I thought it would be easier -- and the less user work -- to create an Excel-like form to enter the new parts' information into a webpage form, grab the data, and then send it to the database.
I want the form to keep adding new rows until the user hits either the CANCEL or SUBMIT button, but I'm not sure how to do this. Probably a do-while loop, but I can't get the specifics worked out.
Can anyone help me get started?
Hard to tell exactly what you need based off just the text, can you post example code of the form? (ie what is it written in)
You could just do this with a simple form and PHP where the form makes a request and PHP session keeps track of each submission where each added row appears on the next page. Then, there will be a separate form submit button that sends the final results to be processed as such. Once that is done, use AJAX to make it dynamic so the user can stay on the same page.