abstract://php连接mysql$servername = "127.0.0.1";$username = "root";$password = "root";$dbname = "bick"; // 创建连接$conn = new mysqli($servername, $username, $password,
//php连接mysql
$servername = "127.0.0.1";
$username = "root";
$password = "root";
$dbname = "bick";
// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);
// 检测连接
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;
}
Correcting teacher:天蓬老师Correction time:2019-04-04 17:42:52
Teacher's summary:你的代码写得很清奇呢, pdo用在文件操作, 还不多见