<html>
<body>
<center><b><font size=+1>Bed and Breakfast SQL Query</font></b></center>
<br>
<center>
<pre>
Room(RoomNr, Name, NrBeds, Cost)
Guest(GuestNr, Name, StreetNr, City)
Reservation(GuestNr, RoomNr, ArrivalDate, NrDays)
</pre>
<form enctype="multipart/form-data" action="BandBquery.php" method="post">
<center>
<?php
$SQL = '';
if (array_key_exists('SQL', $_REQUEST)) {
$SQL = $_REQUEST['SQL'];
}
?>
</center>
<textarea name="SQL" rows="7" cols="50"
maxlength="10000"><?php print StripSlashes($SQL) ?></textarea>
</center>
<center><size="-1"><input type=submit value="Process SQL "></center>
<a href="index.html">Back To Index</a>
<?php
if ($SQL != "") {
print "<hr width=\"100%\">\n";
print "<size=\"-1\">";
print "<center><h2>SQL Query Results</h2></center>\n";
try {
$dbHandle = new PDO('sqlite:/users/ta/cs452ta/public_html/sqliteInfo/db/BandB.sqlite3');
} catch( PDOException $exception ) {
die($exception->getMessage());
}
print "<center>";
$q = $dbHandle->query(StripSlashes($SQL));
try {
$num_fields = $q->columnCount();
print "<table border=2 cellpadding=2 cellspacing=0>";
print "<tr><size=-1>";
for ($i = 0; $i < $num_fields; $i++) {
$meta = $q->getColumnMeta($i);
print "<th><size=-1>" . $meta['name'] . " </th>\n";
}
print "</tr>\n";
while ($row = $q->fetch()) {
print "<tr><size=-1>";
for ($i = 0; $i < $num_fields; $i++)
print "<td><size=-1>$row[$i]</td>\n";
print "</tr>";
}
print "</td></tr></table>\n";
} catch (PDOException $exception) {
echo "<B>Error: " . $exception->getMessage() . "</B> " . "<BR>";
}
print "</center>";
}
?>
</form>
</body>
</html>