hiii alll
I have one one form where i want to display values in textfields from database.
here is my form details:
MstPay(_form.php)
<table>
<tr>
<td>
<?php echo $form->labelEx($model,'EmployeeId'); ?>
<?php echo $form->textField($model,'EmployeeId',array('size'=>20,'maxlength'=>20)); ?>
<?php echo $form->error($model,'EmployeeId'); ?>
</td>
<td>
<?php echo $form->labelEx($model,'FixSalary'); ?>
<?php echo $form->textField($model,'FixSalary',array('size'=>20,'maxlength'=>20)); ?>
<?php echo $form->error($model,'FixSalary'); ?>
</td>
<td>
<?php echo $form->labelEx($model,'Basic'); ?>
<?php echo $form->textField($model,'Basic',array('size'=>20,'maxlength'=>20)); ?>
<?php echo $form->error($model,'Basic'); ?>
</td>
</tr>
Here EmployeeId is a pk field.
I have Mstemployee table which has fields:
-
EmployeeId Pk field.
-
FixSalary.
-
Basic.
My question is when i will enter some value in EmployeeId textfield i want to display FixSalary & Basic values assign for that EmployeeId pk field from mstemployee table.