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;
}
?>The Mortal Instruments: City of Bones (Young Adult, Fantasy, Demons, Adaptation)


 PLOT: Clary Fray (Lily Collins) is an average New York City teen, that is until she witnesses a murder and all those involved disappear before her eyes. It is learned that the victim is a demon and she was a witness to the work of the Shadowhunters. But why? What makes her able to see things others can't? After her mother (Lena Headey) is attacked and taken away, Clary uncovers parts of her past and family history that put her on the path to an unsettling answer. AUTHOR: Cassandra Clare

|
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
|