rendered paste body<?php require_once('../Connections/Monqiboy.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
//Insert New Member
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "newMember")) {
$insertSQL = sprintf("INSERT INTO members (first_name, last_name, email, b_date, notes) VALUES (%s, %s, %s, %s, %s)",
GetSQLValueString($_POST['first_name'], "text"),
GetSQLValueString($_POST['last_name'], "text"),
GetSQLValueString($_POST['email'], "text"),
GetSQLValueString($_POST['b_date'], "date"),
GetSQLValueString($_POST['notes'], "text"));
mysql_select_db($database_Monqiboy, $Monqiboy);
$Result1 = mysql_query($insertSQL, $Monqiboy) or die(mysql_error());
$lastMemberId = mysql_insert_id();
$confirmCreated = '<p class=ok> member susccesfully created! ' .' with the member id: ' .$lastMemberId. '</p>';
// Update last member inserted
} elseif ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "updateMember")){
$updateSQL = sprintf("UPDATE members SET first_name=%s, last_name=%s, email=%s, b_date=%s, notes=%s WHERE member_id=%s",
GetSQLValueString($_POST['first_name'], "text"),
GetSQLValueString($_POST['last_name'], "text"),
GetSQLValueString($_POST['email'], "text"),
GetSQLValueString($_POST['b_date'], "date"),
GetSQLValueString($_POST['notes'], "text"),
GetSQLValueString($_POST['member_id'], "int"));
mysql_select_db($database_Monqiboy, $Monqiboy);
$Result1 = mysql_query($updateSQL, $Monqiboy) or die(mysql_error());
$lastMemberId = $_POST['member_id'];
}
// Delete Last member Inserted
if ((isset($_POST['MM_delete'])) && ($_POST['MM_delete'] == "deleteMember")) {
$deleteSQL = sprintf("DELETE FROM members WHERE member_id=%s",
GetSQLValueString($_POST['member_id'], "int"));
mysql_select_db($database_Monqiboy, $Monqiboy);
$Result1 = mysql_query($deleteSQL, $Monqiboy) or die(mysql_error());
$confirmDelete = '<p class=warning> member succesfully deleted! </p>' ;
}
//override values after post insert to auto fill form for update (once created)if needed
if (isset($_POST['first_name'])){
$first_name = $_POST['first_name'];
$last_name = $_POST['last_name'];
$email = $_POST['email'];
$b_date = $_POST['b_date'];
$notes = $_POST['notes'];
$title = $first_name .' ' .$last_name .' ' .$b_date;
$submit = 'Save Changes';
$MM_insert = 'updateMember';
$reset = 'hidden';
$delete = '';
}
else {
$title = 'Add a new member';
$submit = 'Add this member';
$MM_insert = 'newMember';
$reset = 'reset';
$delete = 'hidden';
}
// override values after post from address form
if (isset($_POST['MM_insertAddr'])) {
$zip = $_POST['zip'];
$street = $_POST['street'];
$apt = $_POST['apt_unit'];
$submitAddr = 'Save Changes';
$MM_insertAddr = 'updateAddr';
}
else {
$submitAddr = 'Add address';
$MM_insertAddr = 'contactInfo';
}
// add addres
if ((isset($_POST["MM_insertAddr"])) && ($_POST["MM_insertAddr"] == "contactInfo")) {
$insertSQL = sprintf("INSERT INTO members_addresses (member_id, street, apt_unit, zip) VALUES (%s, %s, %s, %s)",
GetSQLValueString($_POST['member_id'], "int"),
GetSQLValueString($_POST['street'], "text"),
GetSQLValueString($_POST['apt_unit'], "text"),
GetSQLValueString($_POST['zip'], "double"));
mysql_select_db($database_Monqiboy, $Monqiboy);
$Result1 = mysql_query($insertSQL, $Monqiboy) or die(mysql_error());
echo $Result1;
}
?><!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=UTF-8" />
<title>NEW MEMBER</title>
<link href="../SpryAssets/SprySlidingPanels.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
body {
margin: 0;
padding: 0;
}
#formHead {
background: #ECF3FF;
}
.ok {
color: #00CC33;
}
.style8 {
font-family: "Times New Roman", Times, serif;
font-weight: bold;
font-style: italic;
}
.warning {color: #FF0000}
.divPosition {
width: 420px;
margin-left: 110px;
}
#notes {
border-top: 1px dashed #CCCCCC;
border-bottom: 1px dashed #CCCCCC;
border-right-width: 0px;
border-left-width: 0px;
border-right-color: #CCCCCC;
border-left-color: #CCCCCC;
}
.hidden {
display: none;
}
.style10 {color: #0000CC}
-->
</style>
<style type="text/css">
.SlidingPanels {
width: 500px;
height: 500px;
}
.SlidingPanelsContent {
width: 500px;
height:500px;
}
.p1 {
}
.p2 {
}
.p3 {
}
#addNewMemberSlides.SlidingPanels {
float: left;
}
#addNewMemberSlides .SlidingPanelsContentGroup {
float: left;
width: 10000px;
}
#addNewMemberSlides .SlidingPanelsContent {
float: left;
}
</style>
<script src="../SpryAssets/SpryEffects.js" type="text/javascript"></script>
<script src="../SpryAssets/SprySlidingPanels.js" type="text/javascript"></script>
<script src="../SpryAssets/SpryData.js" type="text/javascript"></script>
<script src="../SpryAssets/SpryDataUtils.js" type="text/javascript"></script>
</head>
<body>
<div id="formHead">
<h2><img src="../images/untitled.jpg" alt="" width="107" height="106" align="middle" /> <span class="style8"><?php echo $title; ?></span></h2>
</div>
<div id="addNewMemberSlides" class="SlidingPanels" tabindex="0">
<div class="SlidingPanelsContentGroup">
<div id="personal_info" class="SlidingPanelsContent p1">
<form id="newMember" name="newMember" method="POST" action="<?php echo $editFormAction; ?>">
<table width="400" border="0">
<tr>
<td>First name<br />
<input type="text" name="first_name" id="first_name" value="<?php echo $first_name; ?>" /></td>
<td>Last name<br />
<input type="text" name="last_name" id="last_name" value="<?php echo $last_name; ?>" /></td>
</tr>
<tr>
<td>e-mail address<br />
<input type="text" name="email" id="email" value="<?php echo $email; ?>" /></td>
<td> </td>
</tr>
<tr>
<td>Date of birth<br />
<input type="text" name="b_date" id="b_date" value="<?php echo $b_date; ?>" /></td>
<td> </td>
</tr>
<tr>
<td colspan="2">Notes<br />
<textarea name="notes" id="notes" cols="45" rows="5"><?php echo $notes; ?></textarea></td>
</tr>
<tr>
<td colspan="2"><a href="#" onclick="sp.showPanel('address'); return false;">Add contact information</a> - You can do this later</td>
</tr>
<tr>
<td><input type="hidden" name="member_id" id="member_id" value="<?php echo $lastMemberId; ?>" />
<input type="hidden" name="MM_insert" value="<?php echo $MM_insert; ?>" /></td>
<td> </td>
</tr>
<tr>
<td colspan="2"><input type="submit" name="addMember" id="addMember" value="<?php echo $submit; ?>" />
|<span class="warning">Cancel</span>|
<input type="<?php echo $reset; ?>" name="reset" id="reset" value="Start over" />
<input class="<?php echo $delete; ?>" type="image" name="MM_delete" id="MM_delete" value="deleteMember"
src="../images/trash_can.jpg" width="60" height="60" border="0"
onClick="javascript:return confirm('Are you sure you want to delete this member?')" /></td>
</tr>
</table>
</form>
</div>
<div id="address" class="SlidingPanelsContent p2">
<p>Add contact information:<br />
<br />
</p>
<form id="contactInfo" name="contactInfo" method="POST" action="<?php echo $editFormAction; ?>">
Address:<br />
<table width="400" border="0">
<tr>
<td>Street<br />
<input type="text" name="street" id="street" value="<?php echo $street; ?>" /></td>
<td>Apt / Unit / Floor<br />
<input type="text" name="apt_unit" id="apt_unit" value="<?php echo $apt; ?>" /></td>
</tr>
<tr>
<td>zip code<br />
<input type="text" name="zip" id="zip" value="<?php echo $zip; ?>" /></td>
<td> </td>
</tr>
<tr>
<td><label>
<input type="submit" name="submitAddr" id="submitAddr" value="<?php echo $submitAddr; ?>" />
</label></td>
<td><input type="hidden" name="member_id" id="member_id" value="<?php echo $lastMemberId; ?>" /></td>
</tr>
</table>
<input type="hidden" name="MM_insertAddr" value="<?php echo $MM_insertAddr; ?> " />
</form>
</div>
<div id="phone_numbers" class="SlidingPanelsContent p3"> Phone Numbers </div>
</div>
</div>
<p> Navigate by id: <a href="#" onclick="sp.showPanel('personal_info'); return false;">Personal Information</a> | <a href="#" onclick=
"sp.showPanel('address'); return false;">Addresses</a> | <a href="#" onclick="sp.showPanel('phone_numbers'); return false;">Phone numbers</a> | </p>
<pre><?php print_r($_POST); ?></pre>
<!-- confirmations insert delete -->
<?php if(isset($confirmDelete)) {
echo $confirmDelete;
}
elseif
(isset($confirmCreated)) {
echo $confirmCreated;
}
?>
<script type="text/javascript">
var sp = new Spry.Widget.SlidingPanels('addNewMemberSlides');
</script>
</body>
</html>