<?php include_once 'db_functions.php'; $db = new DatabaseFunction(); $result = $db->getUnSyncRowCount(); $response = ['flag' => $result['flag'], 'count' => $result['data']]; echo json_encode($response);
Add User
</div>
</center>
<form method="POST">
<table>
<tr>
<td>Name:</td><td><input name="username" /></td>
</tr>
<tr><td colspan="2" align="center"><input type="submit" value="Add User"/></td></tr>
</table>
</form>
<?php
include_once './db_functions.php';
//Create Object for DatabaseFunction class
if (isset($_POST["username"]) && !empty($_POST["username"])) {
$db = new DatabaseFunction();
//Store User into MySQL DB
$uname = $_POST["username"];
$res = $db->storeUser($uname);
//Based on insertion, create JSON response
if ($res) {
?>
<div id="msg">Insertion successful</div>
<?php
} else {
?>
<div id="msg">Insertion failed</div>
<?php
}
} else {
?>
<?php
include_once 'db_functions.php';
$db = new DatabaseFunction();
$json = $_POST['sync_status'];
if (get_magic_quotes_gpc()) {
$json = stripslashes($json);
}
$data = json_decode($json);
$response = ['users' => [], 'flag' => false];
for ($i = 0; $i < count($data); $i++) {
$id = $data[$i]->id;
$status = $data[$i]->sync_status;
/**
* Store User Data into DB
*/
$result = $db->updateSync($id, $status);
$temp["id"] = $id;
$temp["sync_status"] = $result ? 'Yes' : 'No';
$response['users'][] = $temp;
$response['flag'] = $result;
}
echo json_encode($response);
}
img{
height: 32px;
width: 32px;
}
</style>
<script>
var val= setInterval(function(){
location.reload();
},2000);
</script>
</head>
<body>
<?php
include_once 'db_functions.php';
$db = new DatabaseFunction();
$result = $db->getAllUsers();
$users = $result['data'];
if ($result['flag'] != false) {
$no_of_users = count($users);
} else {
$no_of_users = 0;
}
?>
<center>
<div id="link_insert_user"><a href="http://ray-renaldi.com:44400/services/insert_user.php">Add New User</a></div>
<div class="header">
View Users
<h2>There's <?php
echo $no_of_users;
?>
<?php /** * Return */ include_once 'db_functions.php'; $db = new DatabaseFunction(); $result = $db->getUsers(); $response = ['users' => $result['data'], 'flag' => $result['flag']]; echo json_encode($response["users"]);
