OAndac/myYearBooks.php at master · barisdoga2/OAndac · 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
<div class="container-fluid">
    <div class="card mb-12">
        <div class="card-header">
            <i class="fa fa-table"></i> Sizin Oluşturduğunuz Yıllıklar Listeleniyor</div>
        <div class="card-body">
            <div class="table-responsive">
                <table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
                    <thead>
                    <tr>
                        <th>Başlık</th>
                        <th>Okul</th>
                        <th>Oluşturan</th>
                        <th>Başlangıç Tarihi</th>
                        <th>Bitiş Tarihi</th>
                        <th>Yönet</th>
                    </tr>
                    </thead>
                    <tfoot>
                    <tr>
                        <th>Başlık</th>
                        <th>Okul</th>
                        <th>Oluşturan</th>
                        <th>Başlangıç Tarihi</th>
                        <th>Bitiş Tarihi</th>
                        <th>Yönet</th>
                    </tr>
                    </tfoot>
                    <tbody>

                    <?php

                        $sql = $conn->query("SELECT * FROM yearbooks WHERE creator_id='".$_SESSION["id"]."'");

                        while($row = $sql->fetch_assoc()){
                            $creator = $conn->query("SELECT * FROM users WHERE id='".$row["creator_id"]."' LIMIT 1")->fetch_assoc();
                            ?>
                            <tr>
                                <td><?php echo $row["title"]; ?></td>
                                <td><?php echo $row["school"]; ?></td>
                                <td><?php echo $creator["namee"]." ".$creator["surname"]; ?></td>
                                <td><?php echo $row["start_date"]; ?></td>
                                <td><?php echo $row["end_date"]; ?></td>
                                <td><?php echo "<a href='index.php?task=yearBooks&subTask=manageYearBook&yearBookId=".$row["id"]."'>Yönet</a>"; ?></td>
                            </tr>
                            <?php
                        }

                    ?>

                    </tbody>
                </table>
            </div>
        </div>
        <div class="card-footer small text-muted">Updated yesterday at 11:59 PM</div>
    </div>
</div>