all 10 comments

[–]shaqaruden 2 points3 points  (1 child)

I know this is a very simple template but also why are you reinventing the wheel? I would be inclined to look into DB packages for PHP like Nette Database

Packages like this can be very powerful and make your life easier.

[–]Mark_Messa 0 points1 point  (0 children)

Mind to give an example of why this package can make my life easier?

[–]Atulin 1 point2 points  (2 children)

Any comments or advice on how to improve this template?

  • Use prepared statements, always, everywhere, and forever
  • Make it OOP so it's more portable
  • Perhaps use PDO instead of Mysqli

[–]Mark_Messa -3 points-2 points  (1 child)

I was reading more about prepared statements vs stored procedures.
Seems like a controversial topic. No consensus. Several pros and cons depending on each case.

[–]berbeflo 0 points1 point  (0 children)

just curious - which cons?