Cacher is the code snippet organizer for pro developers

<?php
  echo '------------------------PAGES---------------------------------';
  $output = '';
  $w = Mage::getSingleton('core/resource')->getConnection('core_write');
  $result = $w->query("SELECT title,content,root_template FROM cms_page WHERE is_active = '1'");
  
  if (!$result) {
   $output = '<textarea cols="100%" rows="10"> Not found </textarea>';
  } else {
    $output .= '<textarea cols="100%" rows="20">';
    while ( $row = $result->fetch(PDO::FETCH_ASSOC) ) {
     $output .= "Title: ".$row['title']."\n";
     $output .= "Template: ".$row['root_template']."\n";
     $output .= "Content: \n\n".$row['content']."\n\n";
     $output .= "---------------------------------------------------------------\n\n";
    }
    $output .= '</textarea>';
    echo $output;
  }
?>

<?php

  echo '------------------------BLOCKS---------------------------------';
  $output = '';
  $w = Mage::getSingleton('core/resource')->getConnection('core_write');
  $result = $w->query("SELECT title, identifier, content FROM cms_block WHERE is_active = '1'");
  
  if (!$result) {
   $output = '<textarea cols="100%" rows="10"> Not found </textarea>';
  } else {
    $output .= '<textarea cols="100%" rows="20">';
    while ( $row = $result->fetch(PDO::FETCH_ASSOC) ) {
     $output .= "Title: ".$row['title']."\n";
     $output .= "Identifier: ".$row['identifier']."\n";
     $output .= "Content: \n\n".$row['content']."\n\n";
     $output .= "---------------------------------------------------------------\n\n";
    }
    $output .= '</textarea>';
    echo $output;
  }

?>