Germany
PDOStatement Object ( [queryString] => SELECT T1.id, T1.sortby, T1.year, T1.genres, T1.score, T1.imdb_id, T1.certification, T1.runtime, T2.user_rating FROM movie_info T1, user_movie_settings T2 WHERE T1.id = T2.id )<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=iso-8859-1" />
<script type="text/javascript" src="javascript/mootools1.2.1.js"></script>
<script type="text/javascript" src="javascript/movies.js"></script>
<script type="text/javascript" src="javascript/sorttable.js"></script>
<link rel="stylesheet" href="css/main.css" type="text/css" media="screen" charset="utf-8" />
<title>HTPC Movies</title>
</head>
<body>
<center>The HTPC's Flicks...</center><p>
<?php
/*
"SELECT T1.title FROM movie_info T1, user_movie_settings T2 WHERE T1.ID = T2.ID AND T2.watched > 0"
This select statement should give you a list of movies that have been watched. You could add an 'ORDER BY T2.watched DESC' at the end of that and it will also give you a top down from most watched to least watched movie.
*/
try {
/*** connect to SQLite database ***/
$dbh = new PDO("sqlite:./movingpictures.db3");
}
catch(PDOException $e){
echo $e->getMessage();
}
$queryStatement = 'SELECT T1.id, T1.sortby, T1.year, T1.genres, T1.score, T1.imdb_id, T1.certification, T1.runtime, T2.user_rating FROM movie_info T1, user_movie_settings T2 WHERE T1.id = T2.id';
//Query results
$stmt = $dbh->query($queryStatement);
?>
<table class="sortable" border='1'>
<thead>
<tr>
<td>ID</td>
<td>Title</td>
<td>Year</td>
<td>Genres</td>
<td>IMDB Score</td>
<td>My Score</td>
<td>Rating</td>
<td>Runtime</td>
<td>IMDB</td>
</tr>
</thead>
<?php
//loop through results to make table
while($next_row = $stmt->fetch(PDO::FETCH_ASSOC))
{
?>
<tr class="movieRow">
<td class="movieid"><?php print($next_row["id"]); ?></td>
<td class="movieTitle"><?php print($next_row["sortby"]); ?></td>
<td class="movieYear"><?php print($next_row["year"]); ?></td>
<td class="movieGenres"><?php print(str_replace('|', ' | ', $next_row["genres"])); ?></td>
<td class="movieScore"><?php print($next_row["score"]); ?></td>
<td class="movieMyScore"><?php print($next_row["user_rating"]); ?></td>
<td class="movieRating"><?php print($next_row["certification"]); ?></td>
<td class="movieLength"><?php print($next_row["runtime"]); ?></td>
<td class="movieImdb"><a href="http://www.imdb.com/title/<?php print($next_row["imdb_id"]); ?>">IMDB</a></td>
</tr>
<?php
}
?>
</table>
<p>
</body>
</html>That page's source is disgusting. There is so much formatting in the page.