Contact lookup via Email field

Question

I am using Force.com Toolkit for PHP (Version 20.0) to integrate with Salesforce.

I would like to look up some Contact via the email field and print in on page if the condition is met. Here is the query I used:

SELECT Name, Email, npe01__HomeEmail__c, npe01__WorkEmail__c, npe01__AlternateEmail__c FROM Contact WHERE Email = "[email protected]"

In Workbench everything works fine, however, when I use the same query in PHP I get the following error:

'MALFORMED_QUERY: npe01__AlternateEmail__c FROM Contact WHERE Email="[email protected]"

ERROR at Row:1:Column:112

Bind variables only allowed in Apex code'

What would be best practice to help me solve this problem?

Thanks!

Answer 1

You can try the following queries:

SELECT Name, Email, npe01__HomeEmail__c, npe01__WorkEmail__c, npe01__AlternateEmail__c FROM Contact WHERE Email = '[email protected]' 

For example:

$donor_email = '[email protected]';

$query = 'SELECT Name, Email, npe01__HomeEmail__c, npe01__WorkEmail__c, npe01__AlternateEmail__c FROM Contact WHERE Email=\''.$donor_email.'\'';