Avatar of hydrazi
hydrazi
 asked on

PHP Data Import, Step through Pages

I am still new to PHP coding but I have a customer who has a php import system that process a CSV file.  They are orders from their website.  People need to look at the batch of orders from the CSV file and correct any weird issues.  

Currently, each record fills a form.  If there are 10 records, it prints 10 forms on the same page and is created using Do-While to create the forms until there are no more rows.  Once the form data looks good, they hit a submit button and the data is inserted into a MySQL DB.

I have created most of this system, and now they want to change it.

They want each order to create its own form on a single page, to be inserted one at a time, then a PDF made of each individual order data and printed then return to do it all again for each order in that CSV.

I am lost in how to start this.  Any pointers to tutorials on a similar thing or just a general direction.... I don't even know the right words to use to do a google search.  Thanks for any help you can provide!
PHP

Avatar of undefined
Last Comment
hydrazi

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
maeltar

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
hydrazi

ASKER
Awesome, that's definitely going to work for that part!  Thank you!  
My biggest gap of knowledge is creating a way to have a single record on a page, then submit it, print it and then return to the next record in the CSV!  Is this called a session?
SOLUTION
maeltar

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
hydrazi

ASKER
I think pagination just makes it so the page isn't too long, right?
I am looking to do this for each record in a CSV file:

1.  Display single record in a form and make changes.
2.  Hit submit button to insert into database
3.  Go directly to a PDF file made with that single record.  Print it.
4.  Hit button to go back and display next record in CSV file.  Steps 1-3 until there are no more orders in CSV file.
maeltar

Pagination is more commonly used when there are too many records for one page yes,
 but you can paginate for each record without any problems...

Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
hydrazi

ASKER
oooooo..... Ajax.... I have not Ajax before.  I must research this new Kung Fu.
hydrazi

ASKER
This might be too big of a question.  I guess I am looking for how I would go about getting the CSV to stay a part of the session until it is all processed.