teeeee

<?php
$server='localhost';
$user='root';
$password='';
$DB_NAME ='';


try
{
    $pdoconn = new PDO("mysql:host=$server; dbname=$DB_NAME", $user,
            $password, array(PDO::MYSQL_ATTR_INIT_COMMAND=>"SET NAMES utf8"));
    $pdoconn->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);

    $sqlset="SET NAMES 'utf8';";
    $sql="CREATE DATABASE IF NOT EXISTS autodb "
            . "CHARACTER SET utf8 "
            . "COLLATE utf8_hungarian_ci;";

    $use="USE autodb;";

    $sql2="CREATE TABLE IF NOT EXISTS auto_csop ("
          ."auto_csop_nev VARCHAR(6) NOT NULL,"
          ."km_dij INT(3) DEFAULT NULL,"
          ."napi_dij INT(5) DEFAULT NULL,"
          ."PRIMARY KEY (auto_csop_nev) );";

    $sql3="CREATE TABLE IF NOT EXISTS autok ("
         ."rendszam CHAR(7) NOT NULL,"
         ."tipus_nev VARCHAR(15) DEFAULT NULL,"
         ."auto_csop_nev VARCHAR(6) DEFAULT NULL,"
         ."vasarlas_datuma DATE DEFAULT NULL,"
         ."ar INT(10) DEFAULT NULL,"
         ."futott_km INT(6) DEFAULT NULL,"
         ."ut_szerviz INT(6) DEFAULT NULL,"
         ."allapot CHAR(1) DEFAULT NULL,"
         ."reszleg CHAR(2) DEFAULT NULL,"
         ."PRIMARY KEY (rendszam),"
         ."CONSTRAINT autok_auto_csop FOREIGN KEY (auto_csop_nev) REFERENCES auto_csop(auto_csop_nev) ON DELETE RESTRICT ON UPDATE RESTRICT);";


        $pdoconn->beginTransaction();
    $pdoconn->exec($sqlset);
    $pdoconn->exec($sql);
    $pdoconn->exec($use);
    $pdoconn->exec($sql2);
    $pdoconn->exec($sql3);
    $pdoconn->commit();

    echo "Bajnok vagy teeeee!";


}
catch (Exception $ex) <?php
$server='localhost';
$user='root';
$password='';
$DB_NAME ='';


try
{
    $pdoconn = new PDO("mysql:host=$server; dbname=$DB_NAME", $user,
            $password, array(PDO::MYSQL_ATTR_INIT_COMMAND=>"SET NAMES utf8"));
    $pdoconn->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);

    $sqlset="SET NAMES 'utf8';";
    $sql="CREATE DATABASE IF NOT EXISTS autodb "
            . "CHARACTER SET utf8 "
            . "COLLATE utf8_hungarian_ci;";

    $use="USE autodb;";

    $sql2="CREATE TABLE IF NOT EXISTS auto_csop ("
          ."auto_csop_nev VARCHAR(6) NOT NULL,"
          ."km_dij INT(3) DEFAULT NULL,"
          ."napi_dij INT(5) DEFAULT NULL,"
          ."PRIMARY KEY (auto_csop_nev) );";

    $sql3="CREATE TABLE IF NOT EXISTS autok ("
         ."rendszam CHAR(7) NOT NULL,"
         ."tipus_nev VARCHAR(15) DEFAULT NULL,"
         ."auto_csop_nev VARCHAR(6) DEFAULT NULL,"
         ."vasarlas_datuma DATE DEFAULT NULL,"
         ."ar INT(10) DEFAULT NULL,"
         ."futott_km INT(6) DEFAULT NULL,"
         ."ut_szerviz INT(6) DEFAULT NULL,"
         ."allapot CHAR(1) DEFAULT NULL,"
         ."reszleg CHAR(2) DEFAULT NULL,"
         ."PRIMARY KEY (rendszam),"
         ."CONSTRAINT autok_auto_csop FOREIGN KEY (auto_csop_nev) REFERENCES auto_csop(auto_csop_nev) ON DELETE RESTRICT ON UPDATE RESTRICT);";


        $pdoconn->beginTransaction();
    $pdoconn->exec($sqlset);
    $pdoconn->exec($sql);
    $pdoconn->exec($use);
    $pdoconn->exec($sql2);
    $pdoconn->exec($sql3);
    $pdoconn->commit();

    echo "Bajnok vagy teeeee!";


}
catch (Exception $ex)
{
    die("HIBA!".$ex->getMessage());
}





{
    die("HIBA!".$ex->getMessage());
}