1  <?php
2 
3  // get application functions
4  require('include/variables.php');
5  require('include/app_functions.php');
6 
7  include('include/win95.scheme.php');
8 
9  siteHeader("Committees Script");
10 
11  pageTop("Membership Database Application: MEMBER INFORMATION ");
12 
13  bodyTag();
14 
15  // Define $conn
16  $conn = connect();
17 
18  $getcommitteemembers = "SELECT DISTINCTROW Committees.CommitteeName, CommitteeMembers.CommitteePosition,
19                                CONCAT(Members.FirstName,' ', Members.LastName) AS MemberName, Members.HomePhone,
20                                Members.WorkPhone, Members.Extension, Members.FaxNumber
21                                FROM Members
22                                INNER JOIN Committees ON Committees.CommitteeID = CommitteeMembers.CommitteeID
23                                INNER JOIN CommitteeMembers ON Members.MemberID = CommitteeMembers.MemberID
24                   WHERE Members.MemberID = '$MemberID'";
25 
26 
27 
28  // if this is a submit process
29    
30       
31    $result = query($getcommitteemembers);
32    if(!$result) {
33          print error();
34          } else {
35     if(numrows($result) == 0) {
36         print "Member is Not a Member of a Committee";
37     } else {
38          print "<TABLE>\n";
39          print "<tr><th>Member Name</th><th>Committee Name</th><th>Committee Position</th></tr>\n";
40            while($row=fetch_array($result)) {
41              extract($row);
42              print "<tr><td align=center>" . $MemberName
43              . "</td><td align=center>" . $CommitteeName
44              . "</td><td align=center>". $CommitteePosition ."</td></tr>\n";
45               }
46              print "</TABLE>\n";
47        }
48    }
49 
50 
51  printPage();
52 
53  $getmemberpayments = "SELECT Payments.*, PaymentMethods.PaymentMethod
54                          FROM PaymentMethods
55                          RIGHT JOIN Payments ON Payments.PaymentMethodID = PaymentMethods.PaymentMethodID
56                          WHERE MemberID = '$MemberID'";
57 
58 
59 
60  // if this is a submit process
61 
62 
63    $result = query($getmemberpayments);
64    if(!$result) {
65          print error();
66          } else {
67     if(numrows($result) == 0) {
68         print "Member is Not a Member of a Committee";
69     } else {
70          print "<TABLE>\n";
71          print "<tr><th>Payment Method</th><th>Payment Date</th><th>Payment Amount</th></tr>\n";
72            while($row=fetch_array($result)) {
73              extract($row);
74              print "<tr><td align=center>" . $PaymentMethod
75              . "</td><td align=center>" . $PaymentDate
76              . "</td><td align=center>". $PaymentAmount ."</td></tr>\n";
77               }
78              print "</TABLE>\n";
79        }
80    }
81 
82 
83 
84 
85     formActionBegin("display_members.php");
86     formActionEnd("submit","Display Members...");
87 
88  // print "Committees Script";
89 
90 
91 
92 
93  pageBottom();
94  siteFooter();
95 
96 
97 
98  ?>