scarecrowVidDB
CUSTOMER
idCUSTOMER
fname
lname
address
city
state
IMDb_ID(1)
IMDb_ID(2)
movRenStart
movRenEnd
PRIMARY

RENT/BUY
IMDb_ID
Type
Title
Year
Plot
Actors
Director
Writer
Country
Languages
Metascore
imdbVotes
imdbRating
Rated
Runtime
Released
quantity
price
Genre
PRIMARY

function MyViewModel() {
    var self = this;


    self.movies = ko.observableArray();
    self.searchTerm = ko.observable();
    self.moreInfo = ko.observableArray();

    self.currentMovie = {
        Type: ko.observable(),
        Year: ko.observable(),
        Genre: ko.observable(),
        Released: ko.observable(),
        Runtime: ko.observable(),
        Poster: ko.observable(),
        Rated: ko.observable(),
        imdbID: ko.observable(),
        imdbRating: ko.observable(),
        imdbVotes: ko.observable(),
        Metascore:ko.observable(),
        Actors: ko.observable(),
        Plot: ko.observable(),
        Writer: ko.observable(),
        Director: ko.observable(),
        Country: ko.observable(),
        Language: ko.observable(),
        Title: ko.observable()
    };


    self.error = ko.observable(false);
    self.errorMessage = ko.observable();

    self.searchForMovies = function () {
         if($(".searchForm").val() == ""){
             alert("Please Enter a search movie!")
             return;
         }

        $.getJSON("http://www.omdbapi.com/?apikey=f133f8f8&s=" + self.searchTerm(), {
        }).done(function (data) {
            self.error(false);
            self.errorMessage('');

            if (data.Search) {
                ko.mapping.fromJS(data.Search, {}, self.movies);
            } else {
                self.error(true);
                self.errorMessage(data.Error);
            }
        });
    };

    self.viewMoreInfo = function (movie) {
        $.getJSON("http://omdbapi.com/?apikey=f133f8f8&t=" + movie.Title(), {
        }).done(function (data) {
            self.error(false);
            self.errorMessage('');

            if (data) {
                ko.mapping.fromJS(data, {}, self.currentMovie);
            } else {
                self.error(true);
                self.errorMessage(data.Error);
            }
        });
    };

    self.clear = function(){
        $(".searchForm").val("");
        $(".results").fadeOut("fast");
    };
};



ko.applyBindings(new MyViewModel());

<?php
/**
 * Created by PhpStorm.
 * User: ***********
 * Date: 3/10/18
 * Time: 5:31 AM
 */

$servername = "localhost";
$username = "root";
$password = "";
$db = "scarecrowVidDB";

// Create a connection

$con = mysqli_connect($servername, $username, $password,$db);

// Check the connection
if(!$con){
    die("The connection failed: ".mysqli_connect_error());
}

<?php
/**
 * Created by PhpStorm.
 * User: *************
 * Date: 3/9/18
 * Time: 3:41 PM
 */
include "DB.php";
if(isset($_POST["imdb_ID"])){
    **$movie_query = 'INSERT INTO scarecrowVidDB.`RENT/BUY`';**
    $run_query = mysqli_query($con, $movie_query);

    if(mysqli_num_rows($run_query)> 0){
        while($row = mysqli_fetch_array($run_query)){
            $cat_ID = $row['category_ID'];
            $imdbID = $row['IMDb_ID'];
            $Title = $row['title'];
            $Year = $row['year'];
            $Price = $row['price'];

        }
    }
}