Getting a form post checkbox variable from a mysql database outside a while loop on another page

Question

I have read through this and this post, which looks to be the most similar, but it has not solved my problem.

I have the below while loop working to display results from my database. The specific line of question in the while loop is this (note: it is within a form):

while($row = mysqli_fetch_array($result)){
<input type='checkbox' name='check_box_delete[]' value='".$row['BookingNo']."'>
}

The rest of the form data passes through fine except for the checkboxes. In the following php page, I have this:

if(isset($_POST['check_box_delete'])){
    foreach($_POST['check_box_delete'] as $id){
        $sql="DELETE FROM bookings WHERE BookingNo='".$id."'";
        if (!mysqli_query($con,$sql)){
            die('Error: ' . mysqli_error($con));
        }
    echo $id." deleted.";
}

The page echos deleted but no associated $id. I suspect my processor.php is not getting the booking number at all.

Paul Denisevich · Accepted Answer · 2013-09-30 03:14:08Z

0

When it says "Record successfully deleted" it only means that there are some checkboxes have been checked.

Use mysqli_affected_rows() function to determine if you deleted something. It will show you the situation.

answered Sep 30, 2013 at 3:14

Paul Denisevich

2,41216 silver badges19 bronze badges

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

1 Comment

jsc Over a year ago

The "Record successfully deleted" means that the code is going to the right spot (I've edited OP for clarification) sorry. I've added echo mysqli_affected_rows() under the echo "Record..." but nothing is printing

Konsole · Accepted Answer · 2013-09-30 03:39:01Z

0

Change num to $num in your delete query and try again.

$sql="DELETE FROM bookings WHERE BookingNo=".num; //here should be $num

answered Sep 30, 2013 at 3:39

Konsole

3,4753 gold badges31 silver badges41 bronze badges

8 Comments

jsc Over a year ago

Wow I can't believe I missed that; thanks. Fixed but still not working sorry.

Konsole Over a year ago

Try changing your query to this "DELETE FROM bookings WHERE BookingNo='$num'"; (Put backtick in table name) And Record successfully deleted will be always displayed because you are just echoing it without checking if the record is actually deleted or not.

jsc Over a year ago

Do you mean this: else{ $sql="DELETE FROM bookings WHERE BookingNo='$num'"; $result=mysqli_query($sql); } That's what I now have but still nothing

Konsole Over a year ago

What i meant was to wrap your table name with backticks (`).

jsc Over a year ago

Right, nope, still nothing sorry. The query is working fine, I'm sure, the problem lies with getting the correct $booking id from the form

|

Collectives™ on Stack Overflow

Getting a form post checkbox variable from a mysql database outside a while loop on another page

2 Answers 2

1 Comment

8 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

8 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related