|
PHP - Parse Json Response Array To Option Value
Hello.
I am new here.
I have a sligh problem, i saw a few results here which however did not lead to the desired result.
The problem is , i have this Json Response from a API:
Array
(
[0] => Array
(
[isoid] => 0
[omschrijving] => - leeg -
)
[1] => Array
(
[isoid] => 64
[omschrijving] => ArchLinux 2013.5
)
[2] => Array
(
[isoid] => 75
[omschrijving] => AsteriskNOW 3.0.0 64b
)
[3] => Array
(
[isoid] => 67
[omschrijving] => CentOS 5.9 32b
)
[4] => Array
(
[isoid] => 2
[omschrijving] => CentOS 6.3 64b
)
[5] => Array
(
[isoid] => 96
[omschrijving] => CentOS 7.0 64b
)
[6] => Array
(
[isoid] => 4
[omschrijving] => Clear OS 5.2 64b
)
[7] => Array
(
[isoid] => 93
[omschrijving] => CloudLinux 6.4
)
[8] => Array
(
[isoid] => 1
[omschrijving] => Debian GNU/Linux 6.0 / Squeeze 64b
)
[9] => Array
(
[isoid] => 79
[omschrijving] => Debian GNU/Linux 7.0 / Wheezy 32b
)
[10] => Array
(
[isoid] => 71
[omschrijving] => Debian GNU/Linux 7.0 / Wheezy 64b
)
[11] => Array
(
[isoid] => 63
[omschrijving] => Fedora 18 64b
)
[12] => Array
(
[isoid] => 82
[omschrijving] => FreeBSD 10 64b
)
[13] => Array
(
[isoid] => 77
[omschrijving] => FreeBSD 9.2 64b
)
[14] => Array
(
[isoid] => 10
[omschrijving] => FreePBX 5.211.65-12
)
[15] => Array
(
[isoid] => 76
[omschrijving] => GParted Live CD
)
[16] => Array
(
[isoid] => 3
[omschrijving] => KVM Virtio drivers voor Windows
)
[17] => Array
(
[isoid] => 66
[omschrijving] => MailCleaner 2012v6 64b
)
[18] => Array
(
[isoid] => 68
[omschrijving] => Manjaro KDE 0.8.6 64b
)
[19] => Array
(
[isoid] => 78
[omschrijving] => Microsoft Windows 7 Pro 64b
)
[20] => Array
(
[isoid] => 69
[omschrijving] => Microsoft Windows Server 2003 EN
)
[21] => Array
(
[isoid] => 8
[omschrijving] => Microsoft Windows Server 2008R2 EN
)
[22] => Array
(
[isoid] => 7
[omschrijving] => Microsoft Windows Server 2008R2 NL
)
[23] => Array
(
[isoid] => 70
[omschrijving] => Microsoft Windows Server 2012 NL 64b
)
[24] => Array
(
[isoid] => 84
[omschrijving] => Microsoft Windows Server 2012R2 NL
)
[25] => Array
(
[isoid] => 83
[omschrijving] => NOC PS 1.0r11
)
[26] => Array
(
[isoid] => 11
[omschrijving] => OpenBSD 5.2
)
[27] => Array
(
[isoid] => 80
[omschrijving] => OpenBSD 5.4
)
[28] => Array
(
[isoid] => 94
[omschrijving] => OpenBSD 5.5 64b
)
[29] => Array
(
[isoid] => 72
[omschrijving] => OpenSUSE 12.3 64b
)
[30] => Array
(
[isoid] => 95
[omschrijving] => Slackware 13.37
)
[31] => Array
(
[isoid] => 12
[omschrijving] => System Rescue CD
)
[32] => Array
(
[isoid] => 18
[omschrijving] => Turnkey Appflower
)
[33] => Array
(
[isoid] => 19
[omschrijving] => Turnkey ASP.net/Apache
)
[34] => Array
(
[isoid] => 20
[omschrijving] => Turnkey Bugzilla
)
[35] => Array
(
[isoid] => 21
[omschrijving] => Turnkey CodeIgniter
)
[36] => Array
(
[isoid] => 22
[omschrijving] => Turnkey Django
)
[37] => Array
(
[isoid] => 23
[omschrijving] => Turnkey Dokuwiki
)
[38] => Array
(
[isoid] => 24
[omschrijving] => Turnkey DomainControler
)
[39] => Array
(
[isoid] => 25
[omschrijving] => Turnkey Drupal7
)
[40] => Array
(
[isoid] => 26
[omschrijving] => Turnkey Fileserver
)
[41] => Array
(
[isoid] => 27
[omschrijving] => Turnkey Gallery
)
[42] => Array
(
[isoid] => 28
[omschrijving] => Turnkey Gitlab
)
[43] => Array
(
[isoid] => 15
[omschrijving] => Turnkey Google AppEngine Go
)
[44] => Array
(
[isoid] => 16
[omschrijving] => Turnkey Google AppEngine Java
)
[45] => Array
(
[isoid] => 17
[omschrijving] => Turnkey Google AppEngine Python
)
[46] => Array
(
[isoid] => 29
[omschrijving] => Turnkey IceScrum
)
[47] => Array
(
[isoid] => 30
[omschrijving] => Turnkey Joomla2.5
)
[48] => Array
(
[isoid] => 31
[omschrijving] => Turnkey LAMP
)
[49] => Array
(
[isoid] => 32
[omschrijving] => Turnkey Lighttpd/PHP/FastCGI
)
[50] => Array
(
[isoid] => 33
[omschrijving] => Turnkey Magento
)
[51] => Array
(
[isoid] => 34
[omschrijving] => Turnkey Mediawiki
)
[52] => Array
(
[isoid] => 35
[omschrijving] => Turnkey MongoDB
)
[53] => Array
(
[isoid] => 36
[omschrijving] => Turnkey MySQL
)
[54] => Array
(
[isoid] => 37
[omschrijving] => Turnkey NGINX/PHP/FastCGI
)
[55] => Array
(
[isoid] => 38
[omschrijving] => Turnkey OpenLDAP
)
[56] => Array
(
[isoid] => 39
[omschrijving] => Turnkey OpenPhoto
)
[57] => Array
(
[isoid] => 40
[omschrijving] => Turnkey OSCommerce
)
[58] => Array
(
[isoid] => 41
[omschrijving] => Turnkey OTRS
)
[59] => Array
(
[isoid] => 42
[omschrijving] => Turnkey Owncloud
)
[60] => Array
(
[isoid] => 43
[omschrijving] => Turnkey PHPBB
)
[61] => Array
(
[isoid] => 44
[omschrijving] => Turnkey PHPList
)
[62] => Array
(
[isoid] => 45
[omschrijving] => Turnkey PHPNuke
)
[63] => Array
(
[isoid] => 46
[omschrijving] => Turnkey Postgresql
)
[64] => Array
(
[isoid] => 47
[omschrijving] => Turnkey Prestashop
)
[65] => Array
(
[isoid] => 48
[omschrijving] => Turnkey Rails
)
[66] => Array
(
[isoid] => 49
[omschrijving] => Turnkey Redmine
)
[67] => Array
(
[isoid] => 50
[omschrijving] => Turnkey SiTracker
)
[68] => Array
(
[isoid] => 51
[omschrijving] => Turnkey StatusNET
)
[69] => Array
(
[isoid] => 52
[omschrijving] => Turnkey SugarCRM
)
[70] => Array
(
[isoid] => 53
[omschrijving] => Turnkey Symfony
)
[71] => Array
(
[isoid] => 54
[omschrijving] => Turnkey Tomcat
)
[72] => Array
(
[isoid] => 55
[omschrijving] => Turnkey Tomcat/Apache
)
[73] => Array
(
[isoid] => 56
[omschrijving] => Turnkey TRAC
)
[74] => Array
(
[isoid] => 57
[omschrijving] => Turnkey TWiki
)
[75] => Array
(
[isoid] => 58
[omschrijving] => Turnkey Typo3
)
[76] => Array
(
[isoid] => 59
[omschrijving] => Turnkey Wordpress
)
[77] => Array
(
[isoid] => 60
[omschrijving] => Turnkey Zencart
)
[78] => Array
(
[isoid] => 13
[omschrijving] => Ubuntu 10.04 32b
)
[79] => Array
(
[isoid] => 6
[omschrijving] => Ubuntu 10.04 64b
)
[80] => Array
(
[isoid] => 14
[omschrijving] => Ubuntu 12.04 32b
)
[81] => Array
(
[isoid] => 61
[omschrijving] => Ubuntu 12.04 64b
)
[82] => Array
(
[isoid] => 62
[omschrijving] => Ubuntu 12.10 64b
)
[83] => Array
(
[isoid] => 89
[omschrijving] => Ubuntu 14.04 LTS 64b
)
[84] => Array
(
[isoid] => 5
[omschrijving] => Windows Password Reset
)
[85] => Array
(
[isoid] => 81
[omschrijving] => Zen Loadbalancer 3.03
)
[86] => Array
(
[isoid] => 74
[omschrijving] => Zentyal 3.2
)
)
how would i go to fill it automatically in a option value like
<option value='74'>Zentyal 3.2</option>Thank you in advance Similar TutorialsHi
I'm having this issue, when i put an url who must show me records i have blank html page
<?php
error_reporting(E_ALL | E_NOTICE);
ini_set('display_errors', '1');
require_once 'database_connection.php';
$post=array(
'limit'=>(isset($_REQUEST['rows']))?$_REQUEST['rows']:'',
'page'=>(isset($_REQUEST['page']))?$_REQUEST['page']:'',
'orderby'=>(isset($_REQUEST['sidx']))?$_REQUEST['sidx']:'',
'orden'=>(isset($_REQUEST['sord']))?$_REQUEST['sord']:'',
'search'=>(isset($_REQUEST['_search']))?$_REQUEST['_search']:'',
);
$se ="";
if($post['search'] == 'true'){
$b = array();
$search['like']=elements(array('utilizador','email'),$_REQUEST);
foreach($search['like'] as $key => $value){
if($value != false) $b[]="$key like '%$value%'";
}
$search['where']=elements(array('nome','utilizador','email'),$_REQUEST);
foreach($search['where'] as $key => $value){
if($value != false) $b[]="$key = '$value'";
}
$se=" where ".implode(' and ',$b );
}
$query = mysql_query("select count(*) as t from utilizador".$se);
if(!$query)
echo mysql_error();
$count = mysql_result($query,0);
if( $count > 0 && $post['limit'] > 0) {
$total_pages = ceil($count/$post['limit']);
if ($post['page'] > $total_pages) $post['page']=$total_pages;
$post['offset']=$post['limit']*$post['page'] - $post['limit'];
} else {
$total_pages = 0;
$post['page']=0;
$post['offset']=0;
}
$sql = "SELECT idutilizador, nome, utilizador, telefone, email, password FROM utilizador ".$se;
if( !empty($post['orden']) && !empty($post['orderby']))
$sql .= " ORDER BY $post[orderby] $post[orden] ";
if($post['limit'] && $post['offset']) $sql.=" limit $post[offset], $post[limit]";
elseif($post['limit']) $sql .=" limit 0,$post[limit]";
$query = mysql_query($sql);
if(!$query)
echo mysql_error();
$result = array();
$i = 0;
while($row = mysql_fetch_object($query)){
$result[$i]['id']=$row->idutilizador;
$result[$i]['cell']=array($row->idutilizador,$row->nome,$row->utilizador,$row->telefone,$row->email,$row->password);
$i++;
}
$json = new stdClass();
$json->rows=$result;
$json->total=$total_pages;
$json->page=$post['page'];
$json->records=$count;
echo json_encode($json);
function elements($items, $array, $default = FALSE)
{
$return = array();
if ( ! is_array($items)){
$items = array($items);
}
foreach ($items as $item){
if (isset($array[$item])){
$return[$item] = $array[$item];
}else{
$return[$item] = $default;
}
}
return $return;
}
?>
*Update
It works if i put
$result[$i]['cell']=array($row->idutilizador,$row->telefone,$row->email,$row->password);So i'm think it's because in $nome(ex: Luis Miguel) and $utlizador(ex Susana Maria) don't accept this (space between words) it is correct? Edited by alphasil, 19 January 2015 - 08:54 AM. Hi,
I'm getting the following response using:
$json_object = json_decode($unparsed_json, true);
array(1) {
["google.com"]=>
array(2) {
["status"]=>
string(16) "regthroughothers"
["classkey"]=>
string(6) "domcno"
}
}
How do I echo the attribute of the ['status']? I have tried using:
echo $json_object->['status'];Thanks, MoFish Hello, I am needing to cache a json response from an API so I am not making requests on each load. I have come across some code that is suppose to accomplish this but, it seems to not be working and can't figure out as to why. I created the cache file with 777 but it doesn't write or read from that file when I echo out the results.
The code below is just what is suppose to get the contents and cache it. At the end I tried to print it so I can test it to see it prints the response from the cache file but, nothing and the cache file does exists.
This is the first time I have tried something like this so please be gentle.
// cachePath is name of the path and file used to store cached current conditions gathered from the API request
$cachePath = "./cache/nowcast-cache.txt";
// URL to the API request
$url = "http://api.wunderground.com/api/XXXXXXXXXXXX/geolookup/conditions/q/TX/mesquite.json";
date_default_timezone_set('America/Chicago');
/**
* Request jobs from API
*
* Split the request into smaller request chunks
* and then consolidate them into a single array to limit the API
* requests.
*/
function api_request()
{
file_put_contents($cachePath,
file_get_contents($url));
}
/**
* API Request Caching
*
* Use server-side caching to store API request's as JSON at a set
* interval, rather than each pageload.
*
* @arg Argument description and usage info
*/
function json_cached_api_results( $cache_file = NULL, $expires = NULL ) {
global $request_type, $purge_cache, $limit_reached, $request_limit;
if( !$cache_file ) $cache_file = dirname(__FILE__) . $cachePath;
if( !$expires) $expires = time() - 2*60*60;
if( !file_exists($cache_file) ) die("Cache file is missing: $cache_file");
// Check that the file is older than the expire time and that it's not empty
if ( filectime($cache_file) < $expires || file_get_contents($cache_file) == '' || $purge_cache && intval($_SESSION['views']) <= $request_limit ) {
// File is too old, refresh cache
$api_results = api_request();
$json_results = json_encode($api_results);
// Remove cache file on error to avoid writing wrong xml
if ( $api_results && $json_results )
file_put_contents($cache_file, $json_results);
else
unlink($cache_file);
} else {
// Check for the number of purge cache requests to avoid abuse
if( intval($_SESSION['views']) >= $request_limit )
$limit_reached = " <span class='error'>Request limit reached ($request_limit). Please try purging the cache later.</span>";
// Fetch cache
$json_results = file_get_contents($cache_file);
$request_type = 'JSON';
}
return json_decode($json_results);
}
print_r($json_results);
Edited by Texan78, 20 December 2014 - 03:51 PM. Hi- I have to post to a URL, grab one field our of the JSON output/response and format nicely to the user. I've tried a few things with some help but none seem to be working. So any help or direction would be greatly appreciate it!! Attempt 1 (works but not formatted nicely) if I post using the browser, it works. the data is sent to the URL (web service) and I can see in the web service logs that the entry has been recorded. the problem is that since i have the URL in "action", i'm taken to that page and the user gets to see the JSON output Code: [Select] //here's the HTML form in offer.php <form action="http://somewebservice.com/<?php echo $PrizeID;?>" method="post" name="myform"> <input name="account" id="account" type="hidden" value="<?php echo $account;?>"/> <input name="dob" id="dob" type="hidden" value="<?php echo $dob;?>"/> <input name="site" id="site" type="hidden" value="<?php echo $site;?>"/> <input id="submit" type="submit" value="submit"/> </form> //here's the output (JSON) after clicking submit {"Prize":"XXXXXX","ConfirmationCode":"######","Error":false,"ErrorMsg":null} Attempt 2 (doens't work) i tried using php but after submit, the page refreshes and no entry is recorded in the web service log Code: [Select] //here's the HTML form in offer.php <form name="myform"> <input name="account" id="account" type="hidden" value="<?php echo $account;?>"/> <input name="dob" id="dob" type="hidden" value="<?php echo $dob;?>"/> <input name="site" id="site" type="hidden" value="<?php echo $site;?>"/> <input id="submit" type="submit" value="submit"/> //here's the php in offer.php <?php if(isset($_POST['submit'])){ $options = array( 'http'=>array( 'method'=>"POST", 'content'=>http_build_query(array( 'account' => $account, 'dob' => $dob, 'site' => $site )) )); $context = stream_context_create($options); $result = file_get_contents("http://somewebservice.com/{$PrizeID}",NULL,$context); var_dump($result); } ?> Last attempt (doesn't work) i tried using php & curl so that i can process in the back and show only the ConfirmationCode to the user in a nice format but it doesn't work. after submit, i'm taken to process.php where i see nothing and no entry is recorded in the web service log Code: [Select] //here's the HTML form in offer.php <form action="process.php" method="post" name="myform"> <input name="account" id="account" type="hidden" value="<?php echo $account;?>"/> <input name="dob" id="dob" type="hidden" value="<?php echo $dob;?>"/> <input name="site" id="site" type="hidden" value="<?php echo $site;?>"/> <input id="submit" type="submit" value="submit"/> </form> //here's the PHP in process.php <?php $postvars=file_get_contents("php://input"); $curl=curl_init("http://somewebservice.com/{$PrizeID}"); curl_setopt($curl,CURLOPT_POSTFIELDS,$postvars); curl_setopt($curl, CURLOPT_RETURNTRANSFER, true); $result=curl_exec($curl); $decodedresult=json_decode($result,true); ?> i haven't gotten to the point where i grab the ConfirmationCode I want because i want to get this fixed first and also because i can't get that to work but will focus on that once i fix this. Thanks. I want to print data from response json? I was debug with firebug and show this :
{"umumu":"","levelu":1,"nameu":""}
How to echo data array just levelu. But i don't know how to make it?
thanks
Evening everyone and Merry X-Mas (Happy Holidays) or whatever fits you best.... I have been trying over and over for about 12 hours to figure out how to get data from a specific JSON response and assign the specific values to a new array key/value pair. The various ways I have tried to figure this out are numerous so i'm going to avoid the runnig list of "I trieid this...and this...and this... etc etc." just understand I have reached a dead end point where I need help badly.
Here is what our end goal is:
"The company" is a "service industry" provider (plumbing, electrical etc. etc.) who wants to dispatch its technicians to new jobs based on which technician has the shortest travel time from any existing address where they already have a scheduled appointment that day and has available time in there schedule. Thus the dispatching system when a new service call is entered is going to give "recommended" technicians (up to 4) to be assigned the new service call based on the above mentioned criteria. (Efficient routing to save company gas cost)
1.) We have a "New service" street address assigned to the $to variable: $to = "4813 River Basin Dr S, Jacksonville FL 32207"; 2.) We will have "records" array which containes a series of records, each record consists of a ticket# a technician id# and a street address: $records = array( array("DV1012","30453423","9890 Hutchinson Park Dr Jacksonville, FL 32225"), array("DB3434","30404041","821 Orange Ave Crescent City, FL 32112"), array("DB3434","30605060","1972 Wells Road, Orange Park FL 32073"), array("DB4578","30605060","2 Independent Drive, Jacksonville FL 32202"), array("DB7841","30605060","5000 Norwood Avenue, Jacksonville FL 32208"), array("DB3235","30605060","9501 Arlington Expressway, Jacksonville FL 32225"), array("DB7894","30605060","Massey Avenue, Jacksonville, FL 32227"), array("DB2020","30121212","11200 Central Pkwy Jacksonville, FL 32224") ); 3.) We are going to prepare the records array for submission to Google's Distance Matrix API by URL encoding each array value into a single variable and then submit it: foreach ($records as $key => $value) {$from = $from.urlencode($value[2])."|";} $to = urlencode($to); $data = file_get_contents("//maps.googleapis.com/maps/api/distancematrix/json?origins=$from&destinations=$to&language=en-EN&units=imperial&mode=driving&sensor=false"); $res=json_decode($data) or die("Error: Cannot read object"); You may look at the ACTUAL live Google response from this he http://tiny.cc/i6eerx (We have applied <pre> and var_dump($res) to the output) We are looking to get the following information back: The distance and travel time between the "New Service" address ($to) and each of the address' in the $records array ($from), now once that information is returned from Google (JSON response) we need to parse the response and narrow it down to 4 or less (Based on the 4 lowest drive times) to form a new array which ends like this: $results = array( array("DV1012","30453423","2.3 Miles","8 mins"), array("DB3434","30404041","2.8 Miles","9 mins"), array("DB3434","30605060","4.6 Miles","13.8 mins"), array("DB4578","30605060","5.7 Miles","15.2 min") ); OUR PROBLEM: Everything up until the the Google API response is fine, but iterating over the multidimensional arrays within multidimensional arrays of the JSON response is just not coming together in my head (or 2 dozen code attempts). I am able to ECHO an individual value like ( echo $res->rows[0]->elements[0]->distance->text; ) but this has no value for the end result i need to get to. My last thoughts and efforts was that that I was going to have to embed foreach statements within foreach statements to drill down through the various arrays but that hasn't worked very well and it seems like it shouldn't be how it has to be done. I would appreciate any help in showing me how the iteration code should be written and any explanation about the code so i can wrap my head around it. I got a response from an api in json. How do i echo out the account_name in string. Thanks as usual. The response is below...
{ "status": true, "message": "Account number resolved", "data": { "account_number": "2067483918", "account_name": "BABALOLA MAYOWA ABEL", "bank_id": 18 } }
"status": true, "message": "Account number resolved", "data": { "account_number": "2067483918", "account_name": "BABALOLA MAYOWA ABEL", "bank_id": 18 } }
Hi Guys, I have this SOAP message to be parsed using SimpleXML:
<soap:envelope
xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<soap:body>
<isokresponse xmlns="http://tempuri.org/">
<isokresult>1</isokresult>
</isokresponse>
</soap:body>
</soap:envelope>
Then I load the XML: $xml = simplexml_load_string($result); I assume I need to register namespace e.g.
$xml->registerXPathNamespace("soap","http://schemas.xmlsoap.org/soap/envelope/");
But what's next? How do I get the value of the element isokresult? Thank you so much Hello
This may seem like a silly question but if you never ask you never know...
Lets say I json encode a php array. When I echo out the encoded json string into a JS variable it looks something like this in the resultant markup:
var arr = ["cow - Copy (10).jpg","cow - Copy (2).jpg"];So in this instance the string I've echoed out is equivalent to a JS array and I can use it straight away. My questions: 1) Is it valid to do what I've done above? 2) Since I can use the array right away is there any need to JSON.parse? 3) When would you use JSON.parse? Thanks, Drongo Hello Can you please show me how can i parse this JSON in PHP? {"status":"error","error":{"error_code":700,"error_message":"Recognition failed: you didn't send file via POST or file url as `url` param."},"requested_params":{"method":"recognize"}}
I need to setup a condition : If(status="error) than $errorcode=700 errormessage=Recognition failed: you didn't send file via POST or file url as `url` param errorMethod= "recognize" Hello, I am a novice with php and know close to nothing about JSON. I am using wordpress and have 2 calendar type plugins I want to work together. With one plugin the user inputs dates that they are booked. The other plugin is a date picker, the cool part is it allows you to black out dates using php before the date picker is built. So what I'm trying to do is get the data from what the user chose as booked, and not let a user on the front end pick any of the booked dates with the date picker. Hope that makes sense. The problem is the formatting of the data with the date booked plugin. This is what is in the field Code: [Select] a:1:{s:9:"calendars";a:1:{i:1;a:4:{s:12:"calendarName";s:21:"Availability Calendar";s:12:"calendarJson";s:59:"{"year2011":{"month12":{"day25":"booked","day6":"booked"}}}";s:11:"dateCreated";i:1324333825;s:12:"dateModified";i:1324333825;}}} I chose 2 dates to be booked in that example: dec 25 2011, and dec 6 2011. I have no idea how I would parse the above data into what I need. I don't really need the data from the other parts of the above code, just the dates. The others are field descriptions and etc. that wordpress uses. Incidentally, this is what the date picker setup would look like in the above senario: Code: [Select] $myCalendar->setSpecificDate(array("2011-12-06","2011-12-25"), 0, ''); I'm trying the fetch some geocode data from mapquest. Google doesn't like me right now. I keep running into the query_limit. So I want to set a back up that will go into production when I get that error from the big G. I have my api key and I can put the string in a var. Code: [Select] $geocode = file_get_contents($url) I selected json as the output and when I echo $geocode... here is the first portion of the string....(I want lat & lng) Code: [Select] renderOptions({"results":[{"locations":[{"latLng":{"lng":-112.35984,"lat":34.58752},..... Now for the life of me, I can't do anything with it. I've tried json_decode() with the true argument there and not. Code: [Select] $output = json_decode($geocode, true); $output = json_decode($geocode); vardump($output) is NULL. So, I thought, well maybe I don't need to decode it, but I can't figure out how to parse it. I'm lost. This admittedly is my first attempt as trying to work with a jason object, but jeesh, it doesn't seem like it should be that hard. Can someone start me in the right direction? I need parse the JSON string below into an associative array, sort it by the 'age' field and output the sorted array as an HTML table. Here is what I have done so far but it just returns me 'Array': Code: [Select] <?php $json='[{"name": "John","age": 23},{"name": "jim","age": 19},{"name": "jason","age": 34}]'; $array = json_decode( $json, true); function cmp( $a, $b){ if( !isset( $a['age']) && !isset( $b['age'])){ return 0; } if( !isset( $a['age'])){ return -1; } if( !isset( $b['age'])){ return 1; } if( $a['age'] == $b['age']){ return 0; } return (($a['age'] > $b['age']) ? 1 : -1); } usort( $array, 'cmp'); foreach ($array as $key => $value) { echo $key.":".$value."\n"; } ?> Hello.
Server returns this json
{"status":1,"job_status":"READY","iterations":["Contig2","Contig75"],"accessions":["NP_001061702","NP_001068174"]}
And i would like to print out in a textarea (using the above jQuery command)
$('#info').val()
something like this:
Contig2 : NP_001061702
Contig75 : NP_001068174
Any idea on how to achieve this?
Thanks!
Hello all, I have yet again trouble finding a logical solution to my problem. I'm fetching an array which can hold 1 or more values. The problem is, I want these values to ouput in my json_encode function, but this also needs to happen dynamically depending on the amount of values. I can't explain it further, so here's the code so far: Code: (php) [Select] $files = mysql_fetch_array($get_files); $a = count($files); $i = 1; while ($files) { $variablename = 'fileName' . $i; $$variablename = $files['fileName']; $i++; } $output = array( OTHER VALUES , 'fileName1' => $fileName1, 'fileName2' => $fileName2, 'fileName3' => $fileName3, ............); // How do I add the fileNames dynamically depending on how many there are? This got me thinking, I also need to dynamically GET the values with jQuery. How would I do that, when the above eventually works? Thank you. Hi. I have the fokllowing xml response from an API and I am wanting to loop through the array(s) and get informaton for each of the rows below. For example I want to get the cells below for Consulting Income / 98e83040-fa3a-4185-9b9b-a49241e2bb76/150.32 then get each of the other items in the array. So the second iitem I want is Contract Income / 7d05a53d-613d-4eb2-a2fc-dcb6adb80b80 / 11748.96 and so on for each of the results returned
I am having a mental block about best way to get this information. Please advise best approach.
<Response xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Id>20f0b472-a63d-4c1f-a8de-d0fc4e860983</Id>
<Status>OK</Status>
<ProviderName>Xero API Previewer</ProviderName>
<DateTimeUTC>2020-10-12T21:34:33.5492839Z</DateTimeUTC>
<Reports>
<Report>
<ReportID>ProfitAndLoss</ReportID>
<ReportName>Profit and Loss</ReportName>
<ReportType>ProfitAndLoss</ReportType>
<ReportTitles>
<ReportTitle>Profit & Loss</ReportTitle>
<ReportTitle>Demo Company (NZ)</ReportTitle>
<ReportTitle>1 October 2020 to 31 October 2020</ReportTitle>
</ReportTitles>
<ReportDate>12 October 2020</ReportDate>
<UpdatedDateUTC>2020-10-12T21:34:33.5492839Z</UpdatedDateUTC>
<Rows>
<Row>
<RowType>Header</RowType>
<Cells>
<Cell />
<Cell>
<Value>31 Oct 20</Value>
</Cell>
</Cells>
</Row>
<Row>
<RowType>Section</RowType>
<Title>Income</Title>
<Rows>
<Row>
<RowType>Row</RowType>
<Cells>
<Cell>
<Value>Consulting Income</Value>
<Attributes>
<Attribute>
<Value>98e83040-fa3a-4185-9b9b-a49241e2bb76</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
<Cell>
<Value>150.32</Value>
<Attributes>
<Attribute>
<Value>98e83040-fa3a-4185-9b9b-a49241e2bb76</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
</Cells>
</Row>
<Row>
<RowType>Row</RowType>
<Cells>
<Cell>
<Value>Contract Income</Value>
<Attributes>
<Attribute>
<Value>7d05a53d-613d-4eb2-a2fc-dcb6adb80b80</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
<Cell>
<Value>11748.96</Value>
<Attributes>
<Attribute>
<Value>7d05a53d-613d-4eb2-a2fc-dcb6adb80b80</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
</Cells>
</Row>
<Row>
<RowType>Row</RowType>
<Cells>
<Cell>
<Value>Engineering Income</Value>
<Attributes>
<Attribute>
<Value>225d8c93-251d-4a0b-9093-201acf69fe50</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
<Cell>
<Value>7217.29</Value>
<Attributes>
<Attribute>
<Value>225d8c93-251d-4a0b-9093-201acf69fe50</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
</Cells>
</Row>
<Row>
<RowType>Row</RowType>
<Cells>
<Cell>
<Value>Equipment Income</Value>
<Attributes>
<Attribute>
<Value>43f518a6-558f-402a-b22d-317bd64b1566</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
<Cell>
<Value>7377.17</Value>
<Attributes>
<Attribute>
<Value>43f518a6-558f-402a-b22d-317bd64b1566</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
</Cells>
</Row>
<Row>
<RowType>Row</RowType>
<Cells>
<Cell>
<Value>Licence Income</Value>
<Attributes>
<Attribute>
<Value>1ff30343-7bb2-4402-bb8f-a0813a7fb59e</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
<Cell>
<Value>3047.68</Value>
<Attributes>
<Attribute>
<Value>1ff30343-7bb2-4402-bb8f-a0813a7fb59e</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
</Cells>
</Row>
<Row>
<RowType>Row</RowType>
<Cells>
<Cell>
<Value>Other Income</Value>
<Attributes>
<Attribute>
<Value>b447935a-4b37-4f38-a841-fb3ae3b491e0</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
<Cell>
<Value>331.06</Value>
<Attributes>
<Attribute>
<Value>b447935a-4b37-4f38-a841-fb3ae3b491e0</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
</Cells>
</Row>
<Row>
<RowType>SummaryRow</RowType>
<Cells>
<Cell>
<Value>Total Income</Value>
</Cell>
<Cell>
<Value>29872.48</Value>
</Cell>
</Cells>
</Row>
</Rows>
</Row>
<Row>
<RowType>Section</RowType>
<Title>Less Cost of Sales</Title>
<Rows>
<Row>
<RowType>Row</RowType>
<Cells>
<Cell>
<Value>Other Direct Costs</Value>
<Attributes>
<Attribute>
<Value>9e77a829-37ea-4976-a9a8-d754e0e62f44</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
<Cell>
<Value>333.72</Value>
<Attributes>
<Attribute>
<Value>9e77a829-37ea-4976-a9a8-d754e0e62f44</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
</Cells>
</Row>
<Row>
<RowType>SummaryRow</RowType>
<Cells>
<Cell>
<Value>Total Cost of Sales</Value>
</Cell>
<Cell>
<Value>333.72</Value>
</Cell>
</Cells>
</Row>
</Rows>
</Row>
<Row>
<RowType>Section</RowType>
<Rows>
<Row>
<RowType>Row</RowType>
<Cells>
<Cell>
<Value>Gross Profit</Value>
</Cell>
<Cell>
<Value>29538.76</Value>
</Cell>
</Cells>
</Row>
</Rows>
</Row>
<Row>
<RowType>Section</RowType>
<Title>Less Operating Expenses</Title>
<Rows>
<Row>
<RowType>Row</RowType>
<Cells>
<Cell>
<Value>Accounting</Value>
<Attributes>
<Attribute>
<Value>5e312344-4123-4cac-bb69-ad2d72d2280b</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
<Cell>
<Value>60.00</Value>
<Attributes>
<Attribute>
<Value>5e312344-4123-4cac-bb69-ad2d72d2280b</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
</Cells>
</Row>
<Row>
<RowType>Row</RowType>
<Cells>
<Cell>
<Value>Advertising & Promotional</Value>
<Attributes>
<Attribute>
<Value>61835d79-5a1c-4ab3-af82-af6930b38492</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
<Cell>
<Value>1112.21</Value>
<Attributes>
<Attribute>
<Value>61835d79-5a1c-4ab3-af82-af6930b38492</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
</Cells>
</Row>
<Row>
<RowType>Row</RowType>
<Cells>
<Cell>
<Value>Bank Fees</Value>
<Attributes>
<Attribute>
<Value>19828003-cea7-4920-b0fa-9223a2cdb0dc</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
<Cell>
<Value>28.75</Value>
<Attributes>
<Attribute>
<Value>19828003-cea7-4920-b0fa-9223a2cdb0dc</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
</Cells>
</Row>
<Row>
<RowType>Row</RowType>
<Cells>
<Cell>
<Value>Cellphones</Value>
<Attributes>
<Attribute>
<Value>ba533632-ac64-45c8-874e-b5a5aa6829f0</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
<Cell>
<Value>155.00</Value>
<Attributes>
<Attribute>
<Value>ba533632-ac64-45c8-874e-b5a5aa6829f0</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
</Cells>
</Row>
<Row>
<RowType>Row</RowType>
<Cells>
<Cell>
<Value>Courier</Value>
<Attributes>
<Attribute>
<Value>b70cadef-d8aa-46e6-b128-79e2c997fd2c</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
<Cell>
<Value>232.02</Value>
<Attributes>
<Attribute>
<Value>b70cadef-d8aa-46e6-b128-79e2c997fd2c</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
</Cells>
</Row>
<Row>
<RowType>Row</RowType>
<Cells>
<Cell>
<Value>EFTPOS Charges</Value>
<Attributes>
<Attribute>
<Value>a164d99b-308e-4b2e-b3b4-a0c502214c77</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
<Cell>
<Value>40.00</Value>
<Attributes>
<Attribute>
<Value>a164d99b-308e-4b2e-b3b4-a0c502214c77</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
</Cells>
</Row>
<Row>
<RowType>Row</RowType>
<Cells>
<Cell>
<Value>Engineering Resources</Value>
<Attributes>
<Attribute>
<Value>53fdcc86-32ee-4fcb-b053-f449405bc7a5</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
<Cell>
<Value>1303.31</Value>
<Attributes>
<Attribute>
<Value>53fdcc86-32ee-4fcb-b053-f449405bc7a5</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
</Cells>
</Row>
<Row>
<RowType>Row</RowType>
<Cells>
<Cell>
<Value>Entertainment - Partly Deductible</Value>
<Attributes>
<Attribute>
<Value>d27cb87b-a3d2-4275-8948-95871fec4929</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
<Cell>
<Value>15.00</Value>
<Attributes>
<Attribute>
<Value>d27cb87b-a3d2-4275-8948-95871fec4929</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
</Cells>
</Row>
<Row>
<RowType>Row</RowType>
<Cells>
<Cell>
<Value>Equipment Costs</Value>
<Attributes>
<Attribute>
<Value>573a170b-6792-4cfa-b8ce-6f8fd27f5458</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
<Cell>
<Value>13746.93</Value>
<Attributes>
<Attribute>
<Value>573a170b-6792-4cfa-b8ce-6f8fd27f5458</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
</Cells>
</Row>
<Row>
<RowType>Row</RowType>
<Cells>
<Cell>
<Value>General Expenses</Value>
<Attributes>
<Attribute>
<Value>11f618a8-f17e-4757-8b4a-6f24841bdb93</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
<Cell>
<Value>323.23</Value>
<Attributes>
<Attribute>
<Value>11f618a8-f17e-4757-8b4a-6f24841bdb93</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
</Cells>
</Row>
<Row>
<RowType>Row</RowType>
<Cells>
<Cell>
<Value>Insurance</Value>
<Attributes>
<Attribute>
<Value>92c673af-b2bc-45be-a888-a7e2c4bcc7f9</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
<Cell>
<Value>119.00</Value>
<Attributes>
<Attribute>
<Value>92c673af-b2bc-45be-a888-a7e2c4bcc7f9</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
</Cells>
</Row>
<Row>
<RowType>Row</RowType>
<Cells>
<Cell>
<Value>KiwiSaver Employer Contributions</Value>
<Attributes>
<Attribute>
<Value>ab57eabe-5fa8-49d4-87dc-d5e7428323af</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
<Cell>
<Value>519.53</Value>
<Attributes>
<Attribute>
<Value>ab57eabe-5fa8-49d4-87dc-d5e7428323af</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
</Cells>
</Row>
<Row>
<RowType>Row</RowType>
<Cells>
<Cell>
<Value>Licence Costs</Value>
<Attributes>
<Attribute>
<Value>02dbaa55-95b9-464e-999c-c68e203cd67f</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
<Cell>
<Value>2176.91</Value>
<Attributes>
<Attribute>
<Value>02dbaa55-95b9-464e-999c-c68e203cd67f</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
</Cells>
</Row>
<Row>
<RowType>Row</RowType>
<Cells>
<Cell>
<Value>Motor Vehicle Expenses</Value>
<Attributes>
<Attribute>
<Value>b149780d-69bc-4f7c-a3ce-bd48f7a37de5</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
<Cell>
<Value>619.63</Value>
<Attributes>
<Attribute>
<Value>b149780d-69bc-4f7c-a3ce-bd48f7a37de5</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
</Cells>
</Row>
<Row>
<RowType>Row</RowType>
<Cells>
<Cell>
<Value>Office Consumables & Postage</Value>
<Attributes>
<Attribute>
<Value>b1769b51-e98e-432c-9670-d5be3054b717</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
<Cell>
<Value>56.00</Value>
<Attributes>
<Attribute>
<Value>b1769b51-e98e-432c-9670-d5be3054b717</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
</Cells>
</Row>
<Row>
<RowType>Row</RowType>
<Cells>
<Cell>
<Value>Office Expenses</Value>
<Attributes>
<Attribute>
<Value>935e0fbe-6749-41c8-a024-11321e44dfac</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
<Cell>
<Value>113.23</Value>
<Attributes>
<Attribute>
<Value>935e0fbe-6749-41c8-a024-11321e44dfac</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
</Cells>
</Row>
<Row>
<RowType>Row</RowType>
<Cells>
<Cell>
<Value>Payment Processing</Value>
<Attributes>
<Attribute>
<Value>8cd42505-ad73-46e2-932f-67952fdc4e99</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
<Cell>
<Value>174.51</Value>
<Attributes>
<Attribute>
<Value>8cd42505-ad73-46e2-932f-67952fdc4e99</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
</Cells>
</Row>
<Row>
<RowType>Row</RowType>
<Cells>
<Cell>
<Value>Rent</Value>
<Attributes>
<Attribute>
<Value>28113b99-6df2-4123-a2d0-5f54dcf8017b</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
<Cell>
<Value>1935.00</Value>
<Attributes>
<Attribute>
<Value>28113b99-6df2-4123-a2d0-5f54dcf8017b</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
</Cells>
</Row>
<Row>
<RowType>Row</RowType>
<Cells>
<Cell>
<Value>Salaries & Wages</Value>
<Attributes>
<Attribute>
<Value>be2e984a-17e1-4bf7-809c-b03a69325c90</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
<Cell>
<Value>17317.58</Value>
<Attributes>
<Attribute>
<Value>be2e984a-17e1-4bf7-809c-b03a69325c90</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
</Cells>
</Row>
<Row>
<RowType>Row</RowType>
<Cells>
<Cell>
<Value>Security</Value>
<Attributes>
<Attribute>
<Value>c814b08e-6558-4ac4-adce-ba76848a3a9f</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
<Cell>
<Value>45.00</Value>
<Attributes>
<Attribute>
<Value>c814b08e-6558-4ac4-adce-ba76848a3a9f</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
</Cells>
</Row>
<Row>
<RowType>Row</RowType>
<Cells>
<Cell>
<Value>Subscriptions</Value>
<Attributes>
<Attribute>
<Value>5ba8d64a-5b98-4bfd-a35e-7d0569e3446f</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
<Cell>
<Value>102.96</Value>
<Attributes>
<Attribute>
<Value>5ba8d64a-5b98-4bfd-a35e-7d0569e3446f</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
</Cells>
</Row>
<Row>
<RowType>Row</RowType>
<Cells>
<Cell>
<Value>Telephone & Internet</Value>
<Attributes>
<Attribute>
<Value>230e4cfc-f4c4-4c15-aa0d-bab02b954622</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
<Cell>
<Value>89.95</Value>
<Attributes>
<Attribute>
<Value>230e4cfc-f4c4-4c15-aa0d-bab02b954622</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
</Cells>
</Row>
<Row>
<RowType>Row</RowType>
<Cells>
<Cell>
<Value>Travel & Accommodation - National</Value>
<Attributes>
<Attribute>
<Value>36d33c5d-7dea-4911-9ed0-7fccc16f2b5f</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
<Cell>
<Value>210.43</Value>
<Attributes>
<Attribute>
<Value>36d33c5d-7dea-4911-9ed0-7fccc16f2b5f</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
</Cells>
</Row>
<Row>
<RowType>Row</RowType>
<Cells>
<Cell>
<Value>Utilities</Value>
<Attributes>
<Attribute>
<Value>2e277847-022c-48f3-8467-0207230004d6</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
<Cell>
<Value>348.14</Value>
<Attributes>
<Attribute>
<Value>2e277847-022c-48f3-8467-0207230004d6</Value>
<Id>account</Id>
</Attribute>
</Attributes>
</Cell>
</Cells>
</Row>
<Row>
<RowType>SummaryRow</RowType>
<Cells>
<Cell>
<Value>Total Operating Expenses</Value>
</Cell>
<Cell>
<Value>40844.32</Value>
</Cell>
</Cells>
</Row>
</Rows>
</Row>
<Row>
<RowType>Section</RowType>
<Rows>
<Row>
<RowType>Row</RowType>
<Cells>
<Cell>
<Value>Net Profit</Value>
</Cell>
<Cell>
<Value>-11305.56</Value>
</Cell>
</Cells>
</Row>
</Rows>
</Row>
</Rows>
</Report>
</Reports>
</Response>
Edited October 13, 2020 by Barand code tags (XML) added http://paste.ee/p/OhiWv
The above is a link to a readable version of my code. The XMLHTTPREQUEST worked, and the array was pulled down. Was able to print out the undecoded/unparsed array. However, immediately afterwards, all code stops working.
<script>
var xhr;
if (window.XMLHttpRequest) { // Mozilla, Safari, ...
xhr = new XMLHttpRequest();
} else if (window.ActiveXObject) { // IE 8 and older
xhr = new ActiveXObject("Microsoft.XMLHTTP");
}
xhr.open("POST", "PHPLibrary/selectMemberResults.php", true);
xhr.setRequestHeader("Content-Type", "application/x-www-form-urlencoded");
xhr.send();
xhr.onreadystatechange = display_data;
var $phparray
function display_data() {
if (xhr.readyState == 4) {
if (xhr.status == 200) {
//alert(xhr.responseText);
$phparray = xhr.responseText;
document.getElementById("suggestion").innerHTML = $phparray;
//
//
//......................................................?
// The above line of code is the last thing to print or
// to do anything that returns to the browser....
//.......................................................?
// All lines below do nothing............................?
//
} else {
//alert('There was a problem with the request.');
}
}
}
document.write("Length of phparray Array :" + $phparray.length + "<");
var output = JSON.parse($phparray, function (key,val) {
if ( typeof val === 'string' ) {
// regular expression to remove extra white space
if ( val.indexOf('\n') !== -1 ) {
var re = /\s\s+/g;
return val.replace(re, ' ');
} else {
return val;
}
}
return val;
} );
document.write("Length of Array :" + $output.length + "<");
for (var i=0; i < $output.length; i++)
{
document.getElementById("suggestion").innerHTML = $output[i].MEMBER_NAME;
}
</script>
A HTTP request is made to the server, Slim creates a Request and Response object, content in the Request is sent to another server using cURL via Guzzle, Guzzle returns its own Response, and content from Guzzle's response must be returned by the original Slim response. Would you recommend white-listing or black-listing response headers, and which specific headers? Similarly, would you recommend white-listing or black-listing the request headers sent via cURL, and which specific headers? Thanks
<?php
use Psr\Http\Message\ResponseInterface as Response;
use GuzzleHttp\Psr7\Response as CurlResponse;
class ApiResponder
{
public function delete(Response $httpResponse, CurlResponse $curlResponse) {
return $this->proxy($httpResponse, $curlResponse);
}
//other public methods...
private function proxy(Response $httpResponse, CurlResponse $curlResponse) {
foreach($this->getResponseHeaders($curlResponse) as $name=>$value) {
$httpResponse=$httpResponse->withHeader($name, $value);
}
return $httpResponse->withBody($curlResponse->getBody())->withStatus($curlResponse->getStatusCode());
}
private function getResponseHeaders(Response $httpResponse):array
{
//Blacklist headers which should be returned to original client. TBD whether I should whitelist headers instead.
$blacklist=['Date'=>null, 'Server'=>null, 'X-Powered-By'=>null, 'Access-Control-Allow-Origin'=>null, 'Access-Control-Allow-Methods'=>null, 'Access-Control-Allow-Headers'=>null, 'Set-Cookie'=>null];
return array_diff_key($curlResponse->getHeaders(), $blacklist);
}
/**
* This method doesn't really exist in this class, but is just included to show which headers I am forwarding in the cURL request.
*/
private function getRequestHeaders($clientRequest):array
{
$whitelist=['connection'=>null,'accept'=>null,'accept-encoding'=>null,'accept-language'=>null,'content-type'=>null,'content-length'=>null];
return array_intersect_key($clientRequest->getHeaders(), $whitelist);
}
}
I have a json file returned by facebook e.g { "data": [ { "name": "Support! Muffin the fool (Oldham Chronicle FAKE)", "category": "Community", "id": "181377645219010", "access_token": "102650199811234|060d3610d4dba63953209fa5-637782927|181377645219010|MvOBJKYtO7eT8JxMLtJ00HtGNxo" }, { "name": "Northplanet", "category": "Local business", "id": "132483460132622", "access_token": "102650199811234|060d3610d4dba63953209fa5-637782927|132483460132622|AHXPNTZx7aihyQS_A9W6pR115U4" }, { "name": "Social Media Manger", "category": "Application", "id": "102650199811234", "access_token": "102650199811234|060d3610d4dba63953209fa5-637782927|102650199811234|KeH0n1OKzZFtCkpa0lX1yJZ7NBE" }, { "name": "Top Ten Things To Remember Me By!", "category": "Application", "id": "375102030458", "access_token": "102650199811234|060d3610d4dba63953209fa5-637782927|375102030458|H-mpQWrksu_2FzZ_eBNVzeD2Z1Y" } ] } $graph_url = "https://graph.facebook.com/$uid/comments=" . $access_token; $api = json_decode(file_get_contents($graph_url)); $name = $api->data->name; // this bit not storing the name not sure why I am writing a simple connector for an android application and my json_encode is outputting enclosing the array with []. This is throwing an error during the decode process because the array needs to start with a {. I know this has to do with the $output[] in the loop, but I dont know how to pass the values into the array any other way. I even tried to trim after doing the encode. Here is my code: Code: [Select] <?php require_once ('includes/config.php'); require_once ('includes/connect.php'); $agency= mysql_query("SELECT agencyname FROM agency WHERE status ='Prospect' ORDER BY agencyname DESC")or die(mysql_error()); while($ageinfo = mysql_fetch_assoc($agency)) { $output[] = $ageinfo; } print(json_encode($output)); ?> |
|||||||