php链接数据库实行增删查改_PHP操作数据库增删查改

周末有空弄了下数据库操作，实现了增删查改的基本操作，记录一下。

一、增

$servername = "100.0.0.0";

$username = "zjwdb_xxxx";

$password = "xxxxx";

$dbname = "zjwdb_xxxxx";

$name = $_GET['name'];

$age = $_GET['age'];

$type = $_GET['type'];

if ($name == "") {

die('{"code":101,"msg":"请输入name"}');

}

if ($age == "") {

die('{"code":102,"msg":"请输入age"}');

}

if ($type == "") {

die('{"code":103,"msg":"请输入type"}');

}

// 创建连接

$conn = mysqli_connect($servername, $username, $password, $dbname);

mysqli_query($conn, "set names 'UTF8'");