Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I would first like to say, are you creating your own template library? There are some mature ones around like <a href="http://www.smarty.net/" rel="nofollow noreferrer">Smarty</a> which should be able to fill your requirements. This article by Jeff Atwood is also good read : "<a href="http://www.codinghorror.com/blog/archives/001145.html" rel="nofollow noreferrer">Don't Reinvent The Wheel, Unless You Plan on Learning More About Wheels</a>"</p> <p>If you want to roll your own solution then that is fine, here are some suggestions.</p> <h1>BBCode</h1> <hr> <p>This method relies on having the BBCode extension installed with PHP, it is native and does not rely on the regular expression engine (slow). This solution will <em>probably</em> be the fastest.</p> <p>You can have the BBCode parser convert </p> <pre><code>[LOOP]&lt;td&gt;&lt;?php print $row-&gt;title; ?&gt;&lt;/td&gt;[/LOOP] </code></pre> <p>into</p> <pre><code>&lt;?php foreach($result as $row): ?&gt;&lt;td&gt;&lt;?php print $row-&gt;title; ?&gt;&lt;/td&gt;&lt;?php endforeach; ?&gt; </code></pre> <p>Look into the BBCode arguments to learn about passing variables into your [LOOP] syntax.</p> <p>You can view some more examples on the <a href="http://uk.php.net/manual/en/function.bbcode-create.php" rel="nofollow noreferrer">bbcode_create</a> method page.</p> <h1><strong>Regular Expressions</strong></h1> <hr> <p>They are a little bit slower, but are enabled by default on all PHP installations. </p> <p>Credits to go Gumbo for this regular expression (You should up-vote him).</p> <pre><code>/\[LOOP]((?:[^[]+|\[(?=\/LOOP]))*)\[\/LOOP]/ </code></pre> <p>You can then use it as follows.</p> <pre><code>if (preg_match('%\[LOOP\]((?:[^[]+|\[(?=/LOOP\]))*)\[/LOOP\]%i', $subject, $result)) { # Successful match # You can access the content using $result[1]; } else { # Match attempt failed } </code></pre> <p>-Mathew</p>
    singulars
    1. This table or related slice is empty.
    1. POhow to get string between [LOOP]...[/LOOP]
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USThe Pixel Developer
    1. USThe Pixel Developer
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POhow to get string between [LOOP]...[/LOOP]
      singulars
      1. PTQuestion
    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
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWith (.*?) it would still match "[LOOP]...[LOOP]...[/LOOP]". I think the OP had that part right: ([^\]]*). Assuming, of course, there can't be any brackets other than those in the tags. But that's a side issue; the real problem lay in trying to use preg_replace instead of preg_match. +1
      singulars
      1. PO
      1. USAlan Moore
    2. COAh yes, good point. The regex posted by Gumbo below solves this issue.
      singulars
      1. PO
      1. USThe Pixel Developer
 

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