Help with Submitting an Array to MySQL

[schmelding]

Here's my code (greatly simplified):

Below is n number of table rows. Each row represents one record to be inserted (the $requests[] already work perfectly):

<tr>
	<td>
		<input type="checkbox" name="approve[$requests['edit_id']]" value="$requests['edit_id]" />
		<input type="hidden" name="pid[$requests['edit_pid']]" value="$requests['edit_pid]" />
		<input type="hidden" name="cc[$requests['edit_cc']]" value="$requests['edit_cc]" />
		<input type="hidden" name="tag_id[$requests['edit_tag_id']]" value="$requests['edit_tag_id]" />
		<input type="hidden" name="type[$requests['edit_type']]" value="$requests['edit_type]" />
		<input type="hidden" name="requestor[$requests['edit_requestor']]" value="$requests['edit_requestor]" />
		<input type="hidden" name="text[$requests['edit_text']]" value="$requests['edit_text]" />
		<input type="hidden" name="urgent[$requests['edit_urgent']]" value="$requests['edit_urgent]" />
	</td>
	<td>More Table Cells, blah blah blah</td>
</tr>

Below is the post code to insert in the database, but it doesn't work. I don't get any results and would very much like to know why:

<?
if(isset($_POST['approve'])){
	foreach($_POST['approve'] as $appval) {
		$cleantext = stripslashes($_POST['text']);
		$approveReqs = "INSERT INTO `db_table` (`pid`,`cc`,`tag_id`,`type`,`requestor`,`text`,`urgent`,`approval`,`updated_p`) VALUES (NULL,'$_POST[cc]','$_POST[tag_id]','$_POST[type]','$_POST[requestor]','$cleantext','$_POST[urgent]','1',NOW())";

	mysql_query($approveReqs,$conn);//yes, "$conn" is set properly and works with other queries
}
}
?>

I'd appreciate any help you can provide. Thanks in advance!

[rincewind456]

You should be using [man]mysql_real_escape_string()[/man], [man]stripslashes()[/man] does not clean your text.

You don't say how it doesn't work, have you tried echoing out each $approveReqs to see if a valid query is being created?

Have you used [man]print_r()[/man] like

echo '<pre>';
print_r($_POST);
echo '</pre>';

to see if your POST values are being set?

[schmelding]

Thanks for the mysql_real_escape_string() tip!

Below is the output using print_r() as you suggested. The data is being posted, but as an array instead of strings per row. Hmm.

Array
(
    [approve_selected] => Approve Selected Items
    [approve] => Array
        (
            [0] => 29
        )

[pid] => Array
    (
        [0] => 0
        [181] => 181
    )

[cc] => Array
    (
        [bbcqc] => bbcqc
    )

[tag_id] => Array
    (
        [1] => 1
        [3] => 3
    )

[type] => Array
    (
        [0] => 0
    )

[requestor] => Array
    (
        [1] => 1
    )

[text] => Array
    (
        [This is new] => This is new
        [There are those who believe that life here began out there, far across the universe, with tribes of humans] => There are those who believe that life here began out there, far across the universe, with tribes of humans
        [I just changed this.] => I just changed this.
    )

[urgent] => Array
    (
        [0] => 0
        [1] => 1
    )

)

Now what? 🙂

[rincewind456]

Now you find out why you're only passing one piece of data for some fields (cc, type, requestor) and 2 pieces for others, because if your going to use a foreach loop then you need consistent data, or some method of dealing with inconsistent data., if you echo out $approveReqs like

foreach($_POST['approve'] as $appval) {

$approveReqs = "INSERT INTO `db_table` (`pid`,`cc`,`tag_id`,`type`,`requestor`,`text`,`urgent`,`approval`,`updated_p`) VALUES (NULL,'$_POST[cc]','$_POST[tag_id]','$_POST[type]','$_POST[requestor]','$cleantext','$_POST[urgent]','1',NOW())";
echo $approveReqs.'<br>'; /*the <br> is so you can see each query on a seperate line*/
mysql_query($approveReqs,$conn);//yes, "$conn" is set properly and works with other queries
}

you'll see what I mean.

[schmelding]

Erg. I'm getting nada:

INSERT INTO `db_table` (`pid`,`cc`,`tag_id`,`type`,`requestor`,`text`,`urgent`,`approval`,`updated_p`) VALUES (NULL,[B]'','','','','',''[/B],'1',NOW())

[schmelding]

Cancel request. I figured the "non-kludgy" was of doing it. 🙂 THANKS!