-
Notifications
You must be signed in to change notification settings - Fork 1
/
get_qtip_data.php
96 lines (59 loc) · 1.93 KB
/
get_qtip_data.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
<?php
$action = $_POST['action'];
switch($action){
case "get":
if (!empty ($_POST['id'])) {
$id = $_POST['id'];
$con = @mysql_connect("localhost","root","krit1979") or die('error!');
mysql_select_db("kr_ccms", $con);
mysql_query("SET NAMES UTF8");
$result = mysql_query("SELECT content FROM kr_qtip_data where (id='".$id."' and type=0)");
$row=mysql_fetch_array($result);
if($row){
$content = $row['content'];
mysql_close($con);
$data = array(
'status' => 1 ,
'content' => '<p id="'.$id.'" contenteditable="true">'.$content.'</p> '
);
echo json_encode($data);
}else{
$data = array(
'status'=>1,
'content'=>'<p id="'.$id.'" contenteditable="true" class="no_qtip">暂无提示</p>'
);
echo json_encode($data);
}
}else{
$data = array(
'status'=>1,
'content'=>'<p contenteditable="true" class="no_id">无id</p>'
);
echo json_encode($data);
}
break;
case "insert":
$con = @ mysql_connect("localhost","root","krit1979") or die('ddderror!');//http://10.188.199.8
mysql_select_db("kr_ccms", $con) or die('选择数据库失败!');
mysql_query("SET NAMES UTF8");
//插入数据
$sql = "insert into kr_qtip_data(id,content,type) values ('".$_POST['id']."','".$_POST['content']."',0)";
$result = mysql_query($sql);
mysql_close($con);
break;
case "update":
if (!empty ($_POST['id'])&&!empty ($_POST['content'])) {
$con = @ mysql_connect("localhost","root","krit1979") or die('ddderror!');//http://10.188.199.8
mysql_select_db("kr_ccms", $con) or die('选择数据库失败!');
mysql_query("SET NAMES UTF8");
//修改数据
$sql = "UPDATE kr_qtip_data SET content='".$_POST['content']."'where (id='".$_POST['id']."' and type=0)";
$result = mysql_query($sql);
mysql_close($con);
return true;
}else{
return false;
}
break;
}
?>