PHP Execution database query returns JSON format Data _php tutorial

SQL statements to be executed//single $sql= "Select Id,name from Tbl_user where id=1";//Multiple data//$sql = "Select Id,name from Tbl_user";// Call the conn.php file for database operation 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 ']. '
'; $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 result mysql_close ();//close Connection?>

Run result------------------------------------
Single data: {"Jsonobj": {"id": "1", "name": "LMW"}}

Multiple data: {"DataList": [{"id": "1", "name": "LMW"},{"id": "2", "Name": "XXJ"},{"id": "3", "Name": "Xxxj"}]}

http://www.bkjia.com/PHPjc/371414.html www.bkjia.com true http://www.bkjia.com/PHPjc/371414.html techarticle PHP//need to execute SQL statement//single $sql=select id,name from Tbl_user where id=1;//multiple data//$sql =select id,name from tbl_user;// Call conn.php file for database operation re ...

