public function valid_register() { //проверка на пустоту обязательных полей if ($_POST['name'] == "") { return false; } if ($_POST['surname'] == "") { return false; } if ($_POST['email'] == "") { return false; } if (!filter_var($_POST['email'], FILTER_VALIDATE_EMAIL)) { return false; } if (!preg_match('/^([a-zA-Z0-9])(\\w|-|_)+([a-z0-9])$/is', $_POST['name'])) { return false; } if (!preg_match('/^([a-zA-Z0-9])(\\w|-|_)+([a-z0-9])$/is', $_POST['surname'])) { return false; } // проверка на сушествование юзера с емейлом $email = $_POST['email']; $db = new connect_disconnect(); $dbconnect = $db->connect(); $query = "SELECT * FROM `users` WHERE email='" . $email . "'"; $result = mysqli_query($dbconnect, $query); $db->disconnect($dbconnect); if ($num = $result->num_rows != 0) { return false; } return true; }
public function get_data() { $db = new connect_disconnect(); $dbconnect = $db->connect(); $query = "SELECT * FROM `feedback`"; $result = mysqli_query($dbconnect, $query); $db->disconnect($dbconnect); $data = array(); while ($row = mysqli_fetch_array($result)) { $arr = array('name' => $row["name"], 'email' => $row["email"], 'text' => $row["text"]); array_push($data, $arr); } return $data; }
public function get_data() { //проверка на нажатие кнопки. валидация на стороне сервера if (isset($_POST['GO2'])) { $vd = new Model_Validation(); if ($vd->valid_feed()) { $name = $_POST['name']; $email = $_POST['email']; $text = $_POST['text']; $req = "INSERT INTO `feedback`(`name`, `email`, `text`) VALUES ('" . $name . "','" . $email . "','" . $text . "')"; $db = new connect_disconnect(); mysqli_query($db->connect(), $req); $db = new connect_disconnect(); header('Location: index.php?feedback'); } } }
public function get_data() { //проверка на нажатие кнопки. валидация на стороне сервера if (isset($_POST['GO'])) { $vd = new Model_Validation(); if ($vd->valid_register()) { $name = $_POST['name']; $surname = $_POST['surname']; $email = $_POST['email']; $sexs = $_POST['sexs']; $birthday = $_POST['birthday']; $req = "INSERT INTO `users`(`name`, `surname`, `email`, `sexs`, `birthday`) VALUES ('" . $name . "','" . $surname . "','" . $email . "','" . $sexs . "','" . $birthday . "')"; $db = new connect_disconnect(); //запись данных в куки пользователя session_start(); mysqli_query($db->connect(), $req); session_start(); $_SESSION['email'] = $email; header('Location: index.php?feedback'); } } }