function PollMessage() { include 'config/config.php'; require_once 'libs/database.php'; $db = new DataBase($db_server, $db_user, $db_password); $db->Select($db_name); $db->Query("SELECT * FROM messages ORDER BY id DESC LIMIT 2"); $data = $db->ReadNext(); //no message in queue - return nop if ($data == null) { echo "none"; return; } /* echo "<pre>"; print_r($data); echo "</pre>";*/ $id = $data['id']; $message = $data['message']; //return the command to client echo $message; //delete message from queue $db = new DataBase($db_server, $db_user, $db_password); $db->Select($db_name); $db->Query("DELETE FROM messages WHERE id = '{$id}';"); }
public function getAbsence($month, $year) { $userid = $_SESSION['userid']; $sql = 'Select kind, day, year, month From absence , userabsence where abs_id = absence.id and user_id like :userid AND month LIKE :month AND year LIKE :year'; $params = array(':userid' => $userid, ':year' => $year, ':month' => $month); $abs = parent::Select($sql, $params); return $abs; }
public function userExist($uid) { $sts = false; $query = 'select * from user where user_id like :uid'; $params = array(':uid' => $uid); $inf = parent::Select($query, $params); return $inf; }
function EnqueueMessage($message) { include 'config/config.php'; require_once 'libs/database.php'; $db = new DataBase($db_server, $db_user, $db_password); $db->Select($db_name); $query = "INSERT INTO messages (\n\t\t\t\t\tmessage\n\t\t\t\t\t)\n\t\t\t\t\tVALUES (\n\t\t\t\t\t'{$message}'\n\t\t\t\t\t);"; $db->Query($query); }