So I have a list of fonts on my website this have checkbox's to delete them... but I'm a little lost in how you would run the loop to delete them from a MySQL table

This is how I see it, you click Delete with 2 checkbox's ticked, this is grabbed by the delete page by using $_POST[ID] right but how do you use a foreach loop?

foreach($_POST['ID'] as $ID){

// some code

DB::query("DELETE FROM fonts WHERE ID='$_POST[ID][$ID]'");

}

Am I close to being correct, or am I going in completely the wrong direction?

You can't use an array in double quotes like that.

PHP Code:

foreach($_POST['ID'] as $ID){

// some code

DB::query("DELETE FROM fonts WHERE ID='".$_POST['ID'][$ID]."'");

} 


Thanks for the reply.

I tried running it and I get this error.

Warning: Invalid argument supplied for foreach()

Which is on the line of the foreach()

Fixed, it was due to my checkbox's having the same name.

To save some time, you should know that when you have a multi-dimensional array (like $_POST is), you can loop over it like this:

PHP Code:

foreach($_POST as $key=>$value) {
echo $key;//the name of the associative array.
echo $value;//the name of the value associated with it.
} 


This is especially useful when the indexes are associative (as opposed to numerical). I use this type of loop a lot when patching together quick mail functions.

Note: you CAN use multidimensional arrays in strings if you delimit them correctly.

PHP Code:

DB::query("DELETE FROM fonts WHERE ID='{$_POST[ID][$ID]}'"); 


Pay attention to curly brackets. From version 5.0 if I am not mistaken you can even call class methods inline:

PHP Code:

DB::query("DELETE FROM fonts WHERE ID='{$object->method()}'"); 


Some brill info their guys, thanks its much appreciated, I shall have another look over it.

Also you can typecast a var to an array to avoid potential problems:

PHP Code:

foreach ((array)$_POST['ID'] AS $ID) . . .