Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>According to <a href="http://api.cakephp.org/2.3/class-Sanitize.html#_clean" rel="nofollow">the docs</a>, the <code>clean</code> method does not do what you want.</p> <p>First, for the <code>\n</code> characters, you should call another Sanitize function. <code>Sanitize::clean()</code> has a <code>carriage</code> option, but that only removes the <code>\r</code> characters. So, after (or before) calling the <code>clean</code> method, call <a href="http://api.cakephp.org/2.3/source-class-Sanitize.html#124-132" rel="nofollow">stripWhitespaces</a>. Unfortunately, this functions only receives a string, so you need to call it in a loop (or if you know the string you want to sanitize, use it for just that).</p> <pre><code>$cleanOfSpacesString = Sanitize::stripWhitespace($dirtyString); </code></pre> <p>That function removes this characters: <code>\r</code>, <code>\n</code> and <code>\t</code>, and replace 2 or more spaces with just one.</p> <p>And for <code>&amp;</code>, the docs says that <code>remove_html</code> removes html tags and also does a <code>htmlentities($string, ENT_QUOTES, $defaultCharset, true)</code> to the string. So if that <code>htmlentities</code> is not working for you, you'll have to use another function not incuded in the <code>Sanitize</code> class.</p> <p>If you think this behaviour is something you want to have inside the helper, extend the Sanitize helper to include <code>stripWhiteSpaces</code> inside the <code>clean</code> function and to also replace the <code>htmlentities</code> function with something that works for you. If it's just for this case, add those functions in the controller, after calling <code>Sanitize::clean</code></p> <hr> <p><strong>Update as per Jason's update to my answer</strong></p> <p>I found it weird that the <code>stripWhitespaces</code> function didn't work as you wanted. And here is the explanation of why I think it didn't.</p> <p>You want to remove <code>\n</code> from a string like this </p> <pre><code>'test test\n\ntest\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n' </code></pre> <p>and the preg_replace inside stripWhitespaces is this</p> <pre><code>preg_replace('/[\n\r\t]+/', '', $str) </code></pre> <p>That regex <em>will</em> remove newlines, returns and tabs, <em>but</em> on a string like this</p> <pre><code>'test test test ' //and a lot more newlines </code></pre> <p>So the difference here is that you're passing the newlines (maybe the tabs and returns also, I don't know) as <em>strings</em>, real<code>\</code>+<code>n</code>, and so, the <code>preg_replace</code> cake does is not useful for you. I know you found a solution for that (I recommend you add the tab and return match also in there), but I wanted to clarify <em>why</em> cake's function didn't work in case someone else has a similar problem.</p>
    singulars
    1. This table or related slice is empty.
    1. POCakePHP - Sanitize::clean leaving &amp and \n
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USNunser
    1. USNunser
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POCakePHP - Sanitize::clean leaving &amp and \n
      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. VTAcceptedByOriginator
    1. COHi, thanks for the answer - it now strips the whitespace but leaves the \n's I've updated my question with more details - would you mind taking a look? Thanks
      singulars
      1. PO
      1. USJames J
    2. COShould also note I'm running 2.2.1 - http://api.cakephp.org/2.2/source-class-Sanitize.html#_stripWhitespace
      singulars
      1. PO
      1. USJames J
    3. COI've updated my answer with what I think is the reason for your `\n` been ignored :)
      singulars
      1. PO
      1. USNunser
 

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