从Txt文件中检索数据并将其保存在数据库中

Question

I have A data in txt file I want to save it in database

mytxtfile

xxxxxxxxx
xxxxxxxxx
xxxxxxxxx

I want to Save each line in database...

I want to make a PHP file which take 1st line from txt file and save it in db. Then again second line and so on....

myphpcode

$myFile = "data.txt";
$fh = fopen($myFile, 'r');
$theData = fgets($fh);

$con=mysqli_connect("example.com","peter","abc123","my_db");
// Check connection
if (mysqli_connect_errno())
 {
 echo "Failed to connect to MySQL: " . mysqli_connect_error();
 }

mysqli_query($con,"INSERT INTO Persons (ID)
VALUES (''.$theData.'')");

mysqli_close($con);

?>

This Code Is Just Saving 1st line..

Answer 1

You should try something like:

while (!feof($fh)) {
   $line = fgets($fh);
   mysqli_query($con,"INSERT INTO Persons (ID)
        VALUES ('".$line."')");
}

The loop goes through each line of the file and then inserts it into the database.

It is not the most efficient way, especially if you have a very large number of lines, but it does the trick. If you do have very many lines, than you should try and do everything in a single INSERT.