Postgre使用Ajax函数在带有复选框的数据库中进行多记录删除查询,不会返回任何结果;不起作用


Postgre multiple record delete query in the database with checkboxes using Ajax function returns nothing and doesn't work

我有ajax函数,可以从选中的复选框中检索id。然后使用postgre查询将id作为条件传递到where子句,传递到delete文件。

如果查询成功:

                    if($qry){
                      $note = "Success";
                      echo json_encode(array('notify'=>$note));
                     }` else...... `else{
                      $note = "Failed";
                      echo json_encode(array('notify'=>$note));
                     }

然后我的ajax成功函数将通过以下方式接收:

  success: function(data)
  {
    if(data.notify=="Success"){
      console.log(data.notify);
    }
    else{
      console.log(data.notify);
    }
  }

但在我点击删除按钮后,console.log什么也没说,也没有删除任何记录。我如何才能使这项工作正常进行?非常感谢。这是我的密码。

接口.php

<?php
include ('connection.php');
$result = pg_query("SELECT h.hholdnumber,h.yr_residing,h.purok_number,h.brgy_name,f.f_id,f.fname,f.birthday,f.mname,f.age,f.lname,f.civilstatus,f.gender,f.civilstatus,f.job from house_hold as h,f_member as f where h.hholdnumber=f.hholdnumber");
while($row = pg_fetch_array($result))
{
$fid=$row['f_id'];
echo "<tr>";
echo "<td><center><input type='"checkbox'"  class='"check_id'"  name='"check_id[]'" value=".$row['f_id']." /></center></td> ";
echo "<td><center>" . $row['hholdnumber'] . "</center></td>";
echo "<td><center>" . $row['brgy_name'] . "</center></td>";
echo "<td><center>" . $row['purok_number']."</center></td>";
echo "<td><center>" . $row['yr_residing'] . "</center></td>";
echo "<td><center>" . $row['fname'] . "</center></td>";
echo "<td><center>" . $row['lname'] . "</center></td>";
echo "<td><center>" . $row['mname'] . "</center></td>";
echo "<td><center>" . $row['gender'] . "</center></td>";
echo "<td><center>" . $row['birthday'] . "</center></td>";
echo "<td><center>" . $row['age'] . "</center></td>";
echo "<td><center>" . $row['civilstatus'] . "</center></td>";
echo "<td><center>" . $row['job'] . "</center></td>";

echo "</tr>";
}
?>
</tbody>
</table>
</form>
<button id="delete_button" name="delete_button" >Delete</button>
<script type="text/javascript">
$("#delete_button").click(function(){
var array_id= $('input[name="check_id[]"]:checked').map(function(){
return this.value;
}).get();
var postdata = {'f_id':array_id};
$.ajax({
  type: "POST",                                    
  url: 'mem_del.php',
  dataType: 'json',
  data: postdata,
  success: function(data)
  {
    if(data.notify=="Success"){
      console.log(data.notify);
    }
    else{
      console.log(data.notify);
    }
  }
});
});
</script>

mem_del.php

 <?php

  include ('connection.php');
  $f_id = $_POST['f_id'];
                    $qry = pg_query("DELETE FROM f_member WHERE f_id in($f_id)");
                     if($qry){
                      $note = "Success";
                      echo json_encode(array('notify'=>$note));
                     }
                     else{
                      $note = "Failed";
                      echo json_encode(array('notify'=>$note));
                     }
  ?>

一如既往,不要猜测、检查日志、调试等。如果您需要临时在PostgreSQL中记录语句,可以执行以下操作:

ALTER database foo SET log_statements=all'

然后当你完成:

ALTER DATABASE foo RESET log_statements;

但关键是,看看通过了什么,在发送之前是否有报价,等等。

还要注意,您当前的方法倾向于SQL注入。你想走一条参数化的路线,这可能意味着在生成查询字符串的方式上要更有创意。