1  <?php
2  // get application functions
3  require('include/variables.php');
4  require('include/app_functions.php');
5 
6  // Get phpcolortheme
7  include('include/win95.scheme.php');
8 
9  siteHeader("Committees Script");
10 
11  pageTop("Membership Database Application: ADD COMMITTEE MEMBERS");
12 
13  bodyTag();
14 
15  // Define $conn
16  $conn = connect();
17 
18  // if this is a submit process data ...
19 
20  if($submit) {
21    // Error Checking
22    $ErrorArr = array();
23    if(!$CommitteeID) $ErrorArr[] = "APPLICATION ERROR: please notify developer";
24    if(!$MemberID) $ErrorArr[] = "APPLICATION ERROR: please notify developer";
25    if(!$CommitteePosition) $ErrorArr[] = "Committee Position is Required";
26    foreach($ErrorArr as $Errors) {
27          print "<LI>". $Errors ."\n";
28    }
29 
30    // Create query
31    $insert_qry = "INSERT INTO CommitteeMembers";
32    $insert_qry .= " VALUES ('', '$CommitteeID','$MemberID',
33                   '$CommitteePosition')";
34    // Execute Query
35    $result = query($insert_qry);
36    if(!$result) {
37          print error();
38          } else {
39          print "Data was entered<BR>\n";
40          // print "<A HREF=display_members.php>Display Members</A>\n";
41          }
42 
43     } else {
44 
45 
46  $qry = "SELECT DISTINCTROW Members.MemberID, CONCAT(Members.FirstName,' ',Members.LastName) AS MemberName
47                          FROM Members ORDER BY MemberName";
48 
49 
50     formActionBegin("$PHP_SELF");
51       formInput("hidden","CommitteeMemberID","''");
52       formInput("hidden","CommitteeID","''");
53       print "<br>\n";
54       print "MemberID\n<br>\n";
55       print "<SELECT NAME=MemberID>\n";
56        $result = query($qry);
57        if(!$result) {
58          print "ERROR: ". error();
59          } else {
60          while($row=fetch_array($result)) {
61          extract($row);
62           print "<OPTION VALUE=$MemberID>$MemberName\n";
63          }
64           print "</SELECT>\n";
65       print "<br>";
66       print "Committee Position<br>";
67       formTextArea("CommitteePosition");
68     formActionEnd("submit","Submit Committee Members");
69    }
70  }
71  pageBottom();
72  siteFooter();
73 
74 
75  ?>