PHP OCA\Owncollab_Calendar\Db Connect::query Exemples

Exemple #1

Fichier : calendar.php Projet : raceface2nd/owncollab

 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']);
 }

Exemple #2

Fichier : task.php Projet : raceface2nd/owncollab

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