为了便于观察,我这里直接使用get传值
代码如下:
<?php
//设置编码格式
header("Content-type:text/html;charset=utf-8");
$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "test";
// 创建连接
$con =mysqli_connect($servername, $username, $password, $dbname);
$sql="INSERT INTO `user`(`id`, `name`, `age`, `sex`) VALUES (" . $_GET['id'] . "," . $_GET['name'] . "," . $_GET['age'] . "," . $_GET['sex'] . ")";
$result = mysqli_query($con,$sql);
if($result) echo "添加成功!";
else echo "添加失败!";
mysqli_close($con);
?>