[eluser]DaTran[/eluser]
The controller:
Code:
elseif($data = $this->model_auction->retreave($this->uri->segment(3)))
{
if($query = $this->model_auction->list_items())
{
$data['list'] = $query;
}
print_r($data);
$this->load->view('auction_edit', $query);
}
The model:
Code:
function retreave($id = NUll)
{
if($id)
{
$this->db->where('id', $id);
$query = $this->db->get('auction');
foreach($query->result() as $row)
{
// Get item name from database
$this->db->where('id', $row->items_id);
$item_query = $this->db->get('items');
$item = $item_query->row_array();
// Normal array
$new_array = array(
'id' => $row->id,
'min_bid' => $row->min_bid,
'item_id' => $item['id']
);
}
return $new_array;
}
else
{
$query = $this->db->get('auction');
$new_array = array(); // Make array
foreach($query->result() as $row)
{
// Get item name from database
$this->db->where('id', $row->items_id);
$item_query = $this->db->get('items');
$item = $item_query->row_array();
// Add a stdClass object to the final array.
$new_array[] = (object) array( // Adds new object array on to the array created foreach $new_array[]
'id' => $row->id,
'min_bid' => $row->min_bid,
'item_name' => $item['name']
);
}
return $new_array; // return multi-demi array
}
}