Delete a single db row after clicking delete button

Question

I have this query, where I want to delete a single row from DB when clicking on delete button. Right now, it's deleting the whole DB row. but I want to delete a single row by ID.

Here's the code

add_action('admin_menu', 'conference_register');
function conference_register(){
      add_options_page('Register Conference', 'Conference Registration',  'manage_options', 'conference-registration', 'display_conference');
}

function display_conference(){
    echo "<form method='post'>";
    echo "<div class='wrap'>";
    echo "<h2>Conference Registration User Details</h2>";
    global $wpdb;
    $results = $wpdb->get_results("SELECT `id`,`email`,`details` FROM `conference_register`"); ?>
    <table class="wp-list-table widefat fixed striped pages">
      <thead>
          <tr>
            <th id="posts" class="manage-column column-posts num">ID</th>
            <th id="email" class="manage-column column-email">Email</th>      
            <th id="description" class="manage-column column-description">Details</th>
            <th id="posts" class="manage-column column-posts num">Delete</th>
          </tr>
      </thead>
    <tbody id="the-list">
   <?php foreach($results as $value){
        echo "<tr>";
        echo "<td class='posts column-posts'>".$value->id."</td>";
        echo "<td class='email column-email'>".$value->email."</td>";
        echo "<td class='description column-description'><div id='col-container'>".$value->details."</div></td>";
        echo "<td class='posts column-posts'><input type='submit' name='delete_registration' value='delete'/></td>";
        echo "</tr>";
         if(isset($_POST['delete_registration'])){
            $wpdb->delete( 'conference_register', array( 'id' => $value->id ) );
        }

    }
    echo "</tbody></table></div></form>";
}

The code for clicking action is set like this in above code:

 if(isset($_POST['delete_registration'])){
    $wpdb->delete( 'conference_register', array( 'id' => $value->id ) );
}

Am I missing anything here? Any help will be appreciated.

P.S. I want to delete a row without using jQuery.

When you said the whole DB row, did you mean the whole table is deleted? — Hard Spocker
– Hard Spocker, Commented Oct 7, 2015 at 9:09

jitendrapurohit · Accepted Answer · 2015-10-07 09:17:34Z

1

Use this as you are deleting the row if delete_registration is set. You need to set/check it for each row and delete that particular row.

<?php foreach($results as $value){
    echo "<tr>";
    echo "<td class='posts column-posts'>".$value->id."</td>";
    echo "<td class='email column-email'>".$value->email."</td>";
    echo "<td class='description column-description'><div id='col-container'>".$value->details."</div></td>";
    $delRow = "delete_registration_{$value->id}";
    echo "<td class='posts column-posts'><input type='submit' name= $delRow value='delete'/></td>";
    echo "</tr>";
     if(isset($_POST[$delRow])){
        $wpdb->delete( 'conference_register', array( 'id' => $value->id ) );
    }

}

edited Oct 7, 2015 at 9:17

answered Oct 7, 2015 at 9:08

jitendrapurohit

9,7032 gold badges31 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

Prabin Parajuli Over a year ago

wait I'll give it a try.

Prabin Parajuli Over a year ago

nothing is happening now. The page just gets reloaded but a row not deleted.

jitendrapurohit Over a year ago

are you having a delete button for each row ? Also check the updated answer.

Prabin Parajuli Over a year ago

Yes.. you can see the screenshot here awesomescreenshot.com/image/639957/…

jitendrapurohit Over a year ago

Let us continue this discussion in chat.

|

malfoj · Accepted Answer · 2015-10-07 09:15:24Z

0

You are not passing the id or the database query syntax is not okay

answered Oct 7, 2015 at 9:15

malfoj

1

1 Comment

Prabin Parajuli Over a year ago

Query syntax is fine, just cannot delete the single row.

test123123 · Accepted Answer · 2015-10-07 11:38:38Z

0

Use this:

 echo "<td class='posts column-posts'><input type='submit' name= 'delete_registration_{$value->id}' value='delete'/></td>";
 echo "</tr>";
  if(isset($_POST[delete_registration_{$value->id}])){
    $wpdb->delete( 'conference_register', array( 'id' => $value->id ) );
 }

This should work

answered Oct 7, 2015 at 11:38

test123123

1

Comments

bluepinto · Accepted Answer · 2015-10-07 11:53:00Z

0

How I do this is in each row I have a hidden input field and have default value = "x". When user changes any field I use javascript to change the value to "e" and if user clicks "delete" I change the value to "d" and submit the form.

On Submit I use a switch . Loop through all records, if e - edit, d-delete.

answered Oct 7, 2015 at 11:53

bluepinto

16510 bronze badges

Collectives™ on Stack Overflow

Delete a single db row after clicking delete button

4 Answers 4

9 Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

9 Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related