<?php
 $fname = filter_input(INPUT_POST, 'firstName');
 $lname = filter_input(INPUT_POST, 'lastName');
 $email = filter_input(INPUT_POST, 'eventEmail');
 $mobile = filter_input(INPUT_POST, 'pNumber');

 if (!empty($fname)){
    if (!empty($lname)){
        if (!empty($email)){
             if (!empty($mobile)){
                $host = "localhost";
                $dbusername = "root";
                $dbpassword = "";
                $dbname = "attendee";
                $port="3307";
               // 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 badge (fname,lname, email,mobile) values ('$fname','$lname', '$email', '$mobile')";}
                if ($conn->query($sql)){
                          echo'hna code html ila bghiti ';
//wla diri
include("path lfile li bghiti");

                                         }
                else{
                           echo "Error: ". $sql ."". $conn->error;
                        }
                $conn->close();

               }
               else {
            echo "Please enter your mobile number";
            die();
                }

                    }
                   else {
            echo "Please enter your email";
            die();
             }

                }
                else {
     echo "Last name should not be empty";
     die();
        }

 }

else {
    echo "Username should not be empty";
    die();
     }
?>