PHP增删改查代码

<?php//init.php$conn = mysqli_connect('127.0.0.1','root','','xz',3306);$sql = "SET NAMES UTF8";mysqli_query($conn,$sql);?>

<?php//插入@$uname = $_REQUEST['uname'];if($uname === null || $uname === ""){die("uname required");}@$upwd = $_REQUEST['upwd'];if($upwd === null || $upwd === ""){die("upwd required");}@$email = $_REQUEST['email'];if($email === null || $email === ""){die("email required");}@$phone = $_REQUEST['phone'];if($phone === null || $phone === ""){die("phone required");}require("init.php");$sql = "INSERT INTO xz_user(uname,upwd,email,phone) VALUES('$uname','$upwd','$email','$phone')";$result = mysqli_query($conn,$sql);if($result === false){echo "操作失败";}else{$uid = mysqli_insert_id($conn);echo $uid;echo "操作成功";}?>

<?php//删除@$uid = $_REQUEST['uid'];if($uid == null || $uid === ""){die("uid required");}require('init.php');$sql = "DELETE FROM xz_user WHERE uid='$uid'";$result = mysqli_query($conn,$sql);if($result === false){echo "操作错误";}else{$count = mysqli_affected_rows($conn);if($count > 0){echo "操作成功";}else{echo "记录不存在";}}?>

<?php//更新@$uid = $_REQUEST['uid'];if($uid === null || $uid === ""){die("uid required");}@$uname = $_REQUEST['uname'];if($uname === null || $uname === ""){die("uname required");}@$upwd = $_REQUEST['upwd'];if($upwd === null || $upwd === ""){die("upwd required");}@$email = $_REQUEST['email'];if($email === null || $email === ""){die("email required");}@$phone = $_REQUEST['phone'];if($phone === null || $email === ""){die("phone required");}require("init.php");$sql = "UPDATE xz_user SET uname='$uname',upwd='$upwd',email='$email',phone='$phone' WHERE uid='$uid'";$result = mysqli_query($conn,$sql);if($result === false){echo "操作失败";}else{$count = mysqli_affected_rows($conn);if($count > 0){echo "影响行数：$count<br/>";echo "操作成功";}else if($count == 0){echo "要更新的记录不存在或者更新前后数据不变或者其他...";}}?>

<?php//查询@$uname = $_REQUEST['uname'];if($uname === null || $uname === ""){die("uname required");}require('init.php');$sql = "SELECT * FROM xz_user WHERE uname='$uname'";$result = mysqli_query($conn,$sql);if($result === false){echo "操作失败";}else{//$arr = mysqli_fetch_all($result,MYSQLI_ASSOC);//$arr = mysqli_fetch_all($result,MYSQLI_BOTH);$count = mysqli_affected_rows($conn);echo $count . "<br/>";if($count > 0){$arr = mysqli_fetch_all($result,1);var_dump($arr);}else{echo "无查询结果";}}?>