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()">&lt;</button>
<button onclick="addAll()">&lt;&lt;&lt;</button>
<button onclick="delAttribute()">&gt;</button>
<button onclick="delAll()">&gt;&gt;&gt;</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 Like 9 Dislike
Previous forums Next forums
Other forums

mysql UPDATE request not working and driving me crazy!!!
Hi,

I have been stuck on this for ages.

Quite simply I am trying to update my database

This is driving me nuts!
This insert query looks to be alright, however I get this error:

QuoteYou have an error in yo

Having Problem with Date
l have a submit buttom where user have the possibility to add a date to specify when his message s

Not Inserting into DB
I can't get my Add new Division form to submit to the database. Anyone see my issue?

Code: &a

PHP hyperlinks generator
Hi

I need some help to get this done using php:


1 - I have few hyperlinks say 500

Socket programming
Hello all,

I have a PHP socket script. GPS trackers connect to this socket. IMEI verification

Undefined variable: adHTML
Hello:

While checking my site error logs, I've noticed one repetitive error that fills the lo

2 things: enter doesn't work in IE & empty form
i have this search form that works well except for 2 things.

1) on IE when i hit enter instea

Phase Error I can't seem to find :(`
Hey guys, I can seem to find my phase error on this. I am getting this error

[error]
Pars

URL Rewrite issue
Im created a series of Rewrites and on page checks to make sure the correct url is being called. But

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash