<?php

include 'db/db-connect.php';

$uid = $_GET["uid"];

$query = "SELECT SQL_NO_CACHE user_id, username, email, full_name, gender, address, number FROM member WHERE user_id='$uid'";

$stmt = $con->prepare($query);

$stmt->execute();

$stmt->bind_result($user_id, $username, $email, $full_name, $gender, $address, $number);

while($stmt->fetch()){

 $temp = array();

 $temp['user_id'] = $user_id; 

 $temp['username'] = $username; 

 $temp['email'] = $email; 

 $temp['full_name'] = $full_name; 

 $temp['gender'] = $gender; 

 $temp['address'] = $address;

 $temp['number'] = $number;

 $data[] = $temp;

}

$stmt->close();

die(json_encode($data, JSON_PRETTY_PRINT));

?>

<?php

include 'db/db-connect.php';

include 'functions.php';

$inputJSON = file_get_contents('php://input');

$input = json_decode($inputJSON, TRUE); //convert JSON into array



if (isset($input['username']) && isset($input['fullname']) && isset($input['address']) && isset($input['number'])) {

 $username = $input['username'];

 $fullname = $input['fullname'];

 $address = $input['address'];

 $gender = $input['gender'];

 $number = $input['number'];

 

 //Query to register new user

 // $insertQuery  = "UPDATE member SET full_name = '$fullname', address = '$address', gender = '$gender', number = '$number' WHERE username='$username'";

 $insertQuery  = "UPDATE member SET full_name = ?, address = ?, gender = ?, number = ? WHERE username=?";

 if($stmt = $con->prepare($insertQuery)){

 $stmt->bind_param("sssss", $fullname, $address, $gender, $number, $username);

 $stmt->execute();

 $response["status"] = 0;

 $response["message"] = "Profile Updated";

 $stmt->close();

 }

}

else{

 $response['status'] = 2;

 $response["message"] = "Missing mandatory parameters"; 

}

die(json_encode($response));

?>