Ejemplo n.º 1
0
 /**
  * @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]);
 }
Ejemplo n.º 2
0
 public function getCountAllTasks()
 {
     $sql = "SELECT COUNT(*) as count\n                FROM `{$this->tableName}`";
     $result = $this->connect->query($sql);
     return $result['count'];
 }