通过输入字段将数据从数据库更新到用户再到数据库 [英] UPDATE data from db to user to db through an input field

问题描述

通过输入字段将数据从数据库更新到用户再到数据库.谁能告诉我这个更新有什么问题.我正在从一个字段中获取数据，我也在该字段中从 db 中写入数据，这是不可能的吗?

UPDATE data from db to user to db through an input field. Can anyone please tell me whats wrong with this UPDATE. I'm getting the data from a field where I'm also writing from db, is that not possible?

我的sql代码是这样的..

My sql code looks like this..

<?php session_start(); $brugerID = $_SESSION['brugerID']; $holdID = $_SESSION['holdID']; ?>

我的 php 代码如下:

My php code looks like this:

<form method="POST" action="" id="submitvaegt">
    <tr>
        <td colspan="5"><h2>Hvor meget vejer du idag?</h2></td>
    </tr>
        <?php
        $brugerensID = $_SESSION['brugerID'];
        $sql = "SELECT * FROM `brugere` 
        WHERE brugerID = '$brugerensID'";
        $result = mysql_query($sql);
        $row = mysql_fetch_assoc($result);

        echo '<tr>';
        echo '<td rowspan="3" valign="middle" width="128">';
        echo '<img src="http://www.mahogni.com/afs/wp-content/uploads/2012/12/weight.png" width="60"></td>';
        echo '<td>&nbsp;</td>';
        echo '<td colspan="3">&nbsp;</td>';
        echo '</tr>';

        echo '<tr>';
        echo '<td width="245" height="35">Jeg vejer i dag</td>'; //vaegtnu
        echo '<td width="280">';
        echo '<input class="textboxReport" type="text" name="vaegtnu" size="3" value="';
        if ($row['vaegtnu']==0) 
        { 
            echo $row['vaegtstart'];
        } 
        else 
        {
            echo $row['vaegtnu'];
        }           
        echo '"/>&nbsp;kg&nbsp;&nbsp;';
        echo '<input type="submit" name="submitvaegt" id="submitvaegt" value="GEM" />';
        echo '<td width="280" height="35">Jeg har til nu tabt</td>'; //vaegtstart - vaegtnu
        echo '<td align="right">';
        if ($row['vaegtnu']==0) 
        { 
            echo $row['vaegtstart']-$row['vaegtstart'];
        } 
        else 
        {
            echo $row['vaegtstart']-$row['vaegtnu'];
        }           
        echo '&nbsp;kg</td>';               
        echo ' </tr>';

        echo '<tr>';
        echo '<td height="35">Mit mål er</td>'; //vaegtslut
        echo '<td>'. $row['vaegtslut'] . '&nbsp;kg</td>'; 
        echo '<td height="28">Jeg mangler at tabe</td>'; //vaegtslut - vaegtnu ELLER vaegtslut - vaegtstart
        echo '<td>';

        if ($row['vaegtnu']==0) 
        { 
            echo $row['vaegtslut']-$row['vaegtstart'] . '&nbsp;kg';
        } 
        else 
        {
            echo $row['vaegtslut']-$row['vaegtnu'] . '&nbsp;kg';
        }
        echo '</td>';
        echo '</tr>';
        ?>
</form>

推荐答案

你能试试这个吗:

$vaegtnu=$_POST['vaegtnu'];

$brugerensID= $_SESSION['brugerID'];

mysql_query("UPDATE `brugere` SET vaegtnu='$vaegtnu' WHERE brugerID='$brugerensID'");

如果有帮助，请告诉我.

And tell me if it helps.

还要检查您的变量是否匹配，即在 XXXX = $_POST['YYYY'] YYYY 应该是输入的名称，而 XXXX 应该是您正在使用的变量的名称在查询中.

Also check that your variables match, i.e. in XXXX = $_POST['YYYY'] YYYY should be the name of the input, and XXXX should be the name of the variable you're using in the query.

这篇关于通过输入字段将数据从数据库更新到用户再到数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！