<?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"]);