21,886
社区成员
发帖
与我相关
我的任务
分享
$mysqli=mysqli_connect($baselocal,$basetab,$basepass,$basetab);
if (mysqli_connect_errno($mysqli))
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
foreach ($id as $key => $value){
$val="VALUES ('".$myid1[$key]."','".$myid2[$key]."','".$mytext[$key]."')";
$vals=$vals.$val;
}//foreach
$sql="insert into tab (myid1,myid2,mytext) ".$vals." ON DUPLICATE KEY UPDATE myid2=VALUES(myid2), mytext=VALUES(mytext);";
mysqli_query($mysqli,$sql);
echo "New record has id: " . mysqli_insert_id($mysqli);
mysqli_close($mysqli);
$mysqli = new mysqli($baselocal,$basetab,$basepass,$basetab); // 连接MySQL数据库
if (mysqli_connect_errno())
{
// 检查连接错误
printf("连接失败: %s<br>", mysqli_connect_error());
exit();
}
$query = "SELECT `myid1`, `myid2`, `mytext` FROM `tab` limit 1,4"; // 声明SELECT语句
if ($stmt = $mysqli->prepare($query))
{
// 处理打算执行的SQL命令
$stmt->execute();
// 执行SQL语句
$stmt->store_result();
// 取回全部查询结果
echo "记录个数:".$stmt->num_rows."行<br />";
// 输出查询的记录个数
$stmt->bind_result($myid1, $myid2, $mytext);
// 当查询结果绑定到变量中
while ($stmt->fetch())
{
// 逐条从MySQL服务取数据
printf ("%s (%s,%s)<br />", $myid1, $myid2, $mytext); //格式化结果输出
}
$stmt->close();
//释放mysqli_stmt对象占用的资源
}
$mysqli->close();
//关闭与MySQL数据库的连接