<html>
<head>
<title><Organization Name> - Member Business Directory</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="Expires" content="0">
<META HTTP-EQUIV="Update" CONTENT="0">
<link rel="stylesheet" type="text/css" href="memberdb.css">
<script>
function LoadArrays()
{
<?php
include "MemberDb.inc";
$theDb = new cMemberDb();
$catlist = array();
$catidx = 0;
$subcatlist = array();
$subcatidx = 0;
$theDb->GetCategoryList($catlist);
$clen = sizeof($catlist);
echo "cats = [";
for ($i = 0; $i < $clen; $i++) {
echo "\"{$catlist[$i]}\"";
if ($i < $clen - 1) {
// index increments at start of loop
echo ",";
}
if (isset($category) && $catlist[$i] == $category) {
$catidx = $i + 1;
}
}
<title><Your Organization Here> - Member Directory</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<h3><Organization> Member Directory</h3>
<?php
$name = $_GET["name"];
if (isset($name)) {
if (!isset($cMembertype)) {
include "Member.inc";
}
if (!isset($cMemberdbtype)) {
include "MemberDb.inc";
}
include "DeeDubUtils.inc";
$theDb = new cMemberDb();
$mbrlist = array();
$theDb->SelectByName($name, $mbrlist);
print "<p>Members By Name:</p>";
print "<table>";
for ($i = 0; $i < sizeof($mbrlist); $i++) {
$theMember = $mbrlist[$i];
$displayPhone = formatPhone($theMember->phone, $PAREN_STYLE);
$displayFax = formatPhone($theMember->fax, $PAREN_STYLE);
print "<tr><td class=\"memberlabel\">Company:</td><td class=\"memberdata\">{$theMember->company}</td></tr>";
print "<tr><td class=\"memberlabel\">Category:</td><td class=\"memberdata\">{$theMember->category}, {$theMember->subcategory}</td></tr>";
print "<tr><td class=\"memberlabel\">Address:</td><td class=\"memberdata\">{$theMember->address}<br>{$theMember->city}, {$theMember->state} {$theMember->zip}</td></tr>";
print "<tr><td class=\"memberlabel\">Contact:</td><td class=\"memberdata\">{$theMember->firstname} {$theMember->lastname}</td></tr>";
print "<tr><td class=\"memberlabel\">Phone:</td><td class=\"memberdata\">{$displayPhone} Ext: {$theMember->extn}</td></tr>";
print "<tr><td class=\"memberlabel\">Fax:</td><td class=\"memberdata\">{$displayFax}</td></tr>";
print "<tr><td class=\"memberlabel\">Website:</td><td class=\"memberdata\"><a href=\"http://{$theMember->website}\" target=\"_blank\">{$theMember->website}</a></td></tr>";
<title><Your Organization Here> - Member Business Directory</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<h3><Organization> Member Directory</h3>
<?php
$subcategory = $_GET["subcategory"];
if (isset($subcategory)) {
if (!isset($cMembertype)) {
include "Member.inc";
}
if (!isset($cMemberdbtype)) {
include "MemberDb.inc";
}
include "DeeDubUtils.inc";
$theDb = new cMemberDb();
$mbrlist = array();
$theDb->SelectBySubcategory($subcategory, $mbrlist);
print "<p>Members in the subcategory {$subcategory}:</p>";
print "<table>";
for ($i = 0; $i < sizeof($mbrlist); $i++) {
$theMember = $mbrlist[$i];
// format phone numbers for display
$displayPhone = formatPhone($theMember->phone, $PAREN_STYLE);
$displayFax = formatPhone($theMember->fax, $PAREN_STYLE);
print "<tr><td class=\"memberlabel\">Company:</td><td class=\"memberdata\">{$theMember->company}</td></tr>";
print "<tr><td class=\"memberlabel\">Category:</td><td class=\"memberdata\">{$theMember->category}, {$theMember->subcategory}</td></tr>";
print "<tr><td class=\"memberlabel\">Address:</td><td class=\"memberdata\">{$theMember->address}<br>{$theMember->city}, {$theMember->state} {$theMember->zip}</td></tr>";
print "<tr><td class=\"memberlabel\">Contact:</td><td class=\"memberdata\">{$theMember->firstname} {$theMember->lastname}</td></tr>";
print "<tr><td class=\"memberlabel\">Phone:</td><td class=\"memberdata\">{$displayPhone} Ext: {$theMember->extn}</td></tr>";
print "<tr><td class=\"memberlabel\">Fax:</td><td class=\"memberdata\">{$displayFax}</td></tr>";
<title><Your Organization Here> - Member Directory</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<h3><Organization> Member Directory</h3>
<?php
$category = $_GET["category"];
if (isset($category)) {
if (!isset($cMembertype)) {
include "Member.inc";
}
if (!isset($cMemberdbtype)) {
include "MemberDb.inc";
}
include "DeeDubUtils.inc";
$theDb = new cMemberDb();
$mbrlist = array();
$theDb->SelectByCategory($category, $mbrlist);
print "<p>Members in the Category {$category}:</p>";
print "<table>";
for ($i = 0; $i < sizeof($mbrlist); $i++) {
$theMember = $mbrlist[$i];
// format phone numbers for display
$displayPhone = formatPhone($theMember->phone, $PAREN_STYLE);
$displayFax = formatPhone($theMember->fax, $PAREN_STYLE);
print "<tr><td class=\"memberlabel\">Subcategory:</td><td class=\"memberdata\">{$theMember->subcategory}</td></tr>";
print "<tr><td class=\"memberlabel\">Company:</td><td class=\"memberdata\">{$theMember->company}</td></tr>";
print "<tr><td class=\"memberlabel\">Address:</td><td class=\"memberdata\">{$theMember->address}<br>{$theMember->city}, {$theMember->state} {$theMember->zip}</td></tr>";
print "<tr><td class=\"memberlabel\">Contact:</td><td class=\"memberdata\">{$theMember->firstname} {$theMember->lastname}</td></tr>";
print "<tr><td class=\"memberlabel\">Phone:</td><td class=\"memberdata\">{$displayPhone} Ext: {$theMember->extn}</td></tr>";
print "<tr><td class=\"memberlabel\">Fax:</td><td class=\"memberdata\">{$displayFax}</td></tr>";
* Could be used as a template for a alphabetical search page
-->
<html>
<head>
<title><Your Organization Here> - Member Directory</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<h3><Organization> Member Directory</h3>
<?php
$init = $_GET["init"];
if (isset($init)) {
include "Member.inc";
include "MemberDb.inc";
include "DeeDubUtils.inc";
$theDb = new cMemberDb();
$theList = array();
$theDb->SelectByInitial($init, $theList);
print "<p>Members by Initial {$init}</p>";
print "<table>";
for ($i = 0; $i < sizeof($theList); $i++) {
$theMember = $theList[$i];
// format phone numbers for display
$displayPhone = formatPhone($theMember->phone, $PAREN_STYLE);
$displayFax = formatPhone($theMember->fax, $PAREN_STYLE);
print "<tr><td class=\"memberlabel\">Company:</td><td class=\"memberdata\">{$theMember->company}</td></tr>";
print "<tr><td class=\"memberlabel\">Category:</td><td class=\"memberdata\">{$theMember->category}, {$theMember->subcategory}</td></tr>";
print "<tr><td class=\"memberlabel\">Address:</td><td class=\"memberdata\">{$theMember->address}<br>{$theMember->city}, {$theMember->state} {$theMember->zip}</td></tr>";
print "<tr><td class=\"memberlabel\">Contact:</td><td class=\"memberdata\">{$theMember->firstname} {$theMember->lastname}</td></tr>";
print "<tr><td class=\"memberlabel\">Phone:</td><td class=\"memberdata\">{$displayPhone} Ext: {$theMember->extn}</td></tr>";
print "<tr><td class=\"memberlabel\">Fax:</td><td class=\"memberdata\">{$displayFax}</td></tr>";
