[Resolved] multiple arrays to a db in one insert statment

[scambro]

Sorry if this question has already been asked, but I couldn't find it in the search...

I have a submitting form that has a bunch of check boxes, and a text box for sequences next to them. I want to insert into this one table, the values of the check boxes, and their sequences. I can do the one array with the check boxes without a problem:

foreach ($_POST['checkbox_array'] as $value)
{
$sql = "INSERT INTO
	table3
	(table1_id,table2_id,sequence,active_ind)		VALUES				('$table1_id','$value','10','1')";
$results = mysql_query($sql) or die(mysql_error());
}

So that works without a problem, but how can I also include my second array that holds the sequence ($_POST['sequence_array'])?

Thanks!

[devinemke]

Originally posted by scambro
...but how can I also include my second array that holds the sequence ($_POST['sequence_array'])?

the same way you did with the checkboxes, but the key difference is that unchecked checkboxes are not returned to the form handler whereas empty textboxes will, so you probably will want to run a check to see if there is actually anything in those textboxes before doing your db insert.

[liquorvicar]

try this:

foreach ($_POST['checkbox_array'] as $key=>$value)
{
$sql = "INSERT INTO
    table3
    (table1_id,table2_id,sequence,active_ind)        VALUES
                ('$table1_id','$value','{$_POST['sequence_array'][$key]}','1')";
$results = mysql_query($sql) or die(mysql_error());
}

and as devinemke you'll want to do some checking in there probably.

[scambro]

Thanks to the both of you for the help. I had noticed that when I did a print_r on the sequence array I had a lot more elements. Here's what I did:

$checkbox_seq = array_filter($_POST['sequence_array']);
foreach ($checkbox_seq as $value)
{
	$checkbox_seq_sort[] = $value;
}
foreach ($_POST[checkbox_array] as $key=>$value)
{
	$sql = "INSERT INTO
		table3
	(table1_id,table2_id,sequence,active_ind)
		VALUES
	('$table1_id','$value','{$checkbox_seq_sort[$key]}','1')";

echo "<!-".$sql."->";
$results = mysql_query($sql) or die(mysql_error());
}

Let me know if you think there's a more efficient way to "renumber" and strip out the empty elements. Thanks!

[devinemke]

from your code:

$checkbox_seq = array_filter($_POST['sequence_array']);

this does not do anything since you are not passing a callback function as the second argument

foreach ($checkbox_seq as $value) 
{ 
    $checkbox_seq_sort[] = $value; 
} 

this does not really do anhthing either. it's simply makes a copy of $checkbox_seq as $checkbox_seq_sort which could just as easily be done by doing:

$checkbox_seq_sort = $checkbox_seq; 

[scambro]

Yeah, but if I do:

$checkbox_sort_seq = array_filer($_POST['checkbox_seq'];
print_r($checkbox_sort_seq);

I get this:
Array ( [0] => 10 [5] => 20 [10] => 30 )

What I want to get is:
Array ( [0] => 10 [1] => 20 [2] => 30 )

So I thought I had to "recreate" the array to get the array element numbers to be in order to then use in:

'{$checkbox_seq_sort[$key]}'

Thanks for looking this over!

[devinemke]

Originally posted by scambro
I get this:
Array ( [0] => 10 [5] => 20 [10] => 30 )

What I want to get is:
Array ( [0] => 10 [1] => 20 [2] => 30 )

you could acheive the same thing by using [man]sort[/man]