/lenasys/trunk

To get this branch, use:
bzr branch http://gegoxaren.bato24.eu/bzr/lenasys/trunk

« back to all changes in this revision

Viewing changes to DuggaSys/quizAjax/getStudentCourseRegistrations.php

  • Committer: galaxyAbstractor
  • Date: 2013-04-24 14:31:47 UTC
  • mto: This revision was merged to the branch mainline in revision 52.
  • Revision ID: galaxyabstractor@gmail.com-20130424143147-1pdkbu65n1896lmu
Started implementing categories and a menu

Show diffs side-by-side

added added

removed removed

Lines of Context:
8
8
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
9
9
header('Content-type: application/json; charset=utf-8'); 
10
10
 
11
 
include "dbconnect.php";
 
11
include "../../php/dbconnect.php";
12
12
 
13
13
$queryString="SELECT Student.ssn
14
14
                          FROM Student
19
19
$stmt->bindParam(':PASSW', $_POST['password']);
20
20
$stmt->execute();
21
21
$count=$stmt->rowCount();
22
 
if($count==1){ //login successfull
 
22
if($count==1) { //login successfull
23
23
        $studentData=$stmt->fetch(PDO::FETCH_ASSOC);
24
24
        $queryString="SELECT StudentCourseRegistration.courseName, StudentCourseRegistration.courseOccasion
25
25
                                  FROM StudentCourseRegistration
29
29
        $stmt->execute();
30
30
        $listOfCourseRegistrations=array();
31
31
        $courseRegistrations=$stmt->fetchAll(PDO::FETCH_ASSOC);
32
 
        foreach($courseRegistrations as $row){
 
32
        foreach($courseRegistrations as $row) {
33
33
                array_push($listOfCourseRegistrations, array('courseName'=>$row['courseName'],'courseOccasion'=>$row['courseOccasion']));
34
34
        }
35
35
        echo json_encode(array('loginSuccess' => 'true','courseRegistrations'=>$listOfCourseRegistrations));