/** * @param $uid * @return mixed */ public function getUserEmail($uid) { $sql = "SELECT * FROM oc_preferences\n WHERE configkey = 'email'\n AND appid = 'settings'\n AND userid = :uid"; return $this->connect->query($sql, [':uid' => $uid]); }
public function getCountAllTasks() { $sql = "SELECT COUNT(*) as count\n FROM `{$this->tableName}`"; $result = $this->connect->query($sql); return $result['count']; }