$dbUser = 'testUser';
$dbPassword = 'testPassword';
$dbCharset='utf-8';
$dbName = 'testDb';
$dbHost = 'localhost';

$dsn = sprintf("mysql:host=%s;dbname=%s;charset=%s",$dbHost,$dbName,$dbCharset);
$pdo = new PDO($dsn,$dbUser,$dbPassword);
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_OBJ);

$sql = "INSERT INTO users(nickname, name, surname, email, password) VALUES(:nickName,:name,:surname,:email,:password)";
$data = [
':nickName' => $nickname,
':name' => $name,
':surname' => $surname,
':email' => $email,
':password' => $pass_1
];

$statement = $pdo->prepare($sql);

$result = $statement->execute($data);
if($result){
echo "Вы успешно зарегистрированы! Теперь вы можете зайти на сайт.";
}else{
echo "Ошибка! Вы не зарегистрированы.";
}