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
Appending GET data with form submition
Okay, what I'm trying to do is to use a form to append an already existing GET data string.
I
form class help (oop php5)
Hidy Ho Neighbors,
I'm forcing myself to learn oop/classes for php5. It seems like a good id
Help with captcha script needed
Hello,
I am working on a script where reCAPTCHA or a similar form of CAPTCHA will be used, f
Handling text changed in text box control using Ajax
I need to create a web form with a text box control. When someone types text into the textbox I nee
undefined offset help
Hi All,
I kept getting undefined offset PHP notice for a simple for loop. For eg
$va = arr
The repetition structure: the while statement not working
New programming student, have assignment as follows:
A restaurant has 4 lunch combos for custom
upload image name with extension using php
hi frds..
<input id="file1" type="file" name="file[]" &a
Sessions Value Not Saved
Hi,
Im making a login form and im using this code:
Code: if($login=="true"){
Dynamic links in an include file
I am working on a small piece of code that counts records from a database and displays the result to
downloading a file as HTML
Hi.
I'm rather confused with forcing a download. I just want to save dynamic content (from $_SESS
