<?php
$host = '192.168.0.210:3312';
$database = 'sharebed';
$username = 'root';
$password = '123123';
$connection = mysqli_connect($host, $username, $password,$database);//连接到数据库
if(!$connection) {
echo"database error";
}else{
echo"php env successful";
}
$begin = time();
//添加记录
$sqls ='';
for($i=1;$i<=1000;$i++){
$sqls .= "('title','dsfd','18','test'),";
if($i%100=='0'){
$sql = 'INSERT INTO `test001` (`title`,`tags`,`age`,`help`) value'.rtrim($sqls, ",");
mysqli_query($connection,$sql);
$sqls ='';
unset($sql);
}
}
mysqli_close($connection);//关闭连接
$end = time();
echo "用时 ".($end-$begin)." 秒 <hr/>";