-
Notifications
You must be signed in to change notification settings - Fork 0
/
template1.php
128 lines (108 loc) · 5.62 KB
/
template1.php
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
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
<?php
mysql_connect('localhost', 'root', '') or die(mysql_error());
echo 'Connection to MySQL established<br />';
mysql_select_db('csv_db');
echo 'Connected to csv_db<br />';
//Here's where I attempted to change this to the proper way to deal with databases.
//However, I was having trouble then converting it into the variables below, so the next 5
//lines are kind of an orphan:
$result = mysql_query('SELECT * FROM tbl_name WHERE company="Citigroup Inc."');
if (!$result) {
echo("<p>There was an error performing the query: " . mysql_error() . "</p>");
exit();
}
//Ought to change these to non-snake case <- PHP variables like camelCase right?
$company = mysql_query('SELECT company FROM tbl_name WHERE company="Citigroup Inc."');
$score = mysql_query('SELECT score FROM tbl_name WHERE company="Citigroup Inc."');
$rating = mysql_query('SELECT rating FROM tbl_name WHERE company="Citigroup Inc."');
$prohibit_direct = mysql_query('SELECT prohibit_direct FROM tbl_name WHERE company="Citigroup Inc."');
$prohibit_ie = mysql_query('SELECT prohibit_ie FROM tbl_name WHERE company="Citigroup Inc."');
$prohibit_trade_assoc = mysql_query('SELECT prohibit_trade_assoc FROM tbl_name WHERE company="Citigroup Inc."');
$prohibit_ballot_measure = mysql_query('SELECT prohibit_ballot_measure FROM tbl_name WHERE company="Citigroup Inc."');
$disclose_direct = mysql_query('SELECT disclose_direct FROM tbl_name WHERE company="Citigroup Inc."');
$disclose_ie = mysql_query('SELECT disclose_ie FROM tbl_name WHERE company="Citigroup Inc."');
$disclose_trade_asssoc = mysql_query('SELECT disclose_trade_asssoc FROM tbl_name WHERE company="Citigroup Inc."');
$disclose_ballot_measure = mysql_query('SELECT disclose_ballot_measure FROM tbl_name WHERE company="Citigroup Inc."');
//This is gross. Change it. Also, it's not working correctly
//(Here is my attempt to convert a Y/N in my database into the green checkmark or red X that I want. See below table)
$archive_reports = mysql_query('SELECT archive_reports FROM tbl_name WHERE company="Citigroup Inc."');
echo mysql_result($archive_reports, 0);
if ($archive_reports == 'y')
$archive_reports = '<td class="yes">✓</td>';
else
$archive_reports = '<td class="no">X</td>';
$board_oversight = mysql_query('SELECT board_oversight FROM tbl_name WHERE company="Citigroup Inc."');
$semiannual_reports = mysql_query('SELECT semiannual_reports FROM tbl_name WHERE company="Citigroup Inc."');
$policy_url = mysql_query('SELECT policy_url FROM tbl_name WHERE company="Citigroup Inc."');
$wiki_url = mysql_query('SELECT wiki_url FROM tbl_name WHERE company="Citigroup Inc."');
echo
'<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Corporate Cash</title>
<link rel="stylesheet" type="text/css" href="css1.css" />
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js" type="text/javascript"></script>
</head>
<body>
<div id="container">
<!-- ----------Header--------------- -->
<img id="logo" src="../Images/LogoV4.png" alt="Corporate Cash logo" height="100px" />
<div id="projectOf">
<p>A project of <br />
Americans for <br />
People Powered Politics</p>
</div>
<br clear="both">
<!-- NavBar -------------------------->
<div id="navbar">
<ul id="list-nav">
<li><a href="#" onclick="">About</a></li>
<li><a href="#" onclick="">The Problem</a></li>
<li><a href="#" onclick="">The Solution</a></li>
<li><a href="#" onclick="">Compare Corporations</a></li>
<li><a href="#" onclick="">Act</a></li>
</ul>
</div>
<br style="clear:both" />
<!-- --------Main Body---------- -->
<div class="corpLogo">
<img src="../Images/CorpLogos/citi-logo.png" alt="Citi Logo" width="100px" >
</div>
<h1 class="corpName">', mysql_result($company, 0), '</h1>
<div>
<img src="../Images/stamp-irresponsible.png" alt="Irresponsible" width="150px;" style="float:left;"
</div>
<br style="clear: both" />
<div class="contentBox">
<p>Americans for People-Powered Politics rates <strong>', mysql_result($company, 0), '</strong>'s policies as
<strong>', mysql_result($rating, 0), '</strong>.</p>
<p><a href="#" >View APPP's full rating criteria to see why</a>.</p>
</div>
<div class="thankWhipButton"></div>
<table summary="Criteria of rating">
<tr><th colspan="2">Policies</td></tr>
<tr><td>Pledged to not spend treasury money in elections, indirectly or directly</td><td class="no">X</td></tr>
<tr><td>Pledged to not directly spend treasury money in elections, such as Independent Expenditures and candidate contributions</td><td class="no">X</td></tr>
<tr><td>Discloses all political spending</td><td class="no">X</td></tr>
<tr><td>Discloses all direct political spending</td><td class="no">X</td></tr>
<tr><td>Has board of directors oversight over political spending</td><td class="yes">✓</td></tr>
<tr><td>Archives political spending reports online</td>', $archive_reports, '</tr>
<tr><td>CPA-Zicklin disclosure score</td><td>44</td></tr>
</table>
<div class="contentBox">
<p><a href="http://www.citigroup.com/citi/corporategovernance/data/ccpcs.pdf?ieNocache=48">View Citigroup Inc.'s corporate political spending and disclosure policy.</a></p>
<p><a href="http://en.wikipedia.org/wiki/Citigroup">Learn more about Citigroup Inc. on Wikipedia.</a></p>
</div>
<!-- --------Footer---------- -->
<div id="footer">
<p class="footerText">Americans for People-Powered Politics © 2012 |
Site by Kwality Design </p>
<p class="footerText"><a href="#" >Contact</a></p>
</div>
</div>
</body>
</html>'
;
?>