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; }