php arrays to javascript

victor78

I read other people's post regarding this subject and I am still confused.

I have a form that has a select box thats created from php parsing the mysql database. I also have a textarea box below it. I want to design it so that when a user clicks on the select box, the second textbox is automatically filled. I know I need to use javascript, but have no idea how. I need to somehow transfer the array from php to javascript.

I made this page to show an example.

http://www.spguild.com/eqpointsys/a_test.php

and the code

this gets the data

$sql = "SELECT * FROM items";
$result = $obj->Query($sql);
$num = &$obj->Numrows($result);

for ($i=0;$i<$num;$i++)
{
$item_name[] = mysql_result($result,$i,"item_name");
$item_stats[] = mysql_result($result,$i,"stats");
}

this is the form

<FORM NAME="itemdata">
<P>
Select an item<BR>
<SELECT NAME="item_name" onChange="getData(this.form)">
<OPTION>Choose Item
<? for ($i=0;$i<$num;$i++)
{
echo "<OPTION>";
echo $item_name[$i];
}
?>
</SELECT>
</P><P>
<font color="#FF0000">EDIT</font> Item Stats
<BR>
<textarea name="stats" rows="10" cols="35">

</textarea>
<BR>
</FORM>

eriksmoen

.
you'll need to post the javascript, well, just post the whole script, or else create a copy of the file(s) and rename them to FILENAME.txt and provide a link.

Then it might be easier to offer you assistance.

victor78

that's pretty much the code. I don't even know where to begin on the javascript part.

Christoph09

Well, you have the onchange() part right. When the user changes the value of the drop down box, the getData function will be called.

In the getData function try this out -

document.itemData.(getElementByID('textbox')).value = Var1

Var1 will be the parameter of the function that is passed in (the this.value)

Change 'textbox' to whatever you named your text area.

victor78

Still lost. What do you mean by var1. I have zero javascript knowledge, but this is the only js function I plan to use.

Here is the full code

$sql = "SELECT * FROM items";
$result = $obj->Query($sql);
$num = &$obj->Numrows($result);

for ($i=0;$i<$num;$i++)
{
$item_name[] = mysql_result($result,$i,"item_name");
$item_stats[] = mysql_result($result,$i,"stats");
}

<SCRIPT LANGUAGE="JavaScript">
function getData(form) {
document.itemdata.(getElementByID('stats')).value = ?????
}
</SCRIPT>

<BODY onLoad="getData(document.itemdata)">
<H1>Test Lookup</H1>
<HR>
<FORM NAME="itemdata">
<P>
Select an item<BR>
<SELECT NAME="item_name" onChange="getData(this.form)">
<OPTION>Choose Item
<? for ($i=0;$i<$num;$i++) {
echo "<OPTION>";
echo $item_name[$i];
}
?>
</SELECT>
</P><P>
<font color="#FF0000">EDIT</font> Item Stats
<BR>
<textarea name="stats" rows="10" cols="35">

</textarea>
<BR>
</FORM>

Christoph09

Ok, well the way you have it, the statement would be like this -

document.itemData.(getElementByID('stats')).value = form

(form is the parameter that you're passing in to getData)

For the function call, you need to have -

onChange="getData(this.value)"

One other thing, in the textarea make sure you have id = "stats" . . . else the getElementByID won't work.