Smarty/views/templates中的数据库调用-DatabasecallsinSmarty/views/templates

You're right. He's wrong.

你是对的。他错了。

Database calls, no matter in what form, should live in the controller if you want to do MVC right.

如果你想要正确地进行MVC,数据库调用,无论采用何种形式,都应该存在于控制器中。

Obviously people piss all over what it should be and do stuff like that, but it's not the correct way.

很明显,人们会对它应该是什么感到厌恶并做这样的事情,但这不是正确的方法。

Well, there are no "official" rules or anything, but I think something like that belongs in the controller. I don't do anything in my view code except display variables, nothing more complex than an if or a foreach-type loop is allowed. Certainly not calling functions that access the database. That should all be loaded by the controller, the view should only decide whether it needs to display it or not.

好吧,没有“官方”规则或任何东西,但我认为这样的东西属于控制器。除了显示变量之外,我在视图代码中没有做任何事情,没有比if或foreach类型循环更复杂的东西。当然不会调用访问数据库的函数。这应该全部由控制器加载,视图应该只决定是否需要显示它。

Depends on its context and scope really.

真的取决于它的背景和范围。

Is $obj the controller or the model layer? That should answer whether or not it is valid in my opinion.

$ obj是控制器还是模型层?在我看来,这应该回答它是否有效。

In response to reading the other answers.

回应阅读其他答案。

The functions name in itself pertains it to being a simple getter method. It may make a call to the db through a controller layer. Which I would say is ok. Especially if it used some form of caching in memory. (ie the getter is the setter as you only want to cache it when it is used once.)

函数名称本身就是一个简单的getter方法。它可以通过控制器层调用db。我会说的还可以。特别是如果它在内存中使用某种形式的缓存。 (即getter是setter,因为你只想在使用一次时缓存它。)