test directory - Hoosier State Press Association

[et_pb_section admin_label=”section”][et_pb_row admin_label=”row”][et_pb_column type=”4_4″][et_pb_code admin_label=”Code”]<div class=”span-24″ id=”contentwrap”> <div class=”span-16″> <div id=”content”> <h2>Member Directory</h2> <!– TEMPLATE ENDS, START QUERY FORM –> <noscript> <h3>Your browser does not support JavaScript. Please allow JavaScript in order to use the search window.</h3></noscript> <? $username=”hspacom_hspa”; $password=”pixbase12″; $database=”hspacom_directory”; mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die( “Unable to select database”); $query=”SELECT * FROM Newspapers WHERE Member=\”Y\””; $result=mysql_query($query); $quer2=”SELECT NP.NewspaperID, R.Desc, P.FirstName, P.LastName FROM `NewspaperPerson` AS NP INNER JOIN `Newspapers` AS N ON NP.NewspaperID = N.NewspaperID INNER JOIN `Roles` AS R ON NP.RoleID = R.ID INNER JOIN `People` AS P ON NP.PersonID = P.PeopleID ORDER BY N.DirName, R.ID”; $resul2=mysql_query($quer2); $num=mysql_numrows($result); $nu2=mysql_numrows($resul2); mysql_close(); echo ‘<a href=”https://www.hspa.com/hspa_directory_print.php” target=”_blank”>Print</a> full directory by newspaper name.<br />’; echo ‘<a href=”https://www.hspa.com/hspa_directory_county_print.php” target=”_blank”>Print</a> full directory by county.<br />’; echo ‘<a href=”https://www.hspa.com/hspa_directory_newspaperquery.php” target=”_blank”>Print</a> results of newspaper name search.<br />’; echo ‘<a href=”https://www.hspa.com/hspa_directory_countyquery.php” target=”_blank”>Print</a> results of county search.<br />’; echo ‘<a href=”https://www.hspa.com/hspa_directory_cityquery.php” target=”_blank”>Print</a> results of city search.’; echo”<br /><br />\r\n”; echo”<label for=’search_field’>Enter terms to search (newspaper name, city or county):</label><br />”; /* echo”<h1>Hoosier State Press Association</h1>”; echo”<h1>Newspaper Directory</h1>”; echo”<p>Use your browser’s print function to print the directory.</p>”; echo”<br />\r\n”; */ echo”<input id=’search_field’ name=’search_field’ type=’text’/>”; /* echo “Number of newspapers in the database = $num<br><br>”; echo “Number of paper roles in the database = $nu2<br><br>”; */ for( $i = 0; $i < $num; $i++ ) { $NewspaperID=mysql_result($result,$i,”NewspaperID”); $Member=mysql_result($result,$i,”Member”); $CountyID=mysql_result($result,$i,”CountyID”); $CountyName=mysql_result($result,$i,”CountyName”); $DirName=mysql_result($result,$i,”DirName”); $MailAdd1=mysql_result($result,$i,”MailAdd1″); $MailAdd2=mysql_result($result,$i,”MailAdd2″); $MailCity=mysql_result($result,$i,”MailCity”); $MailState=mysql_result($result,$i,”MailState”); $MailZip=mysql_result($result,$i,”MailZip”); $DelAdd1=mysql_result($result,$i,”DelAdd1″); $DelAdd2=mysql_result($result,$i,”DelAdd2″); $DelCity=mysql_result($result,$i,”DelCity”); $DelState=mysql_result($result,$i,”DelState”); $DelZip=mysql_result($result,$i,”DelZip”); $Phone=mysql_result($result,$i,”Phone”); $Phone2=mysql_result($result,$i,”Phone2″); $FAX=mysql_result($result,$i,”FAX”); $EdFax=mysql_result($result,$i,”EdFax”); $AdFax=mysql_result($result,$i,”AdFax”); $EMAIL=mysql_result($result,$i,”EMAIL”); $WEB=mysql_result($result,$i,”WEB”); $YearEstablished=mysql_result($result,$i,”YearEstablished”); $PARENTPAPR=mysql_result($result,$i,”PARENTPAPR”); $Freq=mysql_result($result,$i,”Freq”); $Issuedate=mysql_result($result,$i,”issuedate1″); $Circ_1=mysql_result($result,$i,”Circ_1″); echo “<div class=\”option\”>”; echo “<div class=\”newspaper\”>$DirName</div><br />”; echo “<div class=\”dir\” id=\”label\”>County:</div><div class=\”county\” id=\”value\”>$CountyName</div><br />\r\n”; echo “<div class=\”dir\” id=\”label\”>City/State:</div><div class=\”city\” id=\”value\”>$MailCity, $MailState</div><br />\r\n”; /* echo “<div class=\”dir\” id=\”label\”>Newspaper:</div><div class=\”dir\” id=\”newspapername\”><strong>$DirName</strong></div><br />\r\n”; */ echo “<div class=\”dir\” id=\”label\”>Mailing Address:</div><div class=\”dir\” id=\”value\”>$MailAdd1</div><br />\r\n”; if ($MailAdd2 != “”) { echo “<div class=\”dir\” id=\”label\”> </div><div class=\”dir\” id=\”value\”>$MailAdd2</div><br />\r\n”; } echo “<div class=\”dir\” id=\”label\”> </div><div class=\”dir\” id=\”value\”>$MailCity, $MailState $MailZip</div><br />\r\n”; if ($DelAdd1 != “”) { echo “<div class=\”dir\” id=\”label\”>Street Address:</div><div class=\”dir\” id=\”value\”>$DelAdd1</div><br />\r\n”; if ($DelAdd2 != “”) { echo “<div class=\”dir\” id=\”label\”> </div><div class=\”dir\” id=\”value\”>$DelAdd2</div><br />\r\n”; } echo “<div class=\”dir\” id=\”label\”> </div><div class=\”dir\” id=\”value\”>$DelCity, $DelState $DelZip</div><br />\r\n”; } $Areacode = substr(“$Phone”,0,3); $FirstThreePhone = substr(“$Phone”,3,3); $LastFourPhone = substr(“$Phone”,6,4); echo “<div class=\”dir\” id=\”phone\”>Phone (Main):</div><div class=\”dir\” id=\”value\”>($Areacode) $FirstThreePhone-$LastFourPhone</div>”; if ($Phone2 != “”) { $Areacode2 = substr(“$Phone2”,0,3); $FirstThreePhone2 = substr(“$Phone2”,3,3); $LastFourPhone2 = substr(“$Phone2”,6,4); echo “<div class=\”dir\” id=\”phone2\”>Phone (Toll Free):</div><div class=\”dir\” id=\”value\”>($Areacode2) $FirstThreePhone2-$LastFourPhone2</div><br />\r\n”; } else { echo “<br />\r\n”; } if ($FAX != “”) { $FAXAreacode = substr(“$FAX”,0,3); $FAXFirstThreePhone = substr(“$FAX”,3,3); $FAXLastFourPhone = substr(“$FAX”,6,4); echo “<div class=\”dir\” id=\”phone\”>Ad Fax:</div><div class=\”dir\” id=\”value\”>($FAXAreacode) $FAXFirstThreePhone-$FAXLastFourPhone</div>”; } /* if ($EdFax != “”) { echo “<div class=\”dir\” id=\”phone”; if ($FAX !=””) { echo “2”; } echo “\”>Ed Fax:</div><div class=\”dir\” id=\”value\”>$EdFax</div><br />\r\n”; } else { if ($FAX != “” or $EdFax != “”) { echo “<br />\r\n”; } else { } } */ if ($EdFax != “”) { echo “<div class=\”dir\” id=\”edfax\”>Ed Fax:</div><div class=\”dir\” id=\”value\”>$EdFax</div><br />\r\n”; } else { if ($FAX != “” or $EdFax != “”) { echo “<br />\r\n”; } else { } } $emailfirstfour = substr($EMAIL,0,4); /* echo “$emailfirstfive”; */ if ($EMAIL != “”) { if ($emailfirstfour == ‘(fir’ || $emailfirstfour == ‘(las’ || $emailfirstfour == ‘firs’ || $emailfirstfour == ‘(nam’ || $emailfirstfour == ‘name’) { echo “<div class=\”dir\” id=\”label\”>E-mail Pattern:</div><div class=\”dir\” id=\”value\”>$EMAIL</div><br />\r\n”; } else { echo “<div class=\”dir\” id=\”label\”>E-mail:</div><div class=\”dir\” id=\”value\”><a href=\”mailto:$EMAIL\”>$EMAIL</a></div><br />\r\n”; } } if ($WEB != “”) { echo “<div class=\”dir\” id=\”label\”>Website URL:</div><div class=\”dir\” id=\”value\”><a href=\”http://$WEB\” target=\”_blank\”>$WEB</a></div><br />\r\n”; } if ($YearEstablished != “”) { echo “<div class=\”dir\” id=\”label\”>Year Established:</div><div class=\”dir\” id=\”value\”>$YearEstablished</div><br />\r\n”; } if ($PARENTPAPR != “”) { echo “<div class=\”dir\” id=\”label\”>Parent Co.:</div><div class=\”dir\” id=\”value\”>$PARENTPAPR</div><br />\r\n”; } if ($Freq != “”) { echo “<div class=\”dir\” id=\”label\”>Frequency:</div><div class=\”dir\” id=\”value\”>$Freq</div><br />\r\n”; } if ($Issuedate != “”) { echo “<div class=\”dir\” id=\”label\”>Issues:</div><div class=\”dir\” id=\”value\”>$Issuedate</div><br />\r\n”; } if ($Circ_1 != “”) { $FormatCirc=number_format($Circ_1); echo “<div class=\”dir\” id=\”label\”>Circulation:</div><div class=\”dir\” id=\”value\”>$FormatCirc</div><br />\r\n”; } for( $j = 0; $j < $nu2; $j++ ) { $PersonPaper=mysql_result($resul2,$j,”NewspaperID”); if( $NewspaperID == $PersonPaper ) { $Role = mysql_result($resul2,$j,”Desc”); $FNam = mysql_result($resul2,$j,”FirstName”); $LNam = mysql_result($resul2,$j,”LastName”); echo “<div class=\”dir\” id=\”label\”>$Role:</div><div class=\”dir\” id=\”value\”>$FNam $LNam</div><br />\r\n”; } } echo”</div>”; /* echo”</div>”; */ /* echo “<hr />\r\n”; */ } ?> <!– END QUERY FORM START TEMPLATE –> </div>[/et_pb_code][/et_pb_column][/et_pb_row][/et_pb_section]