<?php
$host = 'localhost';
$db   = 'id3256707';
$user = 'admin';
$pass = '-';
$charset = 'utf8mb4';

$options=[
PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
PDO::ATTR_EMULATE_PREPARES   => false, ];

try {
$pdo = new PDO("mysql:host=$host;dbname=$db;charset=$charset", $user, $pass, $options);
$sql=$pdo->prepare(("INSERT INTO utilizatori(prenume, nume, email, parola) VALUES(:prenume, :nume, :email, :parola)"));
$pdo->execute(array(':prenume'=>$prenume, ':nume'=>$nume, ':email'=>$email, ':parola'=>$parola));

$prenume = $_POST['prenume'];
$nume = $_POST['nume'];
$email = $_POST['email'];
$parola = $_POST['parola'];
$stmt->bindParam(':prenume', $prenume);
$stmt->bindParam(':nume', $nume);
$stmt->bindParam(':email', $email);
$stmt->bindParam(':parola', $parola);
$stmt->execute();
echo "New records created successfully";
}catch(PDOException $e){
  echo "Error: " . $e->getMessage();
}
$pdo= null;