edit_account.inc

不错的东西

<?php
/*
*  Modified: 11/21/05
*  Justin Osterholt
*  SQL class integration
*/
//$query = $sql->query("SELECT * FROM accounts WHERE id = '" . mysql_escape_string($_GET['uid']) . "'") or die(mysql_error());
//$data = mysql_fetch_assoc($query);
$data = $sql->getAssocRow("SELECT * FROM accounts WHERE id = '" . mysql_escape_string($_GET['uid']) . "'") or die(mysql_error());

foreach($_SESSION['packages'] as $k => $package)
{
	if($k == $data['package'])
	{
		$html_data .= "<option value=\"$k\" selected>{$_SESSION['packages'][$k]['pkg_name']}</option>";
	}
	else
	{
		$html_data .= "<option value=\"$k\">{$_SESSION['packages'][$k]['pkg_name']}</option>";
	}
}
?>

<form method="post" action="?page=edit_account&id=<?=$_GET['uid']?>">
<fieldset>
<legend>Edit Account</legend>
<table>
<tr>
	<td colspan="2"><strong>You are currently editing <?=$data['username']?>'s account!</strong></td>
</tr>
<tr>
	<td><label for="package">Package Name:</label></td>
	<td>
	<select name="package" id="package">
		<option>Please select.</option>
		<?=$html_data?>
	</select>
	</td>
</tr>
<tr>
	<td><labek for="pay_period">Billing Period:</label></td>
	<td>
	<select name="pay_period" id="pay_period">
		<option>Please select.</option>
		<option value="1"<?=($data['pay_period'] == 1) ? " selected" : NULL?>>Monthly</option>
		<option value="2"<?=($data['pay_period'] == 2) ? " selected" : NULL?>>Quarterly</option>
		<option value="3"<?=($data['pay_period'] == 3) ? " selected" : NULL?>>Bi-Annually</option>
		<option value="4"<?=($data['pay_period'] == 4) ? " selected" : NULL?>>Annually</option>
	</select>
	</td>
</tr>
<tr>
	<td><label for="firstname"<?=($_SESSION['error']['firstname'] ? " class=\"error\"" : "")?>>First Name:</label></td>
	<td><input type="text" name="firstname" id="firstname" value="<?=$data['firstname']?>" /></td></td>
</tr>
<tr>
	<td><label for="lastname"<?=($_SESSION['error']['lastname'] ? " class=\"error\"" : "")?>>Last Name:</label></td>
	<td><input type="text" name="lastname" id="lastname" value="<?=$data['lastname']?>" /></td>
</tr>
<tr>
	<td><label for="company"<?=($_SESSION['error']['company'] ? " class=\"error\"" : "")?>>Company Name:</label></td>
	<td><input type="text" name="company" id="company" value="<?=$data['company']?>" /></td>
</tr>
<tr>
	<td><label for="address"<?=($_SESSION['error']['address'] ? " class=\"error\"" : "")?>>Address:</label></td>
	<td><input type="text" name="address" id="address" value="<?=$data['address']?>" /></td>
</tr>
<tr>
	<td><label for="city"<?=($_SESSION['error']['city'] ? " class=\"error\"" : "")?>>City:</label></td>
	<td><input type="text" name="city" id="city" value="<?=$data['city']?>" /></td>
</tr>
<tr>
	<td><label for="state"<?=($_SESSION['error']['state'] ? " class=\"error\"" : "")?>>State:</label></td>
	<td><select name="state" id="state" onchange="update_other(this,'state','province');">
	<?php
	foreach($states as $k => $state)
	{
		if(isset($data['state']) && $data['state'] == $k)
		{
			?>

			<option selected="selected" value="<?=$k?>"><?=$state?></option>

			<?php
		}
		elseif($state == "")
		{
			?>

			<option selected="selected"></option>

			<?php
		}
		else
		{
			?>
					
			<option value="<?=$k?>"><?=$state?></option>

			<?php
		}
	}
	?>
	</select>
	<input type="text" name="province" id="province" size="15" style="display:none;"  />
	</td>
</tr>
<tr>
	<td><label for="zip"<?=($_SESSION['error']['zip'] ? " class=\"error\"" : "")?>>Zip Code:</label></td>
	<td><input type="text" name="zip" id="zip" value="<?=$data['zip']?>" /></td>
</tr>
<tr>
	<td><label for="country"<?=($_SESSION['error']['country'] ? " class=\"error\"" : "")?>>Country:</label></td>
	<td><select name="country" id="country" onchange="update_state(this,'state','province');">
	<?php
	foreach($countries as $k => $country)
	{
		if(isset($data['country']) && $data['country'] == $k)
		{
			?>

			<option selected="selected" value="<?=$k?>"><?=$country?></option>

			<?php
		}
		elseif($country == "")
		{
			?>

			<option selected="selected"></option>

			<?php
		}
		else
		{
			?>

			<option value="<?=$k?>"><?=$country?></option>

			<?php
		}
	}
	?>
	</select>
	</td>
</tr>
<tr>
	<td><label for="phone_num"<?=($_SESSION['error']['phone_num'] ? " class=\"error\"" : "")?>>Phone Number:</label></td>
	<td><input type="text" name="phone_num" id="phone_num" value="<?=$data['phone_num']?>" /></td>
</tr>
<tr>
	<td><label for="fax_num"<?=($_SESSION['error']['fax_num'] ? " class=\"error\"" : "")?>>Fax Number:</label></td>
	<td><input type="text" name="fax_num" id="fax_num" value="<?=$data['fax_num']?>" /></td>
</tr>
<tr>
	<td><label for="email"<?=($_SESSION['error']['email'] ? " class=\"error\"" : "")?>>Email Address:</label></td>
	<td><input type="text" name="email" id="email" value="<?=$data['email']?>" /></td>
</tr>
<tr>
	<td><label for="refferer"<?=($_SESSION['error']['refferer'] ? " class=\"error\"" : "")?>>How did you hear about us?</label></td>
	<td><input type="text" name="refferer" id="refferer" value="<?=$data['refferer']?>" /></td>
</tr>
<tr>
	<td colspan="2"><input type="submit" value="edit" /></td>
</tr>
</table>
</fieldset>
</form>