bores_escalovsk Posted July 20, 2014 Share Posted July 20, 2014 <?php $db = new PDO('mysql:host=localhost;dbname=wordpress', 'root',''); //---------prepare $delete3 = $db->prepare("DELETE FROM wp_term_relationships WHERE object_id=:id"); $delete2 = $db->prepare("DELETE FROM wp_posts WHERE ID=:id"); $delete = $db->prepare("DELETE FROM wp_postmeta WHERE post_id=:id"); $select = $db->prepare("SELECT post_id FROM reference WHERE x_id=?"); $delete->bindValue(':id', $id, PDO::PARAM_STR); $delete2->bindValue(':id', $id, PDO::PARAM_STR); $delete3->bindValue(':id', $id, PDO::PARAM_STR); //---------- echo 'conected-----'; { $delfeed = '';} $array = explode(',',$delfeed); foreach($array as $deadman){ $select->execute(array($deadman)); $row = $select->Fetch(PDO::FETCH_ASSOC); $id = $row['post_id']; if ($id == null){} else { echo "$id"."\n"; $delete->execute(); $delete2->execute(); $delete3->execute(); } $id++; } echo 'done!'; ?> its a simple delete script but it doesnt delete, it does print the right $id's witch means is working till thereĀ but delete goes bananas,double checked table names ,colums... tryied working with question mark place holders insted of bind parameter but nothing Link to comment https://forums.phpfreaks.com/topic/290011-pdo-delete-not-working/ Share on other sites More sharing options...
bores_escalovsk Posted July 20, 2014 Author Share Posted July 20, 2014 didnt declare $id ~~facepalm~~ Link to comment https://forums.phpfreaks.com/topic/290011-pdo-delete-not-working/#findComment-1485734 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.