dongtuo6562 2016-07-12 21:14
浏览 28

如何在php中循环更新查询并显示它,就像日志历史一样

<?php
include('core/init.php');//database connection


if(isset($_POST['btn_submit'])){
   $sqlQuery = mysql_query("UPDATE `position` SET `ATR`='".mysql_real_escape_string($_POST['ATR'])."', 
  $resultQuery = mysql_query($connection, $sqlQuery) or die (mysql_error($connection));

  if(mysql_affected_rows($resultQuery) > 0){
  echo "updated";
 }else{
  echo "failed";
 }
  header('Location:position2.php');
   $result = mysql_query("SELECT * FROM position WHERE ID='" .$_POST["id"]. "'");
   $row2 = mysql_fetch_array($result);
 }
 ?>

//What this code does it it updates the database based on user input and I am trying to loop through each of the user input as update and display but it doesn't seem to work

  • 写回答

1条回答 默认 最新

  • doucheng7534 2016-07-13 18:31
    关注

    ($_POST['ATR'])."', Is missing a closing " Also formatting code makes it easier to read and debug.

    评论

报告相同问题?

悬赏问题

  • ¥15 Vue3 大型图片数据拖动排序
  • ¥15 划分vlan后不通了
  • ¥15 GDI处理通道视频时总是带有白色锯齿
  • ¥20 用雷电模拟器安装百达屋apk一直闪退
  • ¥15 算能科技20240506咨询(拒绝大模型回答)
  • ¥15 自适应 AR 模型 参数估计Matlab程序
  • ¥100 角动量包络面如何用MATLAB绘制
  • ¥15 merge函数占用内存过大
  • ¥15 使用EMD去噪处理RML2016数据集时候的原理
  • ¥15 神经网络预测均方误差很小 但是图像上看着差别太大