function delCarousel($id)
{
include_once 'connect.php';
$db = db_Init();
$sql_str = 'UPDATE Carousel SET Del = 1 WHERE ID="' . $id . '"';
$db->query($sql_str);
header('location:admin/carousel.php');
}
<?php
session_start();
include_once '../connect.php';
$db = db_Init();
$name = $_POST['Username'];
$pwd = $_POST['Password'];
$query_str = 'SELECT * FROM User WHERE Name="' . $name . '" and Password="******" limit 1';
$row = $db->get_row($query_str);
$login = count($row) > 0;
if ($login) {
// 登录成功
$_SESSION['user_id'] = $row->ID;
$_SESSION['user_name'] = $row->Name;
header('location:' . 'index.php');
exit;
} else {
//登录失败 返回
$_SESSION['loginStatus'] = 0;
header('location:' . 'login.php');
exit;
}
function updateCarousel($req)
{
include_once 'connect.php';
$db = db_Init();
$sql_str = 'UPDATE Carousel SET Name="' . $req['set_name'] . '",Des="' . $req['set_content'] . '",Image="' . $req['set_img'] . '" WHERE ID=' . $req['set_id'];
$db->query($sql_str);
echo '更新信息成功';
echo '<script>setTimeout(function(){window.location.href="/admin/carousel.php";},1000);</script>';
}
function contactDetail($id)
{
include_once 'connect.php';
$db = db_Init();
$query_str = 'SELECT * FROM Contact WHERE Del=0 AND ID=' . $id . ' limit 1';
$r = $db->get_results($query_str);
$result = json_encode(array("status" => true, "message" => "查询团队数据", 'result' => $r));
$this->_setHeader();
echo $result;
}
function addContact($req)
{
include_once 'connect.php';
$db = db_Init();
$sql_str = 'INSERT INTO Contact (Title,Content,Link,Type) VALUES ("' . $req['t_name'] . '","' . $req['t_content'] . '","' . $req['t_link'] . '",' . $req['t_type'] . ')';
$db->query($sql_str);
echo '添加成功';
echo '<script>setTimeout(function(){window.location.href="/admin/contact.php";},1000);</script>';
}
