libraryDirectory."head.php"); include($bootstrap->libraryDirectory."datacon.php"); include($bootstrap->libraryDirectory."proclibUI.php"); $codeSearchTerm = $HTTP_POST_VARS['search']; $codeSearchTerm2 = $HTTP_POST_VARS['search2']; $details = $HTTP_POST_VARS['details']; $details2 = $HTTP_POST_VARS['details2']; $nameOnly = $HTTP_POST_VARS['nameOnly']; if ( strlen($_GET['codeType']) > 0){ $codeType = $_GET['codeType']; } elseif ( strlen($HTTP_POST_VARS['codeType']) > 0){ $codeType = $HTTP_POST_VARS['codeType']; } else { $codeType = 'NTEE'; } if ($codeType == 'NTEE'){ $codeNameFld = 'TERM_NAME'; $codeFld = 'CODE'; $otherFlds = 'KEYWORDS, SCOPE_NOTE, EXAMPLES'; } else { $codeNameFld = 'NAME'; $codeFld = 'code'; $otherFlds = 'BROADER, NARROWER, SCOPE_NOTES, EXAMPLES'; } if ($details === 0) {$details = 1; } if ( strlen($codeSearchTerm) == 0 and strlen($codeSearchTerm2) == 0 ) {$details =1;} // $details = 1; //------------------- CHANGE PARAMETERS IF FILE CHANGES ------------- if ($codeType == 'NTEE'){ // $codeFile = 'lookup.ntee2004a'; $codeFile = 'lookup.ntee2007a'; } else { $codeFile = 'lookup.npc2004a'; } /***********************************************************/ $debug = 0; $getVal = $_GET['gQry']; if ( strlen($codeSearchTerm2) > 0 and strlen( $codeSearchTerm) == 0) { $codeSearchTerm = $codeSearchTerm2;} echo "NCCS - Search $codeType Definitions\n"; ?>

"; $smallBanner = 1; include("head2.php"); echo "\n"; $detailsChecked =''; if ($details == 1 or $details2 == 1) { $detailsChecked ='CHECKED';} $nameOnlyChecked = ''; if ($nameOnly == 1){ $nameOnlyChecked = 'CHECKED';} // echo "details: $detailsChecked
"; echo "

Search:

Include all details?"; echo " - List codes & names only?"; echo "
View all codes - Help"; echo "

\n"; // echo " (NPC Tools Menu)

\n"; // echo "

NCCS - Search $codeType Definitions

\n"; /* echo "Examples:
- 'A' - NTEE=A - 'A65' - NTEE=Theater - 'Arts' - Any NTEE codes with the word 'arts' in their names, descriptions, etc.

- "; */ echo "

"; // standard query statements: $stdQ = " ORDER BY code"; $codeSearchTerm = strtoupper($codeSearchTerm); $doHilite = 0; if ( strlen( $gQry) > 0){ if ($gQry == 'all'){ $nameOnly = 1; $codeSearchQry = "select * from $codeFile". $stdQ; } else { $codeSearchQry = "select * from $codeFile where code like '". substr($gQry,0,2)."0%' OR code = '".substr($gQry,0,1)."' or code = '$gQry' $stdQ"; } } elseif ( strlen($codeSearchTerm) == 1) { $codeSearchQry = "select * from $codeFile where code like '$codeSearchTerm%' $stdQ"; } elseif ( strlen($codeSearchTerm) <= 4 and substr( $codeSearchTerm,1,1) >= '0' and substr( $codeSearchTerm,1,1) <= '9') { $codeSearchQry = "select * from $codeFile where code like '$codeSearchTerm%' $stdQ"; } elseif ( strlen( $codeSearchTerm) > 0) { $doHilite = 1; $codeSearchQry = "select * from $codeFile where UPPER(CONCAT_WS(',',CODE, $codeNameFld, DEFINITION, $otherFlds )) like '%$codeSearchTerm%' $stdQ"; } // echo "Query: $codeSearchTerm
$codeSearchQry
"; if ( strlen( $codeSearchTerm) > 0 or strlen($gQry)>0){ $codeResults = mysql_query($codeSearchQry); $numCodeResults = mysql_num_rows($codeResults); if ( $numCodeResults == 0) { // echo "Query:
$codeSearchQry

\n"; echo "Search term: '$codeSearchTerm' -- NO RECORDS FOUND.

\n"; echo ''.mysql_error()."

"; return 0; } else { echo "Number found for '$codeSearchTerm': $numCodeResults

\n"; } if ($debug == 1) {echo "Query:
$codeSearchQry

\n";} for ( $i=0; $i < $numCodeResults; $i++) { $row = mysql_fetch_array($codeResults); $code = $row[$codeFld]; $code2 = $code; if ($nameOnly == 1){ $code = ''.$code.''; } $termName = $row[$codeNameFld]; $def = $row['DEFINITION']; $keywords = $row['KEYWORDS']; $scopeNote = $row['SCOPE_NOTE']; $examples = $row['Examples']; $NAICS = '(NAICS: '.trim(substr($row['NAICS3'],0,3)).')'; if (strlen($row['NAICS3'])<1 or $row['NAICS3']=='000') $NAICS = ''; $hcolor = 'BLUE'; if ($doHilite == 1 ) { $termName = HiliteWord($termName, $codeSearchTerm ); $def = HiliteWord($def, $codeSearchTerm ); $scopeNote = HiliteWord($scopeNote, $codeSearchTerm ); $keywords = HiliteWord($keywords, $codeSearchTerm ); $examples = HiliteWord($examples, $codeSearchTerm ); } if (strlen( $code) == 1) { $hcolor = 'RED';} echo "$code - $termName $NAICS"; echo " - (Examples)\n"; echo "(Largest)\n"; echo "
\n"; if ($nameOnly <> 1){ if (strlen( $def)>0) { echo "$def

"; } if (strlen( $keywords) > 0) { echo "Key words: $keywords

";} if (strlen( $scopeNote) > 0) { echo "Scope notes: $scopeNote

";} if ( ($details ==1 or $details2==1) and strlen( $examples)>3 ) { echo "

Examples: $examples

"; } echo "
"; } } } if ($numCodeResults > 0 and 1==1){ // Need submit button if appears if add 2nd button on page: echo "

Search: \n"; echo " Include details? "; echo " - NTEE"; echo " - NPC"; echo "

"; } echo "\n"; echo "

"; ?> A service of the National Center for Charitable Statistics at the Urban Institute