from regestarion database in php

php


<?php
try {
    $pdo = new PDO('mysql:host=localhost;dbname=regestarion', 'root', '');
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $pdo->exec('SET NAMES "utf8"');
} catch (PDOException $e) {
    $error = 'Unable to connect to the database server.';
    include 'error.html.php';
    exit();
}

if (isset($_POST['firstname'])) {
    $firstname = $_POST['firstname'];
    $surname = $_POST['surname'];
    $email = $_POST['email'];
    $password = $_POST['password'];
    $password2 = $_POST['password2'];
    $errors = array();
    if ($password != $password2) {
        $errors[] = "the two passwords do not match";
    }
    if (strlen($password