dtry54612 2014-02-24 22:24
浏览 46
已采纳

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

I am currently trying to get a form button to change a MySQL database table field value? Any ideas where I am going wrong with this code?...

HTML button:

<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 script:

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

}
}

My database looks like this:

"headers" setting | close_site (enum, 0, 1, 2, 3)
"rows" main | 0 (default)

Nothing happens when I click the button? Will appreciate any help!

  • 写回答

2条回答 默认 最新

  • dtbonklcs575884485 2014-02-24 22:29
    关注

    Change html to

    <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>
    

    You have an extra <form>

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥20 数学建模,尽量用matlab回答,论文格式
  • ¥15 昨天挂载了一下u盘,然后拔了
  • ¥30 win from 窗口最大最小化,控件放大缩小,闪烁问题
  • ¥20 易康econgnition精度验证
  • ¥15 msix packaging tool打包问题
  • ¥28 微信小程序开发页面布局没问题,真机调试的时候页面布局就乱了
  • ¥15 python的qt5界面
  • ¥15 无线电能传输系统MATLAB仿真问题
  • ¥50 如何用脚本实现输入法的热键设置
  • ¥20 我想使用一些网络协议或者部分协议也行,主要想实现类似于traceroute的一定步长内的路由拓扑功能