<?php

$host = "localhost";
$user = "root";
$pass = "coderslab";
$db = "ex_1";

try {
    $conn = new PDO(
        "mysql:host=$host;dbname=$db;charset=UTF8",
        $user,
        $pass,
        [
            PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
        ]
    );

    $sql = "
    CREATE TABLE student( id int AUTO_INCREMENT, name varchar(20), number int, PRIMARY KEY(id));
    ";


    $res = $conn->query($sql);
    if($res){
       echo 'Działa!';
    }else{
        echo 'Nie działa!';
    }

} catch (PDOException $e) {
    echo $e->getMessage();
}

echo("Polaczenie udane.");
$conn = null;