Hi,
I am after creating a javascript menu swapper ( basically a multiple select form object) within my form and I want to enter it into my MySQL database but it won't go. I have tried creating the menu on the left hand side as an array but it won't work at all. This is the code that I am using:
<html>
<head>
<title>addsoftwareimage</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<SCRIPT LANGUAGE="JavaScript">
<!-- Begin
function move(fbox, tbox) {
var arrFbox = new Array();
var arrTbox = new Array();
var arrLookup = new Array();
var i;
for (i = 0; i < tbox.options.length; i++) {
arrLookup[tbox.options.text] = tbox.options.value;
arrTbox = tbox.options.text;
}
var fLength = 0;
var tLength = arrTbox.length;
for(i = 0; i < fbox.options.length; i++) {
arrLookup[fbox.options.text] = fbox.options.value;
if (fbox.options.selected && fbox.options.value != "") {
arrTbox[tLength] = fbox.options.text;
tLength++;
}
else {
arrFbox[fLength] = fbox.options.text;
fLength++;
}
}
arrFbox.sort();
arrTbox.sort();
fbox.length = 0;
tbox.length = 0;
var c;
for(c = 0; c < arrFbox.length; c++) {
var no = new Option();
no.value = arrLookup[arrFbox[c]];
no.text = arrFbox[c];
fbox[c] = no;
}
for(c = 0; c < arrTbox.length; c++) {
var no = new Option();
no.value = arrLookup[arrTbox[c]];
no.text = arrTbox[c];
tbox[c] = no;
}
}
// End -->
</script>
</head>
<body bgcolor="#FFFFFF" text="#000000">
<?php
if (!empty($POST['SoftwareName2[]'])) {
$db = mysql_connect("localhost", "admin", "");
mysql_select_db("itlab", $db);
$sql = "insert into softwareimages (Software_ID) VALUES ('".$POST['SoftwareName2[]']."')";
$result = mysql_query($sql);
echo "Form processed<br>";
echo $sql;
$software_values = $HTTP_GET_VARS['SoftwareName2[]'];
for
($i = 0; $i < sizeof($software_values); $i++) {
echo $software_values[$i];
echo "<br />";
}
}
else
{ $db = mysql_connect("localhost", "admin", "");
mysql_select_db("itlab", $db);
$sql = "select Software_ID, Software_Name from software";
$result = mysql_query($sql);
?>
<p> </p>
<p><span id=tick2> </span> <span id=tick2> </span>
</p>
<form method="POST" action="addsoftwareiamge.php" name="SoftwareImage">
<p>
<input type="hidden" name="BackURL" value="http://lspg462081/itlab2/html/template.asp/UserRegForm.php">
</p>
<p align="center">
<input type="hidden" name="To" value="david.dowling3@spcorp.com">
<b><font face="Verdana, Arial, Helvetica, sans-serif" size="+5" color="#990000"><font size="6"><font size="5">-
Add Software To Image - </font></font> </font></b> </p>
<p>
<input type="hidden" name="Subject" value="Computer Information">
</p>
<p align="center">
<input type="hidden" name="From" value="ddowling@bismail.ucc.ie">
<font color="#FF0000">* <i><font size="2" color="#333333">Denotes A Mandatory
Field </font></i></font></p>
<p align="left"> </p>
<div align="center"></div>
<div align="right">
<table width="870" border="0" cellspacing="8" name="regform" height="323" align="left">
<!--DWLayoutTable-->
<tr>
<td width="40" height="189"></td>
<td width="54"></td>
<td width="119" valign="top">
<div align="left">
<p><font size="+2"><b><font size="3" color="#FF0000">*</font><font size="3" color="#333333">Software</font></b></font></p>
<p>
<?php
echo '<select multiple name="SoftwareName" size="10">';
while ($myrow = mysql_fetch_array($result))
{
echo "<option value=".$myrow[Software_ID]." >".$myrow[Software_Name]."</option>";
}
echo "</select>";
?>
</p>
</div>
</td>
<td width="263" valign="top">
<div align="center">
<p> </p>
<p> </p>
<p>
<input name="button2" type="button" onClick="move(this.form.SoftwareName,this.form.SoftwareName2[])" value="Add Software To Image>>">
</p>
<p>
<input name="button" type="button" onClick="move(this.form.SoftwareName2[],this.form.SoftwareName)" value="<< Remove Software From Image">
</p>
</div>
</td>
<td colspan="3" rowspan="4" valign="top"> <p><font size="+2"><b><font size="3" color="#333333">Software</font></b></font> <font color="#333333" size="3"><b>On
Image</b></font>
<p>
<select multiple size="10" name="SoftwareName2[]" style="width:150">
</select>
</p> <p align="center"> </p> <p align="center"> </p> <p align="center"><b><font size="+2"><b>
</b></font></b>
</p> <p> </p> <p> </p>
</td>
<td width="166"></td>
</tr>
<tr>
<td colspan="2" rowspan="4" valign="top">
<div align="left"><font size="+2"><font size="4"><b></b></font></font></div>
</td>
<td height="13"></td>
<td rowspan="2" valign="top">
<div align="left">
<p><b></b></p>
<p align="center"> </p>
<p align="center">
<input type="submit" name="Submit" value="Submit Image">
</p>
<p align="center"> </p>
<p align="center"> </p>
</div>
</td>
<td></td>
</tr>
<tr>
<td rowspan="3" valign="top"><p> </p>
<p> </p>
<p> </p> </td>
<td height="164"></td>
</tr>
<tr>
<td rowspan="3" valign="top"><p align="center">
</p>
<p align="center">
</p>
</td>
<td height="6"></td>
</tr>
<tr>
<td width="120" height="21"></td>
<td width="9"></td>
<td width="11"></td>
<td></td>
</tr>
<tr>
<td height="45"> </td>
<td> </td>
<td> </td>
<td rowspan="2" valign="top">
<div align="center"><b><font size="+2"><b>
</b></font></b></div>
</td>
<td rowspan="2" valign="top"><!--DWLayoutEmptyCell--> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td height="35"> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td height="367"> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
</div>
<p align="center"> </p>
<p> </p>
<p> </p>
<p align="center"> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
</form>
<?php
} //end else
?>
<p> </p>
<p> </p>
