-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathUpdelete.php
45 lines (34 loc) · 886 Bytes
/
Updelete.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
<?php
include "includes/connection.php";
include "includes/functions.php";
$task = 'default, means sql executing';
if(isset($_POST["Delete"])){
//$task = test_input($_POST["text"]);
$id = test_input($_POST["id"]);
try {
$sql = "DELETE FROM `todo` WHERE `todo`.`id` = ".$id .";";
$conn->exec($sql);
toIndex();
}
catch(PDOException $e)
{
echo $sql . "<br>" . $e->getMessage();
}
}
if(isset($_POST["Update"])){
$task = test_input($_POST['text']);
$id = test_input($_POST["id"]);
try {
$sql = "UPDATE `todo` SET `task` = :task WHERE `todo`.`id` = :id;";
$stmt = $conn->prepare($sql);
$stmt->bindParam(':task', $task);
$stmt->bindParam(':id', $id);
$stmt->execute();
toIndex();
}
catch(PDOException $e)
{
echo $sql . "<br>" . $e->getMessage();
}
}
?>