AssetsManagementSystem/AddTask.php at master · burhr2/AssetsManagementSystem · GitHub

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

include ('connection.php');
include('sessionlock.php');
include('bootstrap.html');


$taskname = isset($_POST["TaskName"]) ? $_POST["TaskName"] :" ";


$taskdescription=isset($_POST["TaskDescription"]) ? $_POST["TaskDescription"] :"";

$state=isset($_POST["State"]) ? $_POST["State"] :"";


$location=isset($_POST["Location"]) ? $_POST["Location"] :"";

$sublocation=isset($_POST["SubLocation"]) ? $_POST["SubLocation"] :"";


$assigneddate=isset($_POST["DateAdded"]) ? $_POST["DateAdded"] :"";

$assignername=isset($_POST["assignername"]) ? $_POST["assignername"] :"";
$fullname=isset($_POST["FullName"]) ? $_POST["FullName"] :"";


//INSERT DATA
$sql1="INSERT INTO task (UserId,TaskName,TaskDescription,State,Location,SubLocation,AssignedDate,AssignerName) VALUES('".$fullname."','".$taskname."','".$taskdescription."','".$state."','".$location."','".$sublocation."','".$assigneddate."','".$fullname."');";
//CHECK FOR SUCCESS
$add=mysql_query($sql1);
 if ($add==true) {
 	  header("location: HomeTask.php");
 echo "<script>
        alert('success')
        </script>";


 } else {
echo "error in adding data";

}

?>