// Creare baza de date - fisier creareBazaDeDate.php

<?php

$server = "localhost";
$user = "root";
$password = "";

//Connect to the server
$conn = new mysqli($server, $user, $password);

if ($conn->connect_error) {
    die("Can't connect, " . $conn->connect_error);
}

// Create the database
$db = ("CREATE DATABASE Tasker"); // aici pui numele de la baza de date pe care vrei sa o construiesti
if ($conn->query($db) == True) {
    echo "Database created successfully";
} else {
    echo "Error!" . $conn->query($db);
}

$conn->close();

// Folosire baza de date - fisier init.php

<?php

session_start();

$db = new PDO('mysql:dbname=tasker;host=localhost', 'root', ''); // numele de la baza de date pe care ai construit-o

if (!isset($_SESSION['user_id'])) {
    header("Location: login.php");
}

// Creare tabel cu informatii - fisier creareTabel.php

<?php

$server = "localhost";
$user = "root";
$password = "";
$db = "tasker";

$conn = new mysqli($server, $user, $password, $db);

if ($conn->connect_error) {
    die("Can't connect " . $conn->connect_error);
}

// modifici campurile cu ce ai tu nevoie

$users = "CREATE TABLE users(
        user_id INT(6) AUTO_INCREMENT PRIMARY KEY,
        user_name VARCHAR(50),
        user_email VARCHAR(50),
        user_password VARCHAR(256)
)";