enter data from a dropdown list in to a differernt form

fredbear

I have a list of people in a dropdown list that when selected I want to update some fields in a different form.

This is an include file called chart_menu4.php that contains the correct people.

<?
if ($_SESSION["player"]) {
?>
<h3>Charts and Performance</h3>

<?
} if ($SESSION["assessor"]) {
require_once("playerlist.inc.php");
$myPlayerList = &new PlayerList($db);
$SESSION["arrayPlayerChart"] = $myPlayerList->getPlayerList($SESSION["assessorid"]);
if (sizeof($SESSION["arrayPlayerChart"]) > 1) {
?>
<h3>Charts and Performance</h3>

<form name="form1" method="post">
<select name="playerid" onchange="this.form.submit()">
<?
foreach ($_SESSION["arrayPlayerChart"] as $key => $value) {
if (!$key) continue;
?>
<option value="<? echo($key); ?>"><? echo(htmlentities($value["name"])); ?></option>
<?
}
?>
</select>
</form>
<?
}
?>

<?
}
?>

I want the selected person to update a few fields in a new form based on their id

This is the form that contains the include file above.

<form name="form1" method="post">
<select name="playerid" onchange="this.form.submit()">
<?php

include"chart_menu4.php"; // change to your filename
$assessor_id = 0; // change to the correct value

?>
</select>
<input type="submit" name="submit2" value="Submit" />
</form>

The form to be updated is called assessor-playercreate.php

Thanks in advance

Weedpacket

So what exactly is the problem you're having?

fredbear

Sorry for the confusion, I'm new at this.

OK, at the moment I have a text field where a user must enter a correct id to automatically populate a form on the assessor-playercreate.php page.

Sessions are used to select a group of players that are placed in to a dropdown list instead of the free text field.

I want to be able to select a player from within this dropdown list to populate the form on assessor-playercreate.php page.

I am using a script that selects the users for a different purpose as below.

<?
if ($_SESSION["player"]) {
?>
<h3>Charts and Performance</h3>
<?
} if ($_SESSION["assessor"]) {
require_once("playerlist.inc.php");
$myPlayerList = &new PlayerList($db);
$_SESSION["arrayPlayerChart"] = $myPlayerList->getPlayerList($_SESSION["assessorid"]);
if (sizeof($_SESSION["arrayPlayerChart"]) > 1) {
?>
<h3>Charts and Performance</h3>

<form name="form1" method="post">
<select name="playerid" onchange="this.form.submit()">
<?
foreach ($_SESSION["arrayPlayerChart"] as $key => $value) {
if (!$key) continue;
?>
<option value="<? echo($key); ?>"><? echo(htmlentities($value["name"])); ?></option>
<?
}
?>
</select>
</form>
<?
}
?>

<?
}
?>[/QUOTE] 
This is a copy of the form that includes the above include file

<form name="form1" method="post">
<select name="playerid" onchange="this.form.submit()">
<?php

include"chart_menu4.php"; // change to your filename
$assessor_id = 0; // change to the correct value

?>
</select>
<input type="submit" name="submit2" value="Submit" />
</form>

I have also attached an image of what the page currenlt looks like.

Thanks in advance

Weedpacket

So just to clarify, when the page loads, you want the playerid field to already have the appropriate name selected? Save them having to reselect the same thing all over again? I'm going to have to assume that $key is the same as the player's ID - if it's some arbitrary index it would be hard to keep track of which index refers to which player. I'll also assume that the player's ID is what is stored in $_SESSION['player'].

<option value="<? echo($key); ?>"
<?php if($key==$_SESSION['player']) echo 'selected="selected"'?>>
<? echo(htmlentities($value["name"])); ?>
</option>

fredbear

So just to clarify, when the page loads, you want the playerid field to already have the appropriate name selected?

Yes this is what I want to happen from the selection made in the dropdown list.

Below is all the code from the original page that contains the text field that I want changed from an empty text field into a dropdown list.

<?
session_start();
if (!$_SESSION["assessor"]) {
header("Location: /login.php");
die();
}
include_once("config.inc.php");
include_once("db.inc.php");

if ($_SERVER["REQUEST_METHOD"] == "POST") {
	if ((string)intval($_POST["playerid"]) != $_POST["playerid"]) $playerIDNotValid = 1;
	$sql = "select playerid from player where playerid = ".(int)$_POST["playerid"];
	$rsPlayer = $db->query($sql);
	if (mysql_num_rows($rsPlayer)) {
		header("Location: /assessment-create.php?playerid=".intval($_POST["playerid"]));
		die();
	} else {
		$playerIDNotValid = 1;
	}

	if ($playerIDNotValid) {
		include("top.php");
		echo('<p>Player ID not valid.</p><p><a href="/assessor.php">Back</a></p>');
		include("rightcol-testimonial.php");
		include("bottom.php");
	}
}
include("top.php");
?>

<?
$sql = "select
assessor.*
from
assessor
where
assessorid = ".$_SESSION["assessorid"];
$rsAssessor = $db->query($sql);
if (mysql_num_rows($rsAssessor)) {
$rowAssessor = mysql_fetch_array($rsAssessor);
echo('<p style="float:right;"><a href="/assessor-create.php?edit=1">Edit Profile</a></p>');
echo('<h1>'.$rowAssessor["firstname"].' '.$rowAssessor["surname"].' - Assessor Home</h1>');
echo('<div id="credits"><h3>Purchase Credits & Assessment Kit</h3><p>You have <strong>'.$rowAssessor["credits"].' </strong> credits in your account.</p>');
echo('<p><a href="gotostore.php">Purchase more credits</a></p>');
echo('<p><a href="../ecomm/index.php">Purchase Assessment Kit</a></p>');
echo('<p><em>Oncourt Assessment reserves the right to revoke complimentary credits</em></p></div>');
}
?>
<style type="text/css">

</style>

<link href="dashedborder.css" rel="stylesheet" type="text/css">
<p>As a registered ITN On Court Assessment Assessor you can:</p>
<ul>
<li>Enter Official ITN On Court Assessment results into the database.</li>
<li>Pre-register all your players that have completed an assessment. </li>
<li>Print out all your players Player Profile Numbers and temporary Passwords. </li>
<li>View all your players ITN Assessment scores. </li>
<li>Print out all of your players. </li>
<li>Be listed on the Get Assessed page so players can find you for future assessments.</li><br><br>
You can view the <a href="tutorial1.php">Assessor Tutorial by clicking here</a>.
</ul>

<p align="center"><img src="images/450rule.gif" /></p>

<table width="566" height="217" class="dashedborder">
<tr>

	<td width="558" height="211" valign="top"><h1>Enter On Court Assessment Results for Players here.</h1>
		<h4><font color="#FF0000" face="Verdana, Arial, Helvetica, sans-serif"> Note: You must have Credits in your account to enter Assessment results.</font></h4>
		<div align="center"></div>
		<table width="98%" align="center" bgcolor="#A4EDFF" class="dottedborder2">
			<tr> 
				<td width="53%" valign="top">

		<h2>Existing Player</h2>
					<p>Enter your Player's Player Profile Number to enter a new result   for an existing player.</p>
					<form name="form1" method="post">

						<label for="playerid">Player Profile Number:</label>

						<input type="text" id="playerid" name="playerid" maxlength="10" size="10" />

						<input type="submit" name="submit2" value="Submit" />

		</form></td>
				<td width="47%" valign="top">

		<h2><strong>New Player</strong></h2>
					<p><a href="/assessor-playercreate.php">Enter results for a new Player</a>. Select this link to enter On Court Assessment results for a player's first Official ITN On Court Assessment. </p></td>
			</tr>
		</table>

	</td>
</tr>
</table>
<p align="center"><img src="images/450rule.gif" /></p>
<h2>Past Assessments</h2>

<table width="98%">
<tr>
<td width="50%" valign="top">
<h3>Existing Assessments</h3>

<?
$sql = "select
assessment.*,
player.firstname,
player.surname
from
assessment,
player
where
assessment.assessorid = ".$_SESSION["assessorid"]." and
assessment.playerid = player.playerid
order by
assessment.date";
$rsAssessment = $db->query($sql);
if (mysql_num_rows($rsAssessment)) {
?>
<form name="form1" action="assessor-print.php" method="post">
<p>
<?
while ($rowAssessment = mysql_fetch_array($rsAssessment)) {
?>
<input type="checkbox" name="printAssessment[]" value="<? echo($rowAssessment["assessmentid"]); ?>"> <a href="/assessment-thankyou.php?assessmentid=<? echo($rowAssessment["assessmentid"]); ?>"><? echo($rowAssessment["date"]); ?></a> <? echo(htmlentities($rowAssessment["firstname"])); ?> <? echo(htmlentities($rowAssessment["surname"])); ?> <? echo(($rowAssessment["printed"]) ? "(printed)" : "(not printed)"); ?><br />
<?
}
?>
</p>
<p>
	<input type="submit" name="submit" value="Print Selected" />
</p>
</form>
<?
}
?>
	</td>	

	<td valign="top">
<?
include("chart_menu.php");
?>
	<h3>Rejected Assessments</h3>
<?
$sql = "select
assessment.*,
player.firstname,
player.surname
from
assessment,
player
where
assessment.assessorid = ".$_SESSION["assessorid"]." and
assessment.playerid = player.playerid and
assessment.approved = 2
order by
assessment.date";
$rsAssessment = $db->query($sql);
if (mysql_num_rows($rsAssessment)) {
?>
<p><strong>Note: The following assessments have been rejected.</strong></p>
		<p>
<?
while ($rowAssessment = mysql_fetch_array($rsAssessment)) {
?>
<a href="/assessor-editassessment.php?assessmentid=<? echo($rowAssessment["assessmentid"]); ?>"><? echo($rowAssessment["date"]); ?></a> <? echo(htmlentities($rowAssessment["firstname"])); ?> <? echo(htmlentities($rowAssessment["surname"])); ?><br />
<?
}
?>
</p>
</td>
<?
}
?>
</tr>
</table>

<?
include("rightcol-ecomm.php");
include("bottom.php");
?>

Thanks again