-
Notifications
You must be signed in to change notification settings - Fork 1
/
actionnote.php
79 lines (50 loc) · 1.34 KB
/
actionnote.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
<?php
require 'common.php';
$action=isset($_GET['action'])?$_GET['action']:'';
//添加笔记
if($action=="insert"){
$username=$_COOKIE['username'];
$title=_POST('title');
$content=addslashes(_POST('content'));
$settime=date('y-m-d h:i:s',time());
$sql="insert into
note
(username,settime,title,content)
values('$username','$settime','$title','$content');
";
query($sql);
mysqli_close($mydb);
echo "<script>self.location='shownote.php';</script>";
}
//删除笔记
if($action=="delete"){
echo 'in';
$username=$_COOKIE['username'];
$id=_POST('id');
echo $id;
$sql="delete from note where id = '$id'";
query($sql);
mysqli_close($mydb);
echo "<script>self.location='shownote.php';</script>";
}
//更新笔记
if($action=="update"){
$username=$_COOKIE['username'];
$title=_POST('title');
$content=addslashes(_POST('content'));
$settime=date('y-m-d h:i:s',time());
$id=_POST('id');
$sql="update
note
set
settime='$settime',title='$title',content='$content'
where id='$id'
";
query($sql);
$sqll="select content from note where id = '$id' ";
$reslut=fetch_all($sqll);
var_dump($reslut);
mysqli_close($mydb);
echo "<script>self.location='shownote.php';</script>";
}
?>