Tag Archive for 'snippet'

Menampilkan latest node di Drupal

Published
by
adisetiawan
on 4 December 2007
in Drupal
. 3 Comments

Biasanya kite pengen menampilkan latest node di dalam block. Snippet berikut berdasarkan kode dari sini dengan sedikit modifikasi dimana tidak menggunakan fungsi theme, melainkan langsung meng echo secara barbar :)

PLAIN TEXT
PHP:
  1. <?php
  2. // comma separated lists of terms tid to display nodes
  3. $terms = "47,48,49,50";
  4.  
  5. // the number of nodes to show
  6. $count = 5;
  7.  
  8. $sql = "SELECT DISTINCT n.title, n.nid FROM {node} n INNER JOIN {term_node} tn ON n.nid = tn.nid WHERE tn.tid in ($terms) AND n.status=1 ORDER BY n.created DESC";
  9. $result = db_query_range(db_rewrite_sql($sql), 0, $count);
  10. if (db_num_rows($result)) {
  11.   echo '<ul class="list">';
  12.   while ($node = db_fetch_object($result)) {
  13.     $link = 'node/'.$node->nid;
  14.     echo '<li>'.l($node->title,$link).'</li>';
  15.   }
  16.   echo '</ul>';
  17. }
  18. ?>

kalo mau bikin link misal read more ke term tertentu bisa menggunakan

PLAIN TEXT
PHP:
  1. <?php echo l('read more','taxonomy/term/47',array('class'=>'readmore')); ?>

utk detail penjelasan fungsi2 seperti l(), bisa diliat di API nya drupal

It seems you're using an unsafe, out-of-date browser. Click here to upgrade to Firefox for free. X