Json_encode () function usage.
echo json_encode (Array (' a ' = ' = ' bbbb ', ' c ' = ' ddddd ');
This will generate a standard JSON-formatted data
Code to copy code as follows
<?php
SQL statements that need to be executed
Single
$sql = "Select Id,name from Tbl_user where id=1";
More than one piece of data
$sql = "Select Id,name from Tbl_user";
Invoking the conn.php file for database operations
Require (' conn.php ');
Prompt Operation success Information, note: $result exists in the conn.php file, is called out
if ($result)
{
$array =mysql_fetch_array ($result, MYSQL_ASSOC);
/* Data Set
$users =array ();
$i = 0;
while ($row =mysql_fetch_array ($result, Mysql_assoc)) {
echo $row [' id ']. ' -----------'. $row [' name ']. ' </br> ';
$users [$i]= $row;
$i + +;
}
echo json_encode (Array (' dataList ' = $users));
*/
/* Single Data */
$row =mysql_fetch_row ($result, MYSQL_ASSOC);
echo json_encode (Array (' jsonobj ' = $row));
}
Mysql_free_result ($result);
Release results
Mysql_close ();
Close connection
?>
This is the database that generated the JSON data.
Single data: {"Jsonobj": {"id": "1", "name": "LMW"}}
Multiple data: {"DataList": [{"id": "1", "name": "LMW"},{"id": "2", "Name": "XXJ"},{"id": "3", "Name": "Xxxj"}]}
Now in many cases, we need the program to return a JSON-formatted result, such as:
Code to copy code as follows
{
"Userkeygetresponse":
{"Requestname": "e99e6d63e8c712d7699f52978a", "Api_key_value": "41954dd9b1cb6a95802eab6810"},
"Error_response":
{"Code": "No_error (www.111cn.net)", "MSG": "Get System parameters succeeded"}
}
You can write the result in an array form like this:
$respon = Array (' userkeygetresponse ' = = Array (' requestname ' = = $api _request_name, ' api_key_value ' = = $api _key_ Value),
' Error_response ' = = Array (' Code ' = ' no_error ', ' msg ' = ' = ' Get system parameters succeeded '));
Code
Code to copy code as follows
Function arrayrecursive (& $array, $function, $apply _to_keys_also = False)
{
static $recursive _counter = 0;
if (+ + $recursive _counter > 1000) {
Die (' Possible deep recursion attack ');
}
foreach ($array as $key = = $value) {
if (Is_array ($value)) {
Arrayrecursive ($array [$key], $function, $apply _to_keys_also);
} else {
$array [$key] = $function ($value);
}
if ($apply _to_keys_also && is_string ($key)) {
$new _key = $function ($key);
if ($new _key! = $key) {
$array [$new _key] = $array [$key];
Unset ($array [$key]);
}
}
}
$recursive _counter--;
}
G:
$error _respon = Array (' Code ' = ' Error_msg_miss ', ' msg ' = ' message not present ');
echo JSON ($array);
The result is:
{"Code": "Error_msg_miss", "MSG": "Message does not exist"}
The client can parse the result, and of course the error code should be replaced with a number.
So much the more we show the direct is the Chinese, of course, the 16 binary encoding is not a problem oh.
From:http://www.111cn.net/phper/php/62544.htm
PHP returns JSON data function example