} function writeLoging($inneruserId,$rzlt){ $sql = 'INSERT INTO loging (`tmlog`,`login_id`,`moving`,`rzlt`,`vargroup`,`ipuser`) VALUES (NOW(),:login_id,"создание",:rzlt,"1","'.$_SERVER["REMOTE_ADDR"].'")'; $tb = $this->dbIt->connection->prepare($sql); $tb->execute(array(':login_id'=>$inneruserId,':rzlt'=>$rzlt)); } function getAllfromtable($login_request){ $sql = 'SELECT `user_id`,`email`,`email`, CONCAT(`sername`," ",`name`) as fio, `password` FROM users WHERE login = :login'; $tb = $this->db->connection->prepare($sql); $tb->execute(array(':login'=>$login_request)); $this->arrBest = $tb->fetch(PDO::FETCH_ASSOC); return $this->arrBest; } } $workData = new main_query(); $checkLogin = $workData ->getAllfromtable($login); if(!$checkLogin['user_id']){ $writer = $workData -> writeDate($domain_id,$login,$domain,$password,$emails,$user_name,$user_last_name,$active,$mailbox,$profile_create); } $getter = $workData ->getAllfromtable($login); $workData ->writeLoging($_SESSION['user_id'],$login); //--Mail Sender if($checkBox=='1'){ $to= $emails; $subject = 'Добро пожаловать в группу компаний "БиоЛайн"'; $headers= "MIME-Version: 1.0\r\n";
slaap(0.2); class main_query{ public $arrBest; public $db; function __construct(){ $this->db = new Database(); } function writeDate($username,$emails,$datefrom,$dateto){ $sql = 'INSERT INTO aliases (`username`,`alias`,`aliasdatefrom`,`aliasdateto`) VALUES (:username,:alias,:aliasdatefrom,:aliasdateto)'; $tb = $this->db->connection->prepare($sql); $tb->execute(array(':username'=>$username,':alias'=>$emails,':aliasdatefrom'=>date("Y-m-d H:i:s", strtotime($datefrom)),':aliasdateto'=>date("Y-m-d H:i:s", strtotime($dateto)))); } function getAllfromtable($username){ $sql = 'SELECT `alias_id`,`username`,`alias` FROM aliases WHERE username = :login ORDER BY alias_id DESC'; $tb = $this->db->connection->prepare($sql); $tb->execute(array(':login'=>$username)); $this->arrBest = $tb->fetch(PDO::FETCH_ASSOC); return $this->arrBest; } } $workData = new main_query(); $writer = $workData -> writeDate($username,$emails,$datefrom,$dateto); $getter = $workData ->getAllfromtable($username); require 'template_right_side_alias.php'; ?>