function actionAddUser($view) { $view->menu = menu::getDataMenu(); $userDataArray = array(); $userDataArray['login'] = $_POST['login']; $userDataArray['password'] = $_POST['password']; $userDataArray['dblPassword'] = $_POST['dblPassword']; $userDataArray['email'] = $_POST['email']; $userDataArray['user_name'] = $_POST['user_name']; $userDataArray['user_surname'] = $_POST['user_surname']; if ($userDataArray['password'] !== $userDataArray['dblPassword']) { $view->userDataArray = $userDataArray; $view->message = " Пароли не совпадают !"; echo $view->render('registration.php'); return false; } if (!$userDataArray['login'] || !$userDataArray['password'] || !$userDataArray['dblPassword'] || !$userDataArray['email'] || !$userDataArray['user_name'] || !$userDataArray['user_surname']) { $view->userDataArray = $userDataArray; $view->message = " Введены не все данные !"; echo $view->render('registration.php'); return false; } $userDataArray = checkClass::checkAll($userDataArray); $query = "SELECT user_id FROM user WHERE user.user_login ="******";"; if (getDataBase::getData($query, 1)) { $view->userDataArray = $userDataArray; $view->message = " Данный логи занят"; echo $view->render('registration.php'); return false; } $query = "INSERT INTO `maket`.`user` (`user_id` ,`user_login` ,`user_password` ,`user_status` ,`user_block`)\r\n VALUES (NULL , '" . $userDataArray['login'] . "','" . $userDataArray['dblPassword'] . "', 'student', '0');"; if (!self::addData($query)) { $view->userDataArray = $userDataArray; $view->message = " Регистрация не удалась, попробуйте позже"; echo $view->render('registration.php'); return false; } $query = "SELECT user_id FROM user WHERE user.user_login ="******";"; $id = getDataBase::getData($query, 1); if (!$id) { $view->userDataArray = $userDataArray; $view->message = " Регистрация не удалась, попробуйте позже"; echo $view->render('registration.php'); return false; } $query = "INSERT INTO `maket`.`user_data` (`user_data_id`, `user_id`, `user_data_name`, `user_data_surname`,\r\n `user_data_email`, `user_data_secret_w`, `user_data_secret_a`, `user_data_cantry`, `user_data_sity`)\r\n VALUES (NULL, '" . $id . "', '" . $userDataArray['user_name'] . "', '" . $userDataArray['user_surname'] . "',\r\n '" . $userDataArray['email'] . "', \\'апап\\', \\'апа\\', \\'Беларусь\\', \\'Минск\\');"; if (!self::addData($query)) { $view->userDataArray = $userDataArray; $view->message = " Регистрация не удалась, попробуйте позже"; echo $view->render('registration.php'); return false; } $view->message = " Регистрация не удалась, попробуйте позже"; echo $view->render('addUser.php'); }
public static function getDataComment($array) { $query = 'SELECT comment_user,comment_date,comment_text,news_id FROM `comment` where news_id=' . $array[0]; return parent::getData($query); }
public static function getDataArticle() { return parent::getData(self::$query); }