php连接mysql常规实例

<?phpheader('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);// 统一取值编码,数据库编码以实际编码为准,utf8mysqli_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);?>