rendered paste body<?php require_once('../Connections/Monqiboy.php'); ?>
<?php
session_start();
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;
}}
if ($_POST) {
$colname_lastMember = "-1";
if (isset($_SESSION['member_id'])) {
$colname_lastMember = $_SESSION['member_id'];
}
//---select last member
mysql_select_db($database_Monqiboy, $Monqiboy);
$query_lastMember = sprintf("SELECT * FROM members WHERE member_id = %s", GetSQLValueString($colname_lastMember, "int"));
$lastMember = mysql_query($query_lastMember, $Monqiboy) or die(mysql_error());
$row_lastMember = mysql_fetch_assoc($lastMember);
$totalRows_lastMember = mysql_num_rows($lastMember);
}
//---populate locations dropdown selection
mysql_select_db($database_Monqiboy, $Monqiboy);
$query_Locations = "SELECT * FROM locations";
$Locations = mysql_query($query_Locations, $Monqiboy) or die(mysql_error());
$row_Locations = mysql_fetch_assoc($Locations);
$totalRows_Locations = mysql_num_rows($Locations);
// FORMS OPERATIONS
//------------------------------------
$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());
$_SESSION['member_id'] = mysql_insert_id();
$panel = 0;
$confirmCreated = '<p class=ok> member susccesfully created! ' .' with the member id: ' .$_SESSION['member_id']. '</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($_SESSION['member_id'], "int"));
mysql_select_db($database_Monqiboy, $Monqiboy);
$Result1 = mysql_query($updateSQL, $Monqiboy) or die(mysql_error());
$panel = 0;
$confirmCreated = '<p class=ok> member ' .$_POST['member_id'] .' personal info has been susccesfully updated! ' . '</p>';
}
// 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 ($_POST['MM_insert'] == "newMember") {
//$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 ($_POST['MM_insertAddr'] == "contactInfo") {
//$zip = $_POST['zip'];
//$street = $_POST['street'];
//$apt = $_POST['apt_unit'];
$submitAddr = 'Save Changes';
$MM_insertAddr = 'updateAddr';
$title = $first_name .' ' .$last_name .' ' .$b_date .'not set';
}
else {
$submitAddr = 'Add address';
$MM_insertAddr = "contactInfo";
}
// add addres
if ($_POST['MM_insertAddr'] == "contactInfo") {
$insertSQL = sprintf("INSERT INTO members_addresses (member_id, street, apt_unit, zip) VALUES (%s, %s, %s, %s)",
GetSQLValueString($_SESSION['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());
$panel = 1;
$confirmCreated = '<p class=ok> member ' .$_SESSION['member_id'] .' address has been susccesfully registered! ' . '</p>';
}
?><!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" xmlns:spry="http://ns.adobe.com/spry">
<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: #A2BDFF;
}
.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>
<script src="../SpryAssets/xpath.js" type="text/javascript"></script>
<script type="text/javascript">
<!--
//-->
</script>
</head>
<body>
<?php if (!isset($panel)) {$panel = 0;} ?>
<div id="formHead">
<h2><img src="../images/pictureNotSet.jpg" alt="" 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 $row_lastMember['first_name']; ?>" /></td>
<td>Last name<br />
<input type="text" name="last_name" id="last_name" value="<?php echo $row_lastMember['last_name']; ?>" /></td>
</tr>
<tr>
<td>e-mail address<br />
<input type="text" name="email" id="email" value="<?php echo $row_lastMember['email']; ?>" /></td>
<td> </td>
</tr>
<tr>
<td>Date of birth<br />
<input type="text" name="b_date" id="b_date" value="<?php echo $row_lastMember['b_date']; ?>" /></td>
<td> </td>
</tr>
<tr>
<td colspan="2">Notes<br />
<textarea name="notes" id="notes" cols="45" rows="5"><?php echo $row_lastMember['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 $_POST['member_id']; ?>" />
<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>(-) (+)</td>
<td><br />
<select name="location2" id="location2">
<?php
do {
?>
<option value="<?php echo $row_Locations['location_id']?>"><?php echo $row_Locations['location']?></option>
<?php
}
while ($row_Locations = mysql_fetch_assoc($Locations));
$rows = mysql_num_rows($Locations);
if($rows > 0) {
mysql_data_seek($Locations, 0);
$row_Locations = mysql_fetch_assoc($Locations);
}
?>
</select></td>
<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> </td>
<td> </td>
<td>zip code<br />
<input type="text" name="zip" id="zip" value="<?php echo $zip; ?>" /></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td><input type="hidden" name="member_id" id="member_id" value="<?php echo 101;//echo $lastMemberId; ?>" />
<input name="addressId" type="hidden" id="addressId" value="<?php mysql_insert_id; ?>" /></td>
<td>
<input type="submit" name="submitAddr" id="submitAddr" value="<?php echo $submitAddr; ?>" /> </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:<br />
<form id="phones" name="phones" method="post" action="">
<table width="400" border="0">
<tr>
<td>Location<br />
<input type="text" name="location" id="location" value="<?php echo $location; ?>" /></td>
<td>Phonenumber:<br />
<input type="text" name="phone" id="phone" value="<?php echo $phone; ?>" /></td>
</tr>
<tr>
<td><input type="text" name="member_id" id="member_id" value="<?php echo $lastMemberId; ?>" />
<td><input type="submit" name="submitPhone" id="submitPhone" value="<?php echo $submitPhone; ?>" />
</td>
</tr>
</table>
</form>
</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>
<pre><?php echo 'member id: ' .$lastMemberId; ?></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', {defaultPanel: <?php echo $panel; ?>});
</script>
</body>
</html>
<?php
mysql_free_result($lastMember);
mysql_free_result($Locations);
mysql_free_result($LastMember);
?>