有人能帮我吗。这是代码:
public function csv_file()
{
$file = $_FILES['importeren']['tmp_name'];
$handle = fopen($file,"r");
$filecsv = fgetcsv($handle,1000, ";");
foreach($filecsv as $csv)
{
$password = rand(100000,999999);
//echo $password . '</br>' ;
$username = $csv;
$studentnummer = $csv;
$klas = $csv;
/* $voornaam = $csv[3];
$tv = $csv[4];
$achternaam = $csv[5];*/
$query = "INSERT INTO user (fk_klas_ID,admin_ID,username,password,studentnummer) "
. "VALUES ('$klas','0','$username', sha1('$password'),$studentnummer');";
$result = $this->db->query($query);
return $filecsv;
}
}
我得到了这个错误:
Error Number: 1064
You have an error in your SQL syntax;
check the manual that corresponds to your MySQL
server version for the right syntax to use near '')' at line 1
INSERT INTO user (fk_klas_ID,admin_ID,username,password,studentnummer)
VALUES ('Richard','0','Richard', sha1('710565'),Richard');
Filename: C:'xampp'htdocs'codeigniter'system'database'DB_driver.php
Line Number: 330
我希望你可以提供一个csv文件,这样内容就可以进入数据库。我正在使用代码点火器
为我糟糕的英语感到抱歉
您在$studentnummer
中遗漏了一个引号。所以像这个一样更改查询
$query = "INSERT INTO user (fk_klas_ID,admin_ID,username,password,studentnummer) "
. "VALUES ('$klas','0','$username', sha1('$password'),'$studentnummer');";