title: get data from mysql table by PDO
body: <p>i want to show row count by select on table in mysql and pass by webservice i want show number of users in my application</p>
  <pre><code>&lt;?php
      
      
      include &quot;./myPDO.php&quot;;
      
  
      $conn = myPDO::getInstance();
      $select = &quot; Select count(*) From users where isActive = 1 &quot;;
      $stmt = $conn-&gt;prepare($select);
  
      $stmt-&gt;execute();
  
      echo ($stmt-&gt;rowCount());
  </code></pre>