Yesterday we talked about counting the number of nodes by user.
Drupal 7 – Get the number of nodes by user

We could also use similar approach for counting the number of comments by user.

1. Add the following function in your theme template.php

function <theme>_get_user_comments_count($uid) {
  $query = db_select('comment', 'c');
  $query->condition('uid', $uid, '=');
  $query->condition('status', '1', '=');
  $query->addExpression('COUNT(1)', 'count');
  $result = $query->execute();

  if ($record = $result->fetchAssoc())
    return $record['count'];
  
  return 0;
}

Continue reading Drupal 7 – Get the number of comments by user →

1. Add the following function in your theme template.php

function <theme>_get_user_nodes_count($uid) {
  $query = db_select('node', 'n');
  $query->condition('uid', $uid, '=');
  $query->condition('status', '1', '=');
  $query->addExpression('COUNT(1)', 'count');
  $result = $query->execute();

  if ($record = $result->fetchAssoc())
    return $record['count'];
  
  return 0;
}

Continue reading Drupal 7 – Get the number of nodes by user →

db_query() returns a DatabaseStatementInterface object which has a function for retrieving the number of returned rows in the last SQL statement.

You could use the following piece of code to get the total number of nodes in Drupal.

$num_of_nodes = db_query('SELECT nid FROM {node}')->rowCount(); 

Done =)

Reference:

• Druapl API – db_query
• Drupal API – DatabaseStatementInterface
• Drupal API – DatabaseStatementInterface::rowCount

We can easily get the image style file path by image_style_url(). What you need is the image style name and the image uri.

image_style_url('<image-style>', <image-uri>);

Done =)

Reference:

• Drupal 7 Get Image Style Path
• Drupal API – image_style_url

There is a default user login block in every Drupal instance. If you want to customize it layout, you could create your own user-login-block.tpl.php.

1. Edit your theme template.php and implement the following 2 functions. Continue reading Drupal 7 – Customize the login block →