I wanted to do something JUST like that. Can you give me the PHP script for it? I'm too lazy to re-learn PHP and write one. :p
I learned PHP while writing this and it's gone through a few generations, so I wouldn't use it as a learning tool, but it works.
<html>
<head>
<title>Coop's Game List</title>
</head>
<body>
<h1>Under Construction</h1>
<p>Oooh a filterable list of console games, how exciting!</p>
<?
if ($_POST['action'] == "Filter") {
extract ($_POST);
ListGamesinDB ($PlatformFilter, $GenreFilter, $PlayedFilter);
} else {
$qstring = $_SERVER['QUERY_STRING'];
if ($qstring == ""){
ListGamesInDB ("All","All","All");
} else {
parse_str($qstring);
ListGamesinDB ($PlatformFilter, $GenreFilter, $PlayedFilter);
}
}
// Initialize the MySQL database conection
function db_init () {
$host = "localhost";
$username = "insertusernamehere";
$password = "insertpasswordhere";
$db = "insertdatabasenamehere";
$dbh = mysql_pconnect ($host, $username, $password);
if ($dbh) {
if (mysql_select_db ($db)) {
return $dbh;
}
}
return 0;
}
function LoadGenreList () {
$dbh = db_init ();
$query = "SELECT distinct genre FROM game ORDER BY genre";
$res = mysql_query ($query, $dbh);
if ($res) {
echo "<SELECT NAME=GenreFilter>";
echo "<OPTION>All</OPTION>";
while ($template_args = mysql_fetch_assoc($res)) {
extract ($template_args);
echo "<OPTION>$genre</OPTION>";}
echo "</SELECT>";
}
}
function LoadPlatformList () {
$dbh = db_init ();
$query = "SELECT distinct platform FROM game ORDER BY platform";
$res = mysql_query ($query, $dbh);
if ($res) {
echo "<SELECT NAME=PlatformFilter>";
echo "<OPTION>All</OPTION>";
while ($template_args = mysql_fetch_assoc($res)) {
extract ($template_args);
echo "<OPTION>$platform</OPTION>";}
echo "</SELECT>";
}
}
// Save first and last name in the database
function SaveNameInDB ($name, $nickname, $gamertag) {
$dbh = db_init ();
$query = "INSERT INTO gamer SET name='$name', nickname='$nickname', gamertag='$gamertag'";
$res = mysql_query ($query, $dbh);
if ($res) {
echo "<p><span style=\"color:blue;\">Added $gamertag to database.</span></p>";
} else {
die ("There was an error adding $gamertag to database.");
}
}
// List Games in the database
function ListGamesInDB ($PlatformFilter, $GenreFilter, $PlayedFilter) {
$dbh = db_init ();
$where = "";
if ($PlatformFilter != "All"){
$where = "where Platform=\"" . $PlatformFilter . "\"";
}
if ($GenreFilter != "All"){
If ($where != ""){
$where = $where . " and Genre=\"" . $GenreFilter . "\"";
} else {
$where = "where Genre=\"" . $GenreFilter . "\"";
}
}
if ($PlayedFilter != "All"){
if ($PlayedFilter == "Yes"){
$PlayedFilter=1;
}else{
$PlayedFilter=0;
}
If ($where != ""){
$where = $where . " and Played=" . $PlayedFilter . "";
} else {
$where = "where Played=" . $PlayedFilter . "";
}
}
$query = "SELECT name, platform, genre, case when played=0 then 'No' else 'Yes' end played, notes FROM game " . $where . " ORDER BY Name";
$res = mysql_query ($query, $dbh);
if ($res) {
$count = 0;
echo "<h2>Games in database</h2>";
echo "<table>";
echo "<form method=\"post\" action=\"games.php\">";
echo "<tr><td></td><td>";
LoadPlatformList ();
echo "</td><td>";
LoadGenreList ();
echo "</td><td>";
echo "<SELECT Name=PlayedFilter><OPTION>All</OPTION><OPTION>Yes</OPTION><OPTION>No</OPTION></SELECT>";
echo "</td><td><input type=\"Submit\" name=\"action\" value=\"Filter\"></td></tr>";
echo "</form>";
echo "<tr><td><b>Name</b></td><td><b>Platform</b></td><td><b>Genre</b></td><td><b>Played?</b></td><td><b>Notes</b></td></tr>";
while ($template_args = mysql_fetch_assoc($res)) {
$count = $count+1;
extract ($template_args);
echo "<tr><td>$name</td><td>$platform</td><td>$genre</td><td>$played</td><td>$notes</td></tr>";}
echo "</table>";
echo "<b>" . $count . " games found " . $where . "</b>";
} else {
echo "<p><span style=\"color:blue;\">There are no games matching the selected criteria.</span></p>";
}
}
?>
</form>
</body>
</html>
