Help With Some Code

[swifttide]

Hi everyone!

I have a process script that looks like this:

include_once "ez_sql.php";

$clear = $POST['clear'];
reset($clear);
echo('Student ID -> ' . $POST['id'] . '<br><br>');
echo "key clear is key($clear)";
foreach($clear as $clr)
{
if($clr==1)
{
$query = "DELETE FROM student_schedule WHERE
student_schedule_studentid=" . $_POST['id'] . " AND
student_schedule_schedid=". key($clear) .";";
echo($query."<br><br>");
$db->query($query);

I don't understand $_POST['clear'] and reset($clear). I intuit that this is an array. How would I echo out what the values of the array are (since the script is not working)? I tried echo "key clear is key$(clear)" but that isn't working. As you can see, we are trying to delete a record based on 2 fields.

Thanks.

[devinemke]

i have no idea what your form looks like but consider this example:

<?php
if (!isset($_POST['submit']))
{
  echo '
  <form action="" method="POST">
  id: <input type="text" name="id"><br>
	<input type="checkbox" name="clear[]" value="1">1<br>
	<input type="checkbox" name="clear[]" value="2">2<br>
	<input type="checkbox" name="clear[]" value="3">3<br>
	<input type="checkbox" name="clear[]" value="4">4<br>
	<input type="checkbox" name="clear[]" value="5">5<br>
	<input type="submit" name="submit" value="clear">
  </form>
  ';
}
else
{
  if ($_POST['id'] && isset($_POST['clear']))
	{
  	$sql = 'DELETE FROM student_schedule WHERE student_schedule_studentid = ' . $_POST['id'] . ' AND student_schedule_schedid IN(' . implode(',', $_POST['clear']) . ')';
  	echo $sql;
	}	
}
?>

[swifttide]

Hmmm.....I think I am seeing the light! That is a little clearer!
Thanks!

No one should probably get as deep into PHP as I have, with zero understanding of arrays. Time to hit my PHP Basics book tonight!