dsdsm2016 2013-07-19 13:57
浏览 27
已采纳

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

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..

  • 写回答

4条回答 默认 最新

  • douweidao3882 2013-07-19 14:03
    关注

    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.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(3条)

报告相同问题?