<?php
include_once 'bigtable.php';
include_once 'balgorithm.php';
if (isset($_POST['user_id'])) {
$id = $_POST['user_id'];
$key = $_POST['user_key'];
$request_id = $_POST['request_id'];
if ($key == Generate_key($id)) {
$get = mysqli_query($con, "select * from popcorn_users where user_id ='{$request_id}'");
while ($data = $get->fetch_array()) {
$getstatus = mysqli_query($con, "select * from user_status where user_id='{$request_id}'");
$status = $getstatus->fetch_array();
$response = array("user_id" => $data['user_id'], "user_name" => $data['user_name'], "user_status" => $status['user_status'], "user_gender" => $data['user_gender'], "user_age" => $data['user_age'], "user_joined" => $data['user_joined']);
echo json_encode($response);
}
}
}
<?php
include 'bigtable.php';
include 'balgorithm.php';
if (isset($_POST['user_id'])) {
$userid = $_POST['user_id'];
$userkey = $_POST['user_key'];
//AUTENTICATION USER ID AND USER KEY
if ($userkey == Generate_key($userid)) {
$status = $_POST['user_status'];
mysqli_query($con, "update user_status set user_status = '{$status}' where user_id = '{$userid}'");
$response = array("response" => "true");
echo json_encode($response);
}
}
error_reporting(0);
include_once 'bigtable.php';
include_once 'balgorithm.php';
if (isset($_POST['user_id'])) {
$user_id = $_POST['user_id'];
$user_name = $_POST['user_name'];
$user_email = $_POST['user_email'];
$user_gender = $_POST['user_gender'];
$user_age = $_POST['user_age'];
$user_joined = $_POST['user_joined'];
$user_status = "Hi there! i am eating Popcorn.";
//CHECKKING IF USERNAME IF ALREADY REGISTERED
$get = mysqli_query($con, "select * from ofUser where username = '******'");
if ($data = $get->fetch_array()) {
$response = array("response" => "true", "password" => $data['plainPassword']);
echo json_encode($response);
} else {
//TIMESTAMP FOR REGISTERING USER TIME
$time = round(microtime(true) * 1000);
//GENERATING PASSSWORD
$response_key = Generate_key($user_id);
mysqli_query($con, "insert into ofUser(username,plainPassword,name,creationDate,modificationDate) values('{$user_id}','{$response_key}','{$user_name}','{$time}','{$time}')");
//REGISTERING IN THE OPENFIRE OFUSER TABLE
mysqli_query($con, "insert into popcorn_users(user_id,user_name,user_email,user_gender,user_age,user_joined) values('{$user_id}','{$user_name}','{$user_email}','{$user_gender}','{$user_age}','{$user_joined}')");
//REGISTERING USERS IN POPCORN TABLE
mysqli_query($con, "insert into user_status (user_id,user_status) values('{$user_id}','{$user_status}')");
//INSERTING USER_STATUS FIRST TIME IN TABLE
$response = array("response" => "true", "password" => $response_key);
echo json_encode($response);
}
}
