mvc and database connection

[Drongo_III]

Hi guys

 

Building a new application that is likely to grow in complexity over time. I therefore figured it would be perhaps wise to follow some mvc principles.

 

The thing I am confused about is the how best to setup a mysqli db con I can reuse througout my models.

 

Options one - have a base db class and pass in the object to the constructor of each model - thereby utilising one connection.

 

option two - for each model setup new db connection but pass db credentials as constants via config file.

 

or I am sure someone will recommend a better option yet. Any advice is welcome.

 

 

[Christian F.]

This is a nice little video which gives you a very short intro to Dependency Injections, which details the best available solution to your question.

[Drongo_III]

Thanks Christian - as ever.

 

I think I need to spend some time learning about building a class to inject the right resource based on requirement - altho that's quite a BIG topic to get to grips with. At least I am vaguely on the right track by passing the db con via the model constructor so that's reassuring .

[zettageek]

That was a great video! Thank you for posting.

[Christian F.]

You're both very much welcome.

I also recommend checking out his other videos: He really knows what he's talking about, and is able to explain thing in a very simple and understandable manner.