[eluser]Brandt1981[/eluser]
Hello,
The textbox will have no value when the page is loaded, but when a query is done, the textbox value should be set to the database value returned. I am using Doctrine.
I need help with the following code:
Controller home.php:
Code:
class Home extends Controller {
public function __construct() {
parent::Controller();
$this->load->helper(array('form','url'));
$this->load->library('form_validation');
}
public function index() {
$vars['employee']='';
$vars['employment']='';
$vars['performance']='';
$vars['timeoff']='';
$vars['salary']='';
$this->load->view('home',$vars);
}
public function query() {
$user_id = $this->input->post('query');
$vars['employee'] = Doctrine::getTable('Employee_info')->find($user_id);
$vars['employment'] = Doctrine::getTable('Employment_info')->find($user_id);
$vars['performance'] = Doctrine::getTable('Employee_performance')->find($user_id);
$vars['timeoff'] = Doctrine::getTable('Employee_time_off')->find($user_id);
$vars['salary'] = Doctrine::getTable('Salary')->find($user_id);
$this->load->view('home', $vars);
}
View home.php:
Code:
<?php echo form_open('home/query'); echo form_input('query', 'ID#'); echo form_close(); ?>
<?php echo form_open('home/query'); ?>
<p>
<label for="username">Employee ID: </label><br/>
<?php echo form_input('empid',set_value('empid',$employee->pk_emp_id)); ?>
</p>
Hope you can help!