Announcement

**piz** · Feb 17, 2004, 05:26 AM

Re: onSelect, display proper fields in textbox

I perform a search and want to display the results in a listbox or another window,...

well... listbox or another window?

...on select of each item in my list, I want to change/populate the correspondant fields...

With PHP this can not be done without reloading the page with JavaScript, unless
you store all the data of the results in JavaScript Variables (arrays, for exaple) and then you can display the contents on selecting an item.

**j-iN-uK** · Feb 17, 2004, 05:35 AM

Hi,

Yes, I accept with php/javascript, I need to reload the page.
I can do that by:
if(isset($_POST['search'])){
SearchClick(Field1,Field2);
}

function SearchClick(){
$sql = "select Field1,Field2 from Table where Field1 like '%london%'";
$result = mysql_query($sql);
}

In my results, how do I change the data, depending on what I select from my results.

**sad69** · Feb 17, 2004, 04:50 PM

j-iN-uK,

You need to be more specific. What data are you trying to display?

This is what I'm gathering: you've got a list-box (is it multiselect?), based on the selection, you refresh the page using javscript onChange event, and you query the database with the selection.

So what EXACTLY do you want to display? Where?

Sadiq.

**j-iN-uK** · Feb 18, 2004, 08:23 AM

Hi,

This is what I'm trying 2 do, there's 2 things which are not working :
Please find my code below:
Onchange of the SchoolName, then that school details must display onchange.
It displays, but when I change it, it adds into the list instead of displaying the data only.adds

The other problem I'm having is, I wanna display my results in a text box & not a select box.

<HTML>
<title>Dynamic List Boxes in PHP</title>

<BODY>
<?PHP

//connect to the database

mysql_connect("localhost","adri","") or die("server error");
@mysql_select_db("links_db") or die("database error");

//declare the form

echo "<FORM name=f1 action=['PHP_SELF'] method=post>";

//read the database
$sql = "select Name, Street, Address, Town, PostCode from Table where Name like '%london%'";
$result = mysql_query($sql);

//write the table

echo "<CENTER><BR><B>Test</B><BR>";
echo "<TABLE font style='font-family: verdana; font-size: 12; font-weight:700' border=1>";

echo "<TR><TD valign=\"center\">Name</TD><TD><SELECT NAME=\"LstSchoolName\" SIZE=\"10\" ONCHANGE=\"Schoolselected(this);\" >\n";

// write the entry code for the javascript...
// \n is used to force a new line so the resultant code is more readable

$sJavaScript = "function Schoolselected(elem)
{\n for (var i = document.f1.PCode.options.length; i >= 0; i--)
{ \n document.f1.PCode.options[i] = null;\n";

// loop through the database..

$SName="";
while ( $row = mysql_fetch_array($result) )
{
// is this a new School?

If ($SName!=$row["SchoolName"]){

// if yes, add the entry to the SChool's listbox

$SName = $row["SchoolName"];
echo "\n<OPTION VALUE='".$row["SchoolName"]."'>".$SName."</OPTION>";

// and add a new section to the javascript...

$sJavaScript = $sJavaScript."}\n"."if (elem.options[elem.selectedIndex].value=='".$row["SchoolName"]."'){\n";
}

$sJavaScript = $sJavaScript."document.f1.PCode.options[document.f1.PCode.options.length] = new Option('".$row["PostCode"]."','".$row["PostCode"]."');\n";
$sJavaScript = $sJavaScript."document.f1.txtStreet.options[document.f1.txtStreet.options.length] = new Option('".$row["Street"]."','".$row["Street"]."');\n";
$sJavaScript = $sJavaScript."document.f1.txtTown.options[document.f1.txtTown.options.length] = new Option('".$row["Town"]."','".$row["Town"]."');\n";

}

// finish the Name's listbox
echo "</SELECT></TD>";

echo "\n<TD valign=\"center\">Postal</TD><TD><SELECT NAME=\"PCode\" SIZE=10>";
echo "\n<TD valign=\"center\">Street</TD><TD><SELECT NAME=\"txtStreet\" SIZE=10>";
echo "\n<TD valign=\"center\">Town</TD><TD><SELECT NAME=\"txtTown\" SIZE=10>";
echo "\n<TD valign=\"center\">Locality</TD><TD><SELECT NAME=\"txtLocality\" SIZE=10>";
echo "\n<TD valign=\"center\">Postal</TD><TD><INPUT TYPE='TEXT' NAME=\"PCode\" SIZE=10></TD>";
echo "<TD width="17%">Locality</td><TD><INPUT type='text' NAME=\"txtLocality\" SIZE=10></TD>";

echo "</TABLE>";
// finish the javascript and write out

$sJavaScript = $sJavaScript."\n}\n}\n";
echo "\n<SCRIPT LANGUAGE=\"JavaScript\">";
echo "\n".$sJavaScript."\n</SCRIPT>\n";

//close the form

echo "</FORM></center>";

**sad69** · Feb 18, 2004, 12:39 PM

I'm sorry, but your code is too unreadable (dispite your comments!)

Firstly, you need to put all that code in [ php ] [ /php ] tags (no spaces).

Secondly you need to get rid of all those echoed html/javascript. I can't follow all the braces and quotes. In general, it's much nicer to use php sparingly in your code. See:

CodingForum

http://www.codingforum.net/showthread.php?s=&threadid=31782&highlight=when+needed

If you manage to clean that up, post it with the [ php ] [ /php ] tags (no spaces), and I'm sure most people will be willing to give you a hand with it -- and future code submissions!

Sadiq.

**j-iN-uK** · Feb 19, 2004, 05:52 AM

Hi, hope this code is much clearer. Basically onchange of a Schoolname, I run the javascript to display the proper school fields. I know the problem is in my For statement,
for (var i = document.f1.PCode.options.length; i >= 0; i--)
{ \n document.f1.PCode.options[i] = null";
In that statement, I only reference my Postal code, which changes fine when I echo it, how do I include my other fields in the for statement.

echo "<TR><TD valign=\"center\">School</TD><TD><SELECT NAME=\"LstSchoolName\" SIZE=\"10\" ONCHANGE=\"Schoolselected(this);\" >\n";

$sJavaScript = "function Schoolselected(elem)

{\n for (var i = document.f1.PCode.options.length; i >= 0; i--)
{ \n document.f1.PCode.options[i] = null";

// loop through the database..

$SName="";
while ( $row = mysql_fetch_array($result) )
{
If ($SName!=$row["SchoolName"]){
$SName = $row["SchoolName"];
echo "\n<OPTION VALUE='".$row["SchoolName"]."'>".$SName."</OPTION>";
$sJavaScript = $sJavaScript."}\n"."if (elem.options[elem.selectedIndex].value=='".$row["SchoolName"]."'){\n";
}

$sJavaScript = $sJavaScript."document.f1.PCode.options[document.f1.PCode.options.length] = new Option('".$row["PostCode"]."','".$row["PostCode"]."');\n";
$sJavaScript = $sJavaScript."document.f1.txtStreet.options[document.f1.txtStreet.options.length] = new Option('".$row["Street"]."','".$row["Street"]."');\n";
$sJavaScript = $sJavaScript."document.f1.txtTown.options[document.f1.txtTown.options.length] = new Option('".$row["Town"]."','".$row["Town"]."');\n";

}

echo "\n<TD valign=\"center\">Postal</TD><TD><SELECT NAME=\"PCode\" SIZE=10>";
echo "\n<TD valign=\"center\">Street</TD><TD><SELECT NAME=\"txtStreet\" SIZE=10>";
echo "\n<TD valign=\"center\">Town</TD><TD><SELECT NAME=\"txtTown\" SIZE=10>";

**j-iN-uK** · Feb 19, 2004, 07:12 AM

Hi,

I managed to sort out my for statement so that the values dont get repeated.

$sJavaScript = "function Schoolselected(elem)
{\n for (var i = document.f1.length; i >= 0; i--)
\n document.f1.PCode.options[i] = null\n
\n document.f1.txtStreet.options[i] = null\n}";

Thant was the resolution. But now I want to display the data in a normal text field, but can't seem to get that to work except in a Select box:

echo "\n<TD valign=\"center\">Postal</TD><TD><SELECT NAME=\"PCode\" SIZE=10>";
echo "\n<TD valign=\"center\">Street</TD><TD><SELECT NAME=\"txtStreet\" SIZE=10>";

that works, but I want to display them in a text box, when I change input type="text", it does not seem to work.

**sad69** · Feb 19, 2004, 01:31 PM

When you say

when I change input type="text", it does not seem to work.

Can you elaborate on that a little bit? What does happen? Do you get any textboxes? Do you get the right number of textboxes? Do the textboxes have the right names? Are they blank? Do they have values? Should they have values?

You have to be more specific.

When you merely change select to input type="text", you have to note the difference between a select box and an input box. Select boxes have options, inputs don't. They have a value attribute. If you want the text box to show a value, you have to set the value attribute.

I'm not sure what other problems you've got. But try and be as clear and concise with your problems. Number them, like:
problem 1
problem 2
...

That way it's easy to refer to them and answer them.

Also, why have you got those \n characters in your code when they're not inside of quotes? I'm getting confused as to why you're showing code that shouldn't work and claiming your problems are something else altogether.

This week doesn't seem to want to end...
Sadiq.

**j-iN-uK** · Feb 20, 2004, 04:26 AM

Ok, I'm really sorry for not being clear in my problems. Let's hope this is better.

---------------------------------------------------------------------------
Eg1.
This is what I have which works fine

$sJavaScript = "function Schoolselected(elem)
{ for (var i = document.f1.length; i >= 0; i--)
document.f1.PCode.options[i] = null
document.f1.txtStreet.options[i] = null}";

echo "<TD valign=\"center\">Postal</TD><TD><SELECT NAME=\"PCode\" SIZE=10>";
echo "<TD valign=\"center\">Street</TD><TD><SELECT NAME=\"txtStreet\" SIZE=10>";

----------------------------------------------------------------------------------
Eg2.
This is what I want, I want to display the values in text boxes and not a list box,
when I change it to this, the text box appears but it's blank and my onchange does not work.

$sJavaScript = "function Schoolselected(elem)
{ for (var i = document.f1.length; i >= 0; i--)
document.f1.PCode.value[i] = null
document.f1.txtStreet.value[i] = null}";

echo "<TD valign=\"center\">Postal</TD><TD><INPUT TYPE='TEXT' NAME=\"PCode\" SIZE=10>";
echo "<TD valign=\"center\">Street</TD><TD><INPUT TYPE='TEXT' NAME=\"txtStreet\" SIZE=10>";

**sad69** · Feb 20, 2004, 12:25 PM

Like I said in my previous post, you're not setting the value attribute.

This:

PHP Code:


echo "<TD valign=\"center\">Postal</TD><TD><INPUT TYPE='TEXT' NAME=\"PCode\" SIZE=10>";

Should look more like this:

PHP Code:


echo "<TD valign=\"center\">Postal</TD><TD><INPUT TYPE='TEXT' NAME=\"PCode\" SIZE=10 VALUE=\"$PCode\">";

You're still not putting your code in [ php ] [ /php ] tags, but whatever. That should fix your problems.

Sadiq.

**missing-score** · Feb 20, 2004, 12:55 PM

What he means is you need tags like this:

[php]
<?php

echo 'blah';

?>
[/php]

which will then look like this when you post your message.

PHP Code:


<?php



echo 'blah';



?>

**j-iN-uK** · Feb 23, 2004, 07:00 AM

That line of code still does not work, the reason, I'm displaying two fields is to show you that one populates onchange and the other does not. My PCode value gets populated but the txtStreet value does not and this is because its a textbox. I know u did say I must set the value of txtStreet, which I did, I even declared $txtStreet, but it still does not seem to populate.

<?PHP

$sJavaScript = "function Schoolselected(elem)

{ for (var i = document.f1.length; i >= 0; i--)
{ document.f1.PCode.options[i] = null
document.f1.txtStreet.value[i] = null";

$SName="";
while ( $row = mysql_fetch_array($result) )
{
If ($SName!=$row["SchoolName"]){
$SName = $row["SchoolName"];
echo "<OPTION VALUE='".$row["SchoolName"]."'>".$SName."</OPTION>";
$sJavaScript = $sJavaScript."}"."if (elem.options[elem.selectedIndex].value=='".$row["SchoolName"]."'){";
}

$sJavaScript = $sJavaScript."document.f1.PCode.options[document.f1.PCode.options.length] = new Option('".$row["PostCode"]."','".$row["PostCode"]."');";
$sJavaScript = $sJavaScript."document.f1.txtStreet.value[document.f1.txtStreet.value.length] = new Option('".$row["Street"]."','".$row["Street"]."');";

}
echo "</SELECT></TD>";

if (!empty($HTTP_POST_VARS["txtStreet"]))
{
$txtStreet = $HTTP_POST_VARS["txtStreet"];
}

echo "<TD valign=\"center\">Street</TD><TD><INPUT TYPE='TEXT' NAME=\"txtStreet\" SIZE=10 VALUE=\"$txtStreet\">";
echo "<td width=\"83%\"><SELECT NAME=PCode size=1></td>";

?>

**sad69** · Feb 23, 2004, 12:24 PM

Try this out for debugging and see what you come up with. It may help you to narrow down your problem.

Replace:

PHP Code:


if (!empty($HTTP_POST_VARS["txtStreet"]))

{ 

$txtStreet = $HTTP_POST_VARS["txtStreet"];

}

With:

PHP Code:


if (!empty($HTTP_POST_VARS["txtStreet"]))

{ 

$txtStreet = $HTTP_POST_VARS["txtStreet"];

}

else

{

$txtStreet = "EMPTY!!!";

}

Reading that code may also make you think: should txtStreet be in $HTTP_POST_VARS? What does that imply? Does that mean that txtStreet is not coming from the database? Should it be coming from the database?

Also, this bit of code of yours looks kinda funny:

PHP Code:


$sJavaScript = $sJavaScript."document.f1.txtStreet.value[document.f1.txtStreet.value.length] = new Option('".$row["Street"]."','".$row["Street"]."');";

The reason being is that you're creating a new Option. Options are only for select boxes -- NOT for text boxes. Also it looks like you're referring to street with $row["Street"] -- so what is $txtStreet? Where did that come from?

These questions I'm posing are not for me (ie. I don't care about the answers), but for you. Hopefully they will guide you to solving this problem of yours. Study your code.

Hope that helps,
Sadiq.

**missing-score** · Feb 23, 2004, 12:36 PM

hi j-iN-uK

PLEASE could you use the [php][/php] formatting tags as shown in my example above.

Announcement

onSelect, display proper fields in textbox

onSelect, display proper fields in textbox

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment