请看下面代码,想一次执行多条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";
}
?>