<?php
if (isset($_POST['register'])) {
if ($user) {
$error = "This email address is already associated with an account.";
}
// остальные проверкиclass base{
public $conn;
public function __construct(){
mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$this->conn = mysqli_connect('localhost', 'drops', '', 'teach');
mysqli_set_charset($mysqli, $charset);
}
public function query($query, $params = []) {
if (!$params) {
return $this->conn->query($query);
}
$types = $types ?: str_repeat("s", count($params));
$stmt = $this->conn->prepare($sql);
$stmt->bind_param($types, ...$params);
$stmt->execute();
return $stmt;
}
public function get_row($query, $params = []) {
$stmt = $this->query($query, $params);
return $stmt->get_result()->fetch_assoc(MYSQLI_ASSOC);
}
public function get_all($query, $params = []) {
$stmt = $this->query($query, $params);
return $stmt->get_result()->fetch_all(MYSQLI_ASSOC);
}
}<?php
mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$dbc = mysqli_connect('127.0.0.1', 'root', '', 'buy_sell_base');
mysqli_set_charset($dbc, $charset);
if(isset($_POST['submit'])){
$username = mysqli_real_escape_string($dbc, trim($_POST['username']));
$password1 = trim($_POST['password1']);
$password2 = trim($_POST['password2']);
if($username && $password1 && $password1 == $password2){
$query = "SELECT * FROM signup WHERE username ='$username'";
$data = mysqli_query($dbc, $query);
if(mysqli_num_rows($data) == 0){
$password = password_hash($password1, PASSWORD_DEFAULT);
$query = "INSERT INTO signup (username, password) VALUES ('$username', '$password')";
mysqli_query($dbc, $query);
echo 'Все готово';
exit();
}
else{
echo 'Пользователь уже зарегистрирован';
}
}
}