/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/quizSystem/course/index.php

  • Committer: gustav.hartvigsson at gmail
  • Date: 2013-04-03 11:52:56 UTC
  • Revision ID: gustav.hartvigsson@gmail.com-20130403115256-sz6zermzoom4lifc
Ignored .DS_Store files.

Show diffs side-by-side

added added

removed removed

Lines of Context:
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
 
include '../../php/dbconnect.php';      
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'