TMG6470/candidate.php at master · leftger/TMG6470 · 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
93
94
95
96
97
98
<?php
session_start();
//if(!isset($_SESSION['myusername'])){
//header("location:index.php");
//}
include('PoliticalDB.php');

// Connect to server and select databse.
mysql_connect(HOST,DB_USER,DB_PASS)or die("cannot connect");
mysql_select_db(DB_NAME)or die("cannot select DB");
$table_name='people';
$this_id = $_GET['id'];
$result = mysql_query("SELECT * FROM $table_name WHERE id = '$this_id'");
if (!$result) {
    echo 'Could not run query: ' . mysql_error();
}
$ans=mysql_fetch_assoc($result);
include("youtube.php");
include("facebook.php");
include("twitter.php");
?>
<!DOCTYPE html>
<html>
	<head>
		<?php
		include('navbar.php');
		$first_name = $ans['firstname'];
		$last_name = $ans['lastname'];
		?>
		<title><?php echo "$first_name $last_name's Candidate Page";?></title>


	</head>

	<body>
		<div id="bigbox">
		<table border=none position="absolute" top="20%" >
		<tr>
		<td valign="top" >
		<div id="twitterbox">
		<div id="twitterlogowrap">
		<!--<img src="twitterlogo.png" width="125px" height="100px">-->
		</div>
		<?php
		if($ans['twitterid']!=null){
			getTwitterUpdates($ans['twitterid']);
		}
		?></div>
		<br />
		<br />

		</td>
		<td valign="top" >
		<div id="youtubebox">
		<div id="youtubelogowrap">
		<!--<img src="youtubelogo.png" width="125px" height="100px">-->
		</div>
		<?
		if ($ans['youtubeid']!=null){
			echo "<a href=\"http://youtube.com/". $ans['youtubeid']."\">";
			echo "<img src=\"youtubelogo.png\" width=\"125\" border=none >";
			echo "</a>";

			getAndPrintUserUploads($ans['youtubeid']);
		}?>
		</div>
		<div id="info">
			<h1> Other Media Sites/Info:</h1>
			<table border="1">>
				<?php
				foreach($ans as $a=>$b)
				{
					if($b!=NULL){
						echo "<tr> <td>" . $a. "</td><td>" . $b. "</td></tr>";
					}
				}
				?>
			</table>
		</div>
		</td>
		<td valign="top" >
		<div id="facebookbox">
		<div id="facebooklogowrap">
		<!--<img src="facebooklogo.png" width="125px" height="100px" border=none>-->
		</div>
		<?if ($ans['fbid']!=null){
			getFacebookStuff($ans['fbid']);
		}
		?>
		</div>
		</td>
		</tr>
		</table>

		</div>
	</body>

</html>