File "add-task.php"
Full Path: /home/analogde/www/Design/fileman/Fusion/task-manager/add-task.php
File size: 6.66 KB
MIME-type: text/x-php
Charset: utf-8
<?php
include('config/constants.php');
?>
<html>
<head>
<title>Task Manager</title>
<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">
<link rel="stylesheet" href="<?php echo SITEURL; ?>css/style.css" />
</head>
<body>
<div class="wrapper">
<div class="container">
<div class="row">
<div class="col-lg-2"></div>
<div class="col-lg-8">
<h1 class="text-center">Task Manager Application</h1>
<a class="btn-secondary" href="<?php echo SITEURL; ?>">Home</a>
<h3>Add Task Page</h3>
<p>
<?php
if(isset($_SESSION['add_fail']))
{
echo $_SESSION['add_fail'];
unset($_SESSION['add_fail']);
}
?>
</p>
<form method="POST" action="">
<div class="mb-3">
<label for="exampleInputEmail1" class="form-label">Task Name</label>
<input type="text" name="task_name" class="form-control" placeholder="Type your Task Name" required="required" /></td>
</div>
<div class="mb-3">
<label for="exampleInputPassword1" class="form-label">Task Description</label>
<textarea name="task_description" class="form-control" placeholder="Type Task Description"></textarea>
</div>
<div class="mb-3">
<label for="disabledSelect" class="form-label">Select List</label>
<select name="list_id" class="form-select" id="">
<?php
//Connect 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 get the list from table
$sql = "SELECT * FROM tbl_lists";
//Execute Query
$res = mysqli_query($conn, $sql);
//Check whether the query executed or not
if($res==true)
{
//Create variable to Count Rows
$count_rows = mysqli_num_rows($res);
//If there is data in database then display all in dropdows else display None as option
if($count_rows>0)
{
//display all lists on dropdown from database
while($row=mysqli_fetch_assoc($res))
{
$list_id = $row['list_id'];
$list_name = $row['list_name'];
?>
<option value="<?php echo $list_id ?>"><?php echo $list_name; ?></option>
<?php
}
}
else
{
//Display None as option
?>
<option value="0">None</option>p
<?php
}
}
?>
</select>
</div>
<div class="mb-3">
<label for="exampleInputPassword1" class="form-label">Priority:</label>
<select name="priority" class="form-select" id="">
<option value="High">High</option>
<option value="Medium">Medium</option>
<option value="Low">Low</option>
</select>
</div>
<div class="mb-3">
<label for="exampleInputPassword1" class="form-label">Deadline</label>
<input type="date" class="form-control" name="deadline" />
</div>
<button type="submit" class="btn btn-secondary" name="submit">Add</button>
</form>
</div>
<div class="col-lg-2"></div>
</div>
</div>
</div>
</body>
</html>
<?php
//Check whether the SAVE button is clicked or not
if(isset($_POST['submit']))
{
//echo "Button Clicked";
//Get all the Values from Form
$task_name = $_POST['task_name'];
$task_description = $_POST['task_description'];
$list_id = $_POST['list_id'];
$priority = $_POST['priority'];
$deadline = $_POST['deadline'];
//Connect Database
$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());
//CReate SQL Query to INSERT DATA into DAtabase
$sql2 = "INSERT INTO tbl_tasks SET
task_name = '$task_name',
task_description = '$task_description',
list_id = $list_id,
priority = '$priority',
deadline = '$deadline'
";
//Execute Query
$res2 = mysqli_query($conn2, $sql2);
//Check whetehre the query executed successfully or not
if($res2==true)
{
//Query Executed and Task Inserted Successfully
$_SESSION['add'] = "Task Added Successfully.";
//Redirect to Homepage
header('location:'.SITEURL);
}
else
{
//FAiled to Add TAsk
$_SESSION['add_fail'] = "Failed to Add Task";
//Redirect to Add TAsk Page
header('location:'.SITEURL.'add-task.php');
}
}
?>