Select Lists into MYSQL
Posted on
16th Feb 2014 07:03 pm by
admin
Hello All, I am new to PHP @ 1 week. So borrowing code anywhere I can. I am making progress, but hit a snag.
I have 2 list boxes, that I use to move items left to right. When I click submit I want to load the items selected into MySQL. Is anyone able to help please? I can do the insert into MySQL (i think), but i cant work out how to get the values into a variable that PHP can use to submit.
Then to make it more complicated, once I have it working for 1 list, I ideally wany about 10 lists on the page (with only 1 submit box). I am lost.
Thanks
greg
Code: This is my OPTION.js file
var selectedList;
var availableList;
function createListObjects(){
availableList = document.getElementById("availableOptions");
selectedList = document.getElementById("selectedOptions");
}
function delAttribute(){
var selIndex = selectedList.selectedIndex;
if(selIndex < 0)
return;
availableList.appendChild(selectedList.options.item(selIndex))
selectNone(selectedList,availableList);
setSize(availableList,selectedList);
}
function addAttribute(){
var addIndex = availableList.selectedIndex;
if(addIndex < 0)
return;
selectedList.appendChild(availableList.options.item(addIndex));
selectNone(selectedList,availableList);
setSize(selectedList,availableList);
}
function delAll(){
var len = selectedList.length -1;
for(i=len; i>=0; i--){
availableList.appendChild(selectedList.item(i));
}
selectNone(selectedList,availableList);
setSize(selectedList,availableList);
}
function addAll(){
var len = availableList.length -1;
for(i=len; i>=0; i--){
selectedList.appendChild(availableList.item(i));
}
selectNone(selectedList,availableList);
setSize(selectedList,availableList);
}
function selectNone(list1,list2){
list1.selectedIndex = -1;
list2.selectedIndex = -1;
addIndex = -1;
selIndex = -1;
}
function setSize(list1,list2){
list1.size = getSize(list1);
list2.size = getSize(list2);
}
function getSize(list){
/* Mozilla ignores whitespace, IE doesn't - count the elements in the list */
var len = list.childNodes.length;
var nsLen = 0;
//nodeType returns 1 for elements
for(i=0; i<len; i++){
if(list.childNodes.item(i).nodeType==1)
nsLen++;
}
if(nsLen<2)
return 2;
else
return nsLen;
}
function showSelected(){
var optionList = document.getElementById("selectedOptions").options;
var data = '';
var len = optionList.length;
for(i=0; i<len; i++){
if(i>0)
data += ',';
data += optionList.item(i).value;
}
alert(data);
}
Code: This is my edit.php file
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html>
<head>
<title>Test</title>
<script type="text/javascript" src="option.js"></script>
</head>
<body onload="createListObjects()">
<?php
echo" <select name="selectedOptions[]" id="selectedOptions" multiple="true"> "; //start the select box
echo "<option value="1">Cat</option>n"; //and place it in the select
echo "<option value="2">Dog</option>n"; //and place it in the select
echo "</select>"; //close the select
?>
<button onclick="addAttribute()"><</button>
<button onclick="addAll()"><<<</button>
<button onclick="delAttribute()">></button>
<button onclick="delAll()">>>></button> </td>
<?php
echo" <select name="availableOptions" id="availableOptions" multiple="true"> "; //start the select box
echo "<option value="3">pig</option>n"; //and place it in the select
echo "</select>"; //close the select
?>
<tr>
<td colspan="2"><button
onclick="showSelected()">
Submit</button> </td>
</tr>
</body>
</html>
Code: <html><body>
<?php
$data = $_POST['selectedoptions'];
I AM LOST HERE
echo "Data Inserted!";
?>
</body></html>
No comments posted yet
Your Answer:
Login to answer
161 
9 
Other forums
Access website from only 1 computer...?
One of my customers wants his website to only be accessed by people in which they bought the website
Email Form Syntax Issue
I need the TO: in email to display To: CEO instead of To: abc@mail.com
How to alter the scri
PHP Login
Hey!
I got this shopcart code online, am trying to modify it but am getting an error when i try a
Web Host List
Here is a list of web hosts that offer PHP and MySQL. It is no where near a full list, but it is mos
How do I give a developer access to a specific directory and nothing else?
I want to give a develop access to a specific directory and nothing else
I can give them an F
MII Trends - add data onto chart object
Hello,
Can anyone please provide some thoughts on my current requirement:
its pretty
UPLOAD IMAGES NOT WORKING!
Hi there i have a upload script in which it uploads the picture to a folder than creates two thumbna
Help: calling function
Hi,
Is it possible to call a php function on page close?
If yes, could you explain how and whe
sapgui f4 help last search
I know this has to be simople. One user (maybe more) does not have the "last search saved" from the
The IE or FF detector
Hello Friends,
Problem of today ( we seek for php help ) as following ,
we know all th
