rendered paste body5<?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;
}}
// RecordSets
//--------------------------
//------- Active Members Recordset ------------
mysql_select_db($database_Monqiboy, $Monqiboy);
$query_activeMembers = "SELECT * FROM members ORDER BY member_id ASC";
$activeMembers = mysql_query($query_activeMembers, $Monqiboy) or die(mysql_error());
$row_activeMembers = mysql_fetch_assoc($activeMembers);
$totalRows_activeMembers = mysql_num_rows($activeMembers);
//----Recordset to XML
if (isset($_GET['show_member'])) {
header("Content-type: text/xml");
header("Pragma: public");
header("Cache-control: private");
header("Expires: -1");
$export_activeMembers="";
if($export_activeMembers=="1"){
header("Content-Disposition: attachment; filename=recordset.xml");
header("Content-Type: application/force-download");
}
echo "<?xml version=\"1.0\" encoding=\"utf-8\"?>";
echo "<recordset total=\"".$totalRows_activeMembers."\">";
if($totalRows_activeMembers > 0){
$Start_Record = 0;
$Num_Records = $totalRows_activeMembers;
$Current_Record = 0;
if(isset($_POST['Start_Record']) && $_POST['Start_Record']!="" && isset($_POST['Num_Records']) && $_POST['Num_Records']!=""){
$Start_Record = $_POST['Start_Record'];
$Num_Records = $_POST['Num_Records'];
}
if(isset($_GET['Start_Record']) && $_GET['Start_Record']!="" && isset($_GET['Num_Records']) && $_GET['Num_Records']!=""){
$Start_Record = $_GET['Start_Record'];
$Num_Records = $_GET['Num_Records'];
}
$totalColumns=mysql_num_fields($activeMembers);
do{
if($Current_Record>=$Start_Record){
echo "<record>";
for ($x=0; $x<$totalColumns; $x++) {
$field=mysql_field_name($activeMembers, $x);
echo "<".$field."><"."![CD"."ATA[".htmlentities($row_activeMembers[$field])."]"."]></".$field.">";
}
echo "</record>";
}
$Current_Record=$Current_Record+1;
if($Current_Record-$Start_Record==$Num_Records){break;}
}while ($row_activeMembers = mysql_fetch_assoc($activeMembers));
}else{
//echo "<record></record>";
}
echo "</recordset>";
die();
}
// 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());
$lastMemberId = mysql_insert_id();
$panel = 0;
$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'];
$panel = 0;
$confirmCreated = '<p class=ok> member ' .$lastMemberId .' 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($_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());
$panel = 1;
$lastMemberId = $_POST['member_id'];
$confirmCreated = '<p class=ok> member ' .$lastMemberId .' 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: #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>
<script src="../SpryAssets/xpath.js" type="text/javascript"></script>
<script type="text/javascript">
<!--
var ds_members = new Spry.Data.XMLDataSet("newMember.php?show_member=1", "recordset/record",{useCache:false});
ds_members.setColumnType("member_id", "number");
ds_members.setColumnType("b_date", "date");
ds_members.setColumnType("img_location", "image");
//-->
</script>
<link href="../css/dataTable/DataTable.css" rel="stylesheet" type="text/css" />
</head>
<body>
<?php if (!isset($panel)) {$panel = 0;} ?>
<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><input type="hidden" name="member_id" id="member_id" value="<?php 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>
<!-- Spry Active Members Table-->
<div spry:region="ds_members">
<table>
<tr>
<th spry:sort="member_id">Member_id</th>
<th spry:sort="first_name">First_name</th>
<th spry:sort="last_name">Last_name</th>
<th>Email</th>
<th>B_date</th>
<th>Img_location</th>
<th>Notes</th>
</tr>
<tr spry:repeat="ds_members" spry:setrow="ds_members" spry:odd="odd" spry:even="even" spry:hover="hover" spry:select="select">
<td>{member_id}</td>
<td>{first_name}</td>
<td>{last_name}</td>
<td>{email}</td>
<td>{b_date}</td>
<td><img src="{img_location}"/></td>
<td>{notes}</td>
</tr>
</table>
</div>
<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($activeMembers);
?>