functioncreate($name,$age,$email){$conn=mysqli_connect("localhost","username","password","myDB");$sql="INSERT INTO users (name, age, email) VALUES ('$name', '$age', '$email')";mysqli_query($conn,$sql);mysqli_close($conn);}
读取(Read):从数据库中读取数据
functionread($id){$conn=mysqli_connect("localhost","username","password","myDB");$sql="SELECT * FROM users WHERE id=$id";$result=mysqli_query($conn,$sql);$row=mysqli_fetch_assoc($result);mysqli_close($conn);return$row;}
更新(Update):更新数据库中的数据
functionupdate($id,$name,$age,$email){$conn=mysqli_connect("localhost","username","password","myDB");$sql="UPDATE users SET name='$name', age='$age', email='$email' WHERE id=$id";mysqli_query($conn,$sql);mysqli_close($conn);}
删除(delete):从数据库中删除数据
functiondelete($id){$conn=mysqli_connect("localhost","username","password","myDB");$sql="DELETE FROM users WHERE id=$id";mysqli_query($conn,$sql);mysqli_close($conn);