从txt文件中提取数据并插入到数据库中 - Pull data from a txt file and Insert into a database

Pull data from a txt file and Insert into a database

我想从名为domains.txt的txt文件中提取数据，并将该文件的内容插入到数据库中。下面是我写的代码，但不工作。请帮帮我

<?php
$conn = mysql_connect("localhost","root","");
if (!$conn) {
    die("Could not connect: " . mysql_error());
}
mysql_select_db("modify_domains");
$file = fopen("domains.txt", "r");
    // Read line by line until end of file
    while (!feof($file)) { 
    // Make an array using comma as delimiter
       $array = explode(",",fgets($file)); 
        $domain_name=$array[0];
        $reg_email=$array[1];
        $tech_email=$array[2];
        $billing_email=$array[3];
        $admin_email=$array[4];
        $password=$array[5];
    $sql = "INSERT INTO tbl_domains (domain_name, reg_email, tech_email,billing_email,admin_email,password) VALUES('".$adomain_name"','".$reg_email."',".$tech_email.",".$billing_email.",".$admin_email.",".$password.")";   
    mysql_query($sql,$conn)  or die("Could not connect: " . mysql_error());
    // use mysql insert query here
}
?>

所有文本字段必须用单引号分隔(如' ' .$reg_email."')，并且不要忘记将文本字段和变量分开。

查询应该是这样的:

$sql = "INSERT INTO tbl_domains 
(domain_name, reg_email, tech_email,billing_email,admin_email,password) VALUES
('".$adomain_name."','".$reg_email."','".$tech_email."','".$billing_email."','".$admin_email."','".$password."')";

所有文本字段必须用单引号分隔。你也可以这样写:

 $sql = "INSERT INTO tbl_domains 
    (domain_name, reg_email, tech_email,billing_email,admin_email,password) VALUES
    ('$adomain_name','$reg_email','$tech_email','$billing_email','$admin_email','$password')";