Get node id for a chado feature/organism/analysis. E.g, if you want to get the node id for an analysis, use: $nid = chado_get_nid_from_id ('analysis', $analysis_id) Likewise, $nid = chado_get_nid_from_id ('organism', $organism_id) $nid = chado_get_nid_from_id ('feature', $feature_id)

Parameters

$table: The chado table the id is from

$id: The value of the primary key from the $table chado table (ie: feature_id)

$linking_table: The Drupal table linking the chado record to it's node. This field is optional and defaults to chado_$table

Return value

The nid of the associated node

Related topics

File

tripal_core/api/tripal_core.chado_nodes.api.inc, line 87

API to handle much of the common functionality implemented when creating a drupal node type.

Code

function chado_get_nid_from_id($table, $id, $linking_table = NULL) {
  if (empty($linking_table)) {
    $linking_table = 'chado_' . $table;
  }

  $sql = "SELECT nid FROM {" . $linking_table . "} WHERE " . $table . "_id = :" . $table . "_id";
  return db_query($sql, array(":" . $table . "_id" => $id))->fetchField();
}