public function getById($uid) { $sql = "SELECT `id_tasks` FROM `{$this->tableName}`\n WHERE uid = :uid"; $result = $this->connect->query($sql, [':uid' => $uid]); return (array) json_decode($result['id_tasks']); }
public function getCountAllTasks() { $sql = "SELECT COUNT(*) as count\n FROM `{$this->tableName}`"; $result = $this->connect->query($sql); return $result['count']; }