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>"; } }