The data stores in database but it cannot display in page. Help me please
-table project
Project_ID, Project_Name, Project_Desc, User_ID
-table user
User_ID, User_Name
here is my code in model
public function get_all_project() {
$this->db->select('*');
$this->db->from('user');
$this->db->join('project','project.User_ID = user.User_ID');
$query = $this->db->get();
return $query->result();
}
here my code in controller
public function list_all_project() {
$data['projectadmin_list'] = $this->projectadmin_model->get_all_project();
$this->load->view('projectadmin_list',$data);
$this->load->model('projectadmin_model');
}
here my code in view
<?php
foreach ($projectadmin_list as $data){ ?>
<tr>
<td><?php echo $data->Project_ID; ?></td>
<td><?php echo $data->Project_Name; ?></td>
<td><?php echo $data->Project_Desc; ?></td>
<td><?php echo $data->Project_Total; ?></td>
<td><?php echo $data->User_ID; ?></td>
<td width="60" align="left" ><a href="#" onClick="show_confirm('edit',<?php echo $data->Project_ID;?>)">Edit</a></td>
<td width="60" align="left" ><a href="#" onClick="show_confirm('delete_project',<?php echo $data->Project_ID;?>)">Delete </a></td>
</tr>
<?php }?>