blocks|key|1273112|text|看一下结果函数here|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1273113|$this->db->from('yourtable');
[...+more+active+record+code+...]
$query+=+$this->db->get();
$rowcount+=+$query->num_rows();|code-block|syntax|javascript|1273114|entityMap|0|LINK|mutability|MUTABLE|url|http://www.codeigniter.com/user_guide/database/results.html^0|7|4|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]]]]

Have a look at the result functions <a href="http://www.codeigniter.com/user_guide/database/results.html" rel="noreferrer">here</a>:

<pre><code>$this-&gt;db-&gt;from('yourtable');
[... more active record code ...]
$query = $this-&gt;db-&gt;get();
$rowcount = $query-&gt;num_rows();
</code></pre>

blocks|key|1273133|text|而且，如果您只想获得表中所有行的计数|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1273134|$table_row_count+=+$this->db->count_all('table_name');|code-block|syntax|javascript|1273135|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

AND, if you just want to get a count of all the rows in a table

<pre><code>$table_row_count = $this-&gt;db-&gt;count_all('table_name');
</code></pre>

blocks|key|1487826|text|儿子，只要看看医生的话就行了！|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1487827|$query->num_rows();|code-block|syntax|javascript|1487828|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Just gotta read the docs son!

<pre><code>$query-&gt;num_rows();
</code></pre>

blocks|key|1273195|text|如果您只需要查询中的行数，而不需要实际的行数据，请使用count_all_results|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1273196|echo+$this->db
+++++++->where('active',1)
+++++++->count_all_results('table_name');|code-block|syntax|javascript|1273197|entityMap|0|LINK|mutability|MUTABLE|url|http://www.codeigniter.com/user_guide/database/query_builder.html#CI_DB_query_builder::count_all_results^0|R|H|R|H|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@$9|V|A|W|1|X]]|E|$]]|$1|F|3|G|5|H|7|Y|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Z|8|@]|D|@]|E|$]]]|L|$M|$5|N|O|P|E|$Q|R]]]]

If you only need the number of rows in a query and don't need the actual row data, use <a href="http://www.codeigniter.com/user_guide/database/query_builder.html#CI_DB_query_builder::count_all_results" rel="noreferrer"><code>count_all_results</code></a>

<pre><code>echo $this-&gt;db
 -&gt;where('active',1)
 -&gt;count_all_results('table_name');
</code></pre>

blocks|key|1487908|text|这将转到您的模型：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1487909|public+function+count_news_by_category($cat)
{
++++return+$this->db
++++++++->where('category',+$cat)
++++++++->where('is_enabled',+1)
++++++++->count_all_results('news');
}|code-block|syntax|javascript|1487910|这是我当前项目中的一个例子。|1487911|根据benchmarking的说法，此查询的执行速度比执行以下操作的速度更快：|offset|length|1487912|$this->db->select('*')->from('news')->where(...);+
$q+=+$this->db->get();+
return+$q->num_rows();|1487913|entityMap|0|LINK|mutability|MUTABLE|url|http://codeigniter.com/user_guide/general/profiling.html^0|0|0|0|2|C|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Y|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|Z|8|@]|9|@$K|10|L|11|1|12]]|A|$]]|$1|M|3|N|5|D|7|13|8|@]|9|@]|A|$E|F]]|$1|O|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V]]]]

This goes to you model:

<pre><code>public function count_news_by_category($cat)
{
 return $this-&gt;db
 -&gt;where('category', $cat)
 -&gt;where('is_enabled', 1)
 -&gt;count_all_results('news');
}
</code></pre>

It'a an example from my current project.

According to <a href="http://codeigniter.com/user_guide/general/profiling.html">benchmarking</a> this query works faster than if you do the following:

<pre><code>$this-&gt;db-&gt;select('*')-&gt;from('news')-&gt;where(...); 
$q = $this-&gt;db-&gt;get(); 
return $q-&gt;num_rows();
</code></pre>

blocks|key|1273346|text|如果要查找受where条件影响的行或数据，这也是一个非常有用的函数|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1273347|function+num_rows($table)
++++{+++
+++++++return+$this->db->affected_rows($table);
++++}|code-block|syntax|javascript|1273348|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This is also a very useful function if you are looking for a rows or data with where condition affected

<pre><code>function num_rows($table)
 { 
 return $this-&gt;db-&gt;affected_rows($table);
 }
</code></pre>

blocks|key|1488029|text|您可以通过两种不同的方法来完成此操作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1488030|++1.+$this->db->query();+//execute+the+query
+++++$query+=+$this->db->get()+//+get+query+result
+++++$count+=+$query->num_rows()+//get+current+query+record.

++2.++$this->db->query();+//execute+the+query
++++++$query+=+$this->db->get()+//+get+query+result
++++++$count+=+count($query->results())+
++++++++++or+++count($query->row_array())++//get+current+query+record.|code-block|syntax|javascript|1488031|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You can do this in two different ways:

<pre><code> 1. $this-&gt;db-&gt;query(); //execute the query
 $query = $this-&gt;db-&gt;get() // get query result
 $count = $query-&gt;num_rows() //get current query record.

 2. $this-&gt;db-&gt;query(); //execute the query
 $query = $this-&gt;db-&gt;get() // get query result
 $count = count($query-&gt;results()) 
 or count($query-&gt;row_array()) //get current query record.
</code></pre>

blocks|key|1273417|text|$this->db->select('count(id)+as+rows');
$this->db->from('table_name');
$this->db->where('active',1);
$query+=+$this->db->get();
foreach($query->result()+as+$r)
{
+++return+$r->rows;
}|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1273418|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>$this-&gt;db-&gt;select('count(id) as rows');
$this-&gt;db-&gt;from('table_name');
$this-&gt;db-&gt;where('active',1);
$query = $this-&gt;db-&gt;get();
foreach($query-&gt;result() as $r)
{
 return $r-&gt;rows;
}
</code></pre>

blocks|key|1273420|text|function+getCount(){
++++return+$this->db->get('table_name')->num_rows();
}|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1273421|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>function getCount(){
 return $this-&gt;db-&gt;get('table_name')-&gt;num_rows();
}
</code></pre>

blocks|key|1488188|text|适用于您的模型的代码段|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1488189|function+getCount($tblName){
++++$query+=+$this->db->get($tblName);
++++$rowCount+=+$query->num_rows();
++++return+$rowCount;+++++++
}|code-block|syntax|javascript|1488190|这是用于控制的|1488191|++public+function+index()+{
++++$data['employeeCount']=+$this->CMS_model->getCount("employee");
++++$this->load->view("hrdept/main",$data);
}|1488192|这是为了查看|1488193|<div+class="count">
++<?php+echo+$employeeCount;+?>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+</div>|1488194|这段代码在我的项目中使用，并且工作正常。|1488195|​|1488196|📷|atomic|offset|length|1488197|1488198|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/b1afd6e72ca36c0590ed01d1b274c543.jpeg|imageAlt^0|0|0|0|0|0|0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|17|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|18|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|19|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|1A|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|1B|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|1C|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|1D|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1E|8|@]|9|@]|A|$]]|$1|S|3|T|5|U|7|1F|8|@]|9|@$V|1G|W|1H|1|1I]]|A|$]]|$1|X|3|R|5|6|7|1J|8|@]|9|@]|A|$]]|$1|Y|3|-4|5|6|7|1K|8|@]|9|@]|A|$]]]|Z|$10|$5|11|12|13|A|$14|15|16|-4]]]]

This code segment for your Model 

<pre><code>function getCount($tblName){
 $query = $this-&gt;db-&gt;get($tblName);
 $rowCount = $query-&gt;num_rows();
 return $rowCount; 
}
</code></pre>

This is for controlr

<pre><code> public function index() {
 $data['employeeCount']= $this-&gt;CMS_model-&gt;getCount("employee");
 $this-&gt;load-&gt;view("hrdept/main",$data);
}
</code></pre>

This is for view 

<pre><code>&lt;div class="count"&gt;
 &lt;?php echo $employeeCount; ?&gt; 
 &lt;/div&gt;
</code></pre>

This code is used in my project and is working properly.

<img src="https://i.stack.imgur.com/DS1Oj.jpg" alt="result">

blocks|key|1488216|text|$sql+=+"SELECT+count(id)+as+value+FROM+your_table+WHERE+your_field+=+?";
$your_count+=+$this->db->query($sql,+array($your_field))->row(0)->value;
echo+$your_count;|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1488217|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>$sql = "SELECT count(id) as value FROM your_table WHERE your_field = ?";
$your_count = $this-&gt;db-&gt;query($sql, array($your_field))-&gt;row(0)-&gt;value;
echo $your_count;
</code></pre>

I'm very new to CodeIgniter and Active Record in particular, I know how to do this well in normal SQL but I'm trying to learn.

How can I select some data from one of my tables, and then count how many rows are returned using CodeIgniters Active Record class?

Thanks,
Tom.

CodeIgniter Active Record - Get number of returned rows

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

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

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

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

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

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

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

我对CodeIgniter和活动记录非常陌生，我知道如何在普通的SQL中很好地做到这一点，但我正在努力学习。如何从一个表中选择一些数据，然后使用CodeIgniters Active Record类计算返回了多少行？谢谢，汤姆。

问CodeIgniter Active Record -获取返回的行数
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问CodeIgniter Active Record -获取返回的行数EN