projects/index.php at master · mkraghav/projects · 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
<?php include "sidebar.php" ?>
        <div class="content">
            <div class="container-fluid">
                <div class="row">

					<div class="col-md-6">
                        <div class="card">

                            <div class="header">
                                <h4 class="title">Email Statistics</h4>
                                <p class="category">Last Campaign Performance</p>
                            </div>
                            <div class="content">
                                <div id="chartPreferences" class="ct-chart ct-perfect-fourth"></div>

                                <div class="footer">

                                    <hr>
                                    <div class="stats">

                                        <i class="fa fa-clock-o"></i> Welcome
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>


                               <div class="col-md-6">
                        <div class="card ">
                            <div class="header">
                                <h4 class="title">Latest</h4>
                                <p class="category">Reported Offences</p>
                            </div>
                            <div class="content">
                                <div class="table-full-width">
                                    <table class="table">
                                        <tbody>
<?php
	$result = $db->prepare("SELECT * FROM reported_offence ORDER BY id DESC limit 5");
	$result->execute();
	for($i=0; $row = $result->fetch(); $i++){
?>
										   <tr>
                                                <td><?php echo $row['offence']; ?></td>
                                                <td class="td-actions text-right">
                                                  <span style="padding:2px; background-color:#1DC7EA; color:#FFF;">  <?php echo $row['date']; ?> </span>
                                                </td>
                                            </tr>
	<?php } ?>
                                          </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>

<?php include "footer.php"?>