使用HTML和Php将CSV文件导入数据库[重复]

Question

This question already has an answer here:

• Can I mix MySQL APIs in PHP? 4 answers

i try this code to import a CSV file into my database but i got this error : Warning: mysqli::query(): Empty query

$db = new mysqli('localhost','root','', 'BD_Conference');


    $sql=mysql_query("INSERT INTO tbl_conference (pid, name,  chairs,keynote, abstract, speaker, affiliation, ville, pays, salle, date, time, session, image_url) VALUES ('','$champs1','$champs2','$champs3','$champs4','$champs5','$champs6','$champs7','$champs8','$champs9','$champs10','$champs11','$champs12','$champs13')");

    $result = $db-> query($sql) ;

</div>

Answer 1

please use mysqli_query instead of mysql_query. So the connection is opened using mysqli.

$db = new mysqli('localhost','root','', 'BD_Conference');
if ($db->connect_errno) {
        echo "Errno: " . $mysqli->connect_errno . "
";
}
$sql="INSERT INTO tbl_conference (pid, name,  chairs,keynote, abstract, speaker, affiliation, ville, pays, salle, date, time, session, image_url) VALUES ('','$champs1','$champs2','$champs3','$champs4','$champs5','$champs6','$champs7','$champs8','$champs9','$champs10','$champs11','$champs12','$champs13')";

$result = $db->query($sql) ;