rendered paste body<?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"] == "addMemberForm")) {
$insertSQL = sprintf("INSERT INTO members (first_name, middle_name, last_name, email, b_date, notes) VALUES (%s, %s, %s, %s, %s, %s)",
GetSQLValueString($_POST['first_name'], "text"),
GetSQLValueString($_POST['middle_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);
$Result = mysql_query($insertSQL, $Monqiboy) or die(mysql_error());
$_SESSION['last_memberId'] = mysql_insert_id();
}
// insert addresses
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "addressForm")) {
$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);
$Result = mysql_query($insertSQL, $Monqiboy) or die(mysql_error());
}
// Show active members Recordset table
mysql_select_db($database_Monqiboy, $Monqiboy);
$query_RsMembers = "SELECT * FROM members";
$RsMembers = mysql_query($query_RsMembers, $Monqiboy) or die(mysql_error());
$row_RsMembers = mysql_fetch_assoc($RsMembers);
$totalRows_RsMembers = mysql_num_rows($RsMembers);
//Show addresses recordset by memberId
$colname_RsAddresses = "-1";
if (isset($_SESSION['last_memberId'])) {
$colname_RsAddresses = $_SESSION['last_memberId'];
}
mysql_select_db($database_Monqiboy, $Monqiboy);
$query_RsAddresses = sprintf("SELECT members_addresses.*, citystatezip.stateAb, citystatezip.city, citystatezip.state
FROM (members_addresses LEFT JOIN citystatezip ON citystatezip.zip=members_addresses.zip)
WHERE members_addresses.member_id = %s", GetSQLValueString($colname_RsAddresses, "int"));
$RsAddresses = mysql_query($query_RsAddresses, $Monqiboy) or die(mysql_error());
$row_RsAddresses = mysql_fetch_assoc($RsAddresses);
$totalRows_RsAddresses = mysql_num_rows($RsAddresses);
// Recordset to XML (RsMembers)
if (isset($_GET['show_members'])) {
header("Content-type: text/xml");
header("Pragma: public");
header("Cache-control: private");
header("Expires: -1");
$export_RsMembers="";
if($export_RsMembers=="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_RsMembers."\">";
if($totalRows_RsMembers > 0){
$Start_Record = 0;
$Num_Records = $totalRows_RsMembers;
$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($RsMembers);
do{
if($Current_Record>=$Start_Record){
echo "<record>";
for ($x=0; $x<$totalColumns; $x++) {
$field=mysql_field_name($RsMembers, $x);
echo "<".$field."><"."![CD"."ATA[".htmlentities($row_RsMembers[$field])."]"."]></".$field.">";
}
echo "</record>";
}
$Current_Record=$Current_Record+1;
if($Current_Record-$Start_Record==$Num_Records){break;}
}while ($row_RsMembers = mysql_fetch_assoc($RsMembers));
}else{
//echo "<record></record>";
}
echo "</recordset>";
die();
}
// Recordset to XML (RsAddresses)
if (isset($_GET['show_addr'])) {
header("Content-type: text/xml");
header("Pragma: public");
header("Cache-control: private");
header("Expires: -1");
$export_RsAddresses="";
if($export_RsAddresses=="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_RsAddresses."\">";
if($totalRows_RsAddresses > 0){
$Start_Record = 0;
$Num_Records = $totalRows_RsAddresses;
$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($RsAddresses);
do{
if($Current_Record>=$Start_Record){
echo "<record>";
for ($x=0; $x<$totalColumns; $x++) {
$field=mysql_field_name($RsAddresses, $x);
echo "<".$field."><"."![CD"."ATA[".htmlentities($row_RsAddresses[$field])."]"."]></".$field.">";
}
echo "</record>";
}
$Current_Record=$Current_Record+1;
if($Current_Record-$Start_Record==$Num_Records){break;}
}while ($row_RsAddresses = mysql_fetch_assoc($RsAddresses));
}else{
//echo "<record></record>";
}
echo "</recordset>";
die();
}
?><!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>MonQi members</title>
<link rel="stylesheet" type="text/css" href="../yui/build/fonts/fonts-min.css" />
<link rel="stylesheet" type="text/css" href="../yui/build/tabview/assets/skins/sam/tabview.css" />
<link rel="stylesheet" type="text/css" href="../yui/build/container/assets/skins/sam/container.css" />
<script type="text/javascript" src="../yui/build/yahoo-dom-event/yahoo-dom-event.js"></script>
<script type="text/javascript" src="../yui/build/element/element-beta.js"></script>
<script type="text/javascript" src="../yui/build/tabview/tabview.js"></script>
<script src="../SpryAssets/xpath.js" type="text/javascript"></script>
<script src="../SpryAssets/SpryData.js" type="text/javascript"></script>
<script src="../SpryAssets/SpryDataUtils.js" type="text/javascript"></script>
<style type="text/css">
<!--
.yui-skin-sam #addNewMember {
width: 500px;
}
-->
</style>
<script type="text/javascript">
<!--
var dsMembers = new Spry.Data.XMLDataSet("members.php?show_members=1", "recordset/record",{sortOnLoad:"first_name",sortOrderOnLoad:"ascending",useCache:false});
dsMembers.setColumnType("member_id", "number");
dsMembers.setColumnType("b_date", "date");
dsMembers.setColumnType("img_location", "image");
/*dsMembers.addObserver( {onDataChanged: function(ds, type) {
var row = dsMembers.findRowsWithColumnValues()
)*/
var dsAddresses = new Spry.Data.XMLDataSet("members.php?show_addr=1", "recordset/record",{useCache:false});
dsAddresses.setColumnType("address_id", "number");
dsAddresses.setColumnType("member_id", "number");
dsAddresses.setColumnType("zip", "number");
//-->
</script>
<link href="../css/dataTable/DataTable.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
.style5 {font-size: 12px}
-->
</style>
</head>
<body class="yui-skin-sam">
<div id="listMembers">
<div spry:region="dsMembers">
<table>
<tr>
<td colspan="7">
<div align="right">
<span class="style5">Add a new member</span>
<a href="#"> <img src="/images/add.png" alt="" width="23" height="22" border="0" align="absbottom"
class="a_no_border" onclick="slideReset()" />
</a>
</div>
</td>
</tr>
<tr>
<th spry:sort="member_id">Member_id</th>
<th spry:sort="first_name">First_name</th>
<th>Middle_name</th>
<th spry:sort="last_name">Last_name</th>
<th>Email</th>
<th width="73" class="left_dash-border">update</th>
<th width="64" class="left_dash-border">delete</th>
</tr>
<tr spry:repeat="dsMembers" spry:setrow="dsMembers" spry:odd="odd" spry:even="even" spry:hover="hover" spry:select="select">
<td>{member_id}</td>
<td>{first_name}</td>
<td>{middle_name}</td>
<td>{last_name}</td>
<td>{email}</td>
<td valign="middle" class="left_dash-border"><div align="center"> <a href="#"><img src="/images/edit.png" alt="edit" width="16" height="16"
class="a_no_border" onclick="MM_effectSlide('updateFormClass', 1000, '0%', '100%', false)"/> </a> </div></td>
<td valign="middle" class="left_dash-border"><div align="center"> <a href="#"><img src="/images/delete.png" alt="delete" width="16" height="16"
class="a_no_border" onclick="MM_effectSlide('deleteConfirm', 1000, '0%', '100%', false)" /> </a> </div></td>
</tr>
</table>
<br />
</div>
</div>
<div id="addNewMember" class="yui-navset">
<ul class="yui-nav">
<li><a href="#tab1"><em>Personal Info:</em></a></li>
<li class="selected"><a href="#tab2"><em>Addresses:</em></a></li>
<li><a href="#tab3"><em>Phone Numbers:</em></a></li>
</ul>
<div class="yui-content">
<div id="tab1">
<p><strong>Add a new member</strong></p>
<br />
<form action="<?php echo $editFormAction; ?>" name="addMemberForm" id="addMemberForm" method="POST">
<table border="0">
<tr>
<td colspan="2">Personal information:</td>
</tr>
<tr>
<td>First name</td>
<td><input type="text" name="first_name" id="first_name" /></td>
</tr>
<tr>
<td>Middle name</td>
<td><input type="text" name="middle_name" id="middle_name" /></td>
</tr>
<tr>
<td>Last name</td>
<td><input type="text" name="last_name" id="last_name" /></td>
</tr>
<tr>
<td>e-mail address:</td>
<td><input type="text" name="email" id="email" /></td>
</tr>
<tr>
<td>Date of birth:</td>
<td><input type="text" name="b_date" id="b_date" /></td>
</tr>
<tr>
<td>Notes:</td>
<td><label>
<textarea name="notes" id="notes" cols="45" rows="5"></textarea>
</label></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="submit" id="submit" value="add member" /></td>
</tr>
</table>
<br />
<input type="hidden" name="MM_insert" value="addMemberForm" />
</form>
</div>
<div id="tab2">
<form action="<?php echo $editFormAction; ?>" id="addressForm" name="addressForm" method="POST">
<table width="400" border="0">
<tr>
<td colspan="2">Address information:
<div align="right"></div></td>
</tr>
<tr>
<td>street:</td>
<td><input type="text" name="street" id="street" /></td>
</tr>
<tr>
<td>apt:</td>
<td><input type="text" name="apt_unit" id="apt_unit" /></td>
</tr>
<tr>
<td>zip:</td>
<td><input type="text" name="zip" id="zip" /></td>
</tr>
<tr>
<td>submit</td>
<td><input type="submit" name="submitAddr" id="submitAddr" value="Add Adrrees" /></td>
</tr>
<tr>
<td><input name="member_id" type="text" id="member_id" value="<?php echo $_SESSION['last_memberId']; ?>" />
<input name="MM_insert" type="hidden" id="MM_insert" value="addressForm" /></td>
<td></td>
</tr>
</table>
<input type="hidden" name="MM_insert" value="addressForm" />
</form>
<br />
<br />
Assoiciated member's addresses:
<br />
<div spry:region="dsAddresses">
<table>
<tr>
<th spry:sort="member_id">Member_id</th>
<th>Street</th>
<th>Apt_unit</th>
<th>Zip</th>
<th>StateAb</th>
<th>City</th>
<th>State</th>
</tr>
<tr spry:repeat="dsAddresses" spry:odd="odd" spry:even="even" spry:hover="hover" spry:select="select">
<td>{member_id}</td>
<td>{street}</td>
<td>{apt_unit}</td>
<td>{zip}</td>
<td>{stateAb}</td>
<td>{city}</td>
<td>{state}</td>
</tr>
</table>
</div>
</div>
<div id="tab3">
<form id="addressForm2" name="phoneForm" method="post" action="">
<table width="400" border="0">
<tr>
<td colspan="2">phone information:
<div align="right"></div></td>
</tr>
<tr>
<td>phone id</td>
<td><input type="text" name="phone_id" id="phone_id" /></td>
</tr>
<tr>
<td>location:</td>
<td><input type="text" name="street2" id="street2" /></td>
</tr>
<tr>
<td>phone number:</td>
<td><input type="text" name="apt_unit2" id="apt_unit2" /></td>
</tr>
<tr>
<td>submit</td>
<td><input type="submit" name="submit3" id="submit3" value="Submit" /></td>
</tr>
<tr>
<td><input name="member_id" type="hidden" id="member_id" value="<?php echo $_SESSION['last_memberId']; ?>" /></td>
<td> </td>
</tr>
</table>
</form>
<p> </p>
</div>
</div>
</div>
<script language="javascript" type="text/javascript">
Spry.DataUtils.ServerAction('addMemberForm','','',false,'dsMembers','');
</script>
<script language="javascript" type="text/javascript">
Spry.DataUtils.ServerAction('addressForm','','',false,'dsAddresses','');
</script>
<script type="text/javascript">
var tabView = new YAHOO.widget.TabView('addNewMember');
</script>
</body>
</html>
<?php
mysql_free_result($RsMembers);
mysql_free_result($RsAddresses);
?>