Search code examples
phpdatabasearrayssalesforcesoql

Output Array Items


I'm using Salesforce.com Toolkit for PHP and I'm trying to output something I think is very simple.

THIS IS WORKING EXAMPLE CODE

$query = "SELECT ID, Phone FROM Contact LIMIT 5";
$response = $mySforceConnection->query($query);

foreach ($response->records as $record) {
echo $record->ID." - ".$record->Phone;
}

I'VE TWEAKED THE QUERY AND NOW WANT TO JUST OUTPUT THE NAME AND THE COUNT. HOWEVER THE CODE BELOW DOES NOT WORK

$query = "SELECT owner.name, count(type) FROM Task LIMIT 5";
$response = $mySforceConnection->query($query);

foreach ($response->records as $record) {
echo $record->owner.name; //DOES NOT WORK
}

THIS IS WHAT I GET WHEN I print_r ($record);

stdClass Object ( [Id] => [any] => Array ( [0] => First Last [1] => 2177 ) ) 

I just want to be able to output "First Last - 2177"


Solution

  • foreach ($response->records as $record)
    {
        echo implode(' - ', $record->any);
    }