php - Deleting multiple with PDO and javascript -
having issue current script. using pdo , ajax delete record. call images via mysql pdo using below code:
<?php $stmt = $db->query('select * img_slider order id '); while($row = $stmt->fetch(pdo::fetch_assoc)) { echo " <li id='{$row['id']}'> <div class='imghover'> <div class='hover'> <a href='delete.php?id={$row['id']}' class='deleteitem' ><img src='../img/delete.png'></a></div> <img src='{$row['path']}'> </div> </li>"; }
i use javascript send id , delete.php
, remove image thumbnail list:
$(function() { $('.deleteitem').click(function(e) { e.preventdefault(); var id = $(this).parent('li').attr('id'); $.get('delete.php',{ id: id}).done(function(data) { if(data=='error, insert query failed') { // dont delete list alert('failed delete '+id); } else { //delete list $('#'+id).remove(); alert('deleted '+id); } }); }); });
i have multiple records different rows wish delete, use following pdo code execute deletion:
require("common.php"); if(empty($_session['user'])) { header("location: login.php"); die("redirecting login.php"); } $id = $_get['id']; $pdo->begintransaction(); $st = $pdo->prepare('delete img_nav id = :id'); $st->execute(array(':id', $id)); $st = $pdo->prepare('delete img_slider id = :id'); $st->execute(array(':id', $id)); $st = $pdo->prepare('delete img_landing id = :id'); $pdo->commit();
i have tried linking directly delete.php
, not going through javascript, chrome simple gives me server error. doing right here? beginner , english not advice appreciated.
Comments
Post a Comment