Json在PHP与JS之间传输
1. JS-->PHP
a). JS create Json
1 <script> 2 $(document).ready(function(){ 3 /*--JS create Json--*/ 4 var jsonObject={}; // In another way: jsonObject={'name':"Bruce",'age':25}; 5 jsonObject['name'] = "Bruce"; 6 jsonObject['age'] = 25; 7 console.log(jsonObject); 8 console.log('This is stringfied json object: ' + JSON.stringify(jsonObject)); 9 console.log(JSON.parse(JSON.stringify(jsonObject))); 10 $("#demo").html(jsonObject.name + ", " +jsonObject.age); 11 /*--JS create Json--*/ 12 13 }); 14 </script>
b). Pass Json from JS to PHP by using Ajax
1 <script> 2 $(document).ready(function(){ 3 /*--JS create Json--*/ 4 var jsonObject={}; // In another way: jsonObject={'name':"Bruce",'age':25}; 5 jsonObject['name'] = "Bruce"; 6 jsonObject['age'] = 25; 7 console.log(jsonObject); 8 console.log('This is stringfied json object: ' + JSON.stringify(jsonObject)); 9 console.log(JSON.parse(JSON.stringify(jsonObject))); 10 $("#demo").html(jsonObject.name + ", " +jsonObject.age); 11 /*--JS create Json--*/ 12 13 /*--Ajax pass data to php--*/ 14 $.ajax({ 15 url: 'php/test.php', 16 type: 'POST', //or use type: 'GET', then use $_GET['json'] or $_POST['json'] to in PHP script 17 data: { json: JSON.stringify(jsonObject)}, 18 success: function(response) { 19 console.log(response); 20 var jsonObj = JSON.parse(response); 21 $("#demo").html("From PHP's echo: " + jsonObj.name + ", " + jsonObj.age); 22 } 23 }); 24 /*--Ajax pass data to php--*/ 25 26 }); 27 </script>
1 <script> 2 $(document).ready(function(){ 3 /*--JS create Json--*/ 4 var jsonObject={}; // In another way: jsonObject={'name':"Bruce",'age':25}; 5 jsonObject['name'] = "Bruce"; 6 jsonObject['age'] = 25; 7 console.log(jsonObject); 8 console.log('This is stringfied json object: ' + JSON.stringify(jsonObject)); 9 console.log(JSON.parse(JSON.stringify(jsonObject))); 10 $("#demo").html(jsonObject.name + ", " +jsonObject.age); 11 /*--JS create Json--*/ 12 13 /*--Ajax pass data to php--*/ 14 $.ajax({ 15 url: 'php/test.php', 16 type: 'POST', //or use type: 'GET', then use $_GET['json'] or $_POST['json'] to in PHP script 17 data: { json: JSON.stringify(jsonObject)}, 18 success: function(response) { 19 console.log(response); 20 var jsonObj = JSON.parse(response); 21 $("#demo").html("From PHP's echo: " + jsonObj.name + ", " + jsonObj.age); 22 } 23 }); 24 /*--Ajax pass data to php--*/ 25 26 }); 27 </script>
2. PHP-->JS
a). PHP create Json
1 <?php 2 3 $arr = array( 4 'name' => "Bruce", 5 'age' => 25, 6 ); 7 echo json_encode($arr); // {"name":"Bruce","age":25} 8 echo $arr['name']; // Bruce 9 echo JSON_decode(json_encode($arr))->{'name'};// Bruce 10 echo implode((array)json_encode($arr)); // {"name":"Bruce","age":25} 11 12 ?>
b). PHP cURL Call RESTful web service
1 <?php 2 3 try { 4 $data = $_POST['json']; 5 //echo $data; 6 7 try { 8 $rest_url = ""; 9 //echo $rest_url; 10 //$host = array("Content-Type: application/json; charset=utf-8"); 11 $header = array( 12 'Content-Type: application/json', 13 'Centent-Length:'.strlen($data) 14 //'Content-Disposition: attachment; filename=template1.xlsx' 15 ); 16 17 $ch = curl_init(); 18 curl_setopt($ch, CURLOPT_HEADER, 0); 19 curl_setopt($ch, CURLOPT_HTTPHEADER, $header); 20 curl_setopt($ch, CURLOPT_URL, $rest_url); 21 curl_setopt($ch, CURLOPT_VERBOSE, 1); 22 curl_setopt($ch, CURLOPT_POST, true); 23 curl_setopt($ch, CURLOPT_POSTFIELDS, $data); 24 curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); 25 $output = curl_exec($ch); 26 27 echo $output; 28 } catch (Exception $e) { 29 echo $e -> getMessage(); 30 } 31 32 }catch (Exception $e) { 33 echo 'Caught exception: ', $e->getMessage(), "\n"; 34 } 35 36 ?>
3. Pass Json from PHP to PHP (must be array then json_encode('json string')?)
http://stackoverflow.com/questions/871858/php-pass-variable-to-next-page
4. Submit parameters to PHP through HTML form POST/GET to download a file (e.g. Excel...)
I figure out a way around this. Instead of making a POST call to force the browser to open the save dialog, I will make a POST call to generate the file, then temporary store the file on the server, return the filename . Then use a GET call for this file with "Content-Disposition: attachment; filename=filename1". The GET call with that header will force the browser to open the "Save this file" dialog, always.
<?php require_once 'RESTClient.php'; $url = 'http://158.132.51.202/SWR-SHRS/API/V1/'; //echo $url; $type = 1; if(!empty($_GET['type'])){ $type = trim($_GET['type']); } $data = $_GET['filter']; $client = new SHRRESTClient($url); $path = $client->downloadExcel($dataId['studid'], (array)json_decode($data)); if($type == 0){ echo "http://localhost/php/".$path; }else{ // send header information to browser header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;'); header('Content-Disposition: attachment; filename="helpers_list.xlsx"'); header('Content-Length: ' . filesize($path)); header('Expires: 0'); header('Cache-Control: max-age=0'); //stream file flush(); print file_get_contents($path); unlink($path); //delete the php server side excel data } ?>
<?php class SHRRESTClient{ public $base_url = null; public function __construct($base_url = null) { if (!extension_loaded('curl')) { throw new \ErrorException('cURL library is not loaded'); } $this->base_url = $base_url; } public function downloadExcel($sid, $data){ $url = $this->base_url.$sid.'/...url...'; $data_string = json_encode($data); # open file to write $path = 'tmp/'.$sid.'.xlsx'; $fp = fopen ($path, 'w+'); $ch = curl_init(); curl_setopt($ch, CURLOPT_URL,$url); curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "POST"); curl_setopt($ch, CURLOPT_POSTFIELDS, $data_string); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_HTTPHEADER, array( 'Content-Type: application/json', 'Content-Length: ' . strlen($data_string)) ); # write data to local file curl_setopt($ch, CURLOPT_FILE, $fp ); $result = curl_exec($ch); # close local file fclose( $fp ); curl_close($ch); return $path; } } ?>
