JavascPhpApp/Amendments.php at master · jcschnall/JavascPhpApp · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92


<?php

//script to link in when the Amendments php is called.........


//Retrieve API json data using form input values........
//API Key: 52bf01e9cad0422c8e3c1faa809ad959
$formVals = array();

foreach($_POST as $key => $value) {   //array of form values excluding submit button
	if ($key != "submit") {
		array_push($formVals,$value);

	}
}


//Call state keymap to get state abreviation........

$states = array("Alabama" => "AL", "Montana" => "MT", "Alaska" => "AK", "Nebraska" => "NE", "Arizona" => "AZ", "Nevada" => "NV",
		"Mississippi" => "MS", "Wyoming" => "WY", "Missouri" => "MO", "Wisconsin" => "WI", "Minnesota" => "MN","West Virginia" => "WV",
		"Michigan" => "MI", "Washington" => "WA", "Massachusetts" => "MA", "Virginia" => "VA", "Maryland" => "MD", "Vermont" => "VT", "Maine" => "ME",
		"Louisiana" => "LA", "Tennessee" => "TN", "Kentucky" => "KY", "Utah" => "UT", "Texas" => "TX", "Kansas" => "KS", "South Dakota" => "SD",
		"Iowa" => "IA",  "South Carolina" => "SC", "Indiana" => "IN", "Rhode Island" => "RI", "Illinois" => "IL", "Pennsylvania" => "PA",
		"Idaho" => "ID", "Oregon" => "OR",  "Hawaii" => "HI", "Oklahoma" => "OK", "Georgia" => "GA", "Ohio" => "OH", "Florida" => "FL",
		"North Dakota" => "ND", "District Of Columbia" => "DC", "North Carolina" => "NC", "Deleware" => "DE", "New York" => "NY",
		"Connecticut" => "CT", "New Mexico" => "NM", "Colorado" => "CO", "New Jersey" => "NJ", "California" => "CA", "Arkansas" => "AR", "New Hampshire" => "NH");


//call url and get json object

$url=  "http://congress.api.sunlightfoundation.com/" . $formVals[0]. "?amendment_id=" . $formVals[2] . "&chamber=" . $formVals[1] . "&apikey=52bf01e9cad0422c8e3c1faa809ad959" ;
$content = file_get_contents($url);


//load json object using json_decode........
$json = json_decode($content, true);

//if($json == ""){
//	echo "The API returned zero results for the request"
//}
//else

//write out html table.......   columns are Name/State/Chamber/Details(links)
//....first put data into associative array.....
//output table is.....  amendment ID / amendment type / Chamber / introduced on
$AIDRay = array();
$ANameRay = array();
$chamberRay = array();
$introRay = array();

$legisTable = array( "ID" =>$AIDRay , "name" =>$ANameRay , "Chamber" =>$chamberRay, "intro" =>$introRay );


foreach($json['results'] as $item) {
	array_push($legisTable["ID"], $item['amendment_id'] );
	array_push($legisTable["name"], $item['amendment_type']) ;
	array_push($legisTable["Chamber"], $item['chamber']) ;
	array_push($legisTable["intro"], $item['introduced_on']);
}


// This is the php output for the first table created.....

if(empty($json['results'])){
	echo " \n \n The API returned zero results for the request";
}else{
    $i = 0;
    echo "<br><br><table border ='2'><tbody>";
    echo "<th>amendment ID</th>";
    echo "<th>amendment type</th>";
    echo "<th>chamber</th>";
    echo "<th>introduced on </th>";
    foreach ($legisTable["ID"] as $row) {
        echo "<tr>";
            echo "<td>  " . $legisTable["ID"][$i] . "  </td>";
            echo "<td>  " . $legisTable["name"][$i] . "  </td>";
            echo "<td>  " . $legisTable["Chamber"][$i] . "  </td>";
            echo "<td>  " . $legisTable["intro"][$i] . "  </td>";
        echo "</tr>";
        $i = $i + 1;
    }
    echo "</tbody></table>";

}
?>