Apex Code Development You need to sign in to do that
Don't have an account?
Sakthi169 How to insert the record into salesforce (sandbox) using php
Hi,
I am create the simple page with mandatory field(Firstname,Lastname,email,city,mobileno,source) once i submit form and it directly insert into salesforce. My code for ur reference
Fatal error: Uncaught SoapFault exception: [soapenv:Client] No operation available for request {urn:enterprise.soap.sforce.com}login in C:\xampp\htdocs\soapclient\SforceBaseClient.php:169 Stack trace: #0 C:\xampp\htdocs\soapclient\SforceBaseClient.php(169): SoapClient->__call('login', Array) #1 C:\xampp\htdocs\soapclient\SforceBaseClient.php(169): SoapClient->login(Array) #2 C:\xampp\htdocs\test2.php(20): SforceBaseClient->login('xxxxxxx...') #3 {main} thrown in C:\xampp\htdocs\soapclient\SforceBaseClient.php on line 169
I am create the simple page with mandatory field(Firstname,Lastname,email,city,mobileno,source) once i submit form and it directly insert into salesforce. My code for ur reference
<?php
// session_start() has to go right at the top, before any output!
session_start();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title></title>
</head>
<body>
<?php
require_once ('soapclient/SforceEnterpriseClient.php');
define("USERNAME", "xxxxxxx");
define("PASSWORD", "xxxxxx");
define("SECURITY_TOKEN", "xxxxxxx");
$mySforceConnection = new SforceEnterpriseClient();
$wsdl = 'soapclient/enterprise.wsdl.xml';
$mySforceConnection->createConnection($wsdl);
$mySforceConnection->login(USERNAME, PASSWORD.SECURITY_TOKEN);
$mySforceConnection->setEndpoint('https://test.salesforce.com/services/Soap/c/30.0');
$LastName=$_POST["name"];
$CustomMobile__c=$_POST["mobileno"];
$query = "insert into 'Account'(LastName,CustomMobile__c )VALUES('$LastName','$CustomMobile__c')";
$result = $mySforceConnection->query($query);
print_r($result);
$nameErr = $emailErr = $genderErr = $mobilenoErr = $websiteErr = "";
$name = $email = $gender = $comment = $mobileno = $website = "";
if ($_POST['submit']) {
if (empty($_POST["name"])) {
$nameErr = "Name is required";
} else {
$name = test_input($_POST["name"]);
// check if name only contains letters and whitespace
if (!preg_match("/^[a-zA-Z ]*$/",$name)) {
$nameErr = "Only letters and white space allowed";
}
}
if (empty($_POST["mobileno"])) {
$mobileno= "";
} else {
$mobileno= test_input($_POST["mobileno"]);
// check if URL address syntax is valid (this regular expression also allows dashes in the URL)
if (!preg_match("/^[1-9][0-9]*$/",$mobileno)) {
$mobilenoErr = "Invalid mobileno";
}
}
if (empty($_POST["email"])) {
$emailErr = "Email is required";
} else {
$email = test_input($_POST["email"]);
// check if e-mail address is well-formed
if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
$emailErr = "Invalid email format";
}
}
if (empty($_POST["website"])) {
$website = "";
} else {
$website = test_input($_POST["website"]);
// check if URL address syntax is valid (this regular expression also allows dashes in the URL)
if (!preg_match("/b(?:(?:https?|ftp)://|www.)[-a-z0-9+&@#/%?=~_|!:,.;]*[-a-z0-9+&@#/%=~_|]/i",$website)) {
$websiteErr = "Invalid URL";
}
}
if (empty($_POST["comment"])) {
$comment = "";
} else {
$comment = test_input($_POST["comment"]);
}
if (empty($_POST["gender"])) {
$genderErr = "Gender is required";
} else {
$gender = test_input($_POST["gender"]);
}
}
function test_input($data) {
$data = trim($data);
$data = stripslashes($data);
$data = htmlspecialchars($data);
return $data;
}
?>
<h2>Account Details</h2>
<p><span class="error">* required field.</span></p>
<form method="post" action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?>">
Name: <input type="text" name="name" value="<?php echo $name;?>">
<span class="error">* <?php echo $nameErr;?></span>
<br><br>
Mobile No: <input type="text" name="mobileno" value="<?php echo $mobileno;?>">
<span class="error">* <?php echo $mobilenoErr;?></span>
<br><br>
E-mail: <input type="text" name="email" value="<?php echo $email;?>">
<span class="error">* <?php echo $emailErr;?></span>
<br><br>
<br><br>
Gender:
<input type="radio" name="gender" <?php if (isset($gender) && $gender=="female") echo "checked";?> value="female">Female
<input type="radio" name="gender" <?php if (isset($gender) && $gender=="male") echo "checked";?> value="male">Male
<span class="error">* <?php echo $genderErr;?></span>
<br><br>
<input type="submit" name="submit" value="Submit">
</form>
<?php
echo "<h2>Your Input:</h2>";
echo $name;
echo "<br>";
echo $mobileno;
echo "<br>";
echo $email;
echo "<br>";
echo $website;
echo "<br>";
echo $comment;
echo "<br>";
echo $gender;
?>
Fatal error: Uncaught SoapFault exception: [soapenv:Client] No operation available for request {urn:enterprise.soap.sforce.com}login in C:\xampp\htdocs\soapclient\SforceBaseClient.php:169 Stack trace: #0 C:\xampp\htdocs\soapclient\SforceBaseClient.php(169): SoapClient->__call('login', Array) #1 C:\xampp\htdocs\soapclient\SforceBaseClient.php(169): SoapClient->login(Array) #2 C:\xampp\htdocs\test2.php(20): SforceBaseClient->login('xxxxxxx...') #3 {main} thrown in C:\xampp\htdocs\soapclient\SforceBaseClient.php on line 169