Deleteing Multiple Records Using Checkboxes

bizzaire

Hey this is my first time posting here and i need some help i have got a forum wot i made and its quite good but i am using text links to delete the posts/topics/areas and i want to use checkboxes instead so i can delete multiple posts. This would also help with other areas on my site such as admin. I would be VERY grateful for anyone that replys to try and help cause i really want to kno how to do it

Thanks 🙂

// Bizzaire

_0_05_

well, what i would do, would be to put all the checkboxes in an array (when you define their name, make them all the same) and end them with the "[]"
eg.

  

<input type="checkbox" name="name[]" value="value">

now, once it has been submitted, loop through the array, and delete the applicable fields.

bizzaire

Originally posted by $0.05$
now, once it has been submitted, loop through the array, and delete the applicable fields. [/B]

how would i do that? thanks for helping but i knew that part i dont know how 2 do the array part though 🙁

bizzaire

common some1 please help ... i really need it

diego25

What exactly don't you know how to do? If you made a forum, I'm sure you know how to use a foreach loop to loop through the array...so I don't know what you mean by the "array part".

Diego

bizzaire

well i dont use array's much to loop my areas i use this code:

$area_query = mysql_query("SELECT * FROM areas");
while ($area = mysql_fetch_array($area_query)) {

or is that an array? i dunno, but is i did add checkboxes to the end and named them all the same and then used this query would it work?

mysql_query("DELETE FROM areas WHERE (ID='$id[]')");

or would i use a different code?

thanks 🙂

diego25

It'd have to be this:

foreach ($id as $i) {
mysql_query("DELETE FROM areas WHERE (ID='$i')");
}

Of course, that will make n queries for n checked checkboxes...so you can improve that by using an OR statement, e.g.

DELETE FROM areas WHERE ID=1 Or ID=2 OR ID=5

but I'll leave that implementation to you.

Diego

P.S.: should there be single quotes around the ID field? If it's an ID number, it shouldn't have quotes...

bizzaire

i still dont get wot u mean? would i ahve 2 take my code out or not?

if i used wot name would i put 4 the checkboxes and would i still end them with [] and do i put a value or not?

please explain in a bit more detail

[remember i have never used "foreach" command so i kno nothing about it, but u probally think i am a right dumbass]

Cheers 🙂

diego25

Ok, so maybe this will help you understand better:

for ($i=0; $i<count($id); $i++) {
mysql_query("DELETE FROM areas WHERE (ID='$id[$i]')");
}

You should read about foreach loops in the manual...they come in hand in frequently.

Diego

lostcarpark

I could be mistaken, but I think the basic problem is you haven't learned how to use Arrays.

An array is a set of values stored in a single variable. Each element in the array has an index which allows it to be referenced. For example:

vals[0]="foo";
vals[1]="bar";

I suggest reading the section in the PHP manual on arrays:
http://www.php.net/manual/sv/language.types.array.php

Hope this helps,

James