public function getall() { $Connection = new CreateConnection(); $mysqli = $Connection->connectToDatabase(); $SQL = "SELECT * FROM priority"; $result = $mysqli->query("{$SQL}"); $list = array(); while ($row = $result->fetch_object()) { $list[] = $row; } $Connection->closeConnection(); return $list; }
public function update() { $Connection = new CreateConnection(); $mysqli = $Connection->connectToDatabase(); $this->id = $mysqli->real_escape_string($this->id); $this->name = $mysqli->real_escape_string($this->name); $this->password = $mysqli->real_escape_string($this->password); $this->group_id = $mysqli->real_escape_string($this->group_id); $SQL = "update user set name ='" . $this->name . "',password= '******',group_id= " . $this->group_id . " where id=" . $this->id . ""; $result = $mysqli->query($SQL); if (!$result) { throw new Exception($mysqli->error); } }
public function getaging() { $Connection = new CreateConnection(); $mysqli = $Connection->connectToDatabase(); $SQL = "select i.title, IFNULL(u1.name,'Unassigned') as programer_name,IFNULL(u2.name,'Unassigned') as customer_name,i.created, DATEDIFF(Now(), date(i.created)) AS days,i.customer_id,i.programer_id from issue i left join user u1 on u1.id = i.programer_id left join user u2 on u2.id = i.customer_id where i.state = 1 or i.state = 2 order by days Desc"; $result = $mysqli->query("{$SQL}"); $list = array(); while ($row = $result->fetch_object()) { $list[] = $row; } $Connection->closeConnection(); return $list; }