|
MemberShip Database port to PHP4
|
/ -> display_thismember.php
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 $getmemberlist = "SELECT DISTINCTROW CONCAT(Members.LastName,' ', Members.FirstName) AS MemberName, Members.*,
19 MemberTypes.MemberType FROM MemberTypes
20 RIGHT JOIN Members
21 ON MemberTypes.MemberTypeID = Members.MemberTypeID
22 WHERE Members.MemberID = '$MemberID'";
23
24
25 // if this is a submit process
26
27
28 $result = query($getmemberlist);
29 if(!$result) {
30 print error();
31 } else {
32 print "<TABLE>";
33 while($row=fetch_array($result)) {
34 extract($row);
35 print $MemberID ."<br>";
36 print $HomePhone ."<br>";
37 print $FirstName ."<br>";
38 print $MemberType ."<br>";
39 print $LastName ."<br>";
40 print $DateJoined ."<br>";
41 print $HomeAddress ."<br>";
42 print $InvoiceWorkAddress ."<br>";
43 print $HomeCity ."<br>";
44 print $MemberDues ."<br>";
45 print $HomeStateOrProvince ."<br>";
46 print $AmountPaid ."<br>";
47 print $HomePostalCode ."<br>";
48 print $AmountDue ."<br>";
49 print $HomeCountry ."<br>";
50 print $MemberName ."<br>";
51 print $WorkPhone ."<br>";
52 print $WorkCompany ."<br>";
53 print $Extension ."<br>";
54 print $Title ."<br>";
55 print $FaxNumber ."<br>";
56 print $WorkAddress ."<br>";
57 print $EmailName ."<br>";
58 print $WorkCity ."<br>";
59 print $WorkCountry ."<br>";
60 }
61 print "</TABLE>";
62 }
63
64 print "<center>";
65 $link_array = array(
66 "Edit Member" => "edit_member.php?MemberID=$MemberID");
67
68 navBar($link_array);
69
70 formActionBegin("display_membercommittee.php?MemberID=$MemberID");
71 formActionEnd("submit","GET ADDITIONAL INFO ABOUT MEMBER");
72 print "</center>";
73
74 pageBottom();
75 siteFooter();
76
77
78
79 ?>
| |