Director Movie Search


Search the movie database
0){
        $aname = $arr[1];
     }
   }
  ini_set('display_errors', 'On');
  error_reporting(E_ALL);

   //Make a connection to the mysql server
   $mysqli = new mysqli("sql.cs.oberlin.edu","alice","tiger","imdb");

   if($mysqli->connect_errno){
     echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
   }

   $mysqli->set_charset('utf8mb4');
?>

  Enter an director name to search for:
  
  
  
prepare($query);
  if(!$stmt){
    print("Prepare failed (" . $mysqli->error . ")" );
  }

  if (!$stmt->bind_param("s", $dname)) {
    echo "Binding parameters failed: (" . $stmt->errno . ") " . $stmt->error;
  }

  $stmt->execute();

  $res = $stmt->get_result();

  if($res->num_rows == 0){
    print 'No films found for director '.$dname;
  }
  else {
    print "Films of $dname:";
  }

  // Print the query results as a bulleted list, grouped by genre
  $current_genre = '';
  print '';
  $first = TRUE;
  while ($row = $res->fetch_assoc()) {
    if($row['genre'] != $current_genre){
      // change genre
      if($first)
        $first = FALSE;
      else
        print '';  // end of previous genre
      $current_genre = $row['genre'];
      print '' . $current_genre . '';
      print '';  // start a new genre list
    }
    print '' . $row['title'] . ' (' . $row['year'] . ')';
  }  // end of while
  print '';
}  // end of if $dname
?>