-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathupdate.php
64 lines (57 loc) · 2.09 KB
/
update.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
<?php
if (!isset($_SESSION['username'])) {
header("Location: login.php");
}
session_start();
require_once 'db.php';
$id = base64_decode($_GET['id']);
$data = "SELECT * FROM task_table WHERE id=$id";
$data_from_db = $conn->query($data);
$f_result = $data_from_db->fetch_assoc();
$f_result1 = $data_from_db->fetch_assoc();
$f_result2 = $data_from_db->fetch_assoc();
$f_result3 = $data_from_db->fetch_assoc();
if(isset($_POST['update'])){
$update_text = $_POST['update_text'];
$update_text1 = $_POST['update_text1'];
$update_date_begin = $_POST['update_date_begin'];
$update_date_end = $_POST['update_date_end'];
$update_query = "UPDATE task_table SET task_name='$update_text', task_description ='$update_text1',
date_begin = '$update_date_begin', date_end = '$update_date_end'
WHERE id=$id";
$update_date = $conn->query($update_query);
if($update_date){
$_SESSION['upadate_success'] = "Task updated successfully!";
}
header('location: index.php');
}
?>
<?php
require_once 'header.php';
?>
<div class="container" >
<div class='row'>
<div class='col-8 mx-auto mt-5'>
<h2 class="display-4 mx-auto mt-2 text-center">Update Task</h2>
<form class="" action="" method="post">
<div class='form-group'>
<input class="form-control form-control-lg" type="text" name="update_text" value="<?=$f_result['task_name'] ?>">
</div>
<div class='form-group'>
<input class="form-control form-control-lg" type="text" name="update_text1" value="<?=$f_result1['task_description'] ?>">
</div>
<div class='form-group'>
<input class="form-control form-control-lg" type="date" name="update_date_begin" value="<?=$f_result2['date_begin'] ?>">
</div>
<div class='form-group'>
<input class="form-control form-control-lg" type="date" name="update_date_end" value="<?=$f_result3['date_end'] ?>">
</div>
<div class='form-group'>
<input class="btn btn-warning btn-block" type="submit" name="update" value="update">
</div>
</form>
</div>
</div>
</div>
</body>
</html>