class mainpage_query{ public $arrBest; public $items; public $db; function __construct(){ $this->db = new Database(); } function deleteRows(){ $sql = 'SELECT * FROM aliases WHERE DATE_FORMAT(aliasdateto, "%Y-%m-%d") < DATE_FORMAT(NOW(), "%Y-%m-%d") AND aliasdateto!="0000-00-00 00:00:00"'; $tb = $this->db->connection->prepare($sql); $tb->execute(); $this->arrBest = $tb->fetchAll(PDO::FETCH_ASSOC); foreach($this->arrBest as $Items){ $userName = $Items['username'].'@bioline.ru'; $sql = 'UPDATE bcc SET active=0 WHERE bcc_name = :bcc_name'; $tb = $this->db->connection->prepare($sql); $tb->execute(array(':bcc_name'=>$userName)); } //--DELLPART $sql = 'DELETE FROM aliases WHERE DATE_FORMAT(aliasdateto, "%Y-%m-%d") < DATE_FORMAT(NOW(), "%Y-%m-%d") AND aliasdateto!="0000-00-00 00:00:00"'; $tb = $this->db->connection->prepare($sql); $tb->execute(); } } $dateWork = new mainpage_query(); $dateWork->deleteRows();