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