<?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