sending arrays via php to mysql

283Banfil

I'm stumped. I've been at this for days!! Huh
I'm trying to pass an array via checkboxes, using php and mysql. I have the following 2 pages, can someone please tell me what I've got wrong. I can pass the array to the second page, and have it echo(print) correctly, but when it gets to the database, it will only give me the last choice. I also can get it to post "array" to the database, but I don't want that either!!

Insert form:

<?php 
echo "<form method=post action='form3.php'>";
echo "<table border='0' cellspacing='0' style='border-collapse: collapse' width='100' >
<tr bgcolor='#ffffff'>
<td width='25%'><input type=checkbox name=providers[] value='BlueCross BlueShield'></td>
<td width='25%'>&nbsp;BlueCross BlueShield</td>
<td width='25%'><input type=checkbox name=providers[] value='HealthPartners'></td>
<td width='25%'>&nbsp;HealthPartners</td>
<td width='25%'><input type=checkbox name=providers[] value='PreferredOne'></td>
<td width='25%'>&nbsp;PreferredOne</td>
</tr> 
<tr><td colspan =6 align=center><input type=submit value=Select></form></td></tr>
</table>"; ?>

Results Action page

<?php
$providers=$_POST['providers'];
while (list ($key,$val) = @each ($providers)) {
echo "$val,\n";
$mysql="INSERT INTO oe.hsa SET
    providers='$val'";} 
if (@mysql_query($mysql)) {
echo 'New Registration added';
} else {
echo mysql_error();
}
?>

bpat1434

Your insert syntax is incorrect for mysql. You're mixing INSERT and UPDATE syntax. It should be:

INSERT INTO {tablename} ({column})
VALUES ('{value}')

So your query would look something like:

$mysql = "INSERT INTO `oe`.`hsa` (provider)
VALUES ('{$val}')";

Alternatively, you can do this in one MySQL call (because it's MySQL):

$providers = $_POST['providers'];
$values = "('";
$values .= implode("'), ('", $providers);
$values .= "')";

$mysql = "INSERT INTO `oe`.`hsa` (provider)
VALUES {$values}";

That would create a query like:

INSERT INTO `oe`.`hsa` (provider)
VALUES ('BlueCross BlueShield'), ('PreferredOne'), ('HealthPartners')

which would create 3 new rows.

Hope that helps.

283Banfil

I finally did figure this out, late last night! I think I have different code, but it seems to work. I'm going to try it your way also, and see which seems smoother. THANK YOU so much for looking at this. I've been frustrated way too long!

<?php 
foreach($_POST['providers'] as $val) {
$providers .= "$val\n";
$mysql="INSERT INTO oe.hsaTest SET
	providers='$providers'";}	
if (mysql_query($mysql)) {
echo 'New Registration added';
} else {
echo mysql_error();
}
?>