0

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

2
Contributors
1
Reply
2
Views
10 Years
Discussion Span
Last Post by phper
0

You could use something like this;

<form action="<?php $_SERVER; ?>" 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;

$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.'"/>';
?>

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!

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.