public function get() { $sql = "SELECT *\n FROM `{$this->tableName}` "; $result = $this->connect->queryAll($sql); return $result; }
/** * Retrieve tasks-data of project * Database query selects all opened records, and all columns of type timestamp output * formatting for JavaScript identification * @return array|null */ public function get() { $sql = "SELECT *,\n DATE_FORMAT( `start_date`, '%d-%m-%Y %H:%i:%s') as start_date,\n DATE_FORMAT( `end_date`, '%d-%m-%Y %H:%i:%s') as end_date\n FROM `{$this->tableName}` WHERE open = 1"; return $this->connect->queryAll($sql); }
/** * Retrieve all records from Users * * @return mixed */ public function getGroupsUsers() { $sql = "SELECT gu.uid, gu.gid, u.displayname\n FROM *PREFIX*group_user gu\n LEFT JOIN *PREFIX*users u ON (u.uid = gu.uid)"; return $this->connect->queryAll($sql); }
public function getAllTalks() { $sql = "SELECT *\n FROM `{$this->tableName}` WHERE rid=0 "; $result = $this->connect->queryAll($sql); return $result; }