Support

May 12, 2014 at 4:40 pm

Hey all,

I’m trying to generate a list of attendees via the JSON API in PHP. Here’s the code I’m using to display the results:

<code>&lt;?php 

// create a new cURL resource
$ch = curl_init();

// set URL and other appropriate options
curl_setopt($ch, CURLOPT_URL, &quot;http://triitforlife.com/espresso-api/v1/*REMOVED*);

// Puts return in variable rather than the browser
curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE);

// grab URL and pass it to the variable
$jsonStr = curl_exec($ch);

// close cURL resource, and free up system resources
curl_close($ch);

// decode json and put in array
$data = json_decode($jsonStr, true);

// grab the session key out of the multidimensional array to use later
$sesskey = $data[&#039;body&#039;][&#039;session_key&#039;];

$q = &#039;Event.id__LIKE=174&#039;; 

$endpoint = &#039;http://triitforlife.com/espresso-api/v1/registrations/&#039; . $sesskey . &#039;.pretty_json?&#039; . $q;

echo $endpoint . &#039;&lt;br /&gt;&lt;br /&gt;&#039;;
$session = curl_init($endpoint);
curl_setopt($session, CURLOPT_RETURNTRANSFER, true);
$data = curl_exec($session);
curl_close($session);
$search_results = json_decode($data, true);
if ($search_results === NULL) die(&#039;Error parsing json&#039;);

$event_name = $search_results-&gt;body-&gt;Registrations-&gt;Event-&gt;id;
foreach ($search_results[&#039;body&#039;][&#039;Registrations&#039;] as $attendees)
{
foreach ($attendees as $attendee){
$aname = $attendee[&#039;firstname&#039;].&quot; &quot;.$attendee[&#039;lastname&#039;];
}
echo &quot;&lt;br&gt;&quot;;
}
?&gt;</code>

This “works” technically but the “a21” at the beginning of each line has me stumped. It looks like this:

a21MaryJo
a21Lois
a21Tanja
a21Rogina
a21Lori

How do I get rid of the extra characters?

You can see the result here: http://triitforlife.com/test.php

And the raw JSON here: http://triitforlife.com/espresso-api/v1/registrations/kcmnv6nzwa.pretty_json?Event.id__LIKE=174

Thanks!
Mike

• This topic was modified 9 years, 11 months ago by  Tony. Reason: Remove login info