普通网友 2016-10-16 13:57
浏览 7

在线发行系统

I am making an online issue system in PHP.However,for updating the data,I need to pass a JS variable to PHP using AJAX and am not able to do so.Here is the code.

  <?php   
     

    $sql=mysql_query("SELECT * FROM techroom ORDER BY Id DESC");

 
    while($row=mysql_fetch_assoc($sql)){
 

      
        echo "<tr><th>{$row['Id']}</th>";
      
        echo "<th>{$row['Item']}</th>"; 
        echo "<th> {$row['Description']}</th>";
        echo "<th>{$row['Quantity left']}</th>";
      
        echo '<th><button id="issue'.$row['Id'].'" onclick="issue('.$row['Id'].')">Issue</button></th></tr>';
      
      
        }
        ?>

Here is the JS function and AJAX code:

<script>
function issue(id){    
   
  var quantity=prompt("Quantity required?");
  if(quantity!=null){
   var n= prompt("No. of days required");
   if(n<=10){
        $.ajax(
{
    type: "POST",
    url: "/tech.php",
    data: quantity,id,
    success: function(data, textStatus, jqXHR)
    {
        console.log(data);
    }
});        
     }
    else{
      confirm("Max. limit is 10 days");
    } 
   }
      
}
</script>

And here is the file I want to direct to:

<?php
include "header.php";
include "mysql_connect.php";
$id=mysql_real_escape_string(strip_tags($_POST("id")));
$q=mysql_real_escape_string(strip_tags($_POST("q")));
$sql=mysql_query("SELECT * FROM techroom ORDER BY Id DESC");
     while($row=mysql_fetch_assoc($sql)){
      mysql_query("UPDATE techroom SET $row['Quantity left']=$row['Quantity left']-$q WHERE $row['Id']=$id");
    }
   ?>

Please correct me where I am wrong as I am doing this for the first time.

</div>
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 如何让企业微信机器人实现消息汇总整合
    • ¥50 关于#ui#的问题:做yolov8的ui界面出现的问题
    • ¥15 如何用Python爬取各高校教师公开的教育和工作经历
    • ¥15 TLE9879QXA40 电机驱动
    • ¥20 对于工程问题的非线性数学模型进行线性化
    • ¥15 Mirare PLUS 进行密钥认证?(详解)
    • ¥15 物体双站RCS和其组成阵列后的双站RCS关系验证
    • ¥20 想用ollama做一个自己的AI数据库
    • ¥15 关于qualoth编辑及缝合服装领子的问题解决方案探寻
    • ¥15 请问怎么才能复现这样的图呀