FM / test

/home/desid573/public_html/test_api

Name	Size	Mode	Actions
lib/	-	0755	rm
twilio-php-master/	-	0755	rm
vendor/	-	0755	rm
after_booking_page.php	2595	0644	edit dl rm
booking.php	10716	0644	edit dl rm
booking_28-04-2017.php	947	0644	edit dl rm
booking_29-04-2017.php	3717	0644	edit dl rm
cancel_booking.php	5621	0644	edit dl rm
checkPrice.php	1306	0644	edit dl rm
composer.json	65	0644	edit dl rm
composer.lock	2355	0644	edit dl rm
confirmsend.php	2682	0644	edit dl rm
contact_us_mail.php	903	0644	edit dl rm
dispatch.php	877	0644	edit dl rm
emailConfirmReset.php	486	0644	edit dl rm
error_log	5922247	0644	edit dl rm
generate_credit.php	3187	0644	edit dl rm
generate_referall.php	2779	0644	edit dl rm
getuser_byid.php	2341	0644	edit dl rm
getuser_bymail.php	1968	0644	edit dl rm
get_all_booking.php	779	0644	edit dl rm
get_booking_bybooking_id.php	813	0644	edit dl rm
get_booking_byuser.php	1057	0644	edit dl rm
get_booking_status.php	2219	0644	edit dl rm
get_completed_bookings.php	727	0644	edit dl rm
get_directions.php	813	0644	edit dl rm
get_lead_message.php	673	0644	edit dl rm
get_open_bookings.php	1527	0644	edit dl rm
get_payment_byuser.php	1064	0644	edit dl rm
homekey_img.png	14037	0644	edit dl rm
index.php	14272	0644	edit dl rm
index_backup.php	4791	0644	edit dl rm
lib_tr.zip	105047	0644	edit dl rm
login_api.php	8405	0644	edit dl rm
login_api_old.php	5653	0644	edit dl rm
noteconfirm.php	9259	0644	edit dl rm
passwordResetLink.php	5195	0644	edit dl rm
pay_file.php	7302	0644	edit dl rm
pay_file_back.php	5326	0644	edit dl rm
placehold.html	2184	0644	edit dl rm
reset_email.php	1755	0644	edit dl rm
send_bulk_notif.php	1692	0644	edit dl rm
test_222.php	845	0644	edit dl rm
update_api.php	6318	0644	edit dl rm
update_api_on_mail.php	4677	0644	edit dl rm
validatecode.php	1094	0644	edit dl rm
validatephone.php	1034	0644	edit dl rm

Edit: /home/desid573/public_html/test_api/after_booking_page.php (2595B)

<?php
require("lib/config.php");
require_once 'vendor/eway/eway-rapid-php/include_eway.php';
$data  = $_REQUEST;
$sql = "SELECT * FROM customers where email = '".$_REQUEST['username']."'";
$result = $conn->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;
			}
		}
		$sql = "SELECT * FROM `booking` where email = '".$_REQUEST['username']."'";
		$result = $conn->query($sql);
		if ($result->num_rows > 0) 
		{
			while($row_booking = $result->fetch_assoc()) 
			{
				$cust_booking[] = $row_booking;
			}
		}
		
    }
}
$name = $customer[0]["name"];
$name_split = explode(" ",$name);
$fname = $name_split[0];
$lname = $name_split[1];
$cus = $customer[0]["name"];
$mob = $customer[0]["mobile"];

$Res["data"]["id"] = $customer[0]["id"];
		$Res["data"]["name"] = $customer[0]["name"];
		$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"]["pickup_addr"] = $cust_booking[0]["pickup_addr"];
		$Res["data"]["pickup_lat"] = $cust_booking[0]["pickup_lat"];
		$Res["data"]["pickup_long"] = $cust_booking[0]["pickup_long"];
		$Res["data"]["pickoff_addr"] = $cust_booking[0]["pickoff_addr"];
		$Res["data"]["pickoff_lat"] = $cust_booking[0]["pickoff_lat"];
		$Res["data"]["pickoff_long"] = $cust_booking[0]["pickoff_long"];
		$Res["data"]["booking_date"] = $cust_booking[0]["booking_date"];
		$Res["data"]["booking_time"] = $cust_booking[0]["booking_time"];
		$Res["data"]["Access_token"] = $cust_token[0]["access_token_value"];
		$Res["data"]["show_message"] = "Thank you for submitting your booking. Please make sure the above details are correct. 
You will receive confirmation via SMS within 30 mins. 
When the driver is en route you will receive a tracking link via SMS with driver contact details and their ETA.
Please call 1300466365 if you need to make any changes at short notice."; 
	echo json_encode(new ArrayObject($Res));

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; } } $sql = "SELECT * FROM `booking` where email = '".$_REQUEST['username']."'"; $result = $conn->query($sql); if ($result->num_rows > 0) { while($row_booking = $result->fetch_assoc()) { $cust_booking[] = $row_booking; } } } } $name = $customer[0]["name"]; $name_split = explode(" ",$name); $fname = $name_split[0]; $lname = $name_split[1]; $cus = $customer[0]["name"]; $mob = $customer[0]["mobile"]; $Res["data"]["id"] = $customer[0]["id"]; $Res["data"]["name"] = $customer[0]["name"]; $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"]["pickup_addr"] = $cust_booking[0]["pickup_addr"]; $Res["data"]["pickup_lat"] = $cust_booking[0]["pickup_lat"]; $Res["data"]["pickup_long"] = $cust_booking[0]["pickup_long"]; $Res["data"]["pickoff_addr"] = $cust_booking[0]["pickoff_addr"]; $Res["data"]["pickoff_lat"] = $cust_booking[0]["pickoff_lat"]; $Res["data"]["pickoff_long"] = $cust_booking[0]["pickoff_long"]; $Res["data"]["booking_date"] = $cust_booking[0]["booking_date"]; $Res["data"]["booking_time"] = $cust_booking[0]["booking_time"]; $Res["data"]["Access_token"] = $cust_token[0]["access_token_value"]; $Res["data"]["show_message"] = "Thank you for submitting your booking. Please make sure the above details are correct. You will receive confirmation via SMS within 30 mins. When the driver is en route you will receive a tracking link via SMS with driver contact details and their ETA. Please call 1300466365 if you need to make any changes at short notice."; echo json_encode(new ArrayObject($Res));