E-Learning/elearningserver.php at master · kaiwhata/E-Learning · 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
<?php header('Access-Control-Allow-Origin: *');

function checkPassword($username,$password){
	$connectionString = "host=ec2-54-225-101-64.compute-1.amazonaws.com port=5432 dbname=d1nigmib60rp1v user=jykiewmddlbjft password=kRqkD183znoOpPNTlDq6f_Xs29";
	$dbconnection = pg_connect($connectionString);
	$result = pg_query($dbconnection,"SELECT password FROM useraccount WHERE username='".$username."'");
	$row = pg_fetch_row($result);
	$realPassword = $row[0];
	return ($realPassword==$password) ? 'true' : 'false';
	return $row[0];
}

function getQuizes(){
	$connectionString = "host=ec2-54-225-101-64.compute-1.amazonaws.com port=5432 dbname=d1nigmib60rp1v user=jykiewmddlbjft password=kRqkD183znoOpPNTlDq6f_Xs29";
	$dbconnection = pg_connect($connectionString);
	$result = pg_query($dbconnection,"SELECT * FROM quiz;");
//	$row = pg_fetch_all($result);
	$bigline = "";

	while($row = pg_fetch_array($result)){
		$bigline .= "*";
		$bigline .= $row['coursecode'] . ":" . $row['name'];
	}

	return $bigline;
}

if(isset($_POST['funcName'])){
	switch($_POST['funcName']){
		case 'checkPassword':
			echo(checkPassword($_POST['username'],$_POST['password']));
			break;
		case 'getQuizes':
			echo(getQuizes());
			break;
	}
}
?>