php - 如何停止递归在mysql中插入数据

这将从mysql数据库中打印作业描述，作业ID和作业名称。点击按钮还具有按钮，用户可以选择工作

<?php
include_once("db_connect.php");
$sql = "SELECT  jid,name, description FROM jobs";
$resultset = mysqli_query($conn, $sql) or die("database error:". mysqli_error($conn));
while( $record = mysqli_fetch_assoc($resultset) ) {
?>

<div class="product-card">

  <div class="product-details">
    <h1 id="jid-<?php print($record['jid']); ?>" ><?php echo $record['jid']; ?></h1>
    <h1 id="name-<?php print($record['jid']); ?>"><?php echo $record['name']; ?></h1>
    <p id="description-<?php print($record['jid']); ?>"><?php echo $record['description'];?></p>
    <input type="submit" class="btn" value="Select" id="submit-<?php echo $record['jid'];?>" />
  </div>
</div>

<script type="text/javascript">
$("#submit-<?php echo $record['jid'];?>").click(function(e){
  e.preventDefault();insert_job_f(<?php print($record['jid']); ?>);
});
</script>

<?php
} ?>

*****这是jQuery脚本*****

<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript">
function insert_job_f(jid)
{
  //debugger;
 var jidVal=$("#jid-"+jid).val();

  $.ajax
  ({
  type:'post',
  url:'insert_job.php',
  data:{
   insert_job:"insert_job",

   jid:jidVal
  },
  success:function(response) {
    alert(response);
    if(response=="success")
    {

      //window.location.href="main.php";
    }
    else
    {
      //alert("Wrong Details");
    }
  }
  });
}
</script>

***** insert_job.php ****

<?php
if(isset($_POST['jid']))
{
 $host="localhost";
 $username="Ahad";
 $password="abc.123";
 $databasename="vsm";
 $connect=mysqli_connect($host,$username,$password);
 $db=mysqli_select_db($connect,$databasename);

 $h=$_POST['jid'];[enter image description here][1]

$select_data=mysqli_query($connect,"INSERT INTO ff (jid) VALUES (19)");



 if($select_data===FALSE)
 {

    echo mysqli_error($connect);

    exit();
 }
 else
 {


    echo "successfully registered";

 }
 exit();
}
?>

一旦它一次又一次地发送硬编码值，如何使它发送数据

下图显示了用于测试的硬编码值递归进入数据库

最佳答案

完全删除

<script type="text/javascript">
$("#submit-<?php echo $record['jid'];?>").click(function(e){
  e.preventDefault();insert_job_f(<?php print($record['jid']); ?>);
});
</script>

并将onclick事件直接附加到您的提交按钮：

<input type="submit" class="btn" value="Select" id="submit-<?php echo $record['jid'];?>" onclick="insert_job_f(<?php print($record['jid']); ?>)" />

我不确定如何处理preventDefault()，但是您可以将其附加到insert_job_f()函数。