File "manage-list.php"
Full Path: /home/analogde/www/eliot/Fusion/task-manager/manage-list.php
File size: 7.5 KB
MIME-type: text/x-php
Charset: utf-8
<?php
include('config/constants.php');
?>
<html>
<head>
<title>Task Manager</title>
<link rel="stylesheet" href="<?php echo SITEURL; ?>css/style.css" />
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.0-beta3/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-eOJMYsd53ii+scO/bJGFsiCZc+5NDVN2yr8+0RDqr0Ql0h+rP48ckxlpbzKgwra6" crossorigin="anonymous">
</head>
<body>
<div class="wrapper">
<h1 class="text-center">Task Manager Application</h1>
<!-- Menu Starts Here -->
<nav>
<div class="nav nav-tabs" id="nav-tab" role="tablist">
<a href="<?php echo SITEURL; ?>" style="text-decoration: none;"><button class="nav-link active" id="nav-home-tab" data-bs-toggle="tab" data-bs-target="#nav-home" type="button" role="tab" aria-controls="nav-home" aria-selected="true"><b>Home</b></button></a>
<?php
//Comment Displaying Lists From Database in ourMenu
$conn2 = mysqli_connect(LOCALHOST, DB_USERNAME, DB_PASSWORD) or die(mysqli_error());
//SELECT DATABASE
$db_select2 = mysqli_select_db($conn2, DB_NAME) or die(mysqli_error());
//Query to Get the Lists from database
$sql2 = "SELECT * FROM tbl_lists";
//Execute Query
$res2 = mysqli_query($conn2, $sql2);
//CHeck whether the query executed or not
if($res2==true)
{
//Display the lists in menu
while($row2=mysqli_fetch_assoc($res2))
{
$list_id = $row2['list_id'];
$list_name = $row2['list_name'];
?>
<a href="<?php echo SITEURL; ?>list-task.php?list_id=<?php echo $list_id; ?>" style="text-decoration: none;"><button class="nav-link active" id="nav-home-tab" data-bs-toggle="tab" data-bs-target="#nav-home" type="button" role="tab" aria-controls="nav-home" aria-selected="true"><b><?php echo $list_name; ?></b></button></a>
<?php
}
}
?>
<a href="<?php echo SITEURL; ?>manage-list.php" style="text-decoration: none;"><button class="nav-link active" id="nav-home-tab" data-bs-toggle="tab" data-bs-target="#nav-home" type="button" role="tab" aria-controls="nav-home" aria-selected="true"><b>Manage Lists</b></button></a>
</div>
</nav>
<!-- Menu Ends Here -->
<p>
<?php
//Check if the session is set
if(isset($_SESSION['add']))
{
//display message
echo $_SESSION['add'];
//REmove the message after displaying one time
unset($_SESSION['add']);
}
//Check the session for Delete
if(isset($_SESSION['delete']))
{
echo $_SESSION['delete'];
unset($_SESSION['delete']);
}
//Check Session Message for Update
if(isset($_SESSION['update']))
{
echo $_SESSION['update'];
unset($_SESSION['update']);
}
//Check for Delete Fail
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 href="<?php echo SITEURL; ?>add-list.php"> <button class="btn btn-dark">Add List</button></a>
<table class="tbl-half table table-condensed table-hover">
<tr>
<th>S.N.</th>
<th>List Name</th>
<th>Actions</th>
</tr>
<?php
//Connect the DAtabase
$conn = mysqli_connect(LOCALHOST, DB_USERNAME, DB_PASSWORD) or die(mysqli_error());
//Select Database
$db_select = mysqli_select_db($conn, DB_NAME) or die(mysqli_error());
//SQl Query to display all data fromo database
$sql = "SELECT * FROM tbl_lists";
//Execute the Query
$res = mysqli_query($conn, $sql);
//CHeck whether the query executed executed successfully or not
if($res==true)
{
//work on displaying data
//echo "Executed";
//Count the rows of data in database
$count_rows = mysqli_num_rows($res);
//Create a SErial Number Variable
$sn = 1;
//Check whether there is data in database of not
if($count_rows>0)
{
//There's data in database' Display in table
while($row=mysqli_fetch_assoc($res))
{
//Getting the data from database
$list_id = $row['list_id'];
$list_name = $row['list_name'];
?>
<tr>
<td><?php echo $sn++; ?>. </td>
<td><?php echo $list_name; ?></td>
<td>
<a href="<?php echo SITEURL; ?>update-list.php?list_id=<?php echo $list_id; ?>"><button class="btn btn-success btn-sm">Update</button></a>
<a href="<?php echo SITEURL; ?>delete-list.php?list_id=<?php echo $list_id; ?>"><button class="btn btn-danger btn-sm">Delete</button></a>
</td>
</tr>
<?php
}
}
else
{
//No Data in Database
?>
<tr>
<td colspan="3">No List Added Yet.</td>
</tr>
<?php
}
}
?>
</table>
</div>
<!-- Table to display lists ends here -->
</div>
</body>
</html>