[Resolved] Problem with list menu where I can select multiple records?

[fransi]

I am having a problem with a list menu where I can select
multiple records with a repeat region from a MySQL database.

It works fine when I select 1 record, but when I select 2 or more
records I only get one shown on the next page.
Like: id "1" selected
id "2" selected
id "3" selected and when I submit I only get id"3" to show up.

Here is the code:

Page1
$sql = "SELECT id, haed, gerd, lengd, stk FROM lagerstada ORDER BY id ASC";
$sql_result = mysql_query($sql) or die (mysql_error());
if (!$sql_result) {
echo "Something has gone wrong!";
} else {
echo "

		<FORM method=\"POST\" action=\"syna_innskra.php\">
		<div id=\"option1\">
		<select  name=\"sel_record\" size=\"30\" multiple=\"multiple\">
		<option value=\"\"> -- Veldu hér -- </option>";
		while ($row = mysql_fetch_array($sql_result)) {
				$id = $row["id"];
				$haed = $row["haed"];
				$gerd = $row["gerd"];
				$lengd = $row["lengd"];

				echo "<option  value=\"$id\">$haed -- $gerd -- $lengd</option>";
		}
		echo "
		</select>
		<INPUT id=\"afram1\" type=\"submit\" value=\"áfram\">
		</div>
		</FORM>";
	}

Page2
$sql = "SELECT * FROM lagerstada WHERE id = '$_POST[sel_record]'";
$sql_result = mysql_query($sql) or die (mysql_error());
if (!$sql_result) {
echo "Something has gone wrong!";
} else {

		while ($record = mysql_fetch_array($sql_result)) {
			$id = $record['id'];
			$haed = stripslashes($record['haed']);
			$gerd = stripslashes($record['gerd']);
			$lengd = stripslashes($record['lengd']);
			$stk = stripslashes($record['stk']);

		}
   		echo "
		<div id=\"skrainn\">
		<FORM method=\"POST\" action=\"lagerstada.php\">
		<INPUT TYPE=\"hidden\" name=\"id\" value=\"$id\">
		<INPUT type=\"hidden\" name=\"haed\" value=\"$haed\" size=35 maxlength=60></p>
		<INPUT type=\"hidden\" name=\"gerd\" value=\"$gerd\" size=35 maxlength=60></p>
		<INPUT type=\"hidden\" name=\"lengd\" value=\"$lengd\" size=35 maxlength=60></p>
		<INPUT type=\"hidden\" name=\"stk\" value=\"$stk\" size=35 maxlength=60></p>

		<table  cellspacing=\"0\" cellpadding=\"0\">

<tr>
<td class=\"col2\" colspan=\"2\">Ger&eth;/Lengd</td>
<td class=\"lengd\">$lengd</td>
<td class=\"col1\">Reiknivél</td>
</tr>
<tr>
<td class=\"height2\">$haed</td>
<td class=\"gerd\">$gerd</td>
<td>$stk</td>
<td><input class=\"tablecell2\" name=\"jens\" type=\"text\" size=\"3\" /><input class=\"tablecell2\" type=\"text\" name=\"hildur\" size=\"3\" /><input class=\"tablecell2\" name=\"Submit\" type=\"button\" onclick=\"KW_calcForm('hildur',1,-1,'(','#stk','+','#jens',')');KW_calcForm('stk',1,-1,'(','#hildur',')')\" value=\"reikna\" /></td>
</tr>
</table>
<INPUT id=\"skrainnbutton\" type=\"submit\" value=\"skrá inn\">
</FORM>
</div>";

	}

?>

[drew010]

change
<select name=\"sel_record\" size=\"30\" multiple=\"multiple\">
to
<select name=\"sel_record[]\" size=\"30\" multiple=\"multiple\">

on the next page you will need to create new code to account for the $POST['sel_record'] being a 2d array. i.e. for each item selected you will have
$POST['sel_record'][0] = "first selected";
$POST['sel_record'][1] = "second selected";
$POST['sel_record'][2] = "third selected";
etc...

[fransi]

Thank you for your post!

I changed it to
<select name=\"sel_record[]\" size=\"30\" multiple=\"multiple\">

But I dont understand what you mean for the next page that I
have to change.

I am sorry I only started to learn php 2 weeks ago.

[drew010]

since that field becomes an array, the line
$sql = "SELECT FROM lagerstada WHERE id = '$_POST[sel_record]'";
would become
SELECT FROM lagerstada WHERE id = 'Array'

you would need to make some kind of loop to go over each field in the array and formulate a dynamic select statement. maybe something like this:

$where = "id = '{$_POST['sel_record'][0]}'";
for($i = 1; $i < sizeof($_POST['sel_record']); $i++) {
  $where .= " OR id = '{$_POST['sel_record'][$i]}'";
}

$sql = "SELECT * FROM lagerstada WHERE $where";

[fransi]

Thanks again for your post

I have tried your example and it is working, but not the way I
want to. Maybe I am to stupid to explain how I want it exactly.
Here is an link to the page where I use your example, wich works
fine for multiple selection.

http://www.icedesigners.com/steini2/skra_inn.php

and here is the link where everything works fine exept the multiple selection

http://www.icedesigners.com/steini3/skra_inn.php

thank you for your time

[kmunk]

You need to combine the new code with your previous so your page 2 will look like this:

$where = "id = '{$_POST['sel_record'][0]}'"; 
for($i = 1; $i < sizeof($_POST['sel_record']); $i++) { 
  $where .= " OR id = '{$_POST['sel_record'][$i]}'"; 
} 

$sql = "SELECT * FROM lagerstada WHERE $where";


$sql_result = mysql_query($sql) or die (mysql_error()); 
if (!$sql_result) { 
echo "Something has gone wrong!"; 
} else { 

echo "<div id=\"skrainn\"> 
<FORM method=\"POST\" action=\"lagerstada.php\"> 
<INPUT TYPE=\"hidden\" name=\"id\" value=\"$id\"> 
<INPUT type=\"hidden\" name=\"haed\" value=\"$haed\" size=35 maxlength=60></p> 
<INPUT type=\"hidden\" name=\"gerd\" value=\"$gerd\" size=35 maxlength=60></p> 
<INPUT type=\"hidden\" name=\"lengd\" value=\"$lengd\" size=35 maxlength=60></p> 
<INPUT type=\"hidden\" name=\"stk\" value=\"$stk\" size=35 maxlength=60></p> <table cellspacing=\"0\" cellpadding=\"0\"> ";


while ($record = mysql_fetch_array($sql_result)) { 
$id = $record['id']; 
$haed = stripslashes($record['haed']); 
$gerd = stripslashes($record['gerd']); 
$lengd = stripslashes($record['lengd']); 
$stk = stripslashes($record['stk']); 

echo " 


<tr> 
<td class=\"col2\" colspan=\"2\">Gerð/Lengd</td> 
<td class=\"lengd\">$lengd</td> 
<td class=\"col1\">Reiknivél</td> 
</tr> 
<tr> 
<td class=\"height2\">$haed</td> 
<td class=\"gerd\">$gerd</td> 
<td>$stk</td> 
<td><input class=\"tablecell2\" name=\"jens\" type=\"text\" size=\"3\" /><input class=\"tablecell2\" type=\"text\" name=\"hildur\" size=\"3\" /><input class=\"tablecell2\" name=\"Submit\" type=\"button\" onclick=\"KW_calcForm('hildur',1,- 1,'(','#stk','+','#jens',')');KW_calcForm('stk',1,
-1,'(','#hildur',')')\" value=\"reikna\" /></td> 
</tr> "; //you need one row for each selected value on previous page


} 

echo "</table> 
<INPUT id=\"skrainnbutton\" type=\"submit\" value=\"skrá inn\"> 
</FORM> 
</div>"; 



} 

you need to create a javascript that sets your hidden form fields to the correct values, when you click the button, eg.:

onclick=setValue($id, $head, $gerd, $lengd, $stk);

[fransi]

Thank you!

The multiple select works now as you can see here below.
http://www.icedesigners.com/steini2/skra_inn.php

But where do I have to use the Java Script onclick=setValue($id, $head, $gerd, $lengd, $stk); for the hidden fields.
Is it on page1 one or page2?

The calculator does not workin on page2 isn´t it because the values are empty?

I am sorry for the stupid questions I will need a few months to
get into php.

[kmunk]

You can do one of two things
either you can alter your calculation-function on page2 or you can put in following function and then call setValue($id, $head, $gerd, $lengd, $stk); before any of the other functions in your onClick-procedures in your form fields:

<input class=\"tablecell2\" type=\"text\" name=\"hildur\" size=\"3\" /><input class=\"tablecell2\" name=\"Submit\" type=\"button\" onclick=\"KW_calcForm('hildur',1,- 1,'(','#stk','+','#jens',')');KW_calcForm('stk',1,

-1,'(','#hildur',')')\" value=\"reikna\" />

function:

function setValue(id, head, gerd, lengd, stk){
id.value = id;
head.value = head;
gerd.value = gerd;
lengd.value = lengd;
stk.value = lengd;
}

I imagine that you use these variables from the hidden fields in your calculation-functions. But now you don't get any of the values since you send them to page2 as an array.

Thats why i dosn't work now.

[fransi]

Thank you for your help!

I am going to leave it as it is, where I can only select one.
My knowlegde is not good enough to figure this out.
Maybe after a few months I will bee able to do this.

I really appreciate your help

[kmunk]

If you put the above function within a <script > </script> in the beginning of your page 2 as html that is, and call the script from your onclikcs what happens then.

can you post an url so i can see it?
You a not that far off.

BTW this is an html issue not php

[fransi]

Thank for not giving up on me!

I have put the function you posted in <script > </script> on page2.
But do you want me to call the script with the calculate button?

Here is the example:
http://www.icedesigners.com/steini3/skra_inn.php

[kmunk]

Yep exactly - before calling the 2 other functions you call with the calculate-button you should call the function setValues with the variables as $id... etc

What the function does is to set values in your hidden field to be correct.
Before we altered the page, the values came from the values transfered with your post-variables. but now those variables are in an array, therefore you need to set the values for each insident.

[fransi]

I really dont know how to call the function setValues with the variables as $id... etc.
I am not good with Java Script either, just using the calculate
script from someone else.

Here is the code for page2:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link href="mytable.css" rel="stylesheet" type="text/css" />
</head>
<script language="JavaScript" type="text/JavaScript">
<!--
function setValue(id, head, gerd, lengd, stk){
id.value = id;
head.value = head;
gerd.value = gerd;
lengd.value = lengd;
stk.value = lengd;
}

function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers.document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function KW_getVal(o){ //v1.2
var retVal="0";if (o.type=="select-one")
{retVal=(o.selectedIndex==-1)?0o.options[o.selectedIndex].value;}
else if (o.length>1){for (var i=0;i<o.length;i++) if (o.checked) retVal=o.value;
} else if (o.type=="checkbox") {retVal=(o.checked)?o.value:0;} else {
retVal=Number(o.value)}return parseFloat(retVal);
}

function KW_calcForm() { //v1.2
var str="",a=KW_calcForm.arguments; for (var i=3;i<a.length;i++)
str+=(a.indexOf("#")==-1)?a:KW_getVal(MM_findObj(a.substring(1)));
t=Math.round(a[1]*eval(str))/a[1];tS=t.toString();if(a[2]>0){tSp=tS.indexOf(".");
if(tSp==-1) tS+=".";tSp=tS.indexOf(".");while(tSp!=(tS.length-1-a[2])){tS+="0";
tSp=tS.indexOf(".");}} MM_findObj(a[0]).value=tS;
}
//-->
</script>
</head>
<body>
<?

	// create connection
	$conn = mysql_connect("","","") or die(mysql_error());
	// select database
	$db = mysql_select_db("", $conn) or die(mysql_error());
	//SQL statement to select information
	$where = "id = '{$_POST['sel_record'][0]}'";  
    for($i = 1; $i < sizeof($_POST['sel_record']); $i++) {  
    $where .= " OR id = '{$_POST['sel_record'][$i]}'";  
    }  

    $sql = "SELECT * FROM lagerstada WHERE $where"; 


    $sql_result = mysql_query($sql) or die (mysql_error());  
    if (!$sql_result) {  
    echo "Something has gone wrong!";  
    } else {  

     echo "<div id=\"skrainn\"> 
   <FORM method=\"POST\" action=\"lagerstada.php\"> 
   <INPUT TYPE=\"hidden\" name=\"id\" value=\"$id\"> 
   <INPUT type=\"hidden\" name=\"haed\" value=\"$haed\" size=35 maxlength=60></p> 
   <INPUT type=\"hidden\" name=\"gerd\" value=\"$gerd\" size=35 maxlength=60></p> 
   <INPUT type=\"hidden\" name=\"lengd\" value=\"$lengd\" size=35 maxlength=60></p> 
   <INPUT type=\"hidden\" name=\"stk\" value=\"$stk\" size=35 maxlength=60></p> <table cellspacing=\"0\" cellpadding=\"0\"> "; 


   while ($record = mysql_fetch_array($sql_result)) {  
   $id = $record['id'];  
   $haed = stripslashes($record['haed']);  
   $gerd = stripslashes($record['gerd']);  
   $lengd = stripslashes($record['lengd']);  
   $stk = stripslashes($record['stk']);  

   echo "  

<tr>
<td class=\"col2\" colspan=\"2\">Gerð/Lengd</td>
<td class=\"lengd\">$lengd</td>
<td class=\"col1\">Reiknivél</td>
</tr>
<tr>
<td class=\"height2\">$haed</td>
<td class=\"gerd\">$gerd</td>
<td>$stk</td>
<td><input class=\"tablecell2\" name=\"jens\" type=\"text\" size=\"3\" /><input class=\"tablecell2\" type=\"text\" name=\"hildur\" size=\"3\" /><input class=\"tablecell2\" name=\"Submit\" type=\"button\" setValue($id, $head, $gerd, $lengd, $stk); onclick=\"KW_calcForm('hildur',1,- 1,'(','#stk','+','#jens',')');KW_calcForm('stk',1,-1,'(','#hildur',')')\" value=\"calculate\" /></td>
</tr> ";

}

echo "</table>
<INPUT id=\"skrainnbutton\" type=\"submit\" value=\"submit\">
</FORM>
</div>";

}
?>
</body>
</html>

[kmunk]

Put the call to the setValue after the onClick=\"
and concatenate the variables

like so:

<input class=\"tablecell2\" name=\"Submit\" type=\"button\"  onclick=\"setValue(".$id.", ".$head.", ".$gerd.", ".$lengd.", ".$stk."); KW_calcForm('hildur',1,- 1,'(','#stk','+','#jens',')');KW_calcForm('stk',1,
-1,'(','#hildur',')')\" value=\"calculate\" />

And be obs on errors.

You've made an error in the script inserted at top setValue-function:

the line stk.value = lengd should be stk.value = stk;

[fransi]

I have tried your example but its not working.
I also fixed the error in the function.

Here is the url
http://www.icedesigners.com/steini3/skra_inn.php

Is it because there is no value"" in the hidden fields?

[kmunk]

Try posting your page2

[fransi]

Here is page2

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link href="mytable.css" rel="stylesheet" type="text/css" />
</head>
<script language="JavaScript" type="text/JavaScript">
<!--
function setValue(id, haed, gerd, lengd, stk){
id.value = id;
haed.value = haed;
gerd.value = gerd;
lengd.value = lengd;
stk.value = stk;
}

function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers.document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function KW_getVal(o){ //v1.2
var retVal="0";if (o.type=="select-one")
{retVal=(o.selectedIndex==-1)?0:o.options[o.selectedIndex].value;}
else if (o.length>1){for (var i=0;i<o.length;i++) if (o.checked) retVal=o.value;
} else if (o.type=="checkbox") {retVal=(o.checked)?o.value:0;} else {
retVal=Number(o.value)}return parseFloat(retVal);
}

function KW_calcForm() { //v1.2
var str="",a=KW_calcForm.arguments; for (var i=3;i<a.length;i++)
str+=(a.indexOf("#")==-1)?a:KW_getVal(MM_findObj(a.substring(1)));
t=Math.round(a[1]*eval(str))/a[1];tS=t.toString();if(a[2]>0){tSp=tS.indexOf(".");
if(tSp==-1) tS+=".";tSp=tS.indexOf(".");while(tSp!=(tS.length-1-a[2])){tS+="0";
tSp=tS.indexOf(".");}} MM_findObj(a[0]).value=tS;
}
//-->
</script>
</head>
<body>
<?

	// create connection
	$conn = mysql_connect("","","") or die(mysql_error());
	// select database
	$db = mysql_select_db("", $conn) or die(mysql_error());
	//SQL statement to select information
	$where = "id = '{$_POST['sel_record'][0]}'";  
    for($i = 1; $i < sizeof($_POST['sel_record']); $i++) {  
    $where .= " OR id = '{$_POST['sel_record'][$i]}'";  
    }  

    $sql = "SELECT * FROM lagerstada WHERE $where"; 


    $sql_result = mysql_query($sql) or die (mysql_error());  
    if (!$sql_result) {  
    echo "Something has gone wrong!";  
    } else {  

     echo "<div id=\"skrainn\"> 
   <FORM method=\"POST\" action=\"lagerstada.php\"> 
   <INPUT TYPE=\"hidden\" name=\"id\" value=\"$id\"> 
   <INPUT type=\"hidden\" name=\"haed\" value=\"$haed\" size=35 maxlength=60></p> 
   <INPUT type=\"hidden\" name=\"gerd\" value=\"$gerd\" size=35 maxlength=60></p> 
   <INPUT type=\"hidden\" name=\"lengd\" value=\"$lengd\" size=35 maxlength=60></p> 
   <INPUT type=\"hidden\" name=\"stk\" value=\"$stk\" size=35 maxlength=60></p> <table cellspacing=\"0\" cellpadding=\"0\"> "; 


   while ($record = mysql_fetch_array($sql_result)) {  
   $id = $record['id'];  
   $haed = stripslashes($record['haed']);  
   $gerd = stripslashes($record['gerd']);  
   $lengd = stripslashes($record['lengd']);  
   $stk = stripslashes($record['stk']);  

   echo "  

<tr>
<td class=\"col2\" colspan=\"2\">Gerð/Lengd</td>
<td class=\"lengd\">$lengd</td>
<td class=\"col1\">Reiknivél</td>
</tr>
<tr>
<td class=\"height2\">$haed</td>
<td class=\"gerd\">$gerd</td>
<td>$stk</td>
<td><input class=\"tablecell2\" name=\"jens\" type=\"text\" size=\"3\" /><input class=\"tablecell2\" type=\"text\" name=\"hildur\" size=\"3\" /><input class=\"tablecell2\" name=\"Submit\" type=\"button\" onclick=\"setValue(\".$id.\", \".$haed.\", \".$gerd.\", \".$lengd.\", \".$stk.\"); KW_calcForm('hildur',1,- 1,'(','#stk','+','#jens',')');KW_calcForm('stk',1,-1,'(','#hildur',')')\" value=\"calculate\" />
</tr> ";

}

echo "</table>
<INPUT id=\"skrainnbutton\" type=\"submit\" value=\"submit\">
</FORM>
</div>";

}
?>
</body>
</html>

[kmunk]

setValue(\".$id.\", \".$haed.\", \".$gerd.\", \".$lengd.\", \".$stk.\");

You are not to escape these quotes !

make it:

setValue(".$id.", ".$haed.", ".$gerd.", ".$lengd.", ".$stk.");

[fransi]

I tried it but still not working?

[kmunk]

Ok lets give it another try

copy-paste this instead of the previous:

setValue('".$id."', '".$haed."', '".$gerd."', '".$lengd."', '".$stk."');

and lets see what happens