symfony 统计用户数

发布于 2024-11-27 11:20:04 字数 197 浏览 1 评论 0原文

我使用 symfony 1.4.12 和原则。我有 sfGuardUser 表；我可以像这样计算所有记录：

 $count_user=Doctrine::getTable('sfGuardUser')->count();

我在表“created_at”中有字段；如果可以统计当年创建的所有用户吗？谢谢你！

原文

I use symfony 1.4.12 with doctrine. I have sfGuardUser table; I can count all records like this:

 $count_user=Doctrine::getTable('sfGuardUser')->count();

I have field in table "created_at"; If it possible to count all users, that where created in current year?
Thank you!

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

夏了南城 2024-12-04 11:20:04

$first_day_of_current_year = date('Y-m-d H:i:s', strtotime('1 january'));

$q = Doctrine_Query::create()
  ->select('COUNT(u.*)')
  ->from('sfGuardUser u')
  ->where('u.created_at > ?', $first_day_of_current_year);
$total = $q->execute(array(), Doctrine_Core::HYDRATE_NONE);
$total = $total[0][0];

$first_day_of_current_year = date('Y-m-d H:i:s', strtotime('1 january'));

$q = Doctrine_Query::create()
  ->select('COUNT(u.*)')
  ->from('sfGuardUser u')
  ->where('u.created_at > ?', $first_day_of_current_year);
$total = $q->execute(array(), Doctrine_Core::HYDRATE_NONE);
$total = $total[0][0];

回复收藏 0 原文

◇流星雨 2024-12-04 11:20:04

有多种方法可以获取记录集合的计数。当您在查询对象或 Table 实例上调用 ->count() 函数时，Doctrine 会自动为您创建计数查询。

例如，如果您想知道当年的用户总数和创建的用户数量，您可以按如下方式操作：

$query = Doctrine_Query::create()
  ->from('sfGuardUser');
// alternative query retrieval
// $query = sfGuardUserTable::getInstance()->createQuery();
// all users
$totalUsers = $query->count();
// users created this year
$query->where('YEAR(created_at) = ?', date('Y'));
$totalUsersThisYear = $query->count();

There are various ways to get the count of a record collection. Doctrine automatically creates a count query for you when you call the ->count() function on a query object or Table instance.

If for instance you would like to know the total amount of users and the amount of users created in the current year, you could go about it as follows:

$query = Doctrine_Query::create()
  ->from('sfGuardUser');
// alternative query retrieval
// $query = sfGuardUserTable::getInstance()->createQuery();
// all users
$totalUsers = $query->count();
// users created this year
$query->where('YEAR(created_at) = ?', date('Y'));
$totalUsersThisYear = $query->count();

回复收藏 0 原文

~没有更多了~