<?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$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 additions and deletions to change the change jsonupdate