echo "<script language=\"javascript\">";
echo "location.href=\"Message_land_back.php\"";
echo "</script>";
}
}
if (isset($_POST['submit3'])) {
if (isset($_POST['ids'])) {
require_once 'MessageTool.php';
$MysqliTool = new MysqliTool();
$ids = $_POST['ids'];
$sq = "delete from message where id={$ids}";
$re = $MysqliTool->execute_dml($sq);
echo "<script language=\"javascript\">";
echo "location.href=\"Message_land_back.php\"";
echo "</script>";
}
}
if (isset($_POST['submit5'])) {
if (isset($_POST['ids']) && isset($_POST['add_user'])) {
require_once 'MessageTool.php';
$MysqliTool = new MysqliTool();
$id = $_POST['idss'];
$add_user = $_POST['add_user'];
$add_message = $_POST['add_message'];
$sql = "insert into add_message(messageid,add_user,add_message) value('{$id}','{$add_user}','{$add_message}')";
$res = $MysqliTool->execute_dml($sql);
echo "<script language=\"javascript\">";
echo "location.href=\"Message_land_back.php\"";
echo "</script>";
}
}
$novelist = $_POST['novelist'];
$MysqliTooll = new MysqliTool();
$user = $_SESSION['name'];
$sql = "select novelist from user where name='{$user}';";
$res = $MysqliTooll->execute_dql($sql);
while ($row = $res->fetch_assoc()) {
if ($row['novelist'] != NULL) {
echo "<script language=\"javascript\">";
echo "alert(\"对不起，您之前已经投过票了！\");";
echo "location.href=\"vote.php\"";
echo "</script>";
die;
}
}
$novelist = $_POST['novelist'];
$sqll = "update user set novelist={$novelist} where name='{$user}';";
$ress = $MysqliTooll->execute_dml($sqll);
$sqlll = "select vote from votes where nameid={$novelist}";
$resss = $MysqliTooll->execute_dql($sqlll);
while ($row = $resss->fetch_assoc()) {
$votes = $row['vote'] + 1;
}
$sqllll = "update votes set vote={$votes} where nameid={$novelist}";
$ressss = $MysqliTooll->execute_dml($sqllll);
if ($ress == 1 && $ressss == 1) {
echo "<script language=\"javascript\">";
echo "alert(\"投票成功！\");";
echo "location.href=\"vote.php\"";
echo "</script>";
}
}
