<?php
header('Content-Type:text/html;charset=UTF-8');
$server = "localhost";
$admin = "root";
$passwd = "";
$database = "books";
$sqlstr = "select * from bookinfo";
$invalue = "insert into bookinfo (bname,bnum) values('马克思','34258')";
$delvalue = "delete from bookinfo where bname='马克思'";
$upvalue = "update bookinfo set bname='英语' where bid=3";
// 连接数据库
$conn = mysqli_connect($server, $admin, $passwd, $database);
// 统一取值编码,数据库编码以实际编码为准,utf8
mysqli_query($conn, "set names utf8");
$result = mysqli_query($conn, $sqlstr);
mysqli_data_seek($result, 0);
// 插入数据
// mysqli_query($conn, $invalue);
// 删除数据
// mysqli_query($conn, $delvalue) or die('删除错误' . mysqli_errno($conn));
// 修改数据
mysqli_query($conn, $upvalue);
// 循环取出记录
while (! ! $row = mysqli_fetch_array($result)) {
echo $row['bid'] . '----' . $row['bname'] . '-----' . $row['bnum'] . '<br>';
}
// 释放结果集
mysqli_free_result($result);
// 关闭数据库
mysqli_close($conn);
?>