|
MemberShip Database port to PHP4
|
/ -> edit_member.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: EDIT MEMBER");
12
13 bodyTag();
14
15 // Define $conn
16 $conn = connect();
17
18 // if this is a submit process
19 if($submit) {
20
21 // Error Checking
22 $ErrorArr = array();
23 if(!$HomePhone) $ErrorArr[] = "Home Phone is Required";
24 if(!$FirstName) $ErrorArr[] = "First Name is Required";
25 if(!$MemberType) $ErrorArr[] = "APPLICATION ERROR: Please notify developer";
26 if(!$LastName) $ErrorArr[] = "Last Name is Required";
27 if(!$DateJoined) $ErrorArr[] = "Date Joined is Required";
28 if(!$HomeAddress) $ErrorArr[] = "Home Address is Required";
29 if(!$MemberDues) $ErrorArr[] = "Member Dues is Required";
30 if(!$HomeStateOrProvince) $ErrorArr[] = "State/Province is Required";
31 if(!$AmountPaid) $ErrorArr[] = "Amount Paid is Required";
32 if(!$PostalCode) $ErrorArr[] = "Postal Code is Required";
33 if(!$AmountDue) $ErrorArr[] = "Amount Due is Required";
34 if(!$EmailName) $ErrorArr[] = "Email Address is Required";
35
36 foreach($ErrorArr as $Errors) {
37 $Errors = printColoredtxt("red",$Errors);
38 print $Errors."<br>\n";
39 }
40
41 $insert_qry = "UPDATE Members SET";
42 $insert_qry .= " FirstName = '$FirstName',";
43 $insert_qry .= " LastName = '$LastName',";
44 $insert_qry .= " MemberTypeID = '$MemberTypeID',";
45 $insert_qry .= " WorkCompany = '$WorkCompany',";
46 $insert_qry .= " Title = '$Title',";
47 $insert_qry .= " WorkAddress = '$WorkAddress',";
48 $insert_qry .= " WorkCity = '$WorkCity',";
49 $insert_qry .= " WorkStateOrProvince = '$WorkStateOrProvince',";
50 $insert_qry .= " WorkPostalCode = '$WorkPostalCode',";
51 $insert_qry .= " WorkCountry = '$WorkCountry',";
52 $insert_qry .= " WorkPhone = '$WorkPhone',";
53 $insert_qry .= " Extension = '$Extension',";
54 $insert_qry .= " HomeAddress = '$HomeAddress',";
55 $insert_qry .= " HomeCity = '$HomeCity',";
56 $insert_qry .= " HomeStateOrProvince = '$HomeStateOrProvince',";
57 $insert_qry .= " HomePostalCode = '$HomePostalCode',";
58 $insert_qry .= " HomeCountry = '$HomeCountry',";
59 $insert_qry .= " HomePhone = '$HomePhone',";
60 $insert_qry .= " EmailName = '$EmailName',";
61 $insert_qry .= " DateJoined = '$DateJoined',";
62 $insert_qry .= " FaxNumber = '$FaxNumber',";
63 $insert_qry .= " MobilePhone = '$MobilePhone',";
64 $insert_qry .= " InvoiceWorkAddress = '$InvoiceWorkAddress',";
65 $insert_qry .= " MemberDues = '$MemberDues'";
66 $insert_qry .= " WHERE MemberID = '$MemberID'";
67
68 ";
69
70 $result = query($insert_qry);
71 if(!$result) {
72 print error();
73 } else {
74 print "Data was entered";
75 }
76
77 } else {
78
79
80
81 $getmemberlist = "SELECT DISTINCTROW CONCAT(Members.LastName,' ', Members.FirstName) AS MemberName, Members.*,
82 MemberTypes.MemberType FROM MemberTypes
83 RIGHT JOIN Members
84 ON MemberTypes.MemberTypeID = Members.MemberTypeID
85 WHERE Members.MemberID = '$MemberID'";
86
87
88 // if this is a submit process
89
90
91 $result = query($getmemberlist);
92 if(!$result) {
93 print error();
94 } else {
95 print "<TABLE>";
96 while($row=fetch_array($result)) {
97 extract($row);
98
99
100 formActionBegin("$PHP_SELF");
101
102 print<<<FORM
103 <table border=1 cellspacing=1 width=535><tr><td colspan=2 bgcolor=#000080><font
104 color=#ffffff><b>Get Member Info:</b></font></td></tr></table>
105
106 <table border=0 cellspacing=3 width=535>
107 <tr><td colspan=2 bgcolor=#bbbbbb align=right>MemberID: <INPUT TYPE=text NAME=MemberID value="$MemberID"></td>
108 <td colspan=2 bgcolor=#bbbbbb align=right>Home Phone: <input type=text name=HomePhone value="$HomePhone"></td></tr>
109 <tr><td colspan=2 bgcolor=#bbbbbb align=right>First Name: <INPUT TYPE=TEXT NAME=FirstName value="$FirstName"></td>
110 <td colspan=2 bgcolor=#bbbbbb align=right>Member Type: <input type=text name=MemberType
111 value="$MemberType"></td></tr>
112 <tr><td colspan=2 bgcolor=#bbbbbb align=right>Last Name: <INPUT TYPE=text
113 NAME=LastName value="$LastName"></td>
114 <td colspan=2 bgcolor=#bbbbbb align=right>Date Joined: <INPUT TYPE=text NAME=DateJoined value="$DateJoined"></td</tr>
115 <tr><td colspan=2 bgcolor=#bbbbbb align=right>Home Address: <INPUT TYPE=TEXT NAME=HomeAddress
116 value="$HomeAddress"></td>
117 <td colspan=2 bgcolor=#bbbbbb align=right>Send Inv to Work:
118 <input type=radio name=InvoiceWorkAddress VALUE="N" CHECKED> No
119 <input type=radio name=InvoiceWorkAddress VALUE="Y" > Yes
120 </td></tr>
121 <tr><td colspan=2 bgcolor=#bbbbbb align=right>Member Dues: <INPUT TYPE=text
122 NAME=MemberDues value="$MemberDues"></td>
123 <td colspan=2 bgcolor=#bbbbbb align=right>State/Province: <INPUT TYPE=text NAME=HomeStateOrProvince
124 value="$HomeStateOrProvince"></td</tr>
125 <tr><td colspan=2 bgcolor=#bbbbbb align=right>Amount Paid: <INPUT TYPE=TEXT NAME=AmountPaid value="$AmountPaid"></td>
126 <td colspan=2 bgcolor=#bbbbbb align=right>Postal Code: <input type=text name=PostalCode
127 value="$PostalCode"></td></tr>
128 <tr><td colspan=2 bgcolor=#bbbbbb align=right>Amount Due: <INPUT TYPE=text
129 NAME=AmountDue value="$AmountDue"></td>
130 <td colspan=2 bgcolor=#bbbbbb align=right>Country: <INPUT TYPE=text NAME=HomeCountry value="$HomeCountry"></td</tr>
131 </table>
132 <P>
133 <table border=1 cellspacing=1 width=535><tr><td colspan=2 bgcolor=#000080><font
134 color=#ffffff><b>Get Member Work Info:</b></font></td></tr></table>
135
136 <table border=0 cellspacing=3 width=535>
137 <tr><td colspan=2 bgcolor=#bbbbbb align=right>Company Name: <INPUT TYPE=text NAME=CompanyName
138 value="$CompanyName"></td>
139 <td colspan=2 bgcolor=#bbbbbb align=right>Work Phone: <input type=text name=WorkPhone value="$WorkPhone"></td></tr>
140 <tr><td colspan=2 bgcolor=#bbbbbb align=right>Extension: <INPUT TYPE=TEXT NAME=Extension value="$Extension"></td>
141 <td colspan=2 bgcolor=#bbbbbb align=right>Title: <input type=text name=Title value="$Title"></td></tr>
142 <tr><td colspan=2 bgcolor=#bbbbbb align=right>Fax Number: <INPUT TYPE=text
143 NAME=FaxNumber value="$FaxNumber"></td>
144 <td colspan=2 bgcolor=#bbbbbb align=right>Work Address: <INPUT TYPE=text NAME=WorkAddress
145 value="$WorkAddress"></td</tr>
146 <tr><td colspan=2 bgcolor=#bbbbbb align=right>Email: <INPUT TYPE=TEXT NAME=EmailName value="$EmailName"></td>
147 <td colspan=2 bgcolor=#bbbbbb align=right> </tr>
148 </table>
149 FORM;
150
151
152 formActionEnd("submit","Add Member");
153 }
154 }
155 }
156
157 pageBottom();
158 siteFooter();
159
160
161 ?>
162
| |