blocks|key|88787|text|您可以在模型上使用PHP的__call+Magic+Method来处理任何简单的where子句：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|88788|public+function+__call($method,+$parameters)
{
++++if+(strpos($method,+'get_by_')+===+0)
++++{
++++++++$this->get(array(substr($method,+7),+$parameters[0]));
++++}
}|code-block|syntax|javascript|88789|entityMap|0|LINK|mutability|MUTABLE|url|http://php.net/manual/en/language.oop5.magic.php^0|K|C|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

You could use PHP's __call <a href="http://php.net/manual/en/language.oop5.magic.php" rel="nofollow">Magic Method</a> on your model to handle any simple where clause:

<pre><code>public function __call($method, $parameters)
{
 if (strpos($method, 'get_by_') === 0)
 {
 $this-&gt;get(array(substr($method, 7), $parameters[0]));
 }
}
</code></pre>

blocks|key|88809|text|我很清楚你是从哪里来的，因为几个月前我也有同样的疑虑。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|88810|我使用https://bitbucket.org/philsturgeon/codeigniter-base-model/src/93a643d0d46f/MY_Model.php|offset|length|88811|把它当做一个库就行了。将模型创建为|88812|//+user_m.php
<?php+(defined('BASEPATH'))+OR+exit('No+direct+script+access+allowed');
class+User_m+extends+MY_Model
{}|code-block|syntax|javascript|88813|除了基本的CRUD函数之外，上面的函数还可以包含您想要的任何自定义函数。|88814|在控制器中运行代码的方式为|88815|+++$this->load->model('user_m');
+++$this->data['user']+=+$this->user_m->get($user_id);|88816|或|88817|+++$this->load->model('user_m');
+++$this->data['user']+=+$this->user_m->get_by(array('something_id'+=>+$something));|88818|它有你需要的所有基本的CRUD操作。只需阅读代码，它也有很好的文档记录。|88819|entityMap|0|LINK|mutability|MUTABLE|url|https://bitbucket.org/philsturgeon/codeigniter-base-model/src/93a643d0d46f/MY_Model.php^0|0|3|2F|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|16|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|17|8|@]|9|@$D|18|E|19|1|1A]]|A|$]]|$1|F|3|G|5|6|7|1B|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|1C|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|1D|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|1E|8|@]|9|@]|A|$]]|$1|Q|3|R|5|J|7|1F|8|@]|9|@]|A|$K|L]]|$1|S|3|T|5|6|7|1G|8|@]|9|@]|A|$]]|$1|U|3|V|5|J|7|1H|8|@]|9|@]|A|$K|L]]|$1|W|3|X|5|6|7|1I|8|@]|9|@]|A|$]]|$1|Y|3|-4|5|6|7|1J|8|@]|9|@]|A|$]]]|Z|$10|$5|11|12|13|A|$14|15]]]]

I know exactly where you are coming from since I had the same doubts a few months ago.

I use <a href="https://bitbucket.org/philsturgeon/codeigniter-base-model/src/93a643d0d46f/MY_Model.php" rel="nofollow">https://bitbucket.org/philsturgeon/codeigniter-base-model/src/93a643d0d46f/MY_Model.php</a>

Just use it as a library. You create models as

<pre><code>// user_m.php
&lt;?php (defined('BASEPATH')) OR exit('No direct script access allowed');
class User_m extends MY_Model
{}
</code></pre>

The above can have any custom functions you want other than the basic CRUD ones.

You run the code in your controller as

<pre><code> $this-&gt;load-&gt;model('user_m');
 $this-&gt;data['user'] = $this-&gt;user_m-&gt;get($user_id);
</code></pre>

or

<pre><code> $this-&gt;load-&gt;model('user_m');
 $this-&gt;data['user'] = $this-&gt;user_m-&gt;get_by(array('something_id' =&gt; $something));
</code></pre>

Its got all the basic CRUD operations you need. Just read the code, its pretty well documented too.

blocks|key|3612890|text|如果您对给定的模型有很多get_by_*方法，那么按照TaylorOtwell的建议使用神奇的方法是有意义的。实际上，在其他框架中经常使用__call方法以及__get和__set，这样就可以很容易地完成您所说的事情。只需记住，在映射时，CI不会很好地使用控制器上的__call魔术方法(但这不会影响模型)。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3612891|我在CI中看待CMV的基本方式：|3612892|3612893|库--这是大部分“呈现逻辑”发生的地方，但通常应该是控件/模型/视图不可知的。几乎完全无状态(我的preference).|unordered-list-item|3612894|Helpers+--实用程序函数，主要是与视图相关的(其他一切都更适合作为一个库(更正交，yada，yada，yada))|3612895|Controller+--加载库/模型并调用methods|3612896|Model+--+DB包装层。几乎完全有状态(my+preference).|3612897|Views+--+Display+data|3612898|3612899|通常，控制器会做这样的事情：|3612900|class+Users
{
++++function+display(+$id+)
++++{
++++++++$this->load->library(+'myformatlib'+);
++++++++$this->load->model(+'mymodel'+);
++++++++$data+=+$this->mymodel->get_user(+$id+);
++++++++$formatted+=+$this->myformatlib->addColors(+$data+);
++++++++$this->mymodel->incrementViews(+$id+);
++++++++$this->load->view(+'full_user',+$formatted+);
++++}
}|code-block|syntax|javascript|3612901|至于传递where子句--+DB查询几乎应该完全归于模型，除非没有其他选择，或者这样做太麻烦了(但我想知道您是否不能重构它)。|3612902|entityMap^0|C|8|1X|6|27|5|2D|5|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|15|8|@$9|16|A|17|B|C]|$9|18|A|19|B|C]|$9|1A|A|1B|B|C]|$9|1C|A|1D|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|1E|8|@]|D|@]|E|$]]|$1|H|3|-4|5|6|7|1F|8|@]|D|@]|E|$]]|$1|I|3|J|5|K|7|1G|8|@]|D|@]|E|$]]|$1|L|3|M|5|K|7|1H|8|@]|D|@]|E|$]]|$1|N|3|O|5|K|7|1I|8|@]|D|@]|E|$]]|$1|P|3|Q|5|K|7|1J|8|@]|D|@]|E|$]]|$1|R|3|S|5|K|7|1K|8|@]|D|@]|E|$]]|$1|T|3|-4|5|6|7|1L|8|@]|D|@]|E|$]]|$1|U|3|V|5|6|7|1M|8|@]|D|@]|E|$]]|$1|W|3|X|5|Y|7|1N|8|@]|D|@]|E|$Z|10]]|$1|11|3|12|5|6|7|1O|8|@]|D|@]|E|$]]|$1|13|3|-4|5|6|7|1P|8|@]|D|@]|E|$]]]|14|$]]

If you have a lot of <code>get_by_*</code> methods for a given model, then it does make sense to use the magic method as TaylorOtwell suggested. Actually, the <code>__call</code> method, as well as <code>__get</code> and <code>__set</code> are used frequently in other frameworks to make it easy to do exactly what you're talking about. Just remember CI will not play nice with the __call Magic method on the controller while mapping (but that won't effect the model).

Basic way I look at CMV in CI:

<ul>
<li>Libraries -- this is where the bulk of the "rendering logic" happens but generally should be control/model/view agnostic. Almost entirely stateless (my preference).</li>
<li>Helpers -- utility functions, mostly view-related (everything else is really better off as a library (more orthogonal, yada, yada, yada))</li>
<li>Controller -- Loads libraries/models and calls methods</li>
<li>Model -- DB wrapping layer. Almost entirely stateful (my preference).</li>
<li>Views -- Display data</li>
</ul>

Frequently, the controller will do things like:

<pre><code>class Users
{
 function display( $id )
 {
 $this-&gt;load-&gt;library( 'myformatlib' );
 $this-&gt;load-&gt;model( 'mymodel' );
 $data = $this-&gt;mymodel-&gt;get_user( $id );
 $formatted = $this-&gt;myformatlib-&gt;addColors( $data );
 $this-&gt;mymodel-&gt;incrementViews( $id );
 $this-&gt;load-&gt;view( 'full_user', $formatted );
 }
}
</code></pre>

As to passing where clauses -- DB queries should almost be exclusively relegated to the model unless there is no other option or it would be excessively cumbersome to do so (but I would wonder if you couldn't refactor that).

I'm currently making an app in CodeIgniter and I was wondering on how I should deal with models. The way I have it set up at the moment:

Views: display
Controllers: display related things, form validation, redirects, talk to libraries, etc
Libraries: do the heavy lifting, talk to the models, generate error messages, logs, etc
Models: talk to the DB

(I'm currently using Active Record for most things)

Let me go straight to an example:

I have an Auth library and inside I have queries that area somewhat similar, varying only by the value in the WHERE clause.

Ex:

<pre><code>get_by_id($id);
get_by_password_hash($email);
get_by_email($email);
</code></pre>

Should I have a bunch of these duplicate model functions or should I just have one simple function where I pass WHERE clauses and whatnot via the library?

Ex:

<pre><code>$where = array('id' =&gt; $id);
get($where);
</code></pre>

Please let me know if you'd like me to clarify anything.
Thanks in advance.

CodeIgniter - MVC approach question

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我目前正在用CodeIgniter做一个应用程序，我想知道我应该如何处理模型。我现在设置它的方式是：视图:显示控制器:显示相关内容、表单验证、重定向、与库对话等库:执行繁重任务、与模型对话、生成错误消息、日志等模型:与数据库对话(我目前在大多数情况下都在使用活动记录)让我直接举个例子：我有一个Auth库，在里面我有一些...

问CodeIgniter - MVC方法问题
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问CodeIgniter - MVC方法问题EN