asked on

insert multiple list box values into MySQL Database using PHP

I can't figure out what is wrong with this code. It inserts all fields EXCEPT the which_state field. I've added the brackets [] after the select name, to make it an array, but it's not working. Thank you!

form field:
<select name="which_state[]" id="which_state[]" size="10" multiple="multiple" class="formMenufield_Medium" tabindex="5">
<option value="Colorado">Colorado</option>
<option value="Florida">Florida</option>
<option value="Illinois">Illinois</option>
<option value="Michigan">Michigan</option>
<option value="Minnesota">Minnesota</option>
<option value="Ohio">Ohio</option>
<option value="Texas">Texas</option>
<option value="Wisconsin">Wisconsin</option>
</select>

insert script:
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "SSContact_Sharp_Default")) {
$insertSQL = sprintf("INSERT INTO emails (email, phone, full_name, which_state) VALUES (%s, %s, %s, %s)",
GetSQLValueString($_POST['Email_Address'], "text"),
GetSQLValueString($_POST['phone'], "text"),
GetSQLValueString($_POST['Full_Name'], "text"),
GetSQLValueString($_POST['which_state[]'], "text"));

mysql_select_db($database_allanb, $allanb);
$Result1 = mysql_query($insertSQL, $allanb) or die(mysql_error());

SOLUTION

Jagadishwor Dulal

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Jagadishwor Dulal

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Sandy Sailer

ASKER

I can get the selections to output as an array ... it just won't write the values to the database.

I changed my select statement to this: <select name="which_state[]" id="which_state" size="10" multiple="multiple" class="formMenufield_Medium" tabindex="5">

Actually, the code above is only outputting the first item selected in the list.

Sandy Sailer

ASKER

I can get the array to output doing the following:

if (isset($_POST['which_state'])) {
$ws = $_POST['which_state'];
foreach ($ws as $wch)
{
echo 'which states '.$wch;
}
}

Then, if I change the insert script to this,

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "SSContact_Sharp_Default")) {
$insertSQL = sprintf("INSERT INTO emails (email, phone, full_name, which_state) VALUES (%s, %s, %s, %s)",
GetSQLValueString($_POST['Email_Address'], "text"),
GetSQLValueString($_POST['phone'], "text"),
GetSQLValueString($_POST['Full_Name'], "text"),
GetSQLValueString($wch, "text"));

I would think that it would insert the array in the which_state field. It does not. Although, now it enters ONE of the states from the list, but not all of them.

I know I'm close, but I just can't figure it out.

Jagadishwor Dulal

That's why I am showing you example of foreach loop above for values:

$which_state= $_POST['which_state'];
	foreach($which_state as $ws){
	 echo $ws."<br/>";
	}

Open in new window

change it to your method

Sandy Sailer

ASKER

Finally - I got it to work!

GetSQLValueString(implode(',', $_POST['which_state']), "text"));

ASKER CERTIFIED SOLUTION

Dave Baldwin

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Sandy Sailer

ASKER

Actually, I got it working - see my post above. In the insert script, I used GetSQLValueString(implode...

Sandy Sailer

ASKER

resolved it mostly myself.