timetable/edit_classes.php at main · Flexsidee/timetable · 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
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
<?php include'header.php'; ?>
<div class="pcoded-content">
    <div class="pcoded-inner-content">

        <div class="main-body">
            <div class="page-wrapper">
                <div class="card">
                    <div class="card-header">
                        <h5>Edit Class Population</h5>
                    </div>
                    <div class="card-block">
                        <div class="table-responsive dt-responsive">
                            <table class="table table-striped table-bordered table-hover nowrap">
                                <thead>
                                    <tr class="table-danger">
                                        <th>#</th>
                                        <th>Deparment</th>
                                        <th>Level</th>
                                        <th>Population</th>
                                        <th>Save</th>
                                        <th>Delete</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    <?php
                                                $sn=0;
                                                $sql =mysqli_query($db, "select * from class order by department_id");
                                                while($classes = $sql -> fetch_assoc()){
                                                    $dept=mysqli_fetch_assoc(mysqli_query($db, "select * from department where department_id=".$classes['department_id']." order by department_name"));
                                                    $level=mysqli_fetch_assoc(mysqli_query($db, "select * from level where level_id=".$classes['level_id']));
                                                    $sn++;
                                            ?>
                                    <tr>
                                        <form action="actions/edit_classes_p.php" method="post">
                                            <input type="hidden" value="<?php echo $classes['class_id']; ?>"
                                                name="class_id">
                                            <td><?php echo $sn; ?></td>
                                            <td><?php echo $dept['department_name']; ?></td>
                                            <td><?php echo $level['level_name']; ?></td>
                                            <td>
                                                <input type="text" name="population"
                                                    value="<?php echo $classes['population']; ?>">
                                            </td>
                                            <td>
                                                <input type="submit" value="save" class="btn btn-primary">
                                            </td>
                                            <td>
                                                <input type="button" value="Del" class="btn btn-danger"
                                                    id="<?php echo $classes['class_id']; ?>"
                                                    onclick="del(<?php echo $classes['class_id']; ?>)">
                                            </td>
                                        </form>
                                    </tr>
                                    <?php } ?>
                                </tbody>
                                <tfoot>
                                    <tr>
                                        <th>#</th>
                                        <th>Deparment</th>
                                        <th>Level</th>
                                        <th>Population</th>
                                        <th>Save</th>
                                        <th>Delete</th>
                                    </tr>
                                </tfoot>
                            </table>
                        </div>
                    </div>
                </div>

            </div>

        </div>
    </div>
</div>
</div>
</div>
</div>
</div>
</div>
<script type="text/javascript">
    function del(id) {
        var info = 'id=' + id;
        if (confirm("Are you sure you want to delete this record?")) {
            var html = $.ajax({
                type: "GET",
                url: "actions/edit_classes_p.php",
                data: info,
                async: false,
                success: function () {
                    window.location.reload(true);
                }
            }).responseText;
        }
    }
</script>
<?php include'footer_view.php'; ?>