943,967 Members | Top Members by Rank

Ad:
  • PHP Discussion Thread
  • Unsolved
  • Views: 2114
  • PHP RSS
Nov 28th, 2006
0

view employee info for the employee selected from the drop down list

Expand Post »
i have designed an employee details webpage. there is an option of generating pay slip. to do so all the information related to the employee and his/her salary has to be entered.

the employee details are already stored in the database. i want to design a form that will have a drop down list holding the employee names and some textboxes to hold the related information of the employee.

i want that when a employee name will be selected, the information related to that employee will be displayed in the respective textboxes.

please give a quick reaply with a code example.

thank you
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
fariba123 is offline Offline
2 posts
since Nov 2006
Dec 2nd, 2006
0

Re: view employee info for the employee selected from the drop down list

You could use something like this;

<form action="<?php $_SERVER['PHP_SELF']; ?>" method="POST">
<select name="employee_name">
<option value="Employee 1">Employee 1</option>
<option value="Employee 2">Employee 2</option>
<option value="Employee 3">Employee 3</option>
</select>
</FORM

<?php
$employee_selected=$_REQUEST['employee_name'];

$query="SELECT * FROM employees WHERE employee='$employee_selected'";

$result=mysql_query($query);

$row=mysql_fetch_array($result, MYSQL_ASSOC);

// THEN YOU NEED THE TEXT BOXES

echo '<input name="employee_name" type="text" value="'.$row['employee_name'].'"/>';
?>

This script will get the employee name from the drop down, search the database and display the details you require in the respective textboxes.

I have a Customer/Employee management system on my website you could purchase if your stuck! I can totally customise it for you!
Reputation Points: 15
Solved Threads: 17
Junior Poster
phper is offline Offline
189 posts
since Nov 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in PHP Forum Timeline: Syntax problem!
Next Thread in PHP Forum Timeline: is there something wrong with my SQL statement?





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC