-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathmanage-list.php
119 lines (86 loc) · 3.48 KB
/
manage-list.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
<?php
include('config/constants.php');
?>
<html>
<head>
<title>Task Manager with PHP and MySQL</title>
<link rel="stylesheet" type="text/css" href="css/style.css">
</head>
<body>
<div class="wrapper">
<h1>TASK MANAGER</h1>
<a class="btn-secondary" href="index.php">Home</a>
<h3>Manage Lists Page</h3>
<p>
<?php
//Check if the session is set
if(isset($_SESSION['add']))
{
echo $_SESSION['add'];
unset($_SESSION['add']);
}
if(isset($_SESSION['delete']))
{
echo $_SESSION['delete'];
unset($_SESSION['delete']);
}
if(isset($_SESSION['update']))
{
echo $_SESSION['update'];
unset($_SESSION['update']);
}
if(isset($_SESSION['delete_fail']))
{
echo $_SESSION['delete_fail'];
unset($_SESSION['delete_fail']);
}
?>
</p>
<!-- Table to display lists starts here -->
<div class="all-lists">
<a class="btn-primary" href="add-list.php">Add List</a>
<table class="tbl-half">
<tr>
<th>S.N.</th>
<th>List Name</th>
<th>Actions</th>
</tr>
<?php
$conn = mysqli_connect(LOCALHOST, DB_USERNAME, DB_PASSWORD) or die(mysqli_error());
$db_select = mysqli_select_db($conn, DB_NAME) or die(mysqli_error());
$sql = "SELECT * FROM tbl_lists";
$res = mysqli_query($conn, $sql);
if($res==true){
// echo "Executed";
$count_rows = mysqli_num_rows($res);
$sn = 1;
if($count_rows > 0){
while($row = mysqli_fetch_assoc($res)){
$list_id = $row['list_id'];
$list_name = $row['list_name'];
?>
<tr>
<td><?php echo $sn++ ?>.</td>
<td><?php echo $list_name; ?></td>
<td>
<a class="btn-update" href="update-list.php?list_id=<?php echo $list_id; ?>">Update</a>
<a class="btn-delete" href="delete-list.php?list_id=<?php echo $list_id; ?>">Delete</a>
</td>
</tr>
<?php
}
}else{
?>
<tr>
<td colspan = "3">No List added yet</td>
</tr>
<?php
}
}
?>
</table>
</div>
<!-- Table to display lists ends here -->
</div>
</body>
</html>