Back To Programming / Scripting / Coding Forum

Multiple choice text menus

  • 283banfil
  • Newbie
  • Newbie
  • No Avatar
  • Joined: Sep 10, 2009
  • Posts: 6
  • Status: Offline

Post September 10th, 2009, 2:20 pm

I'm stumped. I've tried everything on web that I can find. I have a multiple choice list menu that when I click submit, it only submits the last choice. I can choose all 3 options and it only chooses the last. PLEASE HELP!!
My code is below. Thanks so much. I'm so frustrated, and I'm sure it's an easy fix. I've also just tried pulling the options from a mysql database, and can pull the options fine, it's that I can't have multiple deploy to my database.
Code: [ Select ]

<head>
</head>

<body>
<form id="form1" name="form1" method="POST" action="/data/oe/hsa/form.php?">
 
<label>Providers
<select name="providers[]" size="4" multiple="TRUE" id="providers">
 <option value="Select">Select up to two options</option>
  <option value="1">BlueCross BlueShield</option>
  <option value="2">HealthPartners</option>

  <option value="3">PreferredOne</option>
 </select>
</label>
<p>
 <label>Submit
  <input type="submit" name="submit" id="submit" value="Submit" />
  </label>
  <br />
 
<input type="hidden" name="MM_insert" value="form1" />
</form>

</body>
</html>
  2. <head>
  3. </head>
  5. <body>
  6. <form id="form1" name="form1" method="POST" action="/data/oe/hsa/form.php?">
  7.  
  8. <label>Providers
  9. <select name="providers[]" size="4" multiple="TRUE" id="providers">
  10.  <option value="Select">Select up to two options</option>
  11.   <option value="1">BlueCross BlueShield</option>
  12.   <option value="2">HealthPartners</option>
  14.   <option value="3">PreferredOne</option>
  15.  </select>
  16. </label>
  17. <p>
  18.  <label>Submit
  19.   <input type="submit" name="submit" id="submit" value="Submit" />
  20.   </label>
  21.   <br />
  22.  
  23. <input type="hidden" name="MM_insert" value="form1" />
  24. </form>
  26. </body>
  27. </html>
  • Anonymous
  • Bot
  • No Avatar
  • Joined: 25 Feb 2008
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post September 10th, 2009, 2:20 pm

  • UPSGuy
  • Lurker ಠ_ಠ
  • Web Master
  • User avatar
  • Joined: Jul 25, 2005
  • Posts: 2735
  • Loc: Nashville, TN
  • Status: Offline

Post September 10th, 2009, 2:38 pm

You're going to receive an array on the server side. How are you processing the params (what leads you to believe you only get the last result)? Could we see the snippet of your processing code?
I'd love to change the world, but they won't give me the source code.
  • 283banfil
  • Newbie
  • Newbie
  • No Avatar
  • Joined: Sep 10, 2009
  • Posts: 6
  • Status: Offline

Post September 11th, 2009, 4:48 am

Actually I am getting an array, my mistake. I'm getting the word 'array' in my mysql database!! What do you mean my processing parameters? I'm fairly new to this. Obviously I'm missing something!! Some other code that I wrote was processing last choice, this is processing the word 'array'.
This is code that should do same thing, but is the code that throws only last option. It's pulling choices out of a database, obviously.

<select name="providers[]" size="4" multiple="TRUE" id="providers">
<option value="Select">Select up to two options</option>
<?php
do {
?>
<option value="<?php echo $row_providers['autoId']?>"><?php echo $row_providers['provider']?></option>
<?php
} while ($row_providers = mysql_fetch_assoc($providers));
$rows = mysql_num_rows($providers);
if($rows > 0) {
mysql_data_seek($providers, 0);
$row_providers = mysql_fetch_assoc($providers);
}
?>
</select>
  • UPSGuy
  • Lurker ಠ_ಠ
  • Web Master
  • User avatar
  • Joined: Jul 25, 2005
  • Posts: 2735
  • Loc: Nashville, TN
  • Status: Offline

Post September 11th, 2009, 5:17 am

That means you're receiving all your options on the other side. I'm assuming PHP, but if you're using another language, I can probably help with that, too. Try something like this in your code:

Code: [ Select ]
$providerArr = $_POST['providers'];
foreach ($providerArr as $provider) {
   echo $provider."<br>\n";
}
  1. $providerArr = $_POST['providers'];
  2. foreach ($providerArr as $provider) {
  3.    echo $provider."<br>\n";
  4. }
I'd love to change the world, but they won't give me the source code.
  • 283banfil
  • Newbie
  • Newbie
  • No Avatar
  • Joined: Sep 10, 2009
  • Posts: 6
  • Status: Offline

Post September 11th, 2009, 5:51 am

So, this is my complete code, minus the other input fields. What looks wrong? I've added you php code, and yes, I am using php, and have been trying to come up with this code, I knew I had to have something else to call the array to the database. Thanks for that help, but still frustrated. I'm sorry!! I'm working with Dreaweaver 9, and it won't let me map my provider[] array to the database. It wants me to remove the [] array? Also, not sure I have the script you provided calling in correct area. Most of this code isn't needed by you, but I put it all in, in case I'm in error somewhere else.
Code: [ Select ]
<?php require_once('../../../Connections/oe.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
 $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

 $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

 switch ($theType) {
  case "text":
   $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
   break;  
  case "long":
  case "int":
   $theValue = ($theValue != "") ? intval($theValue) : "NULL";
   break;
  case "double":
   $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
   break;
  case "date":
   $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
   break;
  case "defined":
   $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
   break;
 }
 return $theValue;
}
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
 $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
 $insertSQL = sprintf("INSERT INTO hsa (firstName, lastName, agency, hrContact, providers, schedule) VALUES (%s, %s, %s, %s, %s, %s)",
            GetSQLValueString($_POST['firstName'], "text"),
            GetSQLValueString($_POST['lastName'], "text"),
            GetSQLValueString($_POST['agency'], "text"),
            GetSQLValueString($_POST['hrContact'], "text"),
            GetSQLValueString($_POST['providers[]'], "text"),
            GetSQLValueString($_POST['schedule'], "text"));

 mysql_select_db($database_oe, $oe);
 $Result1 = mysql_query($insertSQL, $oe) or die(mysql_error());
}

mysql_select_db($database_oe, $oe);
$query_hsa = "SELECT * FROM hsa";
$hsa = mysql_query($query_hsa, $oe) or die(mysql_error());
$row_hsa = mysql_fetch_assoc($hsa);
$totalRows_hsa = mysql_num_rows($hsa);

mysql_select_db($database_oe, $oe);
$query_providers = "SELECT * FROM providers ORDER BY provider ASC";
$providers = mysql_query($query_providers, $oe) or die(mysql_error());
$row_providers = mysql_fetch_assoc($providers);
$totalRows_providers = mysql_num_rows($providers);
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "external link it won't let me post with">
<html xmlns="external link it won't let me post with">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<form id="form1" name="form1" method="POST" action="<?php echo $editFormAction; ?>">
 <label></label>
 <br />
<br />
<label>Providers
<select name="providers[]" size="4" multiple="multiple" id="providers">
<option value="Select">Select up to two options</option>
 <option value="1">BlueCross BlueShield</option>
 <option value="2">HealthPartners</option>
 <option value="3">PreferredOne</option>
 <?php $providerArr = $_POST['providers'];
foreach ($providerArr as $provider) {
  echo $provider."<br>\n";
}?>
</select>
</label>


<p>
 <label>Submit
  <input type="submit" name="submit" id="submit" value="Submit" />
  </label>
  <br />
 
<input type="hidden" name="MM_insert" value="form1" />
</form>
</body>
</html>

<?php
mysql_free_result($hsa);

mysql_free_result($providers);
?>
  1. <?php require_once('../../../Connections/oe.php'); ?>
  2. <?php
  3. if (!function_exists("GetSQLValueString")) {
  4. function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
  5. {
  6.  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  8.  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
  10.  switch ($theType) {
  11.   case "text":
  12.    $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
  13.    break;  
  14.   case "long":
  15.   case "int":
  16.    $theValue = ($theValue != "") ? intval($theValue) : "NULL";
  17.    break;
  18.   case "double":
  19.    $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
  20.    break;
  21.   case "date":
  22.    $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
  23.    break;
  24.   case "defined":
  25.    $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
  26.    break;
  27.  }
  28.  return $theValue;
  29. }
  30. }
  32. $editFormAction = $_SERVER['PHP_SELF'];
  33. if (isset($_SERVER['QUERY_STRING'])) {
  34.  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
  35. }
  37. if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
  38.  $insertSQL = sprintf("INSERT INTO hsa (firstName, lastName, agency, hrContact, providers, schedule) VALUES (%s, %s, %s, %s, %s, %s)",
  39.             GetSQLValueString($_POST['firstName'], "text"),
  40.             GetSQLValueString($_POST['lastName'], "text"),
  41.             GetSQLValueString($_POST['agency'], "text"),
  42.             GetSQLValueString($_POST['hrContact'], "text"),
  43.             GetSQLValueString($_POST['providers[]'], "text"),
  44.             GetSQLValueString($_POST['schedule'], "text"));
  46.  mysql_select_db($database_oe, $oe);
  47.  $Result1 = mysql_query($insertSQL, $oe) or die(mysql_error());
  48. }
  50. mysql_select_db($database_oe, $oe);
  51. $query_hsa = "SELECT * FROM hsa";
  52. $hsa = mysql_query($query_hsa, $oe) or die(mysql_error());
  53. $row_hsa = mysql_fetch_assoc($hsa);
  54. $totalRows_hsa = mysql_num_rows($hsa);
  56. mysql_select_db($database_oe, $oe);
  57. $query_providers = "SELECT * FROM providers ORDER BY provider ASC";
  58. $providers = mysql_query($query_providers, $oe) or die(mysql_error());
  59. $row_providers = mysql_fetch_assoc($providers);
  60. $totalRows_providers = mysql_num_rows($providers);
  61. ?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "external link it won't let me post with">
  62. <html xmlns="external link it won't let me post with">
  63. <head>
  64. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  65. <title>Untitled Document</title>
  66. </head>
  68. <body>
  69. <form id="form1" name="form1" method="POST" action="<?php echo $editFormAction; ?>">
  70.  <label></label>
  71.  <br />
  72. <br />
  73. <label>Providers
  74. <select name="providers[]" size="4" multiple="multiple" id="providers">
  75. <option value="Select">Select up to two options</option>
  76.  <option value="1">BlueCross BlueShield</option>
  77.  <option value="2">HealthPartners</option>
  78.  <option value="3">PreferredOne</option>
  79.  <?php $providerArr = $_POST['providers'];
  80. foreach ($providerArr as $provider) {
  81.   echo $provider."<br>\n";
  82. }?>
  83. </select>
  84. </label>
  87. <p>
  88.  <label>Submit
  89.   <input type="submit" name="submit" id="submit" value="Submit" />
  90.   </label>
  91.   <br />
  92.  
  93. <input type="hidden" name="MM_insert" value="form1" />
  94. </form>
  95. </body>
  96. </html>
  98. <?php
  99. mysql_free_result($hsa);
  101. mysql_free_result($providers);
  102. ?>
  • 283banfil
  • Newbie
  • Newbie
  • No Avatar
  • Joined: Sep 10, 2009
  • Posts: 6
  • Status: Offline

Post September 11th, 2009, 5:59 am

If you can get me to figure this out, I'll buy you a beer next time you're in Minnesota.
  • UPSGuy
  • Lurker ಠ_ಠ
  • Web Master
  • User avatar
  • Joined: Jul 25, 2005
  • Posts: 2735
  • Loc: Nashville, TN
  • Status: Offline

Post September 11th, 2009, 7:03 am

Are you trying to store the selected options to the database or are you wanting to pull the select options from the database?

You're a bit scrambled up on the code. If you can clarify the purpose, then we can help straighten you out I think. ;)
I'd love to change the world, but they won't give me the source code.
  • 283banfil
  • Newbie
  • Newbie
  • No Avatar
  • Joined: Sep 10, 2009
  • Posts: 6
  • Status: Offline

Post September 11th, 2009, 8:06 am

Trying to pass it TO the database!
  • UPSGuy
  • Lurker ಠ_ಠ
  • Web Master
  • User avatar
  • Joined: Jul 25, 2005
  • Posts: 2735
  • Loc: Nashville, TN
  • Status: Offline

Post September 11th, 2009, 10:11 am

Okie doke. You need to separate your coding then. Your flow should be a form that submits to a php file (the form action), which takes the REQUEST vars, builds an insert query, and then inserts into a table. Try something like this or this (the latter shows serializing arrays in case you want to go that route).
I'd love to change the world, but they won't give me the source code.
  • 283banfil
  • Newbie
  • Newbie
  • No Avatar
  • Joined: Sep 10, 2009
  • Posts: 6
  • Status: Offline

Post September 11th, 2009, 10:29 am

That looks perfect. Thanks a ton!!
  • UPSGuy
  • Lurker ಠ_ಠ
  • Web Master
  • User avatar
  • Joined: Jul 25, 2005
  • Posts: 2735
  • Loc: Nashville, TN
  • Status: Offline

Post September 14th, 2009, 8:09 am

If you're still having trouble with this, please resume the conversation here rather than starting a duplicate thread. Please post your updated code and give us a new explanation of the issue and we'll have a look. Thanks.
I'd love to change the world, but they won't give me the source code.

Page 1 of 1

Post Information

  • Total Posts in this topic: 11 posts
  • Users browsing this forum: No registered users and 222 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
cron
 

© 2011 Unmelted, LLC. Ozzu® is a registered trademark of Unmelted, LLC.