Level 74
- To submit something to the backend without reloading the page requires Ajax.
- Since you don't say how big that csv is, you can't assume that it only contains a few rows, so you should handle that with a job.
- You can either call a shell script that utilizes the database to import the csv, or you need to open it with php and loop over each row in it and insert them into the database.
Using the command line https://phoenixnap.com/kb/import-csv-file-into-mysql
Using Laravel https://dev.to/shanisingh03/how-to-import-excel-csv-file-into-laravel-4he3