Advertisement
Advertisement
| 07.24.2008 at 08:14AM PDT, ID: 23592404 |
|
[x]
Attachment Details
|
||
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: |
<?PHP
require_once('../Connections/localhost.php');
mysql_select_db($database_localhost, $localhost);
//List Variables from Login Confirm Submission
$amerinetid = $_POST["amerinetid"];
$facilityname = $_POST["facilityname"];
$facilityaddress = $_POST["facilityaddress"];
$facilitycity = $_POST["facilitycity"];
$facilitystate = $_POST["facilitystate"];
$facilityzip = $_POST["facilityzip"];
$facilityphone = $_POST["facilityphone"];
/*Find any existing Media requests for this ID*/
$existingmediarequestquery = "SELECT inservicemedia.title, mediatransactions.mediatransaction_id, mediatransactions.firstdayneeded, mediatransactions.lastdayneeded FROM mediatransactions left join inservicemedia on inservicemedia.inservicemedia_id = mediatransactions.inservicemedia_id where mediatransactions.amerinetid = '$amerinetid'";
$existingmediarequestresult = mysql_query($existingmediarequestquery) or die(mysql_error());
$existingmediarequesttotal = mysql_num_rows($existingmediarequestresult);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<title>Untitled Document</title>
</head>
<body>
<?PHP
if(isset($_POST["confirm"]) && trim($_POST["confirm"])!=='') {
//Check for Existing Media Reservations for this ID
if(0 == $existingmediarequesttotal) {
echo "No Requests found for this Amerinet ID<br>" .
"<form action='reservechange.php' method='post'>" .
"<input type='hidden' name='mediatitle' value='null'/>" .
"<input type='hidden' name='mediafirstday' value='null'/>" .
"<input type='hidden' name='medialastday' value='null'/>" .
"<input type='hidden' name='amerinetid' value='$amerinetid'/>" .
"<input type='submit' name='requestnew' value='Request New'/></form>";
}
//Show User the Information found in the database and Confirm Submission
else {
echo "<form action='reservechange.php' method='post'>";
while ($existingmedianamerequestrow = mysql_fetch_array($existingmediarequestresult, MYSQL_ASSOC))
{
echo "<input type='checkbox' name='mediacheckbox' value='{$existingmedianamerequestrow['mediatransaction_id']}' unchecked><input type='hidden' name='mediatitle' value='{$existingmedianamerequestrow['title']}'/>{$existingmedianamerequestrow['title']} reserved from <input type='hidden' name='mediafirstday' value='{$existingmedianamerequestrow['firstdayneeded']}'/>{$existingmedianamerequestrow['firstdayneeded']} until <input type='hidden' name='medialastday' value='{$existingmedianamerequestrow['lastdayneeded']}'/>{$existingmedianamerequestrow['lastdayneeded']}<input type='hidden' name='amerinetid' value='$amerinetid'><br>";
}
echo "<input type='hidden' name='amerinetid' value='$amerinetid'/>" .
"<input type='submit' name='cancelselected' value='Cancel Selected'/> <input type='submit' name='requestnew' value='Request New'/></form>";
}
} else {
//Redirect to the Original Form if this page is accessed directly
echo '<META HTTP-EQUIV="Refresh" Content="0; URL=../index.php">';
exit;
}
?>
</body>
</html>
|
