サマリー：//php連接mysql$servername = "127.0.0.1";$username = "root";$password = "root";$dbname = "bick"; // 創(chuàng)建連接$conn = new mysqli($servername, $username, $password,

//php連接mysql

$servername = "127.0.0.1";

$username = "root";

$password = "root";

$dbname = "bick";

// 創(chuàng)建連接

$conn = new mysqli($servername, $username, $password, $dbname);

// 檢測(cè)連接

if ($conn->connect_error) {

    die("連接失敗: " . $conn->connect_error);

} 

$file = fopen("ce.txt", "r") or die("Unable to open file!");

$i=0;

$value =array();

while(!feof($file))

  {

  $arr = fgets($file);

   $value = explode(",",$arr);

   $str = implode("','", $value);

   $sql="INSERT INTO bk_admin (code,nian,yue,js,shu2) VALUES '$str'";

  if ($conn->query($sql) === TRUE) {

    echo "新記錄插入成功"."<br>";

     } else {

    echo "Error: " . $sql . "<br>" . $conn->error;

   }

   $i=$i+1;

  }

添削の先生：天蓬老師添削時(shí)間：2019-04-04 17:42:52
先生のまとめ：你的代碼寫得很清奇呢, pdo用在文件操作, 還不多見