Import data to websites is an important functionality, So in this tutorial will show you how to import CSV data to table with PHP.

gistfile1.php

// Database configs
$host="localhost";
$dbuser="";
$dbpass="";
$dbname = "";
 
$link = mysqli_connect($host, $dbuser, $dbpass, $dbname);
 
if (mysqli_connect_errno())
    echo mysqli_connect_error();
 
//First we need to read the CSV file using fopen function like below:
$csv_file = "sample_table.csv";
$csvfile = fopen($csv_file, 'r');

//Now to get row from CSV file we need to use fgetcsv function like below: 

$i = 0;
while (($data = fgetcsv($csvfile, 1024, ",")) !== FALSE) {
    if($i==0) { $i++; continue; }  // to exclude first row in the csv file.
 
    $id = $data[0];         // first field
    $title = $data[1];      // second field
    $description = $data[2];    // third field
 
    $query = "INSERT INTO sample_table SET id = '".$id."', title = '".$title."', description = '".$description."' ";
 
    mysqli_query($link, $query);
}
fclose($csvfile);
 
echo "csv data imported successfully!";