});
$app->get("/shiningfloor/userquery", function () use($app, $db) {
$query = $db->contact_us()->order('date DESC');
$data = array();
foreach ($query as $user) {
$data[] = array("name" => $user["name"], "email" => $user["email"], "msg" => $user["msg"], "date" => $user["date"]);
}
echo json_encode(array('users_data' => $data));
});
// Subscribe user
$app->post("/shiningfloor/subscribe", function () use($app, $db) {
$email = $app->request()->post('email');
// echo $msg . $name . $email ;
$time = new DateTime("now", new DateTimeZone('Asia/Kolkata'));
$time = $time->format('Y-m-d H:i:s');
if (!count($db->subscribed_user()->where('email', $email))) {
$query = $db->subscribed_user()->insert(array("email" => $email, "date" => (string) $time));
echo 'success';
} else {
echo 'subscribed';
}
});
$app->get("/shiningfloor/subscribedUsers", function () use($app, $db) {
$query = $db->subscribed_user()->order('date DESC');
$data = array();
foreach ($query as $user) {
$data[] = array("email" => $user["email"], "date" => $user["date"]);
}
echo json_encode(array('users_data' => $data));
});
/********************* pwd change info **********************************/
