<?php
$firstname= $_POST['firstname'];
$surname=$_POST['surname'];
$email=$_POST['email'];
$phonenumber=$_POST['phonenumber'];
$Localmovie=$_POST['movie'];
$session=$_POST['session'];
$day=$_POST['day'];

if (!empty($firstname) || !empty($surname) || !empty($email) || !empty($phonenumber) || !empty($Localmovie) || !empty($session) || !empty($day)) {
        $host = "localhost";
        $dbUsername= "root";
        $dbPassword="";
        $dbName="tickets";

        //create connection
        $conn= new mysqli($host, $dbUsername, $dbPassword, $dbName);

        if (mysqli_connect_error()) {
        die('Connect
Error('.mysqli_connect_errno().')'.mysqli_connect_error());
    }else{


             //$sql = "INSERT INTO tutorials_inf(name)VALUES ('".$_POST["name"]."')";
            $sql= "INSERT INTO movie
                        (firstname, surname, phonenumber, email, movie, session, day)
                   values($firstname, $surname, $email,
$phonenumber, $Localmovie, $session, $day)";
            if (mysqli_query($conn, $sql)) {
               echo "New record created successfully";
            } else {
               echo "Error: " . $sql . "" . mysqli_error($conn);
            }
            $conn->close();