[Resolved] Arrays and multiple inserts

[lmayer4]

Afternoon,

I have a form that needs to enter mutiple values into one field, I know how to do it using a simple insert statement but I was advised to do it dynamically as shown below.

The problem is doing this dynamically doesn't bring this multiple selection field over it brings the word Array. Any thoughts or points in the right direction would be appreciated.

Thanks --Laura

The field looks like this:

<select name="CitrixApps[]" multiple>
<option>TRACCS</option>
<option>TMS2000</option>
<option>CARDS</option>
<option>CALM</option>
<option>MP2</option>
<option>TINA</option>
<option>TASK TRACCS</option>
<option>TRANSMAN</option>
</select>

---

//insert page//

//get the values from the Citrix field
$CA=$_POST['CitrixApps'];
for ($i=0; $i<count($CA); $i++){
$CitrixApps = $CitrixApps.",".$CA[$i];
}

echo $CitrixApps;

$host = "HQMSITADMIN01";
$database = "Security";
$table = " tblHolding";

function db_insert($tablename){
global $host;
global $database;

mssql_connect($host) or die("Cannot connect to the database.<br>");
mssql_select_db($database) or die("Cannot select the database.<br>");

$query = "INSERT INTO ".$tablename." SET ";

foreach($_POST as $field => $value){
if($field != "Submit"){
$fields[]=$field;
$values[]=$value;

}

}

$query = "INSERT INTO ".$tablename." (".implode(",",$fields).") VALUES('".implode("','",$values)."')";

echo $query."\n";

$result = mssql_query($query) or die("Cannot run query!");

return $result;
}

$dbinsert = db_insert($table);

echo $dbinsert;
?>

[devinemke]

if you are simply trying to turn the $POST['CitrixApps'] array into a comma separated list then use [man]implode[/man]:

// just for testing
$_POST['CitrixApps'][0] = 'TRACCS';
$_POST['CitrixApps'][1] = 'TMS2000';
$_POST['CitrixApps'][2] = 'CARDS';

$CitrixApps = implode(',', $_POST['CitrixApps']);
echo $CitrixApps; // outputs TRACCS,TMS2000,CARDS 

[lmayer4]

Thanks for that. That did it.

Laura

[lmayer4]

Okay I jumped before I looked 🙂 yes, the implode gives me the results I want but I still can't get anything but the word array into the table. Echoing citrixapps comes out right but not the insert itself.

Since there are 6 of these in one form I need to figure this out...

I would greatly appreciate any help.

Thanks

Laura

[devinemke]

let's back up a sec. you have a select box in a form that allows multiple selections. are these multiple selections all going into a single field in your database table (as a comma separated list) or is each one going into separate fields? what exactly is the data structure of your table?

[lmayer4]

Sorry,

Multiple entries into one field. I've almost got it. This is what it inserts now:

Array,TRACCS,TMS2000,CARDS,CALM

into the field CitrixApps

I tried messing about with the statement:

$CA=$_POST['CitrixApps'];
for ($i=0; $i<count($CA); $i++){
$CitrixApps = $CitrixApps.",".$CA[$i];
}

but I keep screwing it up. I need the word Array to go away....

[devinemke]

Originally posted by lmayer4
I tried messing about with the statement:

$CA=$_POST['CitrixApps'];
for ($i=0; $i<count($CA); $i++){
$CitrixApps = $CitrixApps.",".$CA[$i];
}

you don't need this for loop at all. simply use [man]implode[/man] (as per my previous post).

[lmayer4]

Okay I'm stumped, how come it works now? Weirdness. Oh well murphy has been messing with me for days, I'm starting to get used to it.

Thanks-- now I'm really fixed 🙂 Honest.

Laura