find.php

<?php

$dbh;
try 
{
    /*** connect to SQLite database ***/

    $dbh = new PDO("sqlite:db/contrib.db");

}
catch(PDOException $e)
{
    echo $e->getMessage();
    echo "<br><br>Database -- NOT -- loaded successfully .. ";
    die( "<br><br>Query Closed !!! $error");
}
$search = htmlspecialchars($_GET["name"]);
#$query =  "SELECT * from CandsCRP12 WHERE FirstLastP LIKE '%$search%'";
$query = "SELECT * from CandsCRP12 WHERE CurrCand = 'Y' AND DistIDRunFor = 'PRES'";
header('Content-type: text/plain; charset=us-ascii');
$i=0;
$line="";
echo "["; 
$number = 0;
foreach ($dbh->query($query) as $row) {
	if ($number > 0) {
			echo ",";

	}
	echo "{";
	echo "\"candidateName\": \"".$row["FirstLastP"]."\",";
	echo "\"CID\": \"".$row["CID"]."\",";
	echo "\"Party\": \"".$row["Party"]."\",";
	echo "\"ranFor\": \"".$row["DistIDRunFor"]."\",";
	echo "\"currentPosition\": \"".$row["DistIDCurr"]."\",";
	echo "\"type\": \"".$row["CRPICO"]."\",";
	echo "\"noPacs\": \"".$row["noPacs"]."\",";
	$query2 = "SELECT distinct(PACID), FECCandID, RealCode from PACs12 WHERE FECCandID = '".$row["FECCandID"]."'";
	echo "\"PACs\":{";
	$num = 0;
	$name;
	$amount;
	foreach ($dbh->query($query2) as $row2) {
		if ($num > 0) {
			echo ",";

		}
		$query3 = "SELECT * from Cmtes12 where CmteID = '".$row2["PACID"]."'";
		foreach ($dbh->query($query3) as $row3) {
			$name = $row3["PACShort"];
		}
		$query4 = "SELECT sum(Amount) from PACs12 where PACID = '".$row2["PACID"]."' and FECCandID = '".$row2["FECCandID"]."'";
		foreach ($dbh->query($query4) as $row4) {
			$amount = $row4[0];
		}
		echo "\"".$name."\":".$amount;
		$num += 1;
	}
	echo "}";
 	$i=$i+1;
 	$line="";
 	$number += 1;
 	echo "}";
}
echo "]";
?>