使用AJAX和jQuery从mySQL数据库中删除特定ID [英] Deleting a specific ID from mySQL Database using AJAX and jQuery

问题描述

我正在尝试从问题列表中删除特定ID。现在它只删除问题列表中的最后一个问题而不是我点击删除的问题。



HTML

I'm trying to delete a specific ID from my questions list. Right now it's only deleting the last question from the list of questions not the one I click on to delete.

HTML

<div id="wrapper">
        <div class="projects_list">



         </div>
      </div>

MY JQUERY

MY JQUERY

 var projects = function(){

     $.ajax({
         url: "xhr/get_projects.php",
         type: "get",
         dataType: "json",
         success: function(response){
             if(response.error){
                 console.log(response.error);
             }else{


                 for(var i=0, j=response.projects.length; i < j; i++){
                     var result = response.projects[i];
                     console.log(response.projects[i]);

                     $(".projects_list").append(
                        "<div style='border: 1px solid #555'>" +
                         "<h5> Question ID:</h5> " + result.id + "<br>" +
                         " Question: " + result.projectName + "<br>" +
                         " Question tags: " + result.projectDescription + "<br>" +
                         " <button class='deletebtn'>Delete</button>" +
                      //   " Question Status: " +result.status +
                     //  "<button class='editbtn'>Edit</button>" +
                         "</div> <br>"
                    );

                 };
             $(".deletebtn").on("click", function(e){
                console.log("test delete");
                 $.ajax({
                     url: "xhr/delete_project.php",
                     data: {
                         projectID: result.id
                     },
                     type: "post",
                     dataType: "json",
                     success: function(response){
                         console.log("testing for success");

                         if(response.error) {
                             alert(response.error);

                         }else{
                             window.location.assign("questions.html");
                         };
                     }
                 });
             });
          };
         }
      });
};

MY PHP FOR DELETE_PROJECT.PHP

MY PHP FOR DELETE_PROJECT.PHP

<?php

// UNFINISHED

error_reporting(E_ALL);

session_start();
session_regenerate_id(false);

require_once("reqs/common.php");
require_once("reqs/pdo.php");
require_once("reqs/auth.php");

checkLoggedIn();

$updata = array();

$user = $_SESSION["user"];
$projectID = param($_POST, 'projectID', '');

if( empty($projectID) ){ errormsg("The 'projectID' is required."); }

$dbh = new PDB();
$db = $dbh->db;
$site = new Site($db);

$tasks = $dbh->getTasks($projectID);
$taskArr = array();

for($i=0; $i<count($tasks); $i++){
	array_push($taskArr, $tasks[$i]->id);
}

$arr = implode(", ", $taskArr);

try{
	$ct = 0;
	if(!empty($arr)){ //rich and justin edit
		$sql = "DELETE FROM tasks WHERE id IN (".$arr.")";
		//errormsg($arr);
		$st = $db->prepare($sql);
	
		$st->execute();
	}
}catch (PDOException $e){
	errormsg($e->getMessage());
}

try{
	$ct = 0;
	$sql = "DELETE FROM projects WHERE id = :projectID";
	
	$st = $db->prepare($sql);
	$st->bindParam(":projectID", $projectID);
	
	$st->execute();
	
}catch (PDOException $e){
	errormsg($e->getMessage());
}

exitjson(array("success"=>true));


?>

提前谢谢。

Thank you in advance.

推荐答案

.ajax（{
url：xhr / get_projects.php，
类型：get，
dataType：json，
成功：函数（响应）{
if（response.error）{
console.log（ response.error）;
} else {


for（var i = 0，j = response.projects.length; i< j; i ++）{
var result = response.projects [i];
console.log（response.projects [i]）;

.ajax({ url: "xhr/get_projects.php", type: "get", dataType: "json", success: function(response){ if(response.error){ console.log(response.error); }else{ for(var i=0, j=response.projects.length; i < j; i++){ var result = response.projects[i]; console.log(response.projects[i]);

（。projects_list）。append（
< div style ='border：1px solid＃555'>+
< h5>问题ID：< / h5>+ result.id +< br>+
问题：+ result.projectName +< br>+
问题代码：+ result.projectDescription +< br>+
< button class ='deletebtn'>删除< / button>+
//问题状态： + result.status +
//< button class ='editbtn'> Edit< / button>+
< / div> < br>
）;

};

(".projects_list").append( "<div style='border: 1px solid #555'>" + "<h5> Question ID:</h5> " + result.id + "<br>" + " Question: " + result.projectName + "<br>" + " Question tags: " + result.projectDescription + "<br>" + " <button class='deletebtn'>Delete</button>" + // " Question Status: " +result.status + // "<button class='editbtn'>Edit</button>" + "</div> <br>" ); };

（。deletebtn）。on（click，function（e）{
console.log（test delete）;

(".deletebtn").on("click", function(e){ console.log("test delete");

这篇关于使用AJAX和jQuery从mySQL数据库中删除特定ID的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！