-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathadd-list.php
137 lines (101 loc) · 3.65 KB
/
add-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
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
<?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>
<a class="btn-secondary" href="manage-list.php">Manage Lists</a>
<h3>Add List Page</h3>
<p>
<?php
//Check whether the session is created or not
if(isset($_SESSION['add_fail']))
{
//display session message
echo $_SESSION['add_fail'];
//Remove the message after displaying once
unset($_SESSION['add_fail']);
}
?>
</p>
<!-- Form to Add List Starts Here -->
<form method="POST" action="">
<table class="tbl-half">
<tr>
<td>List Name: </td>
<td><input type="text" name="list_name" placeholder="Type list name here" required="required" /></td>
</tr>
<tr>
<td>List Description: </td>
<td><textarea name="list_description" placeholder="Type List Description Here"></textarea></td>
</tr>
<tr>
<td><input class="btn-primary btn-lg" type="submit" name="submit" value="SAVE" /></td>
</tr>
</table>
</form>
<!-- Form to Add List Ends Here -->
</div>
</div>
</body>
</html>
<?php
//Check whether the form is submitted or not
if(isset($_POST['submit']))
{
//echo "Form Submitted";
//Get the values from form and save it in variables
$list_name = $_POST['list_name'];
$list_description = $_POST['list_description'];
//Connect Database
$conn = mysqli_connect(LOCALHOST, DB_USERNAME, DB_PASSWORD) or die(mysqli_error());
//Check whether the database connected or not
/*
if($conn==true)
{
echo "Database Connected";
}
*/
//SElect Database
$db_select = mysqli_select_db($conn, DB_NAME);
//Check whether database is connected or not
/*
if($db_select==true)
{
echo "Database SElected";
}
*/
//SQL Query to Insert data into database
$sql = "INSERT INTO tbl_lists SET
list_name = '$list_name',
list_description = '$list_description'
";
//Execute Query and Insert into Database
$res = mysqli_query($conn, $sql);
//Check whether the query executed successfully or not
if($res==true)
{
//Data inserted successfully
//echo "Data Inserted";
//Create a SESSION VAriable to Display message
$_SESSION['add'] = "List Added Successfully";
//Redirect to Manage List Page
header('location:manage-list.php');
}
else
{
//Failed to insert data
//echo "Failed to Insert Data";
//Create SEssion to save message
$_SESSION['add_fail'] = "Failed to Add List";
//REdirect to Same Page
header('location:add-list.php');
}
}
?>