douzepao0281 2013-06-13 23:06
浏览 27
已采纳

PHP不重新加载更新

I'm trying to create a system that when i submit the form, after the page refresh it should show the new values that i get from the database. The values work well when they go into the databse but they dont show after submited, only when i refresh again. Thanks for helping

<?php

include("connect.php");

    $query = "SELECT * FROM `laliga`";
    $result = mysql_query($query);

    while($row = mysql_fetch_assoc($result)){
        $id = $row['id'];
        $home = $row['home'];
        $away = $row['away'];
        $win = $row['win'];
        $draw = $row['draw'];
        $lose = $row['lose'];
    }

    echo "<h2>La Liga</h2>";

    echo $home, " - ", $away;

    if (isset($_POST) && $_POST['laliga'] == 1){
        $select = mysql_real_escape_string($_POST['laliga']);
        $select = $win + $select;
        mysql_query("UPDATE laliga SET win='$select'");
    }else if (isset($_POST) && $_POST['laliga'] == 'X'){
        $select = mysql_real_escape_string($_POST['laliga']);
        $select = '1';
        $select = $draw + $select;
        mysql_query("UPDATE laliga SET draw='$select'");
    }else if (isset($_POST) && $_POST['laliga'] == 2){
        $select = mysql_real_escape_string($_POST['laliga']);
        $select = '1';
        $select = $lose + $select;
        mysql_query("UPDATE laliga SET lose='$select'");
    } 

    header('Location: ../laliga.php');


    ?>

    <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">

        <input type="radio" name="laliga" value="1">1
        <input type="radio" name="laliga" value="X">X
        <input type="radio" name="laliga" value="2">2

        <input type="submit" name="submit" value="Submit"/>

    </form>

    <br/>
    <?php

    echo $home, " -> ", $win;
    echo "<br/>Barazim  -> ", $draw,"<br/>";
    echo $away, " -> ", $lose;

    ?>
  • 写回答

2条回答 默认 最新

  • donglu5000 2013-06-13 23:12
    关注

    Add:

    header('Location: <mypage.php>');
    

    After mysql_query.

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

报告相同问题?

悬赏问题

  • ¥15 BP神经网络控制倒立摆
  • ¥20 要这个数学建模编程的代码 并且能完整允许出来结果 完整的过程和数据的结果
  • ¥15 html5+css和javascript有人可以帮吗?图片要怎么插入代码里面啊
  • ¥30 Unity接入微信SDK 无法开启摄像头
  • ¥20 有偿 写代码 要用特定的软件anaconda 里的jvpyter 用python3写
  • ¥20 cad图纸,chx-3六轴码垛机器人
  • ¥15 移动摄像头专网需要解vlan
  • ¥20 access多表提取相同字段数据并合并
  • ¥20 基于MSP430f5529的MPU6050驱动,求出欧拉角
  • ¥20 Java-Oj-桌布的计算