StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>I strongly recommend a templating library like <a href="http://twig.sensiolabs.org/">Twig</a> or <a href="https://github.com/bobthecow/mustache.php">Mustache</a>. However, the basics would be to use external PHP files as HTML, and use require. Here is a bit of a hacky example:</p> <pre><code><?php $comments = array(); while (mysqli_stmt_fetch($stmt)) { $comments[] = $stmt; } require 'comments.php'; </code></pre> <p>Then in <code>comments.php</code>:</p> <pre><code><?php foreach ($comments as $comment) : ?> <tr> <td><?php echo $comment['title'] ?></td> <td><?php echo $comment['date'] ?></td> <td align='center'> <a href='#'> <span class='view' title='View This Comment'></span> </a> </td> <td class='td_catchall' align='center'> <a href='#'> <span class='edit' title='Edit This Comment'></span> </a> </td> <td align='center'> <a href='#'> <span class='delete' title='Delete This Comment'></span> </a> </td> </tr> <?php endforeach ?> </code></pre> <p>Here, I am adding each comment (or whatever it may be) to an array. Then, I include a file called <code>comments.php</code>. Your main file should be mostly PHP and should handle any logic, while <code>comments.php</code> should be mostly HTML and only use PHP for presentation (aka looping through an array and echoing out variables). </p> <p>Your required file has access to all the variables it would have access to if it were inline.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

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