PHP MYSQL Delete and change the list jsonlist

<?PHP//header ("content-type:text/html; Charset=utf8 ");//header (" Content-type:text/html;charset=utf-8 "); /*$d = $_post[' Test '];if ($d = = ' Testgaga ') echo ' success_1! '; else echo ' fail_1 ';*/$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! ";}Else{    #echo "Data connection Successful! ";} $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= "SELECT * from Testtale";//SQL statements$result=$conn->query ($sql);//Query Success//test success One$end=Array();$end[' State ']= ' 1 ';$arr=Array(); //output per row of data while($row=$result-Fetch_assoc ()) {      $count=Count($row);//cannot be in a looping statement because the length of the row array is reduced each time you delete     for($i= 0;$i<$count;$i++)    {          unset($row[$i]);//Delete Redundant data    }      Array_push($arr,$row); $end[' List ']=$arr;} //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 Delete and change the list jsonlist