Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Broadly speaking, it is a bad idea to try and mix HTML markup with regex. Your results will vary -- too variation much for a reliable script. If you need to parse HTML, use the HTML parser available right in PHP, DomDocument.</p> <p>To get RID of HTML is even simpler. You can use <code>strip_tags</code> to remove any and all HTML from the string, even broken markup. Your code could simply be:</p> <pre><code>$this-&gt;return_data = strip_tags(ee()-&gt;TMPL-&gt;tagdata); </code></pre> <p>Proof of concept:</p> <pre><code>$sample1 = 'mailto:email@domain.com&lt;/p&gt;'; echo 'dirty: '.htmlentities($sample1).', clean: '.htmlentities(strip_tags($sample1)); // output: dirty: mailto:email@domain.com&lt;/p&gt;, clean: mailto:email@domain.com </code></pre> <p>See it in action here: <a href="http://codepad.viper-7.com/KHsIr0" rel="nofollow">http://codepad.viper-7.com/KHsIr0</a></p> <p>One function call, no crazy regex to maintain.</p> <hr> <p>Here is an example of how to do this with DomDocument:</p> <pre><code>// create a new DomDocument object $doc = new DOMDocument(); // load the HTML into the DomDocument object (this would be your source HTML) libxml_use_internal_errors(true); $doc-&gt;loadHTML(' &lt;p&gt; &lt;br&gt; Preston Newbill&lt;br&gt; Manager&lt;br&gt; pnewbill@domain.com&lt;br&gt; &lt;a href="mailto:noob@aol.com"&gt;also email me @ noob@aol.com&lt;/a&gt;&lt;br&gt; Party 9/15/2013@10:00pm! '); libxml_clear_errors(); // grab the body, recursively check for child nodes. Turn any email addresses into links $body = $doc-&gt;getElementsByTagName('body')-&gt;item(0); checkDomNodeForEmailAddress($body); // strip off the html,head, and body $doc-&gt;removeChild($doc-&gt;firstChild); $doc-&gt;replaceChild($doc-&gt;firstChild-&gt;firstChild-&gt;firstChild, $doc-&gt;firstChild); die('&lt;hr&gt;final product:'.htmlentities($doc-&gt;saveHtml())); function checkDomNodeForEmailAddress(DOMNode $domNode) { foreach ($domNode-&gt;childNodes as $node) { if($node-&gt;hasChildNodes()) { if (strtolower($node-&gt;nodeName) != 'a') checkDomNodeForEmailAddress($node); } else { $node-&gt;nodeValue = preg_replace('/(\S+@\S+\.[^\&lt;]+)/', '&lt;a href="mailto:$1"&gt;$1&lt;/a&gt;', $node-&gt;nodeValue); } } } </code></pre> <p>Try it here: <a href="http://codepad.viper-7.com/EpdBKx" rel="nofollow">http://codepad.viper-7.com/EpdBKx</a></p> <p><strong>Documentation</strong></p> <ul> <li><code>strip_tags</code> - <a href="http://php.net/manual/en/function.strip-tags.php" rel="nofollow">http://php.net/manual/en/function.strip-tags.php</a></li> <li>DomDocument - <a href="http://php.net/manual/en/class.domdocument.php" rel="nofollow">http://php.net/manual/en/class.domdocument.php</a></li> </ul>
    singulars
    1. This table or related slice is empty.
    1. PORemove closing paragraph tag after email address with regex
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USChris Baker
    1. USChris Baker
    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
    1. COthat would also remove ALL tags that is put in by the editor, then it would be one long text string with no formatting. Would it not?
      singulars
      1. PO
      1. USnick
    2. CO@nick I had asked what `ee()->TMPL->tagdata` is. If it is the full template's HTML, that's an even greater reason not to use regex. Regex just isn't appropriate for parsing HTML. Yes, this would strip all tags out of whatever you passed it. If you need to deal with the whole editor's text, then you really should use DomDocument. RegEx seems easier on the surface, but you'll just keep finding little edge cases that break your pattern.
      singulars
      1. PO
      1. USChris Baker
    3. CO@Chris is right. You should look into a DOM parser. You could then even do something like `document.getElementsByTagName("a");` which would quickly get you every `a` on the page, and you could easily extract the `href` attribute without needing to do any regular expressions or complicated checking.
      singulars
      1. PO
      1. UScrush
 

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