-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathFetchUserData.php
47 lines (36 loc) · 1.26 KB
/
FetchUserData.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
<?php
$servername = "seekt.asia";
$username = "seektasi_fitness";
$password = "fitness53300";
$dbname = "seektasi_bus";
$con = mysqli_connect($servername, $username, $password, $dbname);
if (!$con) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
$email = $_POST["email"];
$password = $_POST["password"];
$statement = mysqli_prepare($con,"SELECT * FROM User WHERE email = ? AND password = ? ");
mysqli_stmt_bind_param($statement,"ss",$email,$password);
mysqli_stmt_execute($statement);
mysqli_stmt_store_result($statement);
mysqli_stmt_bind_result($statement,$id,$name,$email,$password,$gender,$dob,$weight,$height,$image,$reward,$doj,$update,$token);
$user = array();
while(mysqli_stmt_fetch($statement)){
$user["id"] = $id;
$user["name"] = $name;
$user["email"] = $email;
$user["password"] = $password;
$user["dob"] = $dob;
$user["gender"] = $gender;
$user["height"] = $height;
$user["weight"] = $weight;
$user["doj"] = $doj;
$user["update"] = $update;
$user["image"] = base64_encode($image);
$user["reward"] = $reward;
}
echo(json_encode($user));
mysqli_stmt_close($statement);
mysqli_close($con);
?>