prepare($sql); $stmt->execute([$loginuser]); if ($stmt->rowCount() == 0) { echo "4"; exit; } $row = $stmt->fetch(PDO::FETCH_ASSOC); if ($row['loginpwd'] != md5($loginpwd)) { echo "5"; exit; } if ($row['loginstate'] < 1) { echo "6"; exit; } // Check power status $sql = "SELECT COUNT(powerstate) as count, powerstate FROM power WHERE id = ? GROUP BY powerstate"; $stmt = $conn->prepare($sql); $stmt->execute([$row['loginpower']]); $power = $stmt->fetch(PDO::FETCH_ASSOC); if (!$power || $power['count'] == 0 || $power['powerstate'] == 0) { echo "6"; exit; } $_SESSION['zengscode'] = ""; // Update login information $sql = "UPDATE login SET loginlasttime = loginthistime, loginlastip = loginthisip, loginthistime = NOW(), loginthisip = ?, logincount = logincount + 1 WHERE id = ?"; $stmt = $conn->prepare($sql); $stmt->execute([getIp(), $row['id']]); // Set session variables $_SESSION['loginid'] = $row['id']; $_SESSION['loginuser'] = $row['loginuser']; $_SESSION['loginname'] = $row['loginname']; $_SESSION['loginpower'] = $row['loginpower']; echo "7"; exit; } ?> <?php echo $webname; ?> - 网站后台管理