blocks|key|1553852|text|我最终使用了这个：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1553853|$result+=+$db->query($query)->fetchAll();

if+(count($result)+>+0)+{
++++foreach+($result+as+$row)+{
++++++++echo+$row['blah']+.+'<br+/>';
++++}
}+else+{
++++echo+"Nothing+matched+your+query.";
}|code-block|syntax|javascript|1553854|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|$]]

I ended up using this:

<pre><code>$result = $db-&gt;query($query)-&gt;fetchAll();

if (count($result) &gt; 0) {
 foreach ($result as $row) {
 echo $row['blah'] . '&lt;br /&gt;';
 }
} else {
 echo "&lt;p&gt;Nothing matched your query.&lt;/p&gt;";
}
</code></pre>

blocks|key|1338171|text|这已经很晚了，但我遇到了这个问题，我这样做：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1338172|function+countAll($table){
+++$dbh+=+dbConnect();
+++$sql+=+"select+*+from+`$table`";

+++$stmt+=+$dbh->prepare($sql);
++++try+{+$stmt->execute();}
++++catch(PDOException+$e){echo+$e->getMessage();}

return+$stmt->rowCount();|code-block|syntax|javascript|1338173|这真的很简单，也很容易。:)|1338174|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

This is super late, but I ran into the problem and I do this:

<pre><code>function countAll($table){
 $dbh = dbConnect();
 $sql = "select * from `$table`";

 $stmt = $dbh-&gt;prepare($sql);
 try { $stmt-&gt;execute();}
 catch(PDOException $e){echo $e-&gt;getMessage();}

return $stmt-&gt;rowCount();
</code></pre>

It's really simple, and easy. :)

blocks|key|1338409|text|这篇文章很老了，但是用PDO在php中获取行数很简单。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1338410|$stmt+=+$db->query('SELECT+*+FROM+table');
$row_count+=+$stmt->rowCount();|code-block|syntax|javascript|1338411|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 post is old but Getting row count in php with PDO is simple

<pre><code>$stmt = $db-&gt;query('SELECT * FROM table');
$row_count = $stmt-&gt;rowCount();
</code></pre>

blocks|key|1554136|text|回答这个问题是因为我把自己困在了其中，现在知道了这一点，可能会有用。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1554137|请记住，您不能获取两次结果。您必须将fetch结果保存到数组中，通过count($array)获取行数，并使用foreach输出结果。例如：|offset|length|style|CODE|1554138|$query+=+"your_query_here";
$STH+=+$DBH->prepare($query);
$STH->execute();
$rows+=+$STH->fetchAll();
//all+your+results+is+in+$rows+array
$STH->setFetchMode(PDO::FETCH_ASSOC);+++++++++++
if+(count($rows)+>+0)+{+++++++++++++
++++foreach+($rows+as+$row)+{
++++++++//output+your+rows
++++}+++++++++++++++++++++++
}|code-block|syntax|javascript|1554139|entityMap^0|0|Y|D|1J|7|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@$D|Q|E|R|F|G]|$D|S|E|T|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|U|8|@]|9|@]|A|$K|L]]|$1|M|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|N|$]]

Answering this because I trapped myself with it by now knowing this and maybe it will be useful. 

Keep in mind that you cant fetch results twice. You have to save fetch result into array, get row count by <code>count($array)</code>, and output results with <code>foreach</code>.
For example:

<pre><code>$query = "your_query_here";
$STH = $DBH-&gt;prepare($query);
$STH-&gt;execute();
$rows = $STH-&gt;fetchAll();
//all your results is in $rows array
$STH-&gt;setFetchMode(PDO::FETCH_ASSOC); 
if (count($rows) &gt; 0) { 
 foreach ($rows as $row) {
 //output your rows
 } 
}
</code></pre>

blocks|key|1554384|text|如果你只想得到行数(而不是数据)，例如。在准备好的语句中使用COUNT(*)，那么您需要做的就是检索结果并读取值：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1554385|$sql+=+"SELECT+count(*)+FROM+`table`+WHERE+foo+=+bar";
$statement+=+$con->prepare($sql);+
$statement->execute();+
$count+=+$statement->fetch(PDO::FETCH_NUM);+//+Return+array+indexed+by+column+number
return+reset($count);+//+Resets+array+cursor+and+returns+first+value+(the+count)|code-block|syntax|javascript|1554386|实际上，检索所有行(数据)来执行简单的计数是一种资源浪费。如果结果集很大，您的服务器可能会因此而阻塞。|1554387|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

If you just want to get a count of rows (not the data) ie. using COUNT(*) in a prepared statement then all you need to do is retrieve the result and read the value:

<pre><code>$sql = "SELECT count(*) FROM `table` WHERE foo = bar";
$statement = $con-&gt;prepare($sql); 
$statement-&gt;execute(); 
$count = $statement-&gt;fetch(PDO::FETCH_NUM); // Return array indexed by column number
return reset($count); // Resets array cursor and returns first value (the count)
</code></pre>

Actually retrieving all the rows (data) to perform a simple count is a waste of resources. If the result set is large your server may choke on it.

blocks|key|1338840|text|看看这个链接：http://php.net/manual/en/pdostatement.rowcount.php不推荐在SELECT语句中使用rowCount()！|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1338841|entityMap|0|LINK|mutability|MUTABLE|url|http://php.net/manual/en/pdostatement.rowcount.php^0|7|1E|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Have a look at this link:
<a href="http://php.net/manual/en/pdostatement.rowcount.php" rel="nofollow noreferrer">http://php.net/manual/en/pdostatement.rowcount.php</a>
It is not recommended to use rowCount() in SELECT statements!

blocks|key|1338328|text|一个快速的一行程序来返回第一个条目。这对于非常简单的查询是很好的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1338329|<?php
$count+=+current($db->query("select+count(*)+from+table")->fetch());
?>|code-block|syntax|javascript|1338330|Reference|offset|length|1338331|entityMap|0|LINK|mutability|MUTABLE|url|http://www.php.net/manual/en/pdostatement.fetch.php#84495^0|0|0|0|9|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@$I|V|J|W|1|X]]|A|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

A quick one liner to get the first entry returned. This is nice for very basic queries.

<pre><code>&lt;?php
$count = current($db-&gt;query("select count(*) from table")-&gt;fetch());
?&gt;
</code></pre>

<a href="http://www.php.net/manual/en/pdostatement.fetch.php#84495" rel="nofollow">Reference</a>

blocks|key|1338361|text|我在Oracle11.2上试用了$count+=+$stmt->rowCount();，但它不起作用。我决定使用for循环，如下所示。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1338362|+++$count+=++"";
++++$stmt+=++$conn->prepare($sql);
++++$stmt->execute();
+++echo+"<table+border='1'>\n";
+++while($row+=+$stmt->fetch(PDO::FETCH_OBJ))+{
++++++++$count%2B%2B;
++++++++echo+"<tr>\n";
++++foreach+($row+as+$item)+{
++++echo+"<td+class='td2'>".($item+!==+null+?+htmlentities($item,+ENT_QUOTES):"&nbsp;")."</td>\n";
++++++++}+//foreach+ends
++++++++}//+while+ends
++++++++echo+"</table>\n";
+++++++//echo+"+no+of+rows+:+".+oci_num_rows($stmt);
+++++++//equivalent+in+pdo::prepare+statement
+++++++echo+"no.of+rows+:".$count;|code-block|syntax|javascript|1338363|entityMap^0|G|R|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

I tried <code>$count = $stmt-&gt;rowCount();</code> with Oracle 11.2 and it did not work.
I decided to used a for loop as show below. 

<pre><code> $count = "";
 $stmt = $conn-&gt;prepare($sql);
 $stmt-&gt;execute();
 echo "&lt;table border='1'&gt;\n";
 while($row = $stmt-&gt;fetch(PDO::FETCH_OBJ)) {
 $count++;
 echo "&lt;tr&gt;\n";
 foreach ($row as $item) {
 echo "&lt;td class='td2'&gt;".($item !== null ? htmlentities($item, ENT_QUOTES):"&amp;nbsp;")."&lt;/td&gt;\n";
 } //foreach ends
 }// while ends
 echo "&lt;/table&gt;\n";
 //echo " no of rows : ". oci_num_rows($stmt);
 //equivalent in pdo::prepare statement
 echo "no.of rows :".$count;
</code></pre>

blocks|key|1554221|text|对于我想要特定行的直接查询，并想知道是否找到了它，我使用类似于：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1554222|function+fetchSpecificRow(&$myRecord)+{
++++$myRecord+=+array();
++++$myQuery+=+"some+sql...";
++++$stmt+=+$this->prepare($myQuery);
++++$stmt->execute(array($parm1,+$parm2,+...));
++++if+($myRecord+=+$stmt->fetch(PDO::FETCH_ASSOC))+return+0;
++++return+$myErrNum;
}|code-block|syntax|javascript|1554223|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|$]]

For straight queries where I want a specific row, and want to know if it was found, I use something like:

<pre><code>function fetchSpecificRow(&amp;$myRecord) {
 $myRecord = array();
 $myQuery = "some sql...";
 $stmt = $this-&gt;prepare($myQuery);
 $stmt-&gt;execute(array($parm1, $parm2, ...));
 if ($myRecord = $stmt-&gt;fetch(PDO::FETCH_ASSOC)) return 0;
 return $myErrNum;
}
</code></pre>

blocks|key|1338888|text|有一个简单的解决方案。如果您使用PDO连接到数据库，如下所示：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1338889|try+{

++++$handler+=+new+PDO('mysql:host=localhost;dbname=name_of_your_db',+'your_login',+'your_password');+
++++$handler+->+setAttribute(PDO::ATTR_ERRMODE,+PDO::ERRMODE_EXCEPTION);

}+catch+(PDOException+$e)+{+

++++echo+$e->getMessage();
}|code-block|syntax|javascript|1338890|现在，如果您想知道表中有多少行，并且将列'id‘作为主键，那么对DB的查询将是：|1338891|$query+=+$handler->query("SELECT+id+FROM+your_table_name");|1338892|最后，要获得与查询匹配的行数，请编写如下代码：|1338893|$amountOfRows+=+$query->rowCount();|1338894|或者你可以这样写：|1338895|$query+=+$handler+->query("SELECT+COUNT(id)+FROM+your_table_name");

$amountOfRows+=+$query->rowCount();|1338896|或者，如果您想知道表'+products‘中有多少产品的价格在10到20之间，请编写以下查询：|1338897|$query+=+$handler+->query("SELECT+id+FROM+products+WHERE+price+BETWEEN+10+AND+
20");

$amountOfRows+=+$query->rowCount();|1338898|entityMap^0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|10|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|12|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|13|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|14|8|@]|9|@]|A|$]]|$1|Q|3|R|5|D|7|15|8|@]|9|@]|A|$E|F]]|$1|S|3|T|5|6|7|16|8|@]|9|@]|A|$]]|$1|U|3|V|5|D|7|17|8|@]|9|@]|A|$E|F]]|$1|W|3|-4|5|6|7|18|8|@]|9|@]|A|$]]]|X|$]]

There is a simple solution. If you use PDO connect to your DB like this:
<pre><code>try {

 $handler = new PDO('mysql:host=localhost;dbname=name_of_your_db', 'your_login', 'your_password'); 
 $handler -&gt; setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

} catch (PDOException $e) { 

 echo $e-&gt;getMessage();
}
</code></pre>
Now, if you want to know how many rows are existing in your table and you have for example column 'id' as the primary key, the query to DB will be:
<pre><code>$query = $handler-&gt;query(&quot;SELECT id FROM your_table_name&quot;);
</code></pre>
And finally, to get the amount of the rows matching your query, write like this:
<pre><code>$amountOfRows = $query-&gt;rowCount();
</code></pre>
Or you can write:
<pre><code>$query = $handler -&gt;query(&quot;SELECT COUNT(id) FROM your_table_name&quot;);

$amountOfRows = $query-&gt;rowCount();
</code></pre>
Or, if you want to know how many products there are in the table 'products' have the price between 10 and 20, write this query:
<pre><code>$query = $handler -&gt;query(&quot;SELECT id FROM products WHERE price BETWEEN 10 AND 
20&quot;);

$amountOfRows = $query-&gt;rowCount();
</code></pre>

blocks|key|1338912|text|最简单的方法，它只有2行，|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1338913|$sql+=+$db->query("SELECT+COUNT(*)+FROM+tablename+WHERE+statement='condition'");
echo+$sql->fetchColumn();|code-block|syntax|javascript|1338914|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|$]]

The simplest way, it is only 2 lines,
<pre><code>$sql = $db-&gt;query(&quot;SELECT COUNT(*) FROM tablename WHERE statement='condition'&quot;);
echo $sql-&gt;fetchColumn();
</code></pre>

blocks|key|1338218|text|当您在mysql语句中进行计数(*)时，如下所示|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1338219|$q+=+$db->query("SELECT+COUNT(*)+FROM+...");|code-block|syntax|javascript|1338220|你的mysql查询已经在计算结果的数量了，为什么在php中还要计算呢？要获得mysql的结果|1338221|$q+=+$db->query("SELECT+COUNT(*)+as+counted+FROM+...");
$nb+=+$q->fetch(PDO::FETCH_OBJ);
$nb+=+$nb->counted;|1338222|而$nb将包含您用mysql语句计算的整数，虽然编写起来有点长，但执行起来却很快。|offset|length|style|CODE|1338223|编辑:对于错误的帖子，很抱歉，但是作为一些示例show+query+with+count+in，我建议使用mysql结果，但是如果您不使用sql+fetchAll()中的count是有效的，如果您将结果保存在一个变量中，您不会丢失一行。|1338224|$data+=+$dbh->query("SELECT+*+FROM+...");
$table+=+$data->fetchAll(PDO::FETCH_OBJ);|1338225|count($table)将返回行数，在像$row+=+$table[0]或使用foreach之后，您仍然可以使用结果|1338226|foreach($table+as+$row){
++print+$row->id;
}|1338227|entityMap^0|0|0|0|0|1|3|0|0|0|0|D|L|G|14|7|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|12|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|13|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|14|8|@$M|15|N|16|O|P]]|9|@]|A|$]]|$1|Q|3|R|5|6|7|17|8|@]|9|@]|A|$]]|$1|S|3|T|5|D|7|18|8|@]|9|@]|A|$E|F]]|$1|U|3|V|5|6|7|19|8|@$M|1A|N|1B|O|P]|$M|1C|N|1D|O|P]|$M|1E|N|1F|O|P]]|9|@]|A|$]]|$1|W|3|X|5|D|7|1G|8|@]|9|@]|A|$E|F]]|$1|Y|3|-4|5|6|7|1H|8|@]|9|@]|A|$]]]|Z|$]]

when you make a COUNT(*) in your mysql statement like in

<pre><code>$q = $db-&gt;query("SELECT COUNT(*) FROM ...");
</code></pre>

your mysql query is already counting the number of result why counting again in php? to get the result of your mysql

<pre><code>$q = $db-&gt;query("SELECT COUNT(*) as counted FROM ...");
$nb = $q-&gt;fetch(PDO::FETCH_OBJ);
$nb = $nb-&gt;counted;
</code></pre>

and <code>$nb</code> will contain the integer you have counted with your mysql statement
a bit long to write but fast to execute

Edit:
sorry for the wrong post but as some example show query with count in, I was suggesting using the mysql result, but if you don't use the count in sql fetchAll() is efficient, if you save the result in a variable you won't loose a line.

<pre><code>$data = $dbh-&gt;query("SELECT * FROM ...");
$table = $data-&gt;fetchAll(PDO::FETCH_OBJ);
</code></pre>

<code>count($table)</code> will return the number of row and you can still use the result after like <code>$row = $table[0]</code> or using a <code>foreach</code>

<pre><code>foreach($table as $row){
 print $row-&gt;id;
}
</code></pre>

blocks|key|1553936|text|下面是PDO类的一个定制扩展，它使用一个helper函数来检索最后一个查询的"WHERE“条件所包含的行数。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1553937|不过，您可能需要添加更多的“处理程序”，这取决于您使用的命令。目前，它只适用于使用"FROM“或"UPDATE”的查询。|1553938|class+PDO_V+extends+PDO
{
++++private+$lastQuery+=+null;

++++public+function+query($query)
++++{
++++++++$this->lastQuery+=+$query;++++
++++++++return+parent::query($query);
++++}
++++public+function+getLastQueryRowCount()
++++{
++++++++$lastQuery+=+$this->lastQuery;
++++++++$commandBeforeTableName+=+null;
++++++++if+(strpos($lastQuery,+'FROM')+!==+false)
++++++++++++$commandBeforeTableName+=+'FROM';
++++++++if+(strpos($lastQuery,+'UPDATE')+!==+false)
++++++++++++$commandBeforeTableName+=+'UPDATE';

++++++++$after+=+substr($lastQuery,+strpos($lastQuery,+$commandBeforeTableName)+%2B+(strlen($commandBeforeTableName)+%2B+1));
++++++++$table+=+substr($after,+0,+strpos($after,+'+'));

++++++++$wherePart+=+substr($lastQuery,+strpos($lastQuery,+'WHERE'));

++++++++$result+=+parent::query("SELECT+COUNT(*)+FROM+$table+"+.+$wherePart);
++++++++if+($result+==+null)
++++++++++++return+0;
++++++++return+$result->fetchColumn();
++++}
}|code-block|syntax|javascript|1553939|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Here's a custom-made extension of the PDO class, with a helper function to retrieve the number of rows included by the last query's "WHERE" criteria.

You may need to add more 'handlers', though, depending on what commands you use. Right now it only works for queries that use "FROM " or "UPDATE ".

<pre><code>class PDO_V extends PDO
{
 private $lastQuery = null;

 public function query($query)
 {
 $this-&gt;lastQuery = $query; 
 return parent::query($query);
 }
 public function getLastQueryRowCount()
 {
 $lastQuery = $this-&gt;lastQuery;
 $commandBeforeTableName = null;
 if (strpos($lastQuery, 'FROM') !== false)
 $commandBeforeTableName = 'FROM';
 if (strpos($lastQuery, 'UPDATE') !== false)
 $commandBeforeTableName = 'UPDATE';

 $after = substr($lastQuery, strpos($lastQuery, $commandBeforeTableName) + (strlen($commandBeforeTableName) + 1));
 $table = substr($after, 0, strpos($after, ' '));

 $wherePart = substr($lastQuery, strpos($lastQuery, 'WHERE'));

 $result = parent::query("SELECT COUNT(*) FROM $table " . $wherePart);
 if ($result == null)
 return 0;
 return $result-&gt;fetchColumn();
 }
}
</code></pre>

blocks|key|1338669|text|您可以将最佳方法组合到一行或函数中，并自动生成新的查询：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1338670|function+getRowCount($q){+
++++global+$db;
++++return+$db->query(preg_replace('/SELECT+[A-Za-z,]%2B+FROM+/i','SELECT+count(*)+FROM+',$q))->fetchColumn();
}

$numRows+=+getRowCount($query);|code-block|syntax|javascript|1338671|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 combine the best method into one line or function, and have the new query auto-generated for you:

<pre><code>function getRowCount($q){ 
 global $db;
 return $db-&gt;query(preg_replace('/SELECT [A-Za-z,]+ FROM /i','SELECT count(*) FROM ',$q))-&gt;fetchColumn();
}

$numRows = getRowCount($query);
</code></pre>

blocks|key|1338780|text|<table>
++++++<thead>
+++++++++++<tr>
++++++++++++++++<th>Sn.</th>
++++++++++++++++<th>Name</th>
+++++++++++</tr>
++++++</thead>
++++++<tbody>
<?php
+++++$i=0;
+++++$statement+=+$db->prepare("SELECT+*+FROM+tbl_user+ORDER+BY+name+ASC");
+++++$statement->execute();
+++++$result+=+$statement->fetchColumn();
+++++foreach($result+as+$row)+{
++++++++$i%2B%2B;
++++?>++
++++++<tr>
+++++++++<td><?php+echo+$i;+?></td>
+++++++++<td><?php+echo+$row['name'];+?></td>
++++++</tr>
+++++<?php
++++++++++}
+++++?>
+++++</tbody>
</table>|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1338781|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>&lt;table&gt;
 &lt;thead&gt;
 &lt;tr&gt;
 &lt;th&gt;Sn.&lt;/th&gt;
 &lt;th&gt;Name&lt;/th&gt;
 &lt;/tr&gt;
 &lt;/thead&gt;
 &lt;tbody&gt;
&lt;?php
 $i=0;
 $statement = $db-&gt;prepare("SELECT * FROM tbl_user ORDER BY name ASC");
 $statement-&gt;execute();
 $result = $statement-&gt;fetchColumn();
 foreach($result as $row) {
 $i++;
 ?&gt; 
 &lt;tr&gt;
 &lt;td&gt;&lt;?php echo $i; ?&gt;&lt;/td&gt;
 &lt;td&gt;&lt;?php echo $row['name']; ?&gt;&lt;/td&gt;
 &lt;/tr&gt;
 &lt;?php
 }
 ?&gt;
 &lt;/tbody&gt;
&lt;/table&gt;
</code></pre>

blocks|key|1338855|text|function+count_x($connect)+{++
+$query+=+"++SELECT+*+FROM+tbl+WHERE+id+=+'0'+";++
+$statement+=+$connect->prepare($query);++$statement->execute();++
+$total_rows+=+$statement->rowCount();++
+return+$total_rows;+
}|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1338856|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 count_x($connect) { 
 $query = " SELECT * FROM tbl WHERE id = '0' "; 
 $statement = $connect-&gt;prepare($query); $statement-&gt;execute(); 
 $total_rows = $statement-&gt;rowCount(); 
 return $total_rows; 
}
</code></pre>

blocks|key|1338598|text|使用参数array(PDO::ATTR_CURSOR+=>+PDO::CURSOR_SCROLL)，否则使用show+-1：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1338599|Usen+parametro+array(PDO::ATTR_CURSOR+=>+PDO::CURSOR_SCROLL)，sin+-1|1338600|示例：|1338601|$res1+=+$mdb2->prepare("SELECT+clave+FROM+$tb+WHERE+id_usuario='$username'+AND+activo=1+and+id_tipo_usuario='4'",+array(PDO::ATTR_CURSOR+=>+PDO::CURSOR_SCROLL));
$res1->execute();

$count=$res1->rowCount();
echo+$count;|code-block|syntax|javascript|1338602|entityMap^0|4|19|0|F|19|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|T|8|@$9|U|A|V|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|W|8|@]|D|@]|E|$]]|$1|J|3|K|5|L|7|X|8|@]|D|@]|E|$M|N]]|$1|O|3|-4|5|6|7|Y|8|@]|D|@]|E|$]]]|P|$]]

Use parameter <code>array(PDO::ATTR_CURSOR =&gt; PDO::CURSOR_SCROLL)</code>, else show -1:

Usen parametro <code>array(PDO::ATTR_CURSOR =&gt; PDO::CURSOR_SCROLL)</code>, sin ello sale -1 

example:

<pre><code>$res1 = $mdb2-&gt;prepare("SELECT clave FROM $tb WHERE id_usuario='$username' AND activo=1 and id_tipo_usuario='4'", array(PDO::ATTR_CURSOR =&gt; PDO::CURSOR_SCROLL));
$res1-&gt;execute();

$count=$res1-&gt;rowCount();
echo $count;
</code></pre>

There are many conflicting statements around. What is the best way to get the row count using PDO in PHP? Before using PDO, I just simply used <code>mysql_num_rows</code>.
<code>fetchAll</code> is something I won't want because I may sometimes be dealing with large datasets, so not good for my use.
Do you have any suggestions?

Row count with PDO

数据库

服务器

有很多相互矛盾的说法。在PHP中使用PDO获取行数的最佳方法是什么？在使用PDO之前，我只是简单地使用了mysql_num_rows。fetchAll是我不想要的东西，因为我有时可能要处理大型数据集，所以对我的使用不好。你有什么意见建议？

问使用PDO的行数
EN

回答 17

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用PDO的行数EN

回答 17

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用PDO的行数
EN