<?php
$localhost='127.0.0.1';
$user = 'root';
$password = '';
$conn = mysqli_connect($localhost, $user, $password);
// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

// Create database
$sql = "CREATE DATABASE bazka";
if (mysqli_query($conn, $sql)) {
    echo "Database created successfully";
} else {
    echo "Error creating database: " . mysqli_error($conn);
}

mysqli_close($conn);
$database = 'bazka';
mysqli_connect("localhost","root","");

$conn = mysqli_connect($localhost, $user, $password,$database);
$sql = "CREATE TABLE tabelka (
klucz int(5) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
imie varchar(20) NOT NULL,
nazwisko VARCHAR(30) NOT NULL,
pesel VARCHAR(11) NOT NULL,
znak int(3)
)";
$sql = "CREATE TABLE znakzodiaku (
znakZodiaku int(3)
)";
mysqli_query($conn, $sql);
mysqli_close($conn);

?>