how to insert .txt file data into database using php?

September 28, 2022

I have been inserting .txt file data in my sql-server database using php which is working too but I am getting undefined array error please help me in resolving the same

.txt data

ankit,ankit@gmail.com

swapnil, swapnil@gmail.com

shefali, shefali@gmail.com

abhishek, abhishek@gmail.com

my php code for implementing the same

<?php

include 'connection.php';


$open = fopen('employee.txt','r');

while (!feof($open)) 
{
    $getTextLine = fgets($open);
    $explodeLine = explode(",",$getTextLine);
    
    list($name,$email) = $explodeLine;
    
    $qry = "insert into employees (name,email) values('".$name."','".$email."')";

 $run =     sqlsrv_query($conn,$qry);
}

fclose($open);

?>

// sql table query

CREATE TABLE employees(name VARCHAR(255) ,email VARCHAR(255) );

// Error which i am getting

Warning: Undefined array key 1 in
C:\xampp\htdocs\Mainfileupload\filetesting.php on line 18

Warning: Undefined array key 1 in
C:\xampp\htdocs\Mainfileupload\filetesting.php on line 18

Warning: Undefined array key 1 in
C:\xampp\htdocs\Mainfileupload\filetesting.php on line 18

>Solution :

Better check the line to be "non-blank" before executing query. (e.g. check whether $getTextLine is an empty string first)

So change your while block to

while (!feof($open)) 
{
    $getTextLine = fgets($open);
 
    if (trim($getTextLine)!="") {
      $explodeLine = explode(",",$getTextLine);
      list($name,$email) = $explodeLine;    
      $qry = "insert into employees (name,email) values('".$name."','".$email."')";
      $run = sqlsrv_query($conn,$qry);
     }
}