Inserting arrays from a form into DB

[micmac]

Hi all,
If i have the following code within a form:

<?
for ($k=1; $k <= $_POST['range_count'] ; $k++){
?>                

				<tr>
                  <td><input name="stateName[]" type="text" value=""></td>
				  <td><input name="stateAbbrev[]" type="text" value="" size="12"></td>
				  <td><input name="stateTax[]" type="text" value="0" size="5">
                              %</td>
				  <td><input name="stateEnabled[]" type="checkbox" value="1"></td>
                </tr>
<?
}
?>

and i submit it to be inserted into the DB how do i get the arrays into the DB?

Cheers,
micmac

[beirti]

This depends on the db you are using: oracle, mysql, access, etc.

If you post your file where you have db actions and ill give you a sample script based on your code

[micmac]

Thanks for the reply beirti
I'm trying to insert the data into a mySQL DB.
This is what i currently trying but to no avail:

if ($_POST['upload_states']){
include ("db_conn_open.php");
for ($i=1; $i <= $_POST['range_count'] ; $i++){
$iSQL = "INSERT INTO states (countryID,stateName,stateAbbrev,stateTax,stateEnabled) VALUES (" . $_POST['countryID'] . "," . $_POST['stateName'][$i] . "," . $_POST['stateAbbrev'][$i] . "," . $_POST['stateTax'][$i] . "," . $_POST['stateEnabled'][$i] . ")";
$result = mysql_query($iSQL);
}
if ($result){
echo "Success";
} else {
echo "Nup!";
}

Thanks for your time.
micmac

[beirti]

Instead of using the post loop in your form to store the data, try storing it in a normal array and then passing that to your dbScript. I have come across hassle when trying to use $POST so I stick to pure arrays whenever possible. If you still want to stick with the post, I have a simple script that I found on a website that converts the $POST variable to a normal variable. See attachment

[micmac]

Thanks for your time beirti, your file was most helpful.

Cheers,
micmac

[tekky]

Originally posted by beirti
Instead of using the post loop in your form to store the data, try storing it in a normal array and then passing that to your dbScript. I have come across hassle when trying to use $POST so I stick to pure arrays whenever possible. If you still want to stick with the post, I have a simple script that I found on a website that converts the $POST variable to a normal variable. See attachment

That file seems like overkill for most applications... I dont quite understand how the 2nd half of it, with 'arrays' is meant to work... when do you pass arrays on forms?

I generally just use
while(list($key, $val) = each($_POST)) { $$key = $val; }

never had any difficulties from that...