DVDLobby Movie page

Post your HTML code (as attachments) here and a description of what that scene does.
wnl
Member
Member
Posts: 65
Joined: Mon Oct 26, 2009 10:19 pm
Contact:

DVDLobby Movie page

Postby wnl » Fri Mar 11, 2011 6:45 pm

Hello all.

Since I found out we can embed database queries in web pages, I threw together this little web page that lists out all the movies in the DVDLobby database. It's a quick and easy way to look through all my titles on one page from any machine in my house. It also includes slot number because I've found it useful to have that information handy.

If I wanted to take this further, I could put in sorting by arbitrary columns (like slot number) or even add links to pages that describe the individual movies.

Style sheet is embedded in the html. Drop this file somewhere in your HTML folder then open it in a web browser.

Code: Select all

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
<title>Movies</title>
<style type="text/css">
* { font-family: sans-serif; background-color: #8ab; }
h1 { font-size: 14pt; }
table { background-color: #fff; border: solid black 2px; }
th { text-align: left; font-weight: bold; }
th,td { padding: 4px 5px 4px 5px; font-size: 13px; background-color: #fff; }
td.r { text-align: right; }
</style>
</head>

<body>
<h1>Cinemar Theater Movies</h1>

<table id="thelist">
<tr>
<th>Title</th>
<th>Rating</th>
<th>Year</th>
<th>Mins</th>
<th>Slot</th>
</tr>
[[MLQUERY
   Database="Movies.mdb"
   Query Query="Select Movies.Title, Movies.dvdNumber, Movies.MPAARating, Movies.ProductionYear, Movies.RunTime, Left(Movies.SortTitle,1), Movies.SortTitle, MovieDiscs.ChangerSlot From Movies Left Join MovieDiscs ON Movies.dvdNumber=MovieDiscs.dvdNumber Order by Movies.SortTitle, MovieDiscs.ChangerSlot"
   Prototype="<tr><td><P1></td><td><P3></td><td><P4></td><td class="r"><P5></td><td class="r"><P8></td></tr>"
]]
</table>
</body>
</html>

Return to “MLServer HTML Sharing”

Who is online

Users browsing this forum: No registered users and 1 guest