public function getMessageTopParent($id) { $rid = $id; if ($rid > 0) { while ($rid > 0) { $parent = $rid; $res = $this->connect->select("rid", $this->tableName, "id = :id", [':id' => $rid]); $rid = $res[0]['rid']; } } return $parent; }
private function setAllText() { $result = Connect::select("text", ""); foreach ($result as $val) { App::$text[$val['key_t']] = $val['content']; } }
public function getUserStatus($mid) { if ($mid) { $users = array(); $userlist = $this->connect->select('uid, status', $this->tableName, 'mid = ' . $mid); foreach ($userlist as $u => $user) { $users[$user['uid']] = $user['status']; } return $users; } else { return false; } }
function login() { require_once ROOT_REQUEST . "loginRequest.php"; $req = new loginRequest(); if ($req->_error()) { $user = Connect::select("user", " WHERE email='" . $req->_req('email') . "' and password='******'password')) . "' "); if (count($user) > 0) { $_SESSION['email'] = $req->_req('email'); $_SESSION['password'] = md5($req->_req('password')); echo json_encode(['status' => true]); exit(0); } } echo json_encode(['status' => false]); }
/** * @param $id * @return mixed */ public function getChildren($id) { $message = $this->connect->select("*", $this->tableName, "status < 2 AND rid = :rid ", [':rid' => $id]); return $message; }
public function getById($id) { $project = $this->connect->select("*", $this->tableName, "id = :id", [':id' => 1]); return $project; }
public function getMimeType($id) { $mimetype = $this->connect->select("mimetype", "oc_mimetypes", "id = :id", [':id' => $id]); return $mimetype; }
public function getById($id) { $user = $this->connect->select("*", $this->tableName, "uid = :id", [':id' => $id]); return $user; }
/** * Retrieve all date of links project-tasks * @return array|null */ public function get() { return $this->connect->select('*', $this->tableName); }
/** * Retrieve all date of links project-tasks * * @return array|null */ public function get() { return $this->connect->select('*', $this->tableName, 'deleted != 1'); }