I'm trying to recreate my blog using OOP and having a problem working out how to solve the following problem..
I have an ArticleCollection class (extends Collection class) that stores Articles (singleton's -is that right?).
Currently Articles takes a single parameter (article_id) and loads the information from a database.
I want ArticleCollection to loop through all the records in my database and create a new Article instance, then store it in an array / object, so I can access them when I want.
This is where I'm getting troubled, I would need to connect to the DB in ArticleCollection (for all records) AND Article (for the individual record), this smell's like I'm duplicating code. How should I approach this?
I've not written any code yet, trying to get it clear in my head before I set out.