2
Hi there, I need serious help. Ive got a project that needs some unique select box function.
OK THERE IS A LOT OF Code but If you Crack it youll get the credit.
just mail me at info@malachite.de with your Info you wold like posted
My issue:
1. I've got two select boxes, of wich one gets filled with MYSQL Data.. Works great...
2. A Javascript sends the selected items (Values) to select box two.. Works great..
3. Now I would like to write the following values into a database table BUT! not as comma delimited, as single entries.
Theory: A user selects a number of links(URL's) that he would like to be listed under
After writing the urls to his account, his url will be displayed on the selected domains.
Select box 1 >> Select box 2
----------------------------------------------------
Record1 | Record1 - -|
Record2 | Record2 | >> Write to database
Record3 | Record4 |
Record4 | --|
Record5 |
------------------------------------------------------
The solution will be rewarded with a: Code contibuted by "YOURNAME "..online ont the web site
Here is the working code for the 2 select boxes and data connection:
<html>
<head>
<title>Move List</title>
<SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript">
<!--
function MoveOption(objSourceElement, objTargetElement)
{
var aryTempSourceOptions = new Array();
var x = 0;
//looping through source element to find selected options
for (var i = 0; i < objSourceElement.length; i++) {
if (objSourceElement.options.selected) {
//need to move this option to target element
var intTargetLen = objTargetElement.length++;
objTargetElement.options[intTargetLen].text = objSourceElement.options.text;
objTargetElement.options[intTargetLen].value = objSourceElement.options.value;
}
else {
//storing options that stay to recreate select element
var objTempValues = new Object();
objTempValues.text = objSourceElement.options.text;
objTempValues.value = objSourceElement.options.value;
aryTempSourceOptions[x] = objTempValues;
x++;
}
}
//resetting length of source
objSourceElement.length = aryTempSourceOptions.length;
//looping through temp array to recreate source select element
for (var i = 0; i < aryTempSourceOptions.length; i++) {
objSourceElement.options.text = aryTempSourceOptions.text;
objSourceElement.options.value = aryTempSourceOptions.value;
objSourceElement.options.selected = false;
}
}
//-->
</SCRIPT>
</head>
<body>
<table width="64" border="0" cellspacing="1" cellpadding="1" bgcolor="#000066">
<tr>
<td>
<div style="position:relative;width:404px;height:437px; background-color:#fff;-adbe-g:p;">
<div style="position:absolute;top:32px;left:0px;width:3 36px;height:384px;background-color:#fff;-adbe-c:c">
<form action="dbwriterres.php" method ="post" name="MoveList">
<table>
<tr>
<td align="center"><font face="Arial,Helvetica,sans-serif" size="2"><b>Verfugbare<br />
Links</b></font></td>
<td>
<p></p>
</td>
<td align="center"><font face="Arial,Helvetica,sans-serif" size="2"><b>Selektierte Links</b></font></td>
</tr>
<tr>
<td><select name="Enabled" size="18" multiple="multiple" style="width: 150px;">
<?php
$db_host4 = "my_db";
$db_user4 = "password";
$db_pwd4 = "";
$db_name4 = "dbname";
mysql_connect($db_host4, $db_user4, $db_pwd4);
mysql_select_db($db_name4);
$sql = "SELECT * FROM geostorm.url_main where scontent not like 255 ";
$query = mysql_query($sql);
do { ?>
<option selected value="<?php echo $row['url']?>"><?php echo $row['url']?></option><?php } while ($row = mysql_fetch_assoc($query));
$row = mysql_num_rows($query);
if($row > 0) {
mysql_data_seek($query, 0);
$row = mysql_fetch_array($query);
}
?>
</select></td>
<td><input type="button" name="Disable" value=">> " style="width: 80px;" onclick="MoveOption(this.form.Enabled, this.form.Disabled)" /><br />
<br />
<input type="button" name="Enable" value=" <<" style="width: 80px;" onclick="MoveOption(this.form.Disabled, this.form.Enabled)" /><br />
</td>
<td><select name="Disabled" size="18" multiple="multiple" style="width: 150px;"></select></td>
</tr>
</table>
<input type="submit" name="submitButtonName" value="Write to Customer">
</form>
</div>
<div style="position:absolute;top:0px;left:40px;width:3 20px;height:32px;-adbe-c:c">
<div align="center">
<font face="Arial,Helvetica,sans-serif"><b>Server Link Swap</b></font></div>
</div>
<div style="position:absolute;top:416px;left:0px;width: 400px;height:20px;-adbe-c:c">
<div align="center">
Version: V12.0</div>
</div>
</div>
</td>
</tr>
</table>
</body>
</html>
Ps Feel free to use this code as you like!
Kind Regards
Malachite A.K.A Lazy Larry
