How to get the node status?

Question

I have a function that returns sets of variables. Now, I want to control the return value by using node status. Basically I dont want the value to be returned when the node is unpublished. Any idea? Here is the function by the way. I just need to add a condition in the return value like this if($node->status == 1){ return $omniture_variables; }

function my_module_omniture_variables() {
  $current_day = date('D');
  $current_hour = date('G');
  .....

  $omniture_variables['variables'] = array(
    ....
  );

  //Sets omniture variables
  if(module_exists('omniture')) {
  ....
  }
  
  if(count($extra_variables) > 0) {
    $omniture_variables['variables'] = array_merge($omniture_variables['variables'], $extra_variables);
  }

  return $omniture_variables;
}

Answer 1

To avoid a node_load() you can do:

  $query = db_query("SELECT * FROM {node} WHERE nid = %d LIMIT 1", $number);
  $result = db_fetch_object($query);

and then look at $result->status.

Answer 2

Getting a node's status is quite simple:

// Get the node with node ID 123.
$node = node_load(123);
// Get its status.
$status = $node->status;

That said... I don't know what your function looks like or in which context it's running, so depending on your situation, there may be an even better way to get what you want.

Answer 3

For Drupal 8:

<?php

// Get status method
$status = $node->isPublished();

// Set status
node->setPublished(TRUE);

https://api.drupal.org/api/drupal/core%21modules%21node%21src%21Entity%21Node.php/function/Node%3A%3AisPublished/8.2.x

https://api.drupal.org/api/drupal/core%21modules%21node%21src%21Entity%21Node.php/function/Node%3A%3AsetPublished/8.2.x

Answer 4

Drupal 8 method for avoiding using node_load:

$bundle = $node->bundle(); // or $bundle='my_bundle_type';
$query = \Drupal::entityQuery('node');
$query->condition('status', 1);
$query->condition('type', $bundle); // Optional
$entity_ids = $query->execute();

Answer 5

Using the Drupal 7 Database API, you can get the status of a node to determine if it is published or not like this:

// Determine if the node is published or not.
$query = db_select('node', 'n')
  ->fields('n', array('status'))
  ->condition('n.nid', $nid)
  ->execute();
$result = $query->fetchObject();
$is_published = $result ? $result->status : FALSE;

if ($is_published) {
  // Take action...
}
else {
  // Relax...
}