FM / angel

/home/desid573/public_html/angel

Name	Size	Mode	Actions
assets/	-	0755	rm
drivers/	-	0755	rm
font/	-	0755	rm
lib/	-	0755	rm
payment/	-	0755	rm
stripe/	-	0755	rm
twilio-php-master/	-	0755	rm
vendor/	-	0755	rm
after_booking_page.php	2595	0644	edit dl rm
angeldrivers.png	132095	0644	edit dl rm
a_name_address.php	1289	0644	edit dl rm
booking.php	9621	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.php	2430	0644	edit dl rm
cancel_booking.php	5367	0644	edit dl rm
composer.json	65	0644	edit dl rm
composer.lock	2355	0644	edit dl rm
confirmsend.php	2582	0644	edit dl rm
contact_us_mail.php	903	0644	edit dl rm
dispatch.php	864	0644	edit dl rm
error_log	436257456	0644	edit dl rm
generate_credit.php	3187	0644	edit dl rm
generate_referall.php	2779	0644	edit dl rm
getPrice.php	738	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	1465	0644	edit dl rm
get_payment_byuser.php	1064	0644	edit dl rm
home.php	1660	0644	edit dl rm
homekey_img.png	14037	0644	edit dl rm
hook.php	21267	0644	edit dl rm
hook_set_up.php	654	0644	edit dl rm
index.php	12007	0644	edit dl rm
index_backup.php	4791	0644	edit dl rm
jobdetails.php	12197	0644	edit dl rm
lib_tr.zip	105047	0644	edit dl rm
login_api.php	7798	0644	edit dl rm
login_api_old.php	5653	0644	edit dl rm
noteconfirm.php	9259	0644	edit dl rm
online_booking.php	28283	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
priceCheck.php	0	0644	edit dl rm
reset_email.php	1755	0644	edit dl rm
search.php	830	0644	edit dl rm
send_bulk_notif.php	1692	0644	edit dl rm
setprice.php	4429	0644	edit dl rm
setprice_database.php	585	0644	edit dl rm
smsconfirm.php	9830	0644	edit dl rm
smssend.php	2354	0644	edit dl rm
stripe-php-master.zip	254366	0644	edit dl rm
test1.php	159	0644	edit dl rm
test_222.php	845	0644	edit dl rm
thankyou.php	17470	0644	edit dl rm
update_api.php	6290	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/angel/a_name_address.php (1289B)

<?php
ini_set('display_errors', '1');
error_reporting(E_ALL);
header('Content-type: application/json; charset=utf-8');
$name=$_REQUEST['name'];

if(!empty($name))
{
    $dist=GetAddress($name);
    echo $dist;
}

//calculate distance
function GetAddress($name)
{
    require("lib/config.php");
    $conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname) or die($conn->connect_error);
    
    $name = mysqli_real_escape_string($conn, $name);

$query = "select * from customers where name = '".$name."'";
    $result = mysqli_query($conn, $query);
    
    if($result->num_rows > 0) {
        $row = mysqli_fetch_assoc($result);
    
        $cid = $row["id"];
        
        $query = "select * from customer_details where cid =".$cid;
        
        $result = $conn->query($query);
        $details = $result->fetch_assoc();
        $home = $details["address"];
        
        $query = "select * from customer_tokens where cid =".$cid;
        
        $result = $conn->query($query);
        $tokens = $result->fetch_assoc();
        $token = $tokens["access_token_value"];
        
    
        $user=array('cid' => $row["id"], 'name'=> $row['name'],'mobile'=> $row['mobile'],'email'=> $row['email'],'home'=> $home, 'token'=>$token);
    return json_encode($user, true);
    }
}

connect_error); $name = mysqli_real_escape_string($conn, $name); $query = "select * from customers where name = '".$name."'"; $result = mysqli_query($conn, $query); if($result->num_rows > 0) { $row = mysqli_fetch_assoc($result); $cid = $row["id"]; $query = "select * from customer_details where cid =".$cid; $result = $conn->query($query); $details = $result->fetch_assoc(); $home = $details["address"]; $query = "select * from customer_tokens where cid =".$cid; $result = $conn->query($query); $tokens = $result->fetch_assoc(); $token = $tokens["access_token_value"]; $user=array('cid' => $row["id"], 'name'=> $row['name'],'mobile'=> $row['mobile'],'email'=> $row['email'],'home'=> $home, 'token'=>$token); return json_encode($user, true); } }