<?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;
}
<?php
include_once '../includes/functions.php';
$get = filter_input_array(INPUT_GET);
$records = array();
$date = date('Y-m-d');
$query = "SELECT Id,Name,Event_Series__c,Event_Start_Day__c,Start_Time__c,Venue_Name__c,Event_Ticket_Types_ALL__c FROM Event__c WHERE Event_Start_Day__c >= {$date}";
$response = $mySforceConnection->query($query);
$queryResult = new QueryResult($response);
for ($queryResult->rewind(); $queryResult->pointer < $queryResult->size; $queryResult->next()) {
$record = $queryResult->current();
if ($record->fields->Event_Series__c) {
$records[$record->fields->Event_Series__c][] = $record;
} else {
$records[$record->Id][] = $record;
}
}
?>
<form action="" method="post">
<div class="form-group">
<label>Select Event</label>
<select name="event_id" id="eventSelect" class="form-control">
<option>-- Select Event --</option>
<?php
foreach ($records as $key => $record) {
echo '<option value="' . $key . '" ' . ($get['event_id'] == $key ? 'selected' : '') . '>' . $record[key($record)]->fields->Name . '</option>';
}
?>
</select>
</div>
<?php
