<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>";