How to insert EXCEL data sheet into MYSQL database using PHP(xls,xlsx,csv)
We gonna insert EXCEL data Sheet (xls,xlsx,csv) into a MYSQL database using PHP   Exemple:  a) First :   We gonna use two columns : 1) name 2) email  in our excel sheet:      b) Second:   We gonna create three columns(excel_id , excel_name , excel_email) in our MYSQL database :  Why  excel_id?  : because we need a unique key to identifer every fields in the table    c) Thrid:   This is the PHP script  that will allow us to take the data from the EXCEL sheet, means: name and email column and put it into the  MYSQL database.  COPY AND PASTE  this code into your console(NOTEPAD ++)      URGENT: replace root  with your user, replace test  with your database's name, put your password between  root and test if you have one.      <?php  $connect = mysqli_connect("localhost", "root", "", "test");  $output = '';  if(isset($_POST["import"]))  {   $extension = end(explode(".", $_FILES["excel"]["name"]))...