multi_query()不好使啊?

请看下面代码,想一次执行多条sql,好像不行啊,是哪里错了吗?
谢谢

<?php
//连接mysql
$connect = new mysqli("127.0.0.1","root","123456","mydb");
if($connect){
    echo "connected";
}else{
    echo "connection fail";
}
//创建表
$create_table = "CREATE TABLE mytable(
    id int(6),
    name varchar(24),
    age int(6),
    salary int(8)
)";
if($connect->query($create_table)){
    echo "yes";
}else{
    echo "no";
}

//同时插入多条sql
$insert_date = "INSERT INTO mytable (id,name,age,salary) VALUES (2001,'Tom',26,9500)";
$insert_date .= "INSERT INTO mytable (id,name,age,salary) VALUES (2002,'Jom',26,9500)";
$insert_date .= "INSERT INTO mytable (id,name,age,salary) VALUES (2003,'Dom',26,9500)";
//检测sql执行是否成功
if($connect->multi_query($insert_date)){
    echo "yes";
}else{
    echo "no";
}
?>
阅读 1.8k
撰写回答
你尚未登录,登录后可以
  • 和开发者交流问题的细节
  • 关注并接收问题和回答的更新提醒
  • 参与内容的编辑和改进,让解决方法与时俱进
推荐问题