showDetailsm4.php
Source of showDetailsm4.php
<!DOCTYPE html PUBLIC
"-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html lang = "EN" xml:lang = "EN" dir = "ltr">
<head>
<meta http-equiv="content-type" content="text/xml; charset=iso-8859-1" />
<title>showDetails.php</title>
<link rel = "stylesheet"
type = "text/css"
href = "../../xfdMas.css" />
</head>
<body>
<h1>showDetails.php</h1>
<?php
//connect
$conn = mysql_connect("localhost", "username", "password");
//change this password and username to work on your system
mysql_select_db("demo_db");
//get most information for requested hero
$hero = "binary boy";
$query = <<<HERE
SELECT
hero.name AS 'hero',
mission.description AS 'mission',
mission.villain AS 'villain',
mission.plot AS 'plot'
FROM
hero, mission
WHERE
hero.missionID = mission.missionID
AND
hero.name = "$hero"
HERE;
print "<dl> \n";
$result = mysql_query($query, $conn);
$row = mysql_fetch_assoc($result);
foreach ($row as $field => $value){
print <<<HERE
<dt>$field</dt>
<dd>$value</dd>
HERE;
} // end foreach
print " <dt>powers</dt> \n";
print " <dd> \n";
print " <ul> \n";
//create another query to grab the powers
$query = <<<HERE
SELECT
power.name
FROM
hero, power, hero_power
WHERE
hero.heroID = hero_power.heroID
AND
power.powerID = hero_power.powerID
AND
hero.name = "$hero"
HERE;
//put powers in an unordered list
$result = mysql_query($query, $conn);
while ($row = mysql_fetch_assoc($result)){
foreach ($row as $field => $value){
print " <li>$value</li> \n";
} // end foreach
} // end while looop
print " </ul> \n";
print "</dd> \n";
print "</dl> \n";
?>
<h2>Notes</h2>
<p>
This version is optimized for MySQL 4 with no views.
</p>
<h2>Hero - mission query</h2>
<pre>
SELECT
hero.name AS 'hero',
mission.description AS 'mission',
mission.villain AS 'villain',
mission.plot AS 'plot'
FROM hero, mission
WHERE
hero.missionID = mission.missionID;
AND
hero.name = '$hero'
</pre>
<h2>Hero - power query</h2>
<pre>
SELECT
power.name AS 'power'
FROM
hero, power, hero_power
WHERE
hero.heroID = hero_power.heroID
AND
power.powerID = hero_power.powerID
AND
hero.name = '$hero'
</pre>
</html>