Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I think there's a <em>bit</em> of a disconnect here -- at least, enough of a terminology disconnect to make it tough to parse a lot of the existing public documentation about Drupal's theming system.</p> <p>Technically, <em>all</em> of Drupal's output is templated. With a few exceptions (say, the link to a user's username) every bit of markup sits in a foo-bar.tpl.php style template file provided by a module or the current theme. Drupal modules build up data, then pass it into the templates to produce HMTL. In practice, the output from each template is nested inside of the next like a set of Matryoshka dolls. For example:</p> <pre><code>html.tpl.php (the HTML wrapper) page.tpl.php (everything inside the body tag) region.tpl.php (the 'main content' portion of the page) node.tpl.php (post in the main content) field.tpl.php (the post's "related links" field) </code></pre> <p>The <code>field.tpl.php</code> gets rendered, and concatenated with all the other fields, then that aggregate HTML becomes a variable that's passed into the <code>node.tpl.php</code> template and wrapped in other markup, which is then passed as dumb HTML into the <code>region.tpl.php</code> and... well, you get it. The good news is that you can drill down and pick out a tiny bit of markup, modifying it consistently site-wide. The bad news is that there are thousands of small templates for the individual bits of markup that make up a page.</p> <p>The nesting of the objects themselves is specified by Drupal's configuration systems, but the templates themselves still control the actual HTML output. If a theme developer <em>wants</em> to, they can dump a traditional PHP application into <code>html.tpl.php</code> and it will execute -- executing Drupal's code when pages are requested by its menu routing system but completely ignoring the output that it's generating when it comes time to print the page.</p> <p>In essence, the whole system works like a Play-Do Fun Factory. Data is shoved into the Fun Factory, and the theme system squeezes it through the templates to produce fun shapes.</p> <p>To make a long story short, it <em>is</em> possible to jam things like nav menus and so on into individual templates. But it's important to remember the nesting system -- the <code>node.tpl.php</code> template only controls the snippet of markup containing an individual post, not the wrapper around it or the page that contains it. And without writing custom code, the <code>page.tpl.php</code> template doesn't know what's <em>inside</em> its various regions; it only knows how to wrap them in the right container divs.</p> <p>The whole approach makes it very, very easy to drop in various plugin modules that add extra bits to the page, conditionally respond to what's being displayed, and so on without every touching the templates themselves -- since they simply control how each tiny element is rendered, and how the concatenated aggregates are wrapped in containing markup. On the other hand, this approach can also be maddening for someone who's used to building a complete template and pulling useful bits from the CMS to populate it. Drupal's "build stuff, then push it through the templates" approach just doesn't match the "build templates and pull stuff into them" approach many other systems use.</p> <p>There are various modules like Panels that allow site builders to take a more holistic approach to the page, its layout, and so on, but it still uses the same nested-templates approach that can make starting with the HTML tough.</p>
    singulars
    1. This table or related slice is empty.
    1. POHow does a CMS developer used to "traditional" templating learn how to love Drupal?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USEaton
    1. USEaton
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COAlso, in Drupal 8, the templates themselves are being turned into twig templates rather than our homegrown PHPTemplate system. The basic concept -- pushing data through "dumb" templates that are deeply nested within each other -- should still be there, though.
      singulars
      1. PO
      1. USEaton
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload