php向mysql插入数据

为了便于观察，我这里直接使用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);
?>