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

Popular posts from this blog

php - Calling a template part from a post -

Firefox SVG shape not printing when it has stroke -

How to mention the localhost in android -