Posted By

brownrl on 08/22/13

Tagged

Versions (?)

Last Edited at 08/22/13 06:40pm

Statistics

Viewed 804 times

Favorited by 0 user(s)

Related snippets

Sublime Snippet: dbNumRows

/ Published in: PHP

When using PDO with sQlite ->rowCount() doesn't work. the recommendation is to do a pre query to get the number. Thus, I created this snippet to help things along.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

<snippet>
  <content><![CDATA[
 
\$q = "SELECT COUNT( * ) AS total FROM ${1:table} WHERE ${2:field} = '".${3:value}."'";
\$qr = dbQuery( \$q );
\$qrow = dbFetchArray( \$qr );
\$total = \$qrow['total'];
 
]]></content>
  <!-- Optional: Set a tabTrigger to define how to trigger the snippet -->
  <tabTrigger>dbNumRows</tabTrigger>
  <!-- Optional: Set a scope to limit where the snippet will trigger -->
  <!-- <scope>source.python</scope> -->
</snippet>