This repository has been archived by the owner on May 28, 2020. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathemostore_admin_add_do.php
50 lines (50 loc) · 2.09 KB
/
emostore_admin_add_do.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
<!DOCTYPE html>
<html><head><meta charset="utf-8"><title>云颜文字·源商店：添加数据</title></head><body>
<center>云颜文字·源商店<h1>添加数据</h1></center>
<?php
include 'emostore_admin_sqlsetting.php';
session_start();
if (isset($_SESSION['username'])) {
if ($_SESSION['userflag'] == 1) {
echo "管理员：".$_SESSION['username']."。<a href='emostore_admin_logout.php?backurl=".$_SERVER['PHP_SELF']."'>注销</a>。";
}
if ($_SESSION['userflag'] == 0) {
echo "标准用户：".$_SESSION['username']."。<a href='emostore_admin_logout.php?backurl=".$_SERVER['PHP_SELF']."'>注销</a>。";
die("<hr><p><b>访问受限：</b>必须使用管理员账户登录才可以继续哦。</p>");
}
}else{
echo "没有登录任何用户，请先<a href='emostore_admin_login_ui.php?backurl=".$_SERVER['PHP_SELF']."'>登录</a>。";
die("<hr><p><b>访问受限：</b>必须使用管理员账户登录才可以继续哦。</p>");
}
$linkID = db_connect();
$isok = true;
echo "<hr><table border=0 align=\"center\" width=800><tbody>";
$sqlkey = "`";
$sqlval = "'";
for ($i = 1; $i < count($keys); $i++) {
$nowkey = mysqli_real_escape_string($linkID,$keys[$i]);
if (isset($_POST[$nowkey])) {
$nowval = mysqli_real_escape_string($linkID,$_POST[$nowkey]);
echo "<tr><td>".$nowkey."</td><td>".$nowval."</td></tr>";
$sqlkey = $sqlkey.$nowkey."`,`";
$sqlval = $sqlval.$nowval."','";
} else {
echo "找不到参数：".$nowkey."。</br>";
$isok = false;
}
}
$sqlkey = substr($sqlkey, 0,strlen($sqlkey)-2);
$sqlval = substr($sqlval, 0,strlen($sqlval)-2);
$sql = "insert `emostore`(".$sqlkey.") values(".$sqlval.");";
echo "</tbody></table><hr>";
if ($isok == false) {
die("<hr><p><b>参数不正确，提交添加中止。</b></p>");
}
// echo $sql."<hr>";
$query = mysqli_query($linkID,$sql)
or die("<p><b>SQL语句执行失败。</b></p>");
mysqli_close($linkID);
echo "<p><b>条目添加成功。</b></p>";
?><p><a href="emostore_admin_alldata.php">返回源列表</a>
<meta http-equiv="Refresh" content="3;URL=emostore_admin_alldata.php">
</p><?php echo $footer; ?></body></html>