<?PHP//header ("content-type:text/html; Charset=utf8 ");//header (" Content-type:text/html;charset=utf-8 "); $end=Array();$id=$_post[' ID '];$name=$_post[' Name '];$age=$_post[' Age '];$sex=$_post[' Sex '];$end[' Name ']=$name;$mysql _server_name= ' 127.0.0.1 ';//change to your MySQL database server$mysql _username= "Root";//change to your MySQL database user name$mysql _password= "QMTG";//change to your MySQL database password$mysql _database= "Testmydatabase";//change to your MySQL database name$conn=NewMysqli ($mysql _server_name,$mysql _username,$mysql _password);//connecting to a databaseif($conn==false){ #echo "Data connection failed! "; $end[' State ']= '-1 '; $end[' msg ']= ' failed to connect to the database! ‘; EchoJson_encode ($end, Json_unescaped_unicode);//JSON encoding return;}Else{ #echo "Data connection Successful! ";} //, ' age ' = $age, ' sex ' = $sex$conn->query ("Set names ' UTF8 '");//the database output encoding should be consistent with your database encoding. Nanchang Website Construction company hundred Constant network PHP engineer proposed to use UTF-8 International standard Code.$conn-SELECT_DB ($mysql _database);//Open Database//$sql = "Update testtale set name= ' $name ', age= ' $age ', sex= ' $sex ' where id = ' $id '"; SQL statements$sql= "INSERT into Testtale (name,age,sex) VALUES ('$name‘,‘$age‘,‘$sex‘) "; ;$result=$conn->query ($sql);//Query Successful if($result) { $end[' Test ']= ' sucess '; } Else { $end[' Test ']= ' fail '; } $end[' State ']= ' 1 ';//Echo Json_encode ($arr, Json_unescaped_unicode);//json encodingEchoJson_encode ($end, Json_unescaped_unicode);//JSON encoding$conn-Close (); /*while ($rows = $result->fetch_array ()) {//can be directly assigned to an array or by the form of a field name)//$array [] = $rows;//$array [$rows [' ID ']] = $rows;} Print_r ($array);//finally through Json_encode () Transform array echo json_encode ($array);*/?>
PHP MYSQL Add and delete Jsonadd