Szenario: Imagine your friend - the owner of a small book shop - asks you for a simple representation of his latest sales. He provides you a simple plain json export file.
What you need to do?:
- Design a database scheme for optimized storage
- Please note that over time, large amounts of data will accumulate
- Read the json data and save it to the database using php
- Create a simple page with filters for customer, product and price
- Output the filtered results in a table below the filters
- Add a last row for the total price of all filtered entries
1. Run your apache server e.g. wamp or xamp.
2. Type the url e.g. http://localhost/testphp/index.phpNote: Please also check the attached video.