/home/desid573/public_html/app
Edit: /home/desid573/public_html/app/update_api_on_mail.php (4723B)
query($sql);
while($row_details = $result->fetch_assoc())
{
$cid = $row_details["id"] ;
}
$cid;
if ($result->num_rows > 0)
{
$sql= "UPDATE `perthdes_new_pro_api`.`customers` SET";
if(isset($_REQUEST["fname"]) && isset($_REQUEST["lname"]))
{
$sql.= " `name` = '".$fullname."',";
}
if(isset($_REQUEST["phone"]))
{
$sql.= "`mobile` = '".$_REQUEST["phone"]."',";
}
if(isset($_REQUEST["pass"]))
{
$sql.= "`password` = '".$password."' ,";
}
$sql.= "`modified` = NOW() WHERE `customers`.`email` ='".$_REQUEST["email"]."'";
//$sql;
if($conn->query($sql))
{
$cust["status"][] = "ok";
$sql_detail="UPDATE `perthdes_new_pro_api`.`customer_details` SET ";
if(isset($_REQUEST["address"]))
{
$sql_detail.= "`address` = '".$_REQUEST["address"]."', ";
}
if(isset($_REQUEST["addr_la"]))
{
$sql_detail.="`addr_lat` = '".$_REQUEST["addr_la"]."', ";
}
if(isset($_REQUEST["addr_long"]))
{
$sql_detail.="`addr_long` = '".$_REQUEST["addr_long"]."' ";
}
$sql_detail.="WHERE `customer_details`.`cid` =".$cid;
//echo $sql_detail;
if($conn->query($sql_detail))
{
$cust["status"][] = "ok";
//========================token Id ===================================
$client_key = '4T7y1vuKPkdhRYUQdH6msueW9hqV2wpcwnSk0Qwxkvwf7TjQn40qymPW7IJb66gUC1w1505cDMkj9IR82juQEnIp4/8nd0nDhwYDSDoqROtNBWmkqtqYmF6F4qVGMUq3HpJrY3y2kdSljCFfWzWc7LIEn4G5XY2IZAPgAO5+mhwvYrricmqwLhqzV4FBUII5AwTvJZl4awrdul4vLWkS73vJuW/XrXHseGK/nqB3oSRluZ1jKp2qDgVTwrXYEbx4rwwS42X2w0C9tLKywxf27WD2CCK8ftSeQBimVqFI0r6VuRXFVaOn6SQTOD9V/TsCfPk5Zh6/PWcfapyVKS+l1w==';
$apiKey = '44DD7APNUxR8/4sDLhEVT11OS00fmBo4Haxj4ZGJGHvtLBP0rC/ayqNhbVu9tEJrjlJPJm';
$apiPassword = 'y2b7QMpd';
//$apiKey = '60CF3Ce97nRS1Z1Wp5m9kMmzHHEh8Rkuj31QCtVxjPWGYA9FymyqsK0Enm1P6mHJf0THbR';
//$apiPassword = 'API-P4ss';
//$apiEndpoint = \Eway\Rapid\Client::MODE_SANDBOX; // Use \Eway\Rapid\Client::MODE_PRODUCTION when you go live
$apiEndpoint = \Eway\Rapid\Client::MODE_PRODUCTION; // Use \Eway\Rapid\Client::MODE_PRODUCTION when you go live
$client = \Eway\Rapid::createClient($apiKey, $apiPassword, $apiEndpoint);
$customer = [
'Title' => 'Mr.',
'FirstName' => $fname,
'LastName' => $lname,
'Country' => 'au',
'CardDetails' => [
'Name' => $fullname,
'Number' => $_REQUEST["credit_card"],
'ExpiryMonth' => $expmonth ,
'ExpiryYear' => $expyear,
'CVN' => $_REQUEST["CVV"],
]
];
$response = $client->createCustomer(\Eway\Rapid\Enum\ApiMethod::DIRECT, $customer);
$tokencustomerid = $response->Customer->TokenCustomerID;
//===========================token id end here ========================
$sql_card_token = "UPDATE `perthdes_new_pro_api`.`customer_tokens` SET `access_token_value` = '".$tokencustomerid."' , `status` = '".$_REQUEST["user_agree"]."' ,`modified` = NOW() WHERE `customer_tokens`.`cid` ='".$cid."'";
if($conn->query($sql_card_token))
{
$cust["status"][] = "ok";
}
else
{
$cust["error"][] = "error";
}
}
else
{
$cust["error"][] = "error";
}
}
else
{
$cust["error"][] = "error";
}
//echo "
";
// print_r($cust);
//echo "
";
$count = sizeof($cust["status"]);
$count_error = sizeof($cust["error"]);
if($count==3)
{
$Res["massege"] = "customer data is updated";
$Res["status"] = "ok";
}
if($count_error >0)
{
$Res["massege"] = "customer data has some issue";
$Res["status"] = "error";
}
}
else
{
$Res["massege"] = "No such Id present in database";
$Res["status"] = "error";
}
echo json_encode(new ArrayObject($Res));
//echo "
";
//print_r($data);
//print_r($customer);
//print_r($Res);
//echo "
";
$conn->close();
// =============== New customer user api End Here ==========================
?>
