insert csv data to the mysql databaseLearning Curve- Perfect Tutorial for the beginers | Learning Curve- Perfect Tutorial for the beginers

Reading csv file into mysql database

use the below file

$csv_file = "mydata.csv";
$csvfile = fopen($csv_file, 'r');
$theData = fgets($csvfile);
$i = 0;
while (!feof($csvfile))
{
  $csv_data[] = fgets($csvfile, 1024);
  $csv_array = explode("\t", $csv_data[$i]); // datas are separated by tab if it is comma then use , instead of \t
  $insert_csv = array();
 
   $name=$csv_array[0];
   $age=$csv_array[1];
  $insertqry="insert into tbl_words(name,age) values('$name','$age')";
$insertresult=mysql_query($insertqry,$linkfirst); //$link first is the connection string created for mysql database
 
  $i++;
}
fclose($csvfile);

$csv_file = "mydata.csv";

$csvfile = fopen($csv_file, 'r');

$theData = fgets($csvfile);

$i = 0;

while (!feof($csvfile))

{

$csv_data[] = fgets($csvfile, 1024);

$csv_array = explode("\t", $csv_data[$i]); // datas are separated by tab if it is comma then use , instead of \t

$insert_csv = array();

$name=$csv_array[0];

$age=$csv_array[1];

$insertqry="insert into tbl_words(name,age) values('$name','$age')";

$insertresult=mysql_query($insertqry,$linkfirst); //$link first is the connection string created for mysql database

$i++;

}

fclose($csvfile);