-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathstudent_budget.php
122 lines (103 loc) · 5.92 KB
/
student_budget.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
<?php
session_start();
$connect = mysqli_connect('localhost', 'root', '', 'moneyliteracy');
$students_name = $_SESSION['students_name'];
$q="SELECT * from budget 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 Budget 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;">BUDGET</h1><br><br>
<h2 style="text-align:justify;">Definition</h2>
<p style="text-align:justify;">Budgeting is the process of creating a plan to spend your money. This spending plan is called a budget. Creating this spending plan allows you to determine in advance whether you will have enough money to do the things you need to do or would like to do. Budgeting is simply balancing your expenses with your income.</p>
<hr>
<h2 style="text-align:justify;">How to manage your budget?</h2>
<p style="text-align:justify;">- Estimate your amount of pocket money</p>
<p style="text-align:justify;">- Estimate your outgoings</p>
<p style="text-align:justify;">- Calculate your budget for each week</p>
<p style="text-align:justify;">- Set yourself some goals from your budget</p>
<p style="text-align:justify;">- Track your budget</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 BUDGET 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_budget.php">Add New Budget</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['budget_id'].'
<td style="text-align:center;">'.$row['budget_details'].'
<td style="text-align:center;">'.$row['budget_date'].'
<td style="text-align:center;">RM '.$row['budget_total'];
echo '<td style="text-align:center; color:blue;"><a href="update_budget.php?sid='.$row['budget_id'].'">Edit</a>
<td style="text-align:center; color:blue;"><a href="del_budget.php?sid='.$row['budget_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>