Ejemplos de Framework\Core\Database DB::ExecuteScalarQuery en PHP

Ejemplo n.º 1

Archivo: ConfigFromFile.class.php Proyecto: Miljankg/simplef

 public function getUserCountWithSpecifiedRole($roleName)
 {
     $usersCount = 0;
     if ($this->dbObj == null) {
         $users = $this->loadedConfig['users'];
         foreach ($users as $user => $userConfig) {
             if (isset($userConfig['role_name']) && $userConfig['role_name'] == $roleName) {
                 $usersCount++;
             }
         }
     } else {
         $sql = "SELECT count(*) FROM users u LEFT JOIN roles r ON u.user_role = r.role_id WHERE r.role_name='{$roleName}'";
         $usersCount = $this->dbObj->ExecuteScalarQuery($sql);
     }
     return $usersCount;
 }