Tiny File Manager

Back Back Up Advanced Editor

<?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">

<h1 class="text-center">Task Manager Application</h1>

<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>

</div>

<?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');
        }
    }