$username = "root";
$email    = "";
$errors = array();
$servername = "localhost";
$password = "root";
$dbname = "registration";
try {
    $db = new PDO("mysql:host=$servername", $username, $password);
    // set the PDO error mode to exception
    $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $sql = "CREATE DATABASE registration";
    // use exec() because no results are returned
    $conn->exec($sql);
    echo "Database created successfully<br>";
    }
catch(PDOException $e)
    {
    echo $sql . "<br>" . $e->getMessage();
    }
// connect to the database
$db = mysqli_connect('localhost', 'root', 'root', 'registration');
$sql = "CREATE TABLE users (
  id INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  `username` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `token` varchar(100) NOT NULL,
  `pwd` varchar(100) NOT NULL
  )";