echo $disp_year; ?> Movies Based on BooksRead the Book Before You See the Movie. Which is better? You decide. Browse movies based on books.
$book1 = "";
$book2 = "";
$book3 = "";
$book4 = "";
$book5 = "";
if($year == 2008)
{
$book1 = 1243;
$book2 = 1247;
$book3 = 1257;
$book4 = 1160;
$book5 = 1273;
}
else if($year == 2013)
{
$book1 = 1439;
$book2 = 1430;
$book3 = 1442;
$book4 = 1441;
$book5 = 1438;
}
else if($year == 2012)
{
$book1 = 1407;
$book2 = 1408;
$book3 = 1389;
$book4 = 1409;
$book5 = 1419;
}
else if($year == 2011)
{
$book1 = 1362;
$book2 = 1335;
$book3 = 1364;
$book4 = 1368;
$book5 = 1366;
}
else if($year == 2010)
{
$book1 = 1291;
$book2 = 1296;
$book3 = 1350;
$book4 = 1311;
$book5 = 1343;
}
else if($year == 2009)
{
$book1 = 1197;
$book2 = 1270;
$book3 = 1235;
$book4 = 1223;
$book5 = 1234;
}
else if($year == 2007)
{
$book1 = 1155;
$book2 = 1152;
$book3 = 1165;
$book4 = 1144;
$book5 = 1151;
}
else if($year == 2006)
{
$book1 = 1087;
$book2 = 1090;
$book3 = 1092;
$book4 = 1084;
$book5 = 1111;
}
else if($year == 2005)
{
$book1 = 1018;
$book2 = 1047;
$book3 = 1035;
$book4 = 1041;
$book5 = 1015;
}
else if($year == 2004)
{
$book1 = 60;
$book2 = 54;
$book3 = 52;
$book4 = 57;
$book5 = 68;
}
else if($year == 2003)
{
$book1 = 30;
$book2 = 3;
$book3 = 11;
$book4 = 6;
$book5 = 19;
}
else if($year == 2002)
{
$book1 = 117;
$book2 = 108;
$book3 = 106;
$book4 = 100;
$book5 = 86;
}
else if($year == 2001)
{
$book1 = 152;
$book2 = 124;
$book3 = 143;
$book4 = 167;
$book5 = 120;
}
else if($year == 2000)
{
$book1 = 176;
$book2 = 191;
$book3 = 183;
$book4 = 200;
$book5 = 189;
}
?>Dorothy of Oz (Fantasy, Children's Book, Classic, Fairy Tale, Adaptation)


 PLOT: Dorothy Gale (Lea Michele) finds that her beloved Kansas is just a shadow of its former glory after the tornado hit. Soon she travels back to Oz where she is startled by the state of the land, the disappearance of her yellow brick road companions and the replacement of The Wizard. Since his departure The Jester (Martin Short) has taken over and no one is happy about it. Dorothy meets a new group of friends including a marshmallow man (Hugh Dancy), a tugboat (Patrick Stewart) and a china doll princess (Megan Hilty) who are determined to make things right again. AUTHOR: Roger S. Baum

|
echo "" . $disp_year . " Movies Based On Books List"; ?> |
| Movie Title | Book Title | Author |
/* if ($HTTP_SERVER_VARS["HTTP_X_FORWARDED_FOR"] != "")
{
$IP = $HTTP_SERVER_VARS["HTTP_X_FORWARDED_FOR"];
}
else
{
$IP = $HTTP_SERVER_VARS["REMOTE_ADDR"];
}
if ($IP == "")
{
$IP = GetHostByName($REMOTE_ADDR);
} */
if ($bbuserinfo['userid'] == 1)
{
$admin = "klance1";
}
if ($year >= 1980)
{
$query = "SELECT * FROM books WHERE year = '$year' ORDER BY movie";
}
else
{
$lowbnd = $year/10;
$lowbnd = floor($lowbnd) * 10;
$highbnd = $lowbnd + 10;
$query = "SELECT * FROM books WHERE year >= '$lowbnd' && year < '$highbnd' ORDER BY movie";
}
$result = mysqli_query($connection, $query);
// display result rows alphabetized by movie title
$j=0;
while ($row = mysqli_fetch_array($result))
{
$bookid = stripslashes($row['book_id']);
$mov_year = stripslashes($row['year']);
$movie = stripslashes($row['movie']);
$book = stripslashes($row['book']);
$book_year = stripslashes($row['book_year']);
$author = stripslashes($row['author']);
$bookasin = stripslashes($row['bookasin']);
echo " ";
if ($bookasin)
{
echo "";
}
if ($mov_year < 1980)
{
echo $movie." (".$mov_year.")";
}
else
{
echo $movie;
}
if ($bookasin)
{
echo "";
}
if ($admin == "klance1")
{
echo " (edit)";
}
echo " | ".$book;
if ($book_year)
{
echo " (".$book_year.")";
}
echo " | ".$author." | ";
$j++;
} ?>
A good book is the best of friends, the same today and forever.
~Martin Farquhar Tupper
|