<?php
if(!$persistent == "on") {
$conn = mysql_pconnect("$hostname","$dbuser","$dbpasswd");
} else {
$conn = mysql_connect("$hostname","$dbuser","$dbpasswd");
}
if(!$conn)
{
print "ERROR: MySQL Said " . mysql_error();
exit;
} else {
mysql_select_db("$dbname") or die("Failed Database Connection");
}
/*
** Function: siteHeader()
** Input: Title yes or no to cache page
** Output: Std HTML
** Description: HTML header for all pages
**
**
*/
function siteHeader($title,$cache="")
{
global $bgcolor, $bgtext, $link
1 <?php
2 $f=mysql_connect("localhost","root","") or die("Database Down");
3 mysql_select_db("membership");
4
5 // Get Members
6 $getmembers = "SELECT DISTINCTROW Members.* FROM Members
7 WHERE Members.MemberID = '$MembersID'";
8
9
10 // Get Committees
11 $getcommittees = "SELECT DISTINCTROW Committees.* FROM Committees ORDER BY Committees.CommitteeName";
12
13
14 // Get Member Types
15 $getmembertypes = "SELECT DISTINCTROW MemberTypes.* FROM MemberTypes ORDER BY MemberTypes.MemberType";
16
17 // Get Payment Methods
18 $getpaymentmethods = "SELECT DISTINCTROW PaymentMethods.* FROM PaymentMethods ORDER BY PaymentMethods.PaymentMethod";
19
20
21 // Get Member Listing
22 $getmemberlist = "SELECT DISTINCTROW CONCAT(Members.LastName,' ', Members.FirstName) AS MemberName, Members.*,
23 MemberTypes.MemberType FROM MemberTypes
24 RIGHT JOIN Members
25 ON MemberTypes.MemberTypeID = Members.MemberTypeID";
26
27 // Get Committee Members
28 $getcommitteemembers = "SELECT DISTINCTROW Committees.CommitteeName, CommitteeMembers.CommitteePosition,
29 CONCAT(Members.FirstName,' ', Members.LastName) AS MemberName, Members.HomePhone,
30 Members.WorkPhone, Members.Extension, Members.FaxNumber
31 FROM Members
32 INNER JOIN Committees ON Committees.CommitteeID = CommitteeMembers.CommitteeID
33 INNER JOIN CommitteeMembers ON Members.MemberID = CommitteeMembers.MemberID";
34
35 // Get Payment Sum
36 $getpaymentsum_old = "SELECT DISTINCTROW Members.MemberID, CONCAT(Members.LastName,' ', Members.FirstName) AS MemberName
37 FROM Members ORDER BY MemberName";
38
39 // Get Payment Sum
40 $getpaymentsum = "SELECT DISTINCTROW Payments.MemberID, SUM(Payments.PaymentAmount) AS TotalPayments
41 FROM Payments GROUP BY Payments.MemberID ";
42
43 // Get Invoice for member
44 $getmembercommittee = "SELECT * FROM Payments";
45
46
47
48 $result=mysql_query($getmembercommittee);
49 if(!$result) {
50 print "ERROR MySQL SAID: " . mysql_error();
51 print "<P>" . $getpaymentsum;
52 } else {
53 print "<table><tr>\n";
54 while($field=mysql_fetch_field($result)) {
55 print "<th>".$field->name."</th>\n";
56 }
57 print "</tr>";
58 while($value=mysql_fetch_array($result)) {
59 print "<tr bgcolor=#CCCCCC>\n";
60 for($i=0; $i < mysql_num_fields($result); $i++) {
61 print "<td>".$value[$i]."</td>\n";
62 }
63 print "</tr>\n";
64 }
65 print "</table>\n";
66 }
67
68 ?>
\n" ;
while (list($key, $val) = each($link_array)) {
$label = ucfirst($key);
$link = $page_dir . "$val";
echo "<TD align='CENTER'><A HREF=$link>";
echo "<FONT SIZE='1' FACE='Arial'>$label</FONT></TD>\n";
}
echo "</TR></TABLE>\n";
}
/*
** Function: printBoldtxt()
** Input: test string
** Output: Std HTML
** Description: display text bolded
**
**
*/
function printBoldtxt($text)
{
print "<B>" . $text . "</B>";
}
/*
** Function: printColoredtxt()
** Input: color of text and text string
** Output: Std HTML
** Description: bottom table of web site
**
**
*/
function printColoredtxt($color="black", $text)
{
print "<FONT COLOR=\"$color\">" . $text . "</FONT>";
}
/*
** Function: printPage()
** Input:
** Output: Std HTML
** Description: display <P>
**
**
*/
function printPage()
{
print "<P>\n";
}
/*
** Function: makeList()
** Input: variable defined in page
** Output: Std HTML
** Description: display html list
**
**
*/
function makeList()
{
global $listType;
print "<".$listType.">";
for($i=0; $i < func_num_args(); $i++)
{
print "<LI>" . func_get_arg($i) . "\n";
}
print "</".$listType.">";
}
/*
** Function: siteTheme()
** Input:
** Output: Std HTML
** Description: background text, link color template
**
**
*/
function siteTheme($scheme="smoke")
{
include("schemes/$scheme.scheme.php");
return;
}
function displayButtons($type, $button_array, $buttonvalue="")
{
reset($button_array);
for($i=0; $i < count($button_array); $i++) {
$question = $button_array[$i];
$q_id = $buttonvalue;
if($type == "radio") {
print "<input type=\"$type\" name=\"$q_id\" value=\"$q_id\" > $question <br>\n";
} else {
print "<input type=\"$type\" name=\"tt_id[]\" value=\"$question\"> $question <br>\n";
}
}
}
function array2select($arr_str, $sel = "") {
while( list( $key, $val ) = each($arr_str)) {
if($sel && $key == $sel) {
$select_value = " selected";
} else {
$select_value="";
}
print "<option
value=\"$key\" $select_value>$val</option>\n";
}
}
?>
| |