<html>
<head>
<title>Bed and Breakfast Database</title>
</head>
<body>
<center><b><font size="+1">Bed and Breakfast Form</font></b></center>
<form enctype="multipart/form-data" action="BandBform.php" method="post">
<br>
Fill in the form and then click on "Process Form".
<br>
<?php
if (array_key_exists('Name', $_REQUEST)) {
$Name = $_REQUEST['Name'];
} else {
$Name = '';
}
if (array_key_exists('City', $_REQUEST)) {
$City = $_REQUEST['City'];
} else {
$City = '';
}
if (array_key_exists('ArrivalDate', $_REQUEST)) {
$ArrivalDate = $_REQUEST['ArrivalDate'];
} else {
$ArrivalDate = '';
}
?>
<br>
(Guest) Name:
<input type="text" size="12" name="Name" value="<?php print $Name ?>">
<br>
City:
<input type=text size=12 name="City" value="<?php print $City ?>">
<br>
ArrivalDate:
<input type=text size=12 name="ArrivalDate" value="<?php print $ArrivalDate ?>">
<br>
<center><input type=submit value="Process Form "></center>
<?php
if($Name == "" && $City == "" && $ArrivalDate == "")
{
$query = "select" .
" *" .
" from Guest, Reservation" .
" where Guest.GuestNr = Reservation.GuestNr"
;
print "<br>";
print "Generated Default SQL Query:";
print "<br>";
print $query;
print "<br>";
}
else
{
$query = "select" .
" *" .
" from Guest, Reservation" .
" where Guest.GuestNr = Reservation.GuestNr"
;
if ($Name != "") $query = $query . " and Name = \"" . $Name . "\"";
if ($City != "") $query = $query . " and City = \"" . $City . "\"";
if ($ArrivalDate != "") $query = $query . " and ArrivalDate = \"" . $ArrivalDate . "\"";
print "<br>";
print "Generated SQL Query:";
print "<br>";
print $query;
print "<br>";
}
print "<a href=\"index.html\">Back to Index</a>";
if ($query != "") {
print "<hr width=\"100%\">\n";
print "<size=-1>";
print "<center><h2>Form 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($query));
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>