Multiple Selects and Form Submissions

[lmayer4]

Morning,

I found this great link:http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=1622&lngWId=8

Its works like a dream except for one little peice. I have about 5 multiple selects on my form. It keeps insert them as the word "Array"

One of the fields is like this:

<select name="ADGroups[]" size="1" multiple>
<option></option>
<option value="Dataview">Dataview</option>
<option value="Intellitrader">Intellitrader</option>
<option value="Crystal Reporting">Crystal Reporting</option>
<option value="Hyperion">Hyperion</option>
<option value="Kronos">Kronos</option>
<option value="Workbrain">Workbrain</option>
</select>

This is the class to insert the records:

class dbinsert{
var $i;
var $n;
var $fld;
var $val;

function gotcha($arr, $table){
$this->i = 0;

foreach($arr as $key => $value){
if($key != 'Submit'){
$this->fld[$this->i] = $key;
$this->val[$this->i] = "\"$value\"";
}
else{
break;
}

$this->i++;

}

$this->insert($table, $this->fld, $this->val);

}

function insert($table, $fld, $val){
$query = "INSERT INTO $table (%s) VALUES (%s)";
$query = sprintf($query, implode(",", $fld), implode(",", $val));
$result = mssql_query($query) or die;
}

}

My question is how do I make it recognize the array?

Thanks

Laura

[bpat1434]

$ADGroups = $_REQUEST['ADGroups'];

~Brett

[lmayer4]

Thanks Brett, but where would I put it in this class? Keeps bombing out...

[bpat1434]

You would have to retrieve the values prior to looping through the $var so that you get your info in there.

~Brett

[lmayer4]

Well this is what I've tried:

//1st try get the values from the Citrix field
$ADGroups = implode(',', $_POST['ADGroups']);

foreach($arr as $key => $value){
  if($key != 'Submit'){
      $this->fld[$this->i] = $key;
      $this->val[$this->i] = "\"$value\"";
    }

//2nd try get the values from the Citrix field
$ADGroups = $REQUEST['ADGroups'];

foreach($arr as $key => $value){
  if($key != 'Submit'){
      $this->fld[$this->i] = $key;
      $this->val[$this->i] = "\"$value\"";
    }

And still all I get is "Array". I am very confused.....Any thoughts would be apreciated.

Laura

[bpat1434]

I'm not an OOP phper, so I'm not sure what it is you're trying to do. If it were straight PHP, it would look something like:

<?php
$ad = $_REQUEST['ADGroups'];

// See the format of the variable
echo $ad

// Explode into an array based on separator [I'm using ","]
$ad = explode(",", $ad);


$query = "SELECT * FROM `TABLES` WHERE ";
// For each $ad[], then append the mySQL statement

for($i; $i<=count($ad); $i++){
    $query .= "FIELD_NAME = '".$ad[$i]."'";
}

// Run the query...
// Results to array...
// Display as you want.
?>

~Brett

[lmayer4]

Thanks for the help Brett I'll give it a shot