include 'header.php';
include 'class/dbClass.php';
$db = new dbHandler();
// display the html
printHeader();
if ( $advanced )
{
echo "
|
";
} else {
echo "
|
";
}
if ( $submitButton || $words )
{
$url = 'Source';
$col = 'Title';
if ( $state )
$extras .= "&state=$State";
if ( $org )
$extras .= "&org=$org";
if ( $words )
$extras .= "&words=$words";
if ( $topic )
$extras .= "&topic=$topic";
if ( $perPage )
$extras .= "&perPage=$perPage";
$db->dbConnect();
$wordsSplit = explode( " ",$words );
$refers = array();
$limitQuery = array();
if ( $searchOn )
{
switch( $searchOn )
{
case 'fh':
$colOpt = 'First_Heading';
break;
case 'sh':
$colOpt = 'Second_heading';
break;
case 'st':
$colOpt = 'Summary_title';
break;
}
}
for ( $i=0; $i$query";
$db->dbQuery( $query );
$resultCount = $db->resultCount();
} else {
$resultCount = '';
}
if ( $resultCount )
{
for( $i=0; $i<$resultCount; $i++ )
{
( !$commas ) ? $commas = $db->resultArray[$i]['DataTabletxtRefer'] : $commas .= ", " . $db->resultArray[$i]['DataTabletxtRefer'];
}
// limiter for selective heading search crap
if( $limitQuery )
{
$tempLim = array();
foreach( $limitQuery as $discoBob )
{
$discoBob .= " and refer in ( $commas )";
$db->dbQuery( $discoBob );
// echo "$discoBob
";
$tempRc = $db->resultCount();
// echo "toal $tempRc
";
for( $x=0; $x<$tempRc; $x++ )
{
$tempLim[( $db->resultArray[$x]['refer'] )] = 'bob';
// $refer = $db->resultArray[$x]['refer'];
// echo "$refer
";
}
}
if ( $tempLim )
{
$commas = '';
foreach( $tempLim as $key => $crap )
{
( !$commas ) ? $commas = $key : $commas .= ", " . $key;
}
} else {
$resultCount = 0;
$commas = '';
}
}
// New advanced search stuff
if( !$perPage )
$perPage = 50;
(!$limit ) ? $limit = 0 : $prev = true;
if( $state )
$conditions .= "and State = \"$state\"";
if( $org )
$conditions .= "and Type = \"$org\"";
if( $topic )
$conditions .= "and First_Heading = \"$topic\"";
if ( $resultCount )
{
$db->dbQuery( "select * from DataTabletxt where refer in ( $commas )" . $conditions . " order by listOrder" );
// echo "select * from DataTabletxt where refer in ( $commas )" . $conditions;
// $db->dbQuery( "select distinct dt.*, kw.priority from DataTabletxt dt, keyWords kw where dt.refer in ( $commas ) $conditions and kw.DataTabletxtRefer = dt.refer order by kw.priority" );
// echo "select dt.*, kw.priority from DataTabletxt dt, keyWords kw where dt.refer in ( $commas ) $conditions and kw.DataTabletxtRefer = dt.refer order by kw.priority";
$resultCount = $db->resultCount();
}
if( ( $resultCount - $limit )< $perPage )
{
$finalNumber = $resultCount;
} else {
$finalNumber = $limit + $perPage;
$next = true;
}
} else {
// no results
}
if ( $resultCount )
{
if ( $prev )
{
(($limit-$perPage) < 0) ? $prevNum = 0 : $prevNum = $limit - $perPage;
$backFor = "Previous Page";
}
if ( $next )
{
if( $backFor )
$backFor .= " ";
$backFor .= "Next Page";
}
echo "
|
\n";
echo "" . ($limit+1) . " - $finalNumber of $resultCount results for '$words' |
\n";
echo "
|
\n";
echo " |
\n";
if ( $backFor )
{
echo "$backFor |
";
echo " |
\n";
echo "
|
\n";
}
for ( $i=$limit; $i<$finalNumber; $i++ )
{
$rCol = $db->resultArray[$i];
$name = $rCol[$col];
$address = $rCol[$url];
$link = substr( $address, 0, 4 );
switch ( $link )
{
case 'http':
$good = true;
break;
case 'ftp:':
$good = true;
break;
default:
$good = false;
break;
}
if ( $good )
{
echo "$name |
\n";
} else {
echo "$name |
\n";
}
echo "" . $rCol['Abstract'] . " |
\n";
if ( $rCol['Author'] )
$thirdL = $rCol['Author'];
if ( $rCOl['Date'] )
{
if ( $thirdL ) { $thirdL .= ' - '; }
$thirdL .= $rCol['Date'];
}
if( $rCol['Page_Nos'] )
{
if ( $thirdL ) { $thirdL .= ' - '; }
$thirdL .= $rCol['Page_Nos'];
}
if ( $thirdL )
echo "$thirdL |
\n";
$linkText = $address;
// $linkText = "Link";
if( $rCol['Size'] )
$linkText .= " - " . $rCol['Size'];
if( $good )
{
echo "$linkText |
";
} else {
echo "" . $rCol['Phone'] ." |
";
}
echo " |
\n";
}
if ( $backFor )
echo "
$backFor |
";
echo "
Back to the top |
";
} else {
echo "No search results sorry |
\n";
}
$db->dbClose();
}
printFooter();
?>