<?php require 'header.php'; ?>
<?php requireLogin(); ?>

	<section id="content" class="sbr">
		<div class="menu-shadow"></div>
		<div class="container clearfix">
			<div class="page-header clearfix" style="margin-bottom: 20px;">
				<h1>Edit Settings</h1>

				<div class="line"></div>
			</div>
			<!--/ .page-header-->

			<section id="main" class="twelve columns">
				<article class="entry clearfix">
					<!--/ .entry-title-->

					<!--/ .preloader-->

					<!--/ .entry-meta-->

					<div class="entry-body">

<?php
$formFieldList = "ID,fname,lname,Member,Password,EMail,emailsubscribe,City,State,Country,Address1,Address2,Phone,Zip,List";

// RecordID can come from URL (GET) or from POST (settings.php form)
$recordID = isset($_GET['RecordID']) ? $_GET['RecordID'] : (isset($_POST['RecordID']) ? $_POST['RecordID'] : null);

if ($recordID !== null) {
    $db = getReadDb();
    $stmt = $db->prepare("SELECT users.ID, users.fname, users.lname, users.Member, users.Password, users.EMail, users.CurrentDateTime, users.City, users.State, users.Country, users.List, users.OnOff, users.ID AS ID_Field, users.Address1, users.Address2, users.Zip, users.Phone, users.expired, users.emailsubscribe FROM users WHERE users.ID = ?");
    $stmt->execute([$recordID]);
    $record = $stmt->fetch();

    if ($record) {
        $ID_Value = $record['id'];
        $fname_Value = $record['fname'];
        $lname_Value = $record['lname'];
        $Member_Value = $record['member'];
        $Password_Value = $record['password'];
        $EMail_Value = $record['email'];
        $CurrentDateTime_Value = $record['currentdatetime'];
        $City_Value = $record['city'];
        $State_Value = $record['state'];
        $Country_Value = $record['country'];
        $List_Value = $record['list'];
        $Address1_Value = $record['address1'];
        $Address2_Value = $record['address2'];
        $Zip_Value = $record['zip'];
        $Phone_Value = $record['phone'];
        $OnOff_Value = $record['onoff'];
        $emailsubscribe_Value = $record['emailsubscribe'];
    } else {
        $recordID = null;
    }
}

if ($recordID === null) {
    $ID_Value = '';
    $fname_Value = '';
    $lname_Value = '';
    $Member_Value = '';
    $Password_Value = '';
    $EMail_Value = '';
    $CurrentDateTime_Value = '';
    $City_Value = '';
    $State_Value = '';
    $Country_Value = '';
    $List_Value = '';
    $Address1_Value = '';
    $Address2_Value = '';
    $Zip_Value = '';
    $Phone_Value = '';
    $OnOff_Value = '';
    $emailsubscribe_Value = '';
}
?>
<FORM action="user_RecordAction.php" method="post">
<INPUT type="hidden" name="FieldList" value="<?= h($formFieldList) ?>">
<?php if ($recordID !== null): ?>
	<INPUT type="hidden" name="RecordID" value="<?= h($recordID) ?>">
	<INPUT type="hidden" name="ID" value="<?= h($recordID) ?>">
<?php endif; ?>
<div align="center">
<TABLE>

<?php if ($recordID === null): ?>
	<TR>
	<TD valign="top"> ID: </TD>
    <TD>
	<INPUT type="text" name="ID" value="<?= h($ID_Value) ?>" maxLength="4">
	</TD>
	<INPUT type="hidden" name="ID_integer">
	</TR>
	<?php endif; ?>
	<INPUT type="hidden" name="OnOff" value="<?= h($OnOff_Value) ?>" maxLength="75">
	<INPUT type="hidden" name="fname" value="<?= h($fname_Value) ?>" maxLength="75">
	<INPUT type="hidden" name="lname" value="<?= h($lname_Value) ?>" maxLength="75">
	<INPUT type="hidden" name="Member" value="<?= h($Member_Value) ?>" maxLength="10">
	<TR>
	<TD valign="top"><font face=arial size=-1><b> EMail Address: </TD>
    <TD>
	<INPUT type="text" name="EMail" value="<?= h($EMail_Value) ?>" maxLength="75">
	</TD>
	</TR>

	<TR>
	<TD valign="top"><font face=arial size=-1><b> Password: </TD>
    <TD>
	<INPUT type="text" name="Password" value="<?= h($Password_Value) ?>" maxLength="75">
	</TD>
	</TR>

	<INPUT type="hidden" name="CurrentDateTime" value="<?= h($CurrentDateTime_Value) ?>" maxLength="50">
	<TR>
	<TD valign="top"><font face=arial size=-1><b> Address: </TD>
    <TD>
	<INPUT type="text" name="Address1" value="<?= h($Address1_Value) ?>" maxLength="75">
	</TD>
	</TR>
	<TR>
	<TD valign="top"><font face=arial size=-1><b> Address2: </TD>
    <TD>
	<INPUT type="text" name="Address2" value="<?= h($Address2_Value) ?>" maxLength="75">
	</TD>
	</TR>
	<TR>
	<TD valign="top"><font face=arial size=-1><b> City: </TD>
    <TD>
	<INPUT type="text" name="City" value="<?= h($City_Value) ?>" maxLength="75">
	</TD>
	</TR>
	<TR>
	<TD valign="top"><font face=arial size=-1><b> State: </TD>
    <TD>
	<INPUT type="text" name="State" value="<?= h($State_Value) ?>" maxLength="2">
	</TD>
	</TR>
	<TR>
	<TD valign="top"><font face=arial size=-1><b> Zip: </TD>
    <TD>
	<INPUT type="text" name="Zip" value="<?= h($Zip_Value) ?>" maxLength="75">
	</TD>
	</TR>
	<TR>
	<TD valign="top"><font face=arial size=-1><b> Country: </TD>
    <TD>
	<INPUT type="text" name="Country" value="<?= h($Country_Value) ?>" maxLength="75">
	</TD>
	</TR>
	<TR>
	<TD valign="top"><font face=arial size=-1><b> Phone: </TD>
    <TD>
	<INPUT type="text" name="Phone" value="<?= h($Phone_Value) ?>" maxLength="75">
	</TD>
	</TR>
	<TR>
	<TD width=175 valign="top"><font face=arial size=-1><b> List in Directory: </TD>
    <TD>

	    	    <select name="List">
		    <option value="<?= h($List_Value) ?>"><?= h($List_Value) ?></option>
		    <option value="Yes">Yes</option>
		    <option value="No">No</option>

	    </select>

	</TD>
	</TR>

		<TR>
	<TD width=175 valign="top"><font face=arial size=-1><b> Subscribe to Hotline Updates: </TD>
    <TD>
	    <select name="emailsubscribe">
		    <option value="<?= h($emailsubscribe_Value) ?>"><?= h($emailsubscribe_Value) ?></option>
		    <option value="Yes">Yes</option>
		    <option value="No">No</option>

	    </select>
	</TD>
	</TR>
</TABLE></div>
	<p>
<div align="center"><INPUT type="submit" name="btnEdit_OK" value="    Update    ">
<INPUT type="submit" name="btnEdit_Cancel" value="    Cancel    ">
</div>
</FORM>

						<!--/ .about-author-->

					</div>
					<!--/ .entry-body-->

				</article>
				<!--/ .entry-->
			</section>				<!--/ #main-->


<?php require 'sidebar.php'; ?>



<?php require 'footer.php'; ?>