/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: b11johgu
  • Date: 2013-04-24 10:49:33 UTC
  • mfrom: (49 lenasys)
  • mto: This revision was merged to the branch mainline in revision 51.
  • Revision ID: b11johgu@student.his.se-20130424104933-6hzc87bujnlyfvd2
added data in tables:
Quizzes, QuizQuestions, Examples, and Files 

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));