donmqryh49993 2016-04-10 08:47
浏览 97

php mysql更新表使用变量不起作用

i have data on one form which is echoed form a table, i want to use this data to update information in another table. whenever i hit the update button it show an error, "could not update data: query was empty", here is the update code, please help me out.

  <?php
     if(isset($_POST['submit'])) {
        $dbhost = 'localhost';
        $dbuser = 'root';
        $dbpass = '';

        $conn = mysql_connect($dbhost, $dbuser, $dbpass);

        if(! $conn ) {
           die('Could not connect: ' . mysql_error());
        }

        $ItemId = $_POST['ItemId'];
        $Quantity = $_POST['Quantity'];

       //$sql = "UPDATE stationery ". "SET Quantity = $Quantity ". "WHERE ItemId = $ItemId" ;
        $sql = mysql_query("UPDATE stationery set Quantity = ". $Quantity ." WHERE ItemId = '".$ItemId."'");
       //$sql=mysql_query("UPDATE stationery SET Quantity = ".mysql_real_escape_string($Quantity)." WHERE IltemId = '".mysql_real_escape_string($ItemId)."'");
        mysql_select_db('dbtest');
        $retval = mysql_query( $sql, $conn );

        if(! $retval ) {
           die('Could not update data: ' . mysql_error());
        }
        echo "Updated data successfully
";

        mysql_close($conn);
     }
  ?>

and this is the table where data is echoed from a mysql table

<?php
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("dbtest", $con);

 $result = mysql_query ("SELECT * FROM stationery");
echo "<table border = '1' style='margin-left:18px;margin-right:18px;'bgcolor='#CFC'>
  <tr><th bgcolor='#34495E' colspan='9'>
   <h1><font color='white' align='center'>&nbsp&nbsp&nbspORDER OFFICE SUPPLIES</font></h1>
</th></tr>
<tr bgcolor='#CFC' font size='18'>
<th>Item Name</th>
<th>Item Id</th>
<th>Quantity</th>
</tr>";

 while ($row = mysql_fetch_array($result))
 {
    echo "<form action=\"\" method=\"post\" enctype=\"multipart/form-data\">";
    echo "<tr>";
    echo "<td><input type=\"text\" name=\"ItemName\"  size=\"30\" value=\" ". $row ['ItemName'] . "\" readonly></td>";
    echo "<td><input type=\"text\" name=\"ItemId\" value=\" ". $row ['ItemId'] . "\" readonly></td>";
   echo "<td><input type=\"text\" name=\"Quantity\" required></td>";
   echo "<td><input type=\"submit\" name=\"submit\" size=\"30\" style='background-color:#3366FF' value=\"Update  \"></td>";

 echo "</tr>";
   echo "</form>";
  }
  echo "</table>";


  mysql_close($con);

 ?>
  • 写回答

2条回答 默认 最新

  • dongliu5475 2016-04-10 08:53
    关注

    Change this line:

    $sql = mysql_query("UPDATE stationery set Quantity = ". $Quantity ." WHERE ItemId = '".$ItemId."'");
    

    To:

    $sql = "UPDATE stationery set Quantity = '". $Quantity ."' WHERE ItemId = '".$ItemId."'";
    

    Full Code:

    <?php 
        $dbhost = 'localhost';
    $dbuser = 'root';
    $dbpass = '';
    
    $conn = mysql_connect($dbhost, $dbuser, $dbpass);
    
    if(! $conn ) {
       die('Could not connect: ' . mysql_error());
    }
    
    $ItemId = $_POST['ItemId'];
    $Quantity = $_POST['Quantity'];
    
    $sql = "UPDATE stationery set Quantity = '". $Quantity ."' WHERE ItemId = '".$ItemId."'";;
    
    mysql_select_db('test');
    $retval = mysql_query( $sql, $conn );
    
    if(! $retval ) {
       die('Could not update data: ' . mysql_error());
    }
    echo "Updated data successfully
    ";
    
    mysql_close($conn);
    ?>
    
    评论

报告相同问题?

悬赏问题

  • ¥15 数学的三元一次方程求解
  • ¥20 iqoo11 如何下载安装工程模式
  • ¥15 本题的答案是不是有问题
  • ¥15 关于#r语言#的问题:(svydesign)为什么在一个大的数据集中抽取了一个小数据集
  • ¥15 C++使用Gunplot
  • ¥15 这个电路是如何实现路灯控制器的,原理是什么,怎么求解灯亮起后熄灭的时间如图?
  • ¥15 matlab数字图像处理频率域滤波
  • ¥15 在abaqus做了二维正交切削模型,给刀具添加了超声振动条件后输出切削力为什么比普通切削增大这么多
  • ¥15 ELGamal和paillier计算效率谁快?
  • ¥15 蓝桥杯单片机第十三届第一场,整点继电器吸合,5s后断开出现了问题