mysql> describe movies;

+----------------------------+--------------+------+-----+---------+----------------+
| Field                      | Type         | Null | Key | Default | Extra          |
+----------------------------+--------------+------+-----+---------+----------------+
| movie_id                   | int(11)      | NO   | PRI | NULL    | auto_increment |
| movie_title                | varchar(256) | YES  |     | NULL    |                |
| movie_screen               | int(11)      | YES  |     | NULL    |                |
| movie_rating               | varchar(32)  | YES  |     | NULL    |                |
| movie_start_date           | int(11)      | YES  |     | NULL    |                |
| movie_end_date             | int(11)      | YES  |     | NULL    |                |
| movie_first_start          | varchar(16)  | YES  |     | NULL    |                |
| movie_first_end            | varchar(16)  | YES  |     | NULL    |                |
| movie_second_start         | varchar(16)  | YES  |     | NULL    |                |
| movie_second_end           | varchar(16)  | YES  |     | NULL    |                |
| movie_first_matinee_start  | varchar(16)  | YES  |     | NULL    |                |
| movie_first_matinee_end    | varchar(16)  | YES  |     | NULL    |                |
| movie_second_matinee_start | varchar(16)  | YES  |     | NULL    |                |
| movie_second_matinee_end   | varchar(16)  | YES  |     | NULL    |                |
| movie_description          | blob         | YES  |     | NULL    |                |
| movie_image                | longblob     | YES  |     | NULL    |                |
| event_user                 | varchar(64)  | YES  |     | NULL    |                |
+----------------------------+--------------+------+-----+---------+----------------+
17 rows in set (0.00 sec)

<?php
$servername = '0.0.0.0';
$user = 'code_monkey';
$password = '';
$db = 'it_342';
$conn =new mysqli($servername, $user, $password, $db);

if ($conn->connect_error)
{
    die('Connection Error: '.$conn->connect_error);
} else {
 //   echo "Connection established";
    }


 $sqlInsertMovie = $conn->prepare("INSERT INTO movies (movie_title, movie_screen, movie_rating,
                  movie_start_date, movie_end_date, movie_first_start, movie_first_end,
                  movie_second_start, movie_second_end, movie_first_matinee_start, movie_first_matinee_end,
                  movie_second_matinee_start, movie_second_matinee_end, movie_description, event_user)
                  VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?, code_monkey )");

                  //var_dump($sqlInsertMovie);

                            $sqlInsertMovie->bind_param("sisiissssssssb",$_POST['movie_name'], $_POST['movie_screen'], $_POST['movie_rating'], $_POST['movie_start_date'],
                            $_POST['movie_end_date'], $_POST['first_evening_start'], $_POST['first_evening_end'], $_POST['second_evening_start'],
                            $_POST['second_evening_end'], $_POST['first_matinee_start'], $_POST['first_matinee_end'], $_POST['second_matinee_start'],
                            $_POST['second_matinee_end'], $_POST['movie_description']);


                            if ($sqlInsertMovie->execute()){
                                echo "Movie added";
                            $_POST = array();
                            }  else {  // failed to execute
                                $error_msg = "Failes to add Movie";
                            }
                            $sqlInsertMovie->close();

?>