/lenasys/0.1

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

« back to all changes in this revision

Viewing changes to trunk/DuggaSys/quizSystem/course/index.php

  • Committer: Henrik G.
  • Date: 2013-03-26 23:22:55 UTC
  • Revision ID: henrik.gustavsson@his.se-20130326232255-ik6snyatlbkf3zs1
First seed of Lenasys ... Needs to be Organized Further

Show diffs side-by-side

added added

removed removed

Lines of Context:
trunk/DuggaSys/quizSystem/course/index.php
 
1
<?php
 
2
//List/Add/Remove courses
 
3
        // Course(
 
4
        // name VARCHAR(200),
 
5
        // description TEXT,
 
6
        // courseData TEXT,
 
7
        
 
8
//Add course
 
9
if(isset($_POST['addCourse'])){
 
10
        $insertString = "INSERT INTO Course(name, description, courseData) VALUES(:CNAME,:DESC,:CDATA);";
 
11
        $insertStmt = $pdo->prepare($insertString);
 
12
        $insertStmt->bindParam(':NEWCNAME', $_POST['newCourseName']);
 
13
        $insertStmt->bindParam(':DESC', $_POST['courseDesc']);
 
14
        $insertStmt->bindParam(':CDATA', $_POST['courseData']);
 
15
        if($insertStmt->execute()){
 
16
                $userMsg.="Course ".$_POST['newCourseName']." successfully added"; 
 
17
        } else {
 
18
                $errorMsg.="ERROR: Course ".$_POST['newCourseName']." NOT added"; 
 
19
        }
 
20
        
 
21
        $insertQuery="INSERT IGNORE INTO StudentCourseRegistration(studentSsn,courseName,courseOccasion) VALUES(:SSN,:CNAME,:COCCASION);";
 
22
                $insert_stmt = $pdo->prepare($insertQuery);
 
23
                $insert_stmt->bindParam(':SSN', "123");
 
24
        $insert_stmt->bindParam(':CNAME', $_POST['newCourseName']);
 
25
                $insert_stmt->bindParam(':COCCASION', "TEST");
 
26
                $insert_stmt->execute();
 
27
}
 
28
 
 
29
//Fetch data for course to edit
 
30
if(isset($_POST['editCourse'])){
 
31
        $queryString = "SELECT * 
 
32
                                        FROM Course
 
33
                                        WHERE Course.name=:CNAME;";
 
34
        $stmt = $pdo->prepare($queryString);
 
35
        $stmt->bindParam(':CNAME', $_POST['courseName']);
 
36
        $stmt->execute();
 
37
        $courseData=$stmt->fetch(PDO::FETCH_ASSOC);
 
38
}
 
39
 
 
40
//Update edited course
 
41
if(isset($_POST['updateCourse'])){
 
42
        $updateQuery="UPDATE Course 
 
43
                                  SET Course.name=:NEWCNAME, Course.description=:DESC, Course.courseData=:CDATA
 
44
                                  WHERE Course.name=:CNAME;";
 
45
        $updateStmt = $pdo->prepare($updateQuery);
 
46
        $updateStmt->bindParam(':NEWCNAME', $_POST['newCourseName']);
 
47
        $updateStmt->bindParam(':CNAME', $_POST['courseName']);
 
48
        $updateStmt->bindParam(':DESC', $_POST['courseDesc']);
 
49
        $updateStmt->bindParam(':CDATA', $_POST['courseData']);
 
50
        if($updateStmt->execute()){
 
51
                $userMsg.="Course ".$_POST['courseName']." successfully updated"; 
 
52
        } else {
 
53
                $errorMsg.="ERROR: Course ".$_POST['courseName']." NOT updated"; 
 
54
        }
 
55
}
 
56
 
 
57
 
 
58
//Remove course
 
59
if(isset($_POST['removeCourse'])){
 
60
        // $deleteQuery = "DELETE FROM Course 
 
61
                                        // WHERE Course.name=:CNAME";
 
62
        // $deleteStmt = $pdo->prepare($deleteQuery);
 
63
        // $deleteStmt->bindParam(':CNAME', $_POST['courseName']);
 
64
        // if($deleteStmt->execute()){
 
65
                // $userMsg.="Successfully deleted ".$_POST['courseName']; 
 
66
        // } else {
 
67
                // $errorMsg.="ERROR: Could not delete ".$_POST['courseName']; 
 
68
        // }
 
69
        $errorMsg.="ERROR: Could not delete ".$_POST['courseName']." FUNCTION DISABLED"; 
 
70
}
 
71
 
 
72
//Fetch all courses from db
 
73
$queryString = "SELECT * FROM Course";
 
74
$stmt = $pdo->prepare($queryString);
 
75
$stmt->execute();
 
76
$courseList=$stmt->fetchAll(PDO::FETCH_ASSOC);
 
77
 
 
78
 
 
79
$content="course/courses.html.php";
 
80
?>
 
 
b'\\ No newline at end of file'