public function all() { $result = array(); $total = 0; try { $isPage = $_REQUEST['offset']; $sql = "SELECT * FROM " . $_REQUEST['model']; if (isset($isPage)) { $_sql = "SELECT COUNT(*) AS total FROM " . $_REQUEST['model']; $_data = SQLHandler::executeSQL($this->conn, 'get', $_sql); $total = $_data[0]["total"]; $offset = $_REQUEST['offset']; $size = $_REQUEST['size']; $sql = $sql . " LIMIT " . $offset . "," . $size . ";"; } $data = SQLHandler::executeSQL($this->conn, 'get', $sql); $result = array("sql" => $sql, "payload" => $data, "total" => $total); } catch (Exception $e) { $result = array("error" => $e->getMessage()); } return $result; }
public function checkToken($token) { $result = false; try { $args = array("token" => md5($token . "bms")); $sql = "SELECT id FROM bms_user WHERE token=:token"; $rows = SQLHandler::executeSQL($this->conn, 'post', $sql, $args); if (count($rows) > 0) { $result = true; } } catch (Exception $e) { throw $e; } return $result; }
public function read($id) { $result = array(); try { $sql = "SELECT * FROM " . $_REQUEST['model'] . " WHERE id=" . $id; $res = SQLHandler::executeSQL($this->conn, 'get', $sql); $result = $res[0]; } catch (PDOException $e) { $result = array("error" => $e->getMessage()); } return $result; }