Unable to display results into a php table

manpreet Best Answer 3 years ago

I tried the force.com php toolkit to pull results from salesforce into php. Following is my code...

$query = "SELECT Id, Name, Phone from Contact";
$response = $mySforceConnection->query($query);
echo'<table>';
echo'';
echo "Results of query '$query'<br/><br/>\n";
foreach ($response->records as $record) {
 echo'';  echo $record->Id . ":" . $record->Name . "<br/>\n";  echo''; 
}
echo'';
echo'table>';
echo '';
?>

I'm unable to draw a table around my results.

manpreet 3 years ago

Try following code:

$query = "SELECT Id, Name, Phone from Contact";
$response = $mySforceConnection->query($query);

echo '';
echo '";

foreach ($response->records as $record) {
    echo'';
}
echo'
';
echo "Results of query '$query'
';
    echo $record->Id;
    echo "
";
    echo $record->Name;
    echo '
';
echo '';