<?php
// SOAP_CLIENT_BASEDIR - folder that contains the PHP Toolkit and your WSDL
// $USERNAME - variable that contains your Salesforce.com username (must be in the form of an email)
// $PASSWORD - variable that contains your Salesforce.com password
define("SOAP_CLIENT_BASEDIR", "soapclient");
require_once SOAP_CLIENT_BASEDIR . '/SforcePartnerClient.php';
require_once SOAP_CLIENT_BASEDIR . '/SforceHeaderOptions.php';
require_once 'samples/userAuth.php';
try {
$mySforceConnection = new SforcePartnerClient();
$mySoapClient = $mySforceConnection->createConnection(SOAP_CLIENT_BASEDIR . '/partner.wsdl.xml');
$mylogin = $mySforceConnection->login($USERNAME, $PASSWORD);
$query = 'Select Name, BillingStreet, BillingCity, BillingState From Account limit 20';
$response = $mySforceConnection->query($query);
$queryResult = new QueryResult($response);
for ($queryResult->rewind(); $queryResult->pointer < $queryResult->size; $queryResult->next()) {
print_r($queryResult->current());
}
} catch (Exception $e) {
print_r($mySforceConnection->getLastRequest());
echo $e->faultstring;
}
function getSession($USERNAME, $PASSWORD)
{
$sessionId = '';
try {
$mySforceConnection = new SforcePartnerClient();
$mySoapClient = $mySforceConnection->createConnection('phpToolkit/partner.wsdl.xml');
$mylogin = $mySforceConnection->login($USERNAME, $PASSWORD);
$sessionId = $mylogin->sessionId;
} catch (Exception $e) {
print_r($mySforceConnection->getLastRequest());
echo $e->faultstring;
}
return $sessionId;
}
<?php
echo "start";
// SOAP_CLIENT_BASEDIR - folder that contains the PHP Toolkit and your WSDL
// $USERNAME - variable that contains your Salesforce.com username (must be in the form of an email)
$USERNAME = "******";
$PASSWORD = "******";
// $PASSWORD - variable that contains your Salesforce.com password
define("SOAP_CLIENT_BASEDIR", "PHPToolkit/soapclient");
require_once SOAP_CLIENT_BASEDIR . '/SforcePartnerClient.php';
try {
ini_set("soap.wsdl_cache_enabled", "0");
$mySforceConnection = new SforcePartnerClient();
$mySoapClient = $mySforceConnection->createConnection(SOAP_CLIENT_BASEDIR . '/partner.wsdl.xml');
$mylogin = $mySforceConnection->login($USERNAME, $PASSWORD);
//$query = "SELECT Id, FirstName, LastName, Phone from Contact";
$query = "SELECT ID,Date_Reported__c,Title__c FROM Product_Experience_Report__c";
$response = $mySforceConnection->query($query);
$queryResult = new QueryResult($response);
foreach ($queryResult->records as $record) {
print_r($record);
echo "<br>";
echo $record->Product_Experience_Report__c->Id[0];
echo "<br>";
}
} catch (Exception $ex) {
print_r($ex);
echo $mySforceConnection->getLastRequest();
print_r($ex);
}