getActiveSheet()->toArray(null,true,true,true); $vendorData = NULL; //pulls data from vendor sheet function searchVendor($id) { global $vendorData; if ($vendorData ==NULL) { $vendorFile = PHPExcel_IOFactory::load("DIRECTORY_Vendor.xlsx"); $vendorData = $vendorFile->getActiveSheet()->toArray(null,true,true,true); } $keys=array(); $row=$vendorData[1]; foreach($row as $k=>$v) { $keys[$k]=$v; } $ret=NULL; $i=0; foreach($vendorData as $row) { if(intval($row['A']) ==$id) { $ret=$row; break; } } if ($ret !=NULL) { $ret2=array(); foreach($keys as $k=>$v) { $ret2[$v]=$ret[$k]; } $ret=$ret2; } return $ret; } //looks up relevant district info from spreadsheet function searchDistrict($id) { global $districtData; $keys=array(); $row=$districtData[1]; foreach($row as $k=>$v) { $keys[$k]=$v; } $ret=NULL; $i=0; foreach($districtData as $row) { if(intval($row['A']) ==$id) { $ret=$row; break; } } if ($ret !=NULL) { $ret2=array(); foreach($keys as $k=>$v) { $ret2[$v]=$ret[$k]; } $ret=$ret2; } //look up sub data $naData=array('WORK_PHONE'=>'NA'); $subList=array('DIST_ATTORNEY','DIST_BOOKKEEPER','DIST_OPERATOR','DIST_TAXASSESSOR'); foreach($subList as $sl) { if ($ret[$sl]) { $ret[$sl]=searchVendor(intval($ret[$sl])); } else { $ret[$sl]=$naData; } } return $ret; } //search if necessary $searchV=NULL; $selArr=NULL; $lkup=0; if (array_key_exists('lkup', $_GET) && is_numeric($_GET['lkup'])) { $lkup=intval($_GET['lkup']); $searchV=searchDistrict($lkup); } //build the search dropdown $selArr=array(); $i=0; foreach($districtData as $row) { if ($i>0) { $selArr[$row['A']]= $row['B']; } $i++; } ?> Association of Water Board Directors - Texas: District Information Directory

District Information Directory Search

Select a district name from the dropdown to see contact information.

 

Search Results

Water District:
Phone: NA
Administrative/Legal Questions:
Operations or Utility Billing Questions :
Tax Questions: