<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = 'MySQLLesson';

$dbh = new mysqli($servername, $username, $password);

if ($dbh->connect_error) {
    die($dbh->connect_error);
}

if (!$dbh->query("CREATE DATABASE `".$dbname."`")) {
    die($dbh->error);
}

if (!$dbh->select_db($db_name)){
    die($dbh->error);
}

$sql = "CREATE TABLE users(
        id INT(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
        name VARCHAR(30) NOT NULL,
        surname VARCHAR(30) NOT NULL UNIQUE,
        password VARCHAR(30) NOT NULL)";

if(!$dbh->query($sql)){
    die($dbh->error);
}

$dbh->close();