$log = fopen('sforce.log', 'a'); define("SOAP_CLIENT_BASEDIR", "../../sforce"); require_once SOAP_CLIENT_BASEDIR . '/config.inc'; require_once SOAP_CLIENT_BASEDIR . '/SforcePartnerClient.php'; require_once SOAP_CLIENT_BASEDIR . '/SforceHeaderOptions.php'; $sforce = new SforcePartnerClient(); $client = $sforce->createConnection(SOAP_CLIENT_BASEDIR . '/partner.wsdl.xml'); $mylogin = $sforce->login($USERNAME, $PASSWORD . $TOKEN); if ($log) { fwrite($log, date('c') . " - Login\n"); fwrite($log, 'Entry from ' . $_POST['company'] . ' by ' . $_POST['first_name'] . ' ' . $_POST['last_name'] . "\n"); } // retrieve the program $query = "Select Id From TC_Program__c Where Name = '2010'"; try { $response = $sforce->query($query); } catch (Exception $ex) { sendError($ex, $_POST["company"]); exit; } $records = $response->records; $record = $records[0]; $tcid = $record->Id; // retrieve the questions/metrics $query = "Select Id, Question__c, Question_Id__c From Annual_Metric__c Where Top_Company__c = '{$tcid}' "; try { $response = $sforce->query($query); } catch (Exception $ex) { sendError($ex, $_POST["company"]); exit; }
<?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; }