php - Why doesn't it delete the post? -
i wrote code delete per click post out of database table 'community_posts'. when click on button, doesn't delete it, url do=delete&key=theid
doesn't work, why? can me, please!
// php code if($do == "delete" && is_numeric($key)){ $check = mysql_query("select id community_posts id = '".$key."' limit 1") or die(mysql_error()); if(mysql_num_rows($check) > 0){ mysql_query("delete community_posts id = '".$key."' limit 1") or die(mysql_error()); $msg = "<center>neuigkeit wurde erfolgreich gelöscht...</center>"; } else { $msg = "<center>neuigkeit konnte nicht entfernt werden, versuche es erneut...</center>"; } } // html code und ausgabe der datenbank <form action='' method='post'> <?php $getcomments = mysql_query("select * community_posts order id desc limit 100"); ?> <?php while($row = mysql_fetch_array($getcomments)){ $getuserinfo = mysql_query("select * users id = '".$row['userid']."'"); $roww = mysql_fetch_array($getuserinfo); ?> <div class="feedone fade ptr"> <div class="ph20"> <div class="inner-1 lt" style=""><p style="color:#aeaeae;font-size:13px;"><a href="/community/userprofile/<?php echo $roww['username']; ?>" style="color:orange;text-decoration:none;font-weight:normal;"><?php echo $roww['vorname']; ?></a> » open community</p> <p class=lt style="color:#aeaeae;font-size:11px;"><?php echo $row['posted_on']; ?></p><br /> </div> <div class="rt inner-2"> <p style="color:#333;font-size:13px;"><?php echo $row['story']; ?></p> </div> <div class=cl></div> </div> <!-- bei klick soll hiermit der entsprechende beitrag gelÖscht werden --> <a href='<?php echo $path_admin; ?>/openfeed?do=delete&key=<?php echo $row['id']; ?>'><img src="/assets/data/images/icons/delete_round.png" alt="delete" /></a> <!----> </div> <?php } ?> </form>
variables in url header stored in $_get
array. instead first line should :
if($_get['do'] == "delete" && is_numeric($_get['key'])){
edit : might want check if variable set beforehand using isset()
method.
Comments
Post a Comment