Just a little explanation for a beginner...

[eluser]knucklehead[/eluser]
Hello!
I am getting started with CI, just as with MVC approach... So, please tell me if I understood the logic of all this correctly;

Let's say I have a relational database full of artists and events for a club. I would like to get clean URLs at the end, something like last.fm style
www.blah.com/artists/NAME
www.blah.com/events/EVENTNAME
etc.

So, I should start with creating models for db queries, right? Let's call it artistsModel.php;

Code:

<?php
class ArtistsModel extends Model{
    
    function ArtistsModel(){
        parent::Model();
    }
    
    function getAllArtists(){
        
        $query = "..."; // some query to get all artists
        
        $data = $this->db->query($query);
        
        return $data->result();
        
    }
    
    function getArtist($AID){
        
        $query = "..."; // some query to get one artist
        
        $data = $this->db->query($query);
        
        return $data->result();
        
    }
    
    // etc.
    
}
?>

Ok, if I make var_dump of this result, I will get an array full of objects (each object is exactly one row from my query). Is this ok?

Also, my results are now not 'grouped'. I wonder if I should do 'grouping' in my controller or my view?
What I mean by that? If an artist has more than 1 link to their website i will get more than 1 row of that artist from db. So I should make each artist another 'object' with 'formatted' properties before I start to manipulate with him, right? I imagine my object would look like
artist_name = string
artist_description = string
artist_links = array()
artist_countries = array()
...
And all my artists should look like that...

So, should I create those objects in controller or view?

If I make a controller like this:

Code:

class Artists extends Controller{
    
    public $artist_ime;
    public $artist_zemlja = array();
    public $artist_links = array();
    public $artist_opis;
    public $artist_priority;
    
    function Artists(){
        
        parent::Controller();
        
    }
    
    function index(){
        
        $this->load->model('artistsModel');
        $data['artists'] = $this->artistsModel->getAllArtists();
        // should I create my objects at this point already and send them instead of 'raw' data?
        $this->load->view('artists', $data);
        
    }

}

I will maybe use the same code for 'grouping' in a few places, which somehow seems wrong to me...
Should I make some programming to define an artist 'object' in controller and another programming in view to loop through my objects?
I also wonder which datatype should be $data here? Should it be also an array of objects? Because right now, if i var_dump($data) I get an array with 1 value and it is called 'artists' which is actually an array of my rows... Is that ok?
If I make some programming and create objects inside of controller, how should I 'pack' my results and send it to view?

Uf, I am sorry for all the confusion and I know this is some extremely basic and beginner stuff, but I started with OOP few weeks ago and I am still a little bit confused about everything...

Any suggestion/advice/help is extremely welcome! =)

Thanks!