Untitled

<?php
$profpic = "bg.jpg";
?>

<head>
    <link rel="shortcut icon" type="image/x-icon" href="favicon.ico" />
<style type="text/css">
    body
    {
        background-image:url('<?php echo $profpic ?>');
    }
</style>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Cinema</title>
 </head>
<?php
 $nev = $_POST["nev"];
 $varos = $_POST["city"];
 $utca = $_POST["street"];
 $hazszam = $_POST["number"];
 $uname = $_POST["uname"];
 $pass = $_POST["pass"];
 $felh = "kibfc6";
 $jelszo = "eashobev";

       try
       {
          $dbh = new PDO('mysql:host=localhost;dbname=kibfc6', $felh, $jelszo);
            $sql= "SELECT mozi_nev, varos, hazszam FROM mozi WHERE mozi_nev='".$nev."' AND
                                                                     varos='".$varos."' AND
                                                                     hazszam='".$hazszam."'";
            $result = $dbh->query($sql);
            $num=$result->rowCount();
            if($num==0)
            {
                $sth = $dbh->prepare("INSERT INTO mozi (mozi_nev, varos, utca, hazszam) VALUES ('".$nev."','".$varos."','".$utca."','".$hazszam."')");
                $sth->execute();

                $sql = "SELECT mozi_id FROM mozi WHERE mozi_nev='".$nev."' AND varos='".$varos."' AND hazszam='".$hazszam."'";
                $sth2 = $dbh->query($sql);
                $sth2->setFetchMode(PDO::FETCH_OBJ);
                $row = $sth2->fetch();
                $moziid = $row->mozi_id;
                $sth3 = $dbh->prepare("INSERT INTO ulohelyek (szek_id, foglalt, m_sor, m_oszlop, szek_szam, mozi_id) VALUES (NULL, 0, 1, 1, 1, '".$moziid."'), (NULL, 0, 1, 2, 2, '".$moziid."'), (NULL, 0, 1, 3, 3, '".$moziid."'), (NULL, 0, 1, 4, 4, '".$moziid."'), (NULL, 0, 1, 5, 5, '".$moziid."'), (NULL, 0, 1, 6, 6, '".$moziid."'), (NULL, 0, 1, 7, 7, '".$moziid."'), (NULL, 0, 1, 8, 8, '".$moziid."'), (NULL, 0, 1, 9, 9, '".$moziid."'), (NULL, 0, 1, 10, 10, '".$moziid."'), (NULL, 0, 1, 11, 11, '".$moziid."'), (NULL, 0, 1, 12, 12, '".$moziid."'), (NULL, 0, 2, 1, 1, '".$moziid."'), (NULL, 0, 2, 2, 2, '".$moziid."'), (NULL, 0, 2, 3, 3, '".$moziid."'), (NULL, 0, 2, 4, 4, '".$moziid."'), (NULL, 0, 2, 5, 5, '".$moziid."'), (NULL, 0, 2, 6, 6, '".$moziid."'), (NULL, 0, 2, 7, 7, '".$moziid."'), (NULL, 0, 2, 8, 8, '".$moziid."'), (NULL, 0, 2, 9, 9, '".$moziid."'), (NULL, 0, 2, 10, 10, '".$moziid."'), (NULL, 0, 2, 11, 11, '".$moziid."'), (NULL, 0, 2, 12, 12, '".$moziid."'), (NULL, 0, 3, 1, 1, '".$moziid."'), (NULL, 0, 3, 2, 2, '".$moziid."'), (NULL, 0, 3, 3, 3, '".$moziid."'), (NULL, 0, 3, 4, 4, '".$moziid."'), (NULL, 0, 3, 5, 5, '".$moziid."'), (NULL, 0, 3, 6, 6, '".$moziid."'), (NULL, 0, 3, 7, 7, '".$moziid."'), (NULL, 0, 3, 8, 8, '".$moziid."'), (NULL, 0, 3, 9, 9, '".$moziid."'), (NULL, 0, 3, 10, 10, '".$moziid."'), (NULL, 0, 3, 11, 11, '".$moziid."'), (NULL, 0, 3, 12, 12, '".$moziid."'), (NULL, 0, 4, 1, 1, '".$moziid."'), (NULL, 0, 4, 2, 2, '".$moziid."'), (NULL, 0, 4, 3, 3, '".$moziid."'), (NULL, 0, 4, 4, 4, '".$moziid."'), (NULL, 0, 4, 5, 5, '".$moziid."'), (NULL, 0, 4, 6, 6, '".$moziid."'), (NULL, 0, 4, 7, 7, '".$moziid."'), (NULL, 0, 4, 8, 8, '".$moziid."'), (NULL, 0, 4, 9, 9, '".$moziid."'), (NULL, 0, 4, 10, 10, '".$moziid."'), (NULL, 0, 4, 11, 11, '".$moziid."'), (NULL, 0, 4, 12, 12, '".$moziid."'), (NULL, 0, 5, 1, 1, '".$moziid."'), (NULL, 0, 5, 2, 2, '".$moziid."'), (NULL, 0, 5, 3, 3, '".$moziid."'), (NULL, 0, 5, 4, 4, '".$moziid."'), (NULL, 0, 5, 5, 5, '".$moziid."'), (NULL, 0, 5, 6, 6, '".$moziid."'), (NULL, 0, 5, 7, 7, '".$moziid."'), (NULL, 0, 5, 8, 8, '".$moziid."'), (NULL, 0, 5, 9, 9, '".$moziid."'), (NULL, 0, 5, 10, 10, '".$moziid."'), (NULL, 0, 5, 11, 11, '".$moziid."'), (NULL, 0, 5, 12, 12, '".$moziid."'), (NULL, 0, 6, 1, 1, '".$moziid."'), (NULL, 0, 6, 2, 2, '".$moziid."'), (NULL, 0, 6, 3, 3, '".$moziid."'), (NULL, 0, 6, 4, 4, '".$moziid."'), (NULL, 0, 6, 5, 5, '".$moziid."'), (NULL, 0, 6, 6, 6, '".$moziid."'), (NULL, 0, 6, 7, 7, '".$moziid."'), (NULL, 0, 6, 8, 8, '".$moziid."'), (NULL, 0, 6, 9, 9, '".$moziid."'), (NULL, 0, 6, 10, 10, '".$moziid."'), (NULL, 0, 6, 11, 11, '".$moziid."'), (NULL, 0, 6, 12, 12, '".$moziid."'), (NULL, 0, 7, 1, 1, '".$moziid."'), (NULL, 0, 7, 2, 2, '".$moziid."'), (NULL, 0, 7, 3, 3, '".$moziid."'), (NULL, 0, 7, 4, 4, '".$moziid."'), (NULL, 0, 7, 5, 5, '".$moziid."'), (NULL, 0, 7, 6, 6, '".$moziid."'), (NULL, 0, 7, 7, 7, '".$moziid."'), (NULL, 0, 7, 8, 8, '".$moziid."'), (NULL, 0, 7, 9, 9, '".$moziid."'), (NULL, 0, 7, 10, 10, '".$moziid."'), (NULL, 0, 7, 11, 11, '".$moziid."'), (NULL, 0, 7, 12, 12, '".$moziid."'), (NULL, 0, 8, 1, 1, '".$moziid."'), (NULL, 0, 8, 2, 2, '".$moziid."'), (NULL, 0, 8, 3, 3, '".$moziid."'), (NULL, 0, 8, 4, 4, '".$moziid."'), (NULL, 0, 8, 5, 5, '".$moziid."'), (NULL, 0, 8, 6, 6, '".$moziid."'), (NULL, 0, 8, 7, 7, '".$moziid."'), (NULL, 0, 8, 8, 8, '".$moziid."'), (NULL, 0, 8, 9, 9, '".$moziid."'), (NULL, 0, 8, 10, 10, '".$moziid."'), (NULL, 0, 8, 11, 11, '".$moziid."'), (NULL, 0, 8, 12, 12, '".$moziid."'), (NULL, 0, 9, 1, 1, '".$moziid."'), (NULL, 0, 9, 2, 2, '".$moziid."'), (NULL, 0, 9, 3, 3, '".$moziid."'), (NULL, 0, 9, 4, 4, '".$moziid."'), (NULL, 0, 9, 5, 5, '".$moziid."'), (NULL, 0, 9, 6, 6, '".$moziid."'), (NULL, 0, 9, 7, 7, '".$moziid."'), (NULL, 0, 9, 8, 8, '".$moziid."'), (NULL, 0, 9, 9, 9, '".$moziid."'), (NULL, 0, 9, 10, 10, '".$moziid."'), (NULL, 0, 9, 11, 11, '".$moziid."'), (NULL, 0, 9, 12, 12, '".$moziid."')");
                $sth3->execute();
                sikeres($uname, $pass);
            }
            else
            {
                foglalt($uname, $pass);
            }
        }
        catch (PDOException $e)
        {
            print "Hiba!: " . $e->getMessage() . "<br/>";
            die();
        }

    function sikeres($uname, $pass)
    {
        $username = $uname;
        $password = $pass;
        echo '<br></br>';
        echo '<p style="color: yellow; text-align: center"> Mozi sikeresen hozzáadva </p>';
        echo "<html>";
        echo '<form method="POST" action="mozi_hozzaad.php" style="text-align: center">
              <input type="hidden" name="uname" value='.$username.'>
              <input type="hidden" name="pass" value='.$password.'>
              <input style="background: yellow; border: none;" text-align="center" type="submit" value="Vissza">
              </form>';
        echo "</html>";
    }

    function foglalt($uname, $pass)
    {
        $username = $uname;
        $password = $pass;
        echo '<br></br>';
        echo '<p style="color: yellow; text-align: center"> Ezt a mozit már regisztrálták </p>';
        echo "<html>";
        echo '<form method="POST" action="mozi_hozzaad.php" style="text-align: center">
              <input type="hidden" name="uname" value='.$username.'>
              <input type="hidden" name="pass" value='.$password.'>
              <input style="background: yellow; border: none;" text-align="center" type="submit" value="Vissza">
              </form>';
        echo "</html>";
    }

    $dbh = null;
?>