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: ADD 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 = "INSERT INTO Committees";
42    $insert_qry .= " VALUES ('', '$CommitteeName','$CommitteeDescription')";
43       
44    $result = query($insert_qry);
45    if(!$result) {
46          print error();
47          } else {
48          print "Data was entered";
49          }
50 
51  } else {
52 
53   
54     formActionBegin("$PHP_SELF");
55 
56  print<<<FORM
57  <table border=1 cellspacing=1 width=535><tr><td colspan=2 bgcolor=#000080><font
58  color=#ffffff><b>Get Member Info:</b></font></td></tr></table>
59 
60  <table border=0 cellspacing=3 width=535>
61  <tr><td colspan=2 bgcolor=#bbbbbb align=right>MemberID: <INPUT TYPE=text NAME=MemberID value=""></td>
62  <td colspan=2 bgcolor=#bbbbbb align=right>Home Phone: <input type=text name=HomePhone></td></tr>
63  <tr><td colspan=2 bgcolor=#bbbbbb align=right>First Name: <INPUT TYPE=TEXT NAME=FirstName></td>
64  <td colspan=2 bgcolor=#bbbbbb align=right>Member Type: <input type=text name=MemberType></td></tr>
65  <tr><td colspan=2 bgcolor=#bbbbbb align=right>Last Name: <INPUT TYPE=text
66  NAME=LastName></td>
67  <td colspan=2 bgcolor=#bbbbbb align=right>Date Joined: <INPUT TYPE=text NAME=DateJoined></td</tr>
68  <tr><td colspan=2 bgcolor=#bbbbbb align=right>Home Address: <INPUT TYPE=TEXT NAME=HomeAddress ></td>
69  <td colspan=2 bgcolor=#bbbbbb align=right>Send Inv to Work:
70  <input type=radio name=InvoiceWorkAddress VALUE="N" CHECKED> No
71  <input type=radio name=InvoiceWorkAddress VALUE="Y" > Yes
72  </td></tr>
73  <tr><td colspan=2 bgcolor=#bbbbbb align=right>Member Dues: <INPUT TYPE=text
74  NAME=MemberDues></td>
75  <td colspan=2 bgcolor=#bbbbbb align=right>State/Province: <INPUT TYPE=text NAME=HomeStateOrProvince></td</tr>
76  <tr><td colspan=2 bgcolor=#bbbbbb align=right>Amount Paid: <INPUT TYPE=TEXT NAME=AmountPaid></td>
77  <td colspan=2 bgcolor=#bbbbbb align=right>Postal Code: <input type=text name=PostalCode></td></tr>
78  <tr><td colspan=2 bgcolor=#bbbbbb align=right>Amount Due: <INPUT TYPE=text
79  NAME=AmountDue></td>
80  <td colspan=2 bgcolor=#bbbbbb align=right>Country: <INPUT TYPE=text NAME=HomeCountry></td</tr>
81  </table>
82  <P>
83  <table border=1 cellspacing=1 width=535><tr><td colspan=2 bgcolor=#000080><font
84  color=#ffffff><b>Get Member Work Info:</b></font></td></tr></table>
85 
86  <table border=0 cellspacing=3 width=535>
87  <tr><td colspan=2 bgcolor=#bbbbbb align=right>Company Name: <INPUT TYPE=text NAME=CompanyName></td>
88  <td colspan=2 bgcolor=#bbbbbb align=right>Work Phone: <input type=text name=WorkPhone></td></tr>
89  <tr><td colspan=2 bgcolor=#bbbbbb align=right>Extension: <INPUT TYPE=TEXT NAME=Extension></td>
90  <td colspan=2 bgcolor=#bbbbbb align=right>Title: <input type=text name=Title></td></tr>
91  <tr><td colspan=2 bgcolor=#bbbbbb align=right>Fax Number: <INPUT TYPE=text
92  NAME=FaxNumber></td>
93  <td colspan=2 bgcolor=#bbbbbb align=right>Work Address: <INPUT TYPE=text NAME=WorkAddress></td</tr>
94  <tr><td colspan=2 bgcolor=#bbbbbb align=right>Email: <INPUT TYPE=TEXT NAME=EmailName></td>
95  <td colspan=2 bgcolor=#bbbbbb align=right>&nbsp;</tr>
96  </table>
97  FORM;
98 
99 
100     formActionEnd("submit","Add Member");
101  }
102 
103 
104 
105  pageBottom();
106  siteFooter();
107 
108 
109  ?>
110