Error uploading CSV file to mysql using PHP

I am getting error while uploading csv file to mysql. Please advise how I can resolve this.

index page

<?php /** * @author * @copyright 2021 */ $conn = mysqli_connect("localhost","test","","testdb"); if(isset($_POST["import"])) { $filename=$_FILES["file"]["tmp_name"]; if($_FILES["file"]["size"]>0) { $file = fopen($filename,"r"); while (($getData = fgetcsv($file,100000,",")) !==FALSE) { $sql = "INSERT INTO employee (ID,E_Name,E_Last,E_Email) VALUES ('".$getData[0]."', '".$getData[1]."', '".$getData[2]."')"; $result = mysqli_query($conn,$sql); if(!empty($result)) { echo "CSV data Imported"; } else { echo "file not uploded"; } } } } ?>
    <form class="form-horizantal" action="" method="post" name="indexphp" enctype="multipart/form-data" >
        <div>
            <label> Csv File </label>
            <input type="file" name="file" accept=".csv">
            <button type="submit" name="import">Import</button>
        </div>
    </form>

DB
– phpMyAdmin SQL Dump
– version 5.0.3
https://www.phpmyadmin.net/

– Host: 127.0.0.1
– Generation Time: Jan 15, 2021 at 09:14 AM
– Server version: 10.4.14-MariaDB
– PHP Version: 7.2.34

SET SQL_MODE = “NO_AUTO_VALUE_ON_ZERO”;
START TRANSACTION;
SET time_zone = “+00:00”;

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /;
/
!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /;
/
!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /;
/
!40101 SET NAMES utf8mb4 */;


– Database: testdb



– Table structure for table employee

CREATE TABLE employee (
ID int(11) NOT NULL,
E_Name varchar(255) NOT NULL,
E_Last varchar(255) NOT NULL,
E_Email varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;


– Indexes for dumped tables


– Indexes for table employee

ALTER TABLE employee
ADD PRIMARY KEY (ID);


– AUTO_INCREMENT for dumped tables


– AUTO_INCREMENT for table employee

ALTER TABLE employee
MODIFY ID int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT /;
/
!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS /;
/
!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;