Generally we’d wish to migrate our csv file/xlsx-file(s) into our database so as to work with them accordingly, php makes that potential.
On the subject of this, I’ve written a easy script to make that simpler base on a request from a superb pal of mine and I believed it sensible to share it with the world.
1. Firstly unzip the project file and paste it in your htdocs should you’re utilizing xampp or www folder in case you are utilizing wamp or your server folder if any.
2. Find a readMe textual content file
3. Copy the sql code within the readMe textual content file and run it in your mysql work bench or phpmyadmin.
4. Open your net browser and run the index.php file
5. Voila!!, you’ve got efficiently imported a csv file.
