Re: <select> not populating form fields (php,mysql)
- From: David Haynes <david.haynes2@xxxxxxxxxxxx>
- Date: Sat, 29 Oct 2005 07:51:16 -0400
Ian Rutgers wrote:
"David Haynes" <david.haynes2@xxxxxxxxxxxx> wrote in message news:MRz8f.9276$AF.1225@xxxxxxxxxxxxxxxxxxxxxxxxAssuming that you don't want to use a client-side tool - like javascript - to do this, I would set this php page up so that it could handle two cases: 1. where adetails_employee_id was not set and 2. where adetails_employee_id was set. Then the form around the select would simply call this php page. Roughly (assuming a POST method form)...Ian Rutgers wrote:I see what you're saying. I assume then I have to do a separate query "on select" to look up and display the other fields?I think you are missing a fundamental concept about server-side processing which is that once the server responds to the browser (i.e. PHP has processed its response) the page is essentially static.Situation:
I have a form which collects a bunch of data. The form accesses two tables (users and assignment_details). The user table is accessed to get the userid (to be saved in an assignment_details record) and to display other users table info (for display only). There is other information being collected to be saved in the assignment_details table, but it is not relevant to the issue.
I am using a <select> to display user names, and extract the appropriate userid. The <select> tag uses a query to pull all the names from the users table. When the form is loaded all defined fields from the users table are displayed on the form. Selecting a different name doesn't result in extracting and displaying the result of the user fields (as in the code below): ... help!
.
.
.
<td><select name="adetails_employee_id">
<?php
do {
?>
<option value="<?php echo $row_rsEmployeeLookup['id_usr']?>"><?php echo ($row_rsEmployeeLookup['first_name_usr'] . ' ' . $row_rsEmployeeLookup['last_name_usr']);?></option>
<?php
} while ($row_rsEmployeeLookup = mysql_fetch_assoc($rsEmployeeLookup));
$rows = mysql_num_rows($rsEmployeeLookup);
if($rows > 0) {
mysql_data_seek($rsEmployeeLookup, 0);
$row_rsEmployeeLookup = mysql_fetch_assoc($rsEmployeeLookup);
}
?>
</select>
</td>
</tr>
<tr>
<td>mobile phone</td>
<td><?php echo $row_rsEmployeeLookup['mobile_usr']; ?></td>
</tr>
etc.
Try doing a right-click view page source in your browser to see what PHP has sent to the browser and then ask yourself how was the new query based on the select going to happen.
In other words, since all queries need to be resolved on the server, how is the server going to know what you selected?
-david-
Ian
<?php
if( isset($_POST['adetails_employee_id']) ) {
// code to lookup an employee based on the adetails_employee_id
} else {
// default without employee lookup
}
?>.... <form method="POST" action=""> <select name="adetails_employee_id" onchange="Javascript:Submit()"> <option value="...">...</option> </select> </form>
I hope this helps.
-david-
.
- References:
- <select> not populating form fields (php,mysql)
- From: Ian Rutgers
- Re: <select> not populating form fields (php,mysql)
- From: David Haynes
- Re: <select> not populating form fields (php,mysql)
- From: Ian Rutgers
- <select> not populating form fields (php,mysql)
- Prev by Date: Re: <select> not populating form fields (php,mysql)
- Next by Date: mysql_connect() undefined
- Previous by thread: Re: <select> not populating form fields (php,mysql)
- Next by thread: mysql_connect() undefined
- Index(es):
Relevant Pages
|
