-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathstudent_spending.php
128 lines (106 loc) · 6.28 KB
/
student_spending.php
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
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
<?php
session_start();
$connect = mysqli_connect('localhost', 'root', '', 'moneyliteracy');
$students_name = $_SESSION['students_name'];
$q="SELECT * from spending where students_id =".$_SESSION['stu_id'];
$res=mysqli_query($connect, $q) or die("Can't Execute Query...");
$row = mysqli_fetch_assoc($res);
?>
<html>
<head>
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css" integrity="sha384-JcKb8q3iqJ61gNV9KGb8thSsNjpSL0n8PARn9HuZOnIxN0hoP+VmmDGMN5t9UJ0Z" crossorigin="anonymous">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css">
<link rel="stylesheet" href="https://www.w3schools.com/w3css/4/w3.css">
<link rel="stylesheet" type="text/css" href="style.css">
<title>Your Spending List</title>
</head>
<body>
<nav class="navbar navbar-expand-md">
<a class="navbar-brand" href="">Pocket Guide</a>
<button class="navbar-toggler navbar-dark" type="button" data-toggle="collapse" data-target="#main-navigation">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="main-navigation">
<ul class="navbar-nav">
<li class="nav-item dropdown">
<a href="#" class="nav-link dropdown-toggle" data-toggle="dropdown">Student</a> <!-- Add username later at here using php -->
<div class="dropdown-menu dropdown-menu-right">
<a href="StudentProfile.php" class="dropdown-item">Profile</a>
<a href="student_budget.php" class="dropdown-item">Budget</a>
<a href="student_savings.php" class="dropdown-item">Saving</a>
<a href="student_spending.php" class="dropdown-item">Spending</a>
<a href="schedule.php" class="dropdown-item">Schedule</a>
<a href="learning-history.php" class="dropdown-item">Learning History</a>
<a href="feedback-result.php" class="dropdown-item">Parent's Feedback</a>
<div class="dropdown-divider"></div>
<a href="StudentLogout.php" class="dropdown-item">Logout</a>
</div>
</li>
</ul>
</div>
</nav>
<h1 style="text-align:center;">SPENDING</h1><br><br>
<h2 style="text-align:justify;">Definition</h2>
<p style="text-align:justify;"> Spending money is money that you have or are given to spend on personal things for pleasure and entertainment. Spending money makes you feel De-stressed because going out shopping will make you forget about daily problems or struggles you are having in your life. Treating yourself with buying stuff or toys in order to make you feel good. However, Knowing that you have money makes you happy, while saving money isn’t fun in itself, having money when you need it is definitely a great feeling.</p>
<hr>
<h2 style="text-align:justify;">How to manage your spending?</h2>
<p style="text-align:justify;">- Buying things are only that you need</p>
<p style="text-align:justify;">- Try the 'No-Spend day' challenge</p>
<p style="text-align:justify;">- Make a list and stick to it</p>
<p style="text-align:justify;">- Try to estimate your budget when buying somethings</p>
<p style="text-align:justify;">- Set a financial of your spending goals</p>
<p style="text-align:justify;">- Know Your Weaknesses and Avoid Them</p>
<p style="text-align:justify;">- Track your spending</p>
<hr>
<!-- start content -->
<div class="container" style = "margin-left: 300px; margin-right: 0px; width:100%;">
<div class="post">
<div class="col-lg-8" style="text-align: justify;">
<div class="shadow p-3 mb-5 bg-white rounded">
<h1 class="title" style="text-align:center;">YOUR SPENDING LIST</h1><br>
<div class="entry" align="center" width="80%">
<div class="box-body">
<table id="example1" class="table table-bordered table-striped">
<tr>
<thead>
<td style = "text-align:center; color:blue;" colspan="10"><a href="add_spending.php">Add New Spending</a></td>
</tr>
<tr>
<th style="color:black; text-align:center;" WIDTH="50px"><b>NO</b></th>
<th style="color:black; text-align:center;" WIDTH="150px"><b>ID</b></th>
<th style="color:black; text-align:center;" WIDTH="150px"><b>DETAILS</b></th>
<th style="color:black; text-align:center;" WIDTH="150px"><b>DATE/TIME</b></th>
<th style="color:black; text-align:center;" WIDTH="150px"><b>TOTAL</b></th>
<th style="color:black; text-align:center;" WIDTH="100px"><b>EDIT</b></th>
<th style="color:black; text-align:center;" WIDTH="100px"><b>DELETE</b></th>
</tr>
</thead>
<?php
$count=1;
while($row=mysqli_fetch_assoc($res))
{
echo '<tr>
<td style="text-align:center;">'.$count.'
<td style="text-align:center;">'.$row['spending_id'].'
<td style="text-align:center;">'.$row['spending_details'].'
<td style="text-align:center;">'.$row['spending_date'].'
<td style="text-align:center;">RM '.$row['spending_total'];
echo '<td style="text-align:center; color:blue;"><a href="update_spending.php?sid='.$row['spending_id'].'">Edit</a>
<td style="text-align:center; color:blue;"><a href="del_spending.php?sid='.$row['spending_id'].'">Delete</a>
</tr>';
$count++;
}
?>
</div>
</TABLE>
<br>
</div>
</div>
</div>
</div>
</div>
<script src="https://code.jquery.com/jquery-3.5.1.slim.min.js" integrity="sha384-DfXdz2htPH0lsSSs5nCTpuj/zy4C+OGpamoFVy38MVBnE+IbbVYUew+OrCXaRkfj" crossorigin="anonymous"></script>
<script src="https://cdn.jsdelivr.net/npm/popper.js@1.16.1/dist/umd/popper.min.js" integrity="sha384-9/reFTGAW83EW2RDu2S0VKaIzap3H66lZH81PoYlFhbGU+6BZp6G7niu735Sk7lN" crossorigin="anonymous"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js" integrity="sha384-B4gt1jrGC7Jh4AgTPSdUtOBvfO8shuf57BaghqFfPlYxofvL8/KUEfYiJOMMV+rV" crossorigin="anonymous"></script>
</body>
</html>