[eluser]jbads[/eluser]
Hi, I am developing a function/page controller that would like to take a parameter from the url and use that parameter (in this case username) to extract data to populate a profile for the user.
Overall, the controller is in it's infancy, and I'm learning codeigniter as I go, therefore only the basic operations have been coded.
When I load this function through the browser eg. localhost/site/index.php/class/function/parameter it is only extracting the last row in the database, not the row specified in the url. If I enter a url with no /parameter/ it still returns the last entry in the database.
Here is my function thus far, could you please advise me what is wrong with my sql
Quote: function viewprofile(){
//retrieve username from URL
$url_username = $this->uri->segment(3);
if(!isset($url_username)){
redirect('core');
}
$data['segment_id'] = $url_username;
//get info from database
//build where clause in sql statement
$where = $this->db->where('username', $url_username);
//run query
$query = $this->db->query('SELECT * FROM table $where;');
$data['segment_id'] = $query->num_rows();
//check that there was a result
if ($query->num_rows() > 0){
//put results into usable variables
foreach($query->result_array() as $row){
$data['username'] = $row['username'];
$data['firstname'] = $row['firstname'];
$data['lastname'] = $row['lastname'];
$data['emailaddress'] = $row['emailaddress'];
}
}else{
redirect('core');
}
$page_header['title'] = "View Profile";
$this->load->view('index_header_view', $page_header);
$this->load->view('index_menu_view');
$this->load->view('profile/view_profile_body_view', $data);
$this->load->view('index_footer_view');
}
Any other advise in regards to this code would be greatly appreciated,
Thanks, Jake