<?php
/*
** Filename: index.php
** Coder: cthorn
** URL: http://PCCS-Linux.COM
**
**
**
*/
// Should this be a secure page
// if so, lets get the securepage source
// require('incs/securepage.php');
// Define the user and passwd for page
// $page_user=userid;
// $page_pw=password;
// Called the securePage() function
// securePage();
// Now start page
// Get variables and functions for application
require('appinclude.php');
// Create an array to pass to our navBar() function
$link_array = array (
"Main" => "index.php",
"List" => "list.php",
"Add" =>"add.php"
);
// Create an array to pass to our array2select() function
$searchfield_str = array(
"wkorder_id" => "Workorder ID",
"closed" => "Status"
);
// Create site header and define title for page
siteHeader("WorkOrder System");
1 <?php
2 $f=mysql_connect("localhost","root","") or die("Database Down");
3 mysql_select_db("membership");
4
5 // Get Members
6 $getmembers = "SELECT DISTINCTROW Members.* FROM Members
7 WHERE Members.MemberID = '$MembersID'";
8
9
10 // Get Committees
11 $getcommittees = "SELECT DISTINCTROW Committees.* FROM Committees ORDER BY Committees.CommitteeName";
12
13
14 // Get Member Types
15 $getmembertypes = "SELECT DISTINCTROW MemberTypes.* FROM MemberTypes ORDER BY MemberTypes.MemberType";
16
17 // Get Payment Methods
18 $getpaymentmethods = "SELECT DISTINCTROW PaymentMethods.* FROM PaymentMethods ORDER BY PaymentMethods.PaymentMethod";
19
20
21 // Get Member Listing
22 $getmemberlist = "SELECT DISTINCTROW CONCAT(Members.LastName,' ', Members.FirstName) AS MemberName, Members.*,
23 MemberTypes.MemberType FROM MemberTypes
24 RIGHT JOIN Members
25 ON MemberTypes.MemberTypeID = Members.MemberTypeID";
26
27 // Get Committee Members
28 $getcommitteemembers = "SELECT DISTINCTROW Committees.CommitteeName, CommitteeMembers.CommitteePosition,
29 CONCAT(Members.FirstName,' ', Members.LastName) AS MemberName, Members.HomePhone,
30 Members.WorkPhone, Members.Extension, Members.FaxNumber
31 FROM Members
32 INNER JOIN Committees ON Committees.CommitteeID = CommitteeMembers.CommitteeID
33 INNER JOIN CommitteeMembers ON Members.MemberID = CommitteeMembers.MemberID";
34
35 // Get Payment Sum
36 $getpaymentsum_old = "SELECT DISTINCTROW Members.MemberID, CONCAT(Members.LastName,' ', Members.FirstName) AS MemberName
37 FROM Members ORDER BY MemberName";
38
39 // Get Payment Sum
40 $getpaymentsum = "SELECT DISTINCTROW Payments.MemberID, SUM(Payments.PaymentAmount) AS TotalPayments
41 FROM Payments GROUP BY Payments.MemberID ";
42
43 // Get Invoice for member
44 $getmembercommittee = "SELECT * FROM Payments";
45
46
47
48 $result=mysql_query($getmembercommittee);
49 if(!$result) {
50 print "ERROR MySQL SAID: " . mysql_error();
51 print "<P>" . $getpaymentsum;
52 } else {
53 print "<table><tr>\n";
54 while($field=mysql_fetch_field($result)) {
55 print "<th>".$field->name."</th>\n";
56 }
57 print "</tr>";
58 while($value=mysql_fetch_array($result)) {
59 print "<tr bgcolor=#CCCCCC>\n";
60 for($i=0; $i < mysql_num_fields($result); $i++) {
61 print "<td>".$value[$i]."</td>\n";
62 }
63 print "</tr>\n";
64 }
65 print "</table>\n";
66 }
67
68 ?>
|