/home/desid573/public_html/fc_api
Edit: /home/desid573/public_html/fc_api/getuser_bymail.php (3419B)
query($sql);
if ($result->num_rows > 0)
{
while($row = $result->fetch_assoc())
{
$customer[] = $row;
$sql = "SELECT * FROM `customer_details` where `cid` = '".$row["id"]."'";
$result = $conn->query($sql);
if ($result->num_rows > 0)
{
while($row_details = $result->fetch_assoc())
{
$cust_detail[] = $row_details;
}
}
$sql = "SELECT * FROM `customer_tokens` where `cid` = '".$row["id"]."'";
$result = $conn->query($sql);
if ($result->num_rows > 0)
{
while($row_token = $result->fetch_assoc())
{
$cust_token = $row_token["access_token_value"];
}
$client_key = '4T7y1vuKPkdhRYUQdH6msueW9hqV2wpcwnSk0Qwxkvwf7TjQn40qymPW7IJb66gUC1w1505cDMkj9IR82juQEnIp4/8nd0nDhwYDSDoqROtNBWmkqtqYmF6F4qVGMUq3HpJrY3y2kdSljCFfWzWc7LIEn4G5XY2IZAPgAO5+mhwvYrricmqwLhqzV4FBUII5AwTvJZl4awrdul4vLWkS73vJuW/XrXHseGK/nqB3oSRluZ1jKp2qDgVTwrXYEbx4rwwS42X2w0C9tLKywxf27WD2CCK8ftSeQBimVqFI0r6VuRXFVaOn6SQTOD9V/TsCfPk5Zh6/PWcfapyVKS+l1w==';
$apiKey ='44DD7APNUxR8/4sDLhEVT11OS00fmBo4Haxj4ZGJGHvtLBP0rC/ayqNhbVu9tEJrjlJPJm';
$apiPassword = 'y2b7QMpd';
$apiEndpoint = \Eway\Rapid\Client::MODE_PRODUCTION;
$client = \Eway\Rapid::createClient($apiKey, $apiPassword, $apiEndpoint);
$response = $client->queryCustomer($cust_token);
$card_num = $response->Customers[0]->CardDetails->Number;
$card_num = substr($card_num,0,4)." ".substr($card_num,4,4)." ".substr($card_num,8,4)." ".substr($card_num,12,4);
$card_exp_month = $response->Customers[0]->CardDetails->ExpiryMonth;
$card_exp_year = $response->Customers[0]->CardDetails->ExpiryYear;
}
}
$Res["message"] = "user detail ok";
$Res["staus"] = "OK";
if(isset($_REQUEST["all"]))
{
$Res["data"] = $customer;
$Res["cust_detail"] = $cust_detail;
$Res["cust_token"] = $cust_token;
}
elseif(isset($_REQUEST["token"]))
{
$Res["cust_token"] = $cust_token;
}
else
{
$fullname = $customer[0]["name"];
$name_split = explode(" ", $fullname);
$fname = $name_split[0];
$lname = $name_split[1];
$Res["data"]["fname"] = $fname ;
$Res["data"]["lname"] = $lname ;
$Res["data"]["mobile"] = $customer[0]["mobile"];
$Res["data"]["email"] = $customer[0]["email"];
$Res["data"]["address"] = $cust_detail[0]["address"];
$Res["data"]["addr_lat"] = $cust_detail[0]["addr_lat"];
$Res["data"]["addr_long"] = $cust_detail[0]["addr_long"];
$Res["data"]["fam_pax"] = $cust_detail[0]["no_pax"];
$Res["data"]["fam_rf"] = $cust_detail[0]["no_rf"];
$Res["data"]["fam_ff"] = $cust_detail[0]["no_ff"];
$Res["data"]["fam_b"] = $cust_detail[0]["no_b"];
$Res["data"]["card_num"] = $card_num;
$Res["data"]["card_exp_year"] = $card_exp_year;
$Res["data"]["card_exp_month"] = $card_exp_month;
}
}
else
{
$Res["message"] = "Username or Passowrd not correct!";
$Res["staus"] = "error";
}
echo json_encode(new ArrayObject($Res));
/*echo "
";
print_r($Res);
//print_r($response);
echo "
";*/
$conn->close();
// =============== New customer user api End Here ==========================
?>