Scorecard/edit_all.php at master · jholland-vin-dit/Scorecard · 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
<?php
 /*
 This file is part of Scorecard, Copyright 2013-2014 Dan Robinson, Nancy Wallace  and John Holland.

    Scorecard is free software: you can redistribute it and/or modify
    it under the terms of the GNU Affero General Public License as published by
    the Free Software Foundation, either version 3 of the License, or
    (at your option) any later version.

    Scorecard is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU Affero General Public License for more details.

    You should have received a copy of the GNU Affero General Public License
    along with Scorecard.  If not, see <http://www.gnu.org/licenses/>.

*/
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>enviro's first page</title>
</head>
<body>


<?php
if ($_GET["sid"]<>""){
	$county_show = true;
	$sid=$_GET["sid"];
}

$link = mysqli_connect("localhost", "votes", "v0t3s123", "homeint_votes");
/* check connection */
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

// Get and print menu links
$str_state_county_municipality = "select * from tbl_states ";
$str_state_county_municipality .= "order by name;" ;
$sql_state_county_municipality = mysqli_query($link, $str_state_county_municipality);

// print initial list of menu_links
//$row_menu_links = mysqli_fetch_assoc($sql_menu_links);
// echo $str_state_county_municipality;

echo "<table width=880>";
echo "<th colspan=2 bgcolor=lightblue>Legislative analyzer</th>";
//echo "<th bgcolor=lightblue>Choose</th><th bgcolor=lightblue>Expand</th>";
while($row_state_county_municipality = mysqli_fetch_assoc($sql_state_county_municipality)){
echo "<tr><td valign=top bgcolor=#ACFA58 width='50%'><a href='legislation_list.php?sid=".$row_state_county_municipality["id"]."'>".$row_state_county_municipality["name"]."</a></td>";
echo "<td valign=top bgcolor=#ACFA58 width='25%'><a href='index.php?sid=".$row_state_county_municipality["id"]."'>Show counties</a></td>";
//echo "<td valign=top  bgcolor=#ACFA58>".$row_menu_links["short_name"]."</td>";
}
echo "</table>";
mysqli_free_result($sql_menu_links);
?>
</body>
</html>