php - 尝试获取表单按钮来更改数据库中的值

Question

我目前正在尝试获取一个表单按钮来更改 MySQL 数据库表字段值？有什么想法我的这段代码哪里出了问题吗？...

HTML 按钮:

<form><form action="admin.php" method="POST">
<strong>ACTIVE MODE -</strong> Main BaseCentre website is online and active. <input type="submit" value="Maintenance Mode" class="btn btn-default" name="updateclose_site">|
</form>

PHP 脚本:

if (isset($_POST['updateclose_site'])){
$sql = mysql_query("UPDATE adminpage SET close_site='1' WHERE setting='main'");

$sql_doublecheck = mysql_query("SELECT * FROM adminpage WHERE setting='main' AND close_site='1'");
$doublecheck = mysql_num_rows($sql_doublecheck);

if($doublecheck == 0){
echo "<strong><font color=red>> Close site is off</font></strong>";
} elseif ($doublecheck > 0) {
echo "<strong><font color=green>> Close site is working</strong></font><br />";

}
}

我的数据库如下所示:

“标题”设置 | close_site(枚举，0,1,2,3)
“行”主要 | 0(默认)

当我点击按钮时没有任何反应？将不胜感激任何帮助!

Answer 1

将 html 更改为

<form action="admin.php" method="POST">
<strong>ACTIVE MODE -</strong> Main BaseCentre website is online and active. <input type="submit" value="Maintenance Mode" class="btn btn-default" name="updateclose_site">|
</form>

您有一个额外的<form>