Insert an Array to a Database

[Anon]

Hi there,

I'm trying to pass an array from one form to another page.

in the Firstpage.html i have a form with a select box

<form name="source" action="Store.php">
<input type="text" name="field01">
<input type="text" name="field02">
<select multiple name="arraylist" size="4">
<option value=1>ITEM1
<option value=2>ITEM2
<option value=3>ITEM3
<option value=4>ITEM4
</select>
<input type="button" value="submit">

and in the next page i have a function to process the array so as to store all the array items in a table field.

How can i accomplish this?

I assume coding it this way if it were to work.

function store_array_to_DB($field01, $field02, $arraylist) {
if(isset($list2) {
$Array_quantity = count($list2);
for (i=0; i < $Array_quantity; i++) {

from this part onwards I'm lost
How do i store it to the dbase or even get each array element to be put in a SQL statement assuming that one element's insertion would be as below

INSERT INTO Numbers (field01, field02, ArrayItems) VALUES ('$field01', '$field02', '$ArrayItems')

should the insertion of an element be done one by one?

p.s. Field01 and field02 can have multiple entries.

Could someone show me the light?

[Anon]

should the insertion of an element be done >one by one?

Entirely correct. Each element in your form should correspond to a field in your database.

Instead of having a multiple SELECT statement as you have specified , use checkboxes instead with each potential value coresponding to an individual field. This will make it MUCH easier for you to extract data later on
e.g. "i want to know how many people like Fords AND Toyotas" or "i want to know how many people like Fords only"

Example code:
<input type="checkbox" name="option1" value="ford">Ford

<input type="checkbox" name="option2" value="toyota">Toyota

<input type="checkbox" name="option3" value="mercedes">Mercedes

in your ACTION php script, you would thus insert the values of $option1, $option2, and $option3 into 3 separate fields.

You could do a IF test to see if any of these values are empty (NULL) and thus set the field to a 'N' (no) values

if ($option1==NULL){
$option1='N'
}
else
{
$option1='Y'
}

Now, in order to extract data OUT of the database as an array using the mysql_fetch_array function
e.g.

$query="SELECT * FROM Numbers WHERE field01='Freddy' AND field02='Smith'";

$row=mysql_fetch_array(mysql_query($query));

echo $row[field01];
echo "<br>";
echo $row[field02];
echo "<br>";
echo $row[option1];
echo "<br>";
echo $row[option2];
echo "<br>";
echo $row[option3];
echo "<br>";

Of course, if your option fields are set to either Y or N based on the user's form input you could do something like this instead

if ($row[option]=='Y')
{
echo "Ford";
}

[Anon]

SORRY - TYPO!

if ($row[option]=='Y')
{
echo "Ford";
}

should read

if ($row[option1]=='Y')
{
echo "Ford";
}