php mysql 后台 操作

	  $infoName=$_GET['infoName'];
	  echo "infoName:".$infoName;
	  $infoCode=$_GET['infoCode'];
	  echo "infoCode:".$infoCode;
	  $infoPhone=$_GET['infoPhone'];
	  echo "infoPhone:".$infoPhone;
	  $infoManagIndex=$_GET['infoManagIndex'];
	  echo "infoManagIndex:".$infoManagIndex;
	  $infoContent=$_GET['infoContent'];
	  echo "infoContent:".$infoContent;
	  $infoPassword=$_GET['infoPassword'];
	  echo "infoPassword:".$infoPassword;
	  $infoNewPassword=$_GET['infoNewPassword'];
	  echo "infoNewPassword:".$infoNewPassword;
	  //连接数据库
	  $servername = "localhost";
	  $username = "root";
	  $password = "123456";
		$conn = mysqli_connect($servername, $username, $password);
		//选择数据库
		$dbname = "guoruijun0603";
		mysqli_select_db($conn, $dbname);
		$sql = "INSERT INTO fa_regist_user (info_name, info_code,info_phone,info_managIndex,info_content,info_password) VALUES ('$infoName','$infoCode','$infoPhone','$infoManagIndex','$infoContent','$infoPassword')";
		//执行查询语句
		//$result = mysqli_query($conn, $sql);
		//将查询结果转换为PHP数组
		//$data = mysqli_fetch_all($result, MYSQLI_ASSOC);
		$retval = mysqli_query( $conn, $sql );
		if(!$retval )
		{
		  die('无法插入数据: ' . mysqli_error($conn));
		}
		echo "数据插入成功\n";
		//关闭数据库连接
		mysqli_close($conn);
    //$json = json_encode($data);
    header("Content-Type: application/json Access-Control-Allow-Origin:* ");
    //Access-Control-Allow-Methods 
    // POST,GET,OPTIONS, PUT, DELETE Access-Control-Allow-Headers Accept, Content-Type, Content-Length, Accept-Encoding, X-CSRF-Token, Authorization");
    //echo $json;
?>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42