I&#39;m using `now()` in MySQL query.  

    INSERT INTO table SET data = &#39;$data&#39;, date = now()

But I want to add 1 day to this date (so that `date` should contain tomorrow).  
Is it possible?


MySQL&#39;s now() +1 day

How to set multiple columns of a table using update query in mysql?

setting multiple column using one update

I have strings like 

    var str = &#39;One &amp;amp; two &amp;amp; three&#39;;

rendered into HTML by the web server. I need to transform those strings into 

    &#39;One &amp; two &amp; three&#39;

Currently, that&#39;s what I am doing (with help of jQuery):

    $(document.createElement(&#39;div&#39;)).html(&#39;{{ driver.person.name }}&#39;).text()

However I have an unsettling feeling that I am doing it wrong.
I have tried 

    unescape(&quot;&amp;amp;&quot;)

but it doesn&#39;t seem to work, neither do decodeURI/decodeURIComponent.

Are there any other, more native and elegant ways of doing so?

Decode &amp;amp; back to &amp; in JavaScript

I have strings like
<pre><code class="hljs language-ini">var str = 'One &#x26;amp; two &#x26;amp; three';
</code></pre>
rendered into HTML by the web server. I need to transform those strings into
<pre><code class="hljs language-arduino">'One &#x26; two &#x26; three'
</code></pre>
Currently, that's what I am doing (with help of jQuery):
<pre><code class="hljs language-javascript">$(document.createElement('div')).html('{{ driver.person.name }}').text()
</code></pre>
However I have an unsettling feeling that I am doing it wrong.
I have tried
<pre><code class="hljs language-javascript">unescape("&#x26;amp;")
</code></pre>
but it doesn't seem to work, neither do decodeURI/decodeURIComponent.
Are there any other, more native and elegant ways of doing so?

I&#39;d like to do some fancy jQuery stuff when the user scrolls the page. But I have no idea how to tackle this problem, since there is only the `scroll()` method.

Any ideas?

Event when user stops scrolling

This function works perfectly on IE, Firefox and Chrome but when on the iPhone, it will only work when clicking on a `&lt;img&gt;`. Clicking on the page (anywhere but on a img) wont fire the event. 

    $(document).ready(function () {
      $(document).click(function (e) {
        fire(e);
      });
    });

    function fire(e) { alert(&#39;hi&#39;); }

The HTML part is extremely basic and shouldnt be a problem. 

Any ideas?

$(document).click() not working correctly on iPhone. jquery

How do I make a function wait until all jQuery Ajax requests are done inside another function?

In short, I need to wait for all Ajax requests to be done before I execute the next. But how?

Wait until all jQuery Ajax requests are done?

Was recently using some code along the lines of 

    $(&quot;#divMenuContainer:visible&quot;).hide(&quot;explode&quot;);

However after some time spent trying to get it to work I realized my selector was referencing a div that didnt exist.

The result of the query was simply that it didn’t execute. 

Obviously this is by design, could anyone explain the logic of why this design choice was made rather than raise some sort of exception?

Not trying to criticise just trying to understand.

Why doesn&#39;t jQuery bomb if your selector object is invalid?

    isJsonString(&#39;{ &quot;Id&quot;: 1, &quot;Name&quot;: &quot;Coke&quot; }&#39;)

should be `true` and

    isJsonString(&#39;foo&#39;)
    isJsonString(&#39;&lt;div&gt;foo&lt;/div&gt;&#39;)

should be `false`.

I&#39;m looking for a solution that doesn&#39;t use `try`/`catch` because I have my debugger set to &quot;break on all errors&quot; and that causes it to break on invalid JSON strings.

How to check if a string is a valid JSON string?

I&#39;m writing code that automatically generates HTML, and I want it to encode things properly.

Say I&#39;m generating a link to the following URL:

    http://www.google.com/search?rls=en&amp;q=stack+overflow

I&#39;m assuming that all attribute values should be HTML-encoded. (Please correct me if I&#39;m wrong.)  So that means if I&#39;m putting the above URL into an anchor tag, I should encode the ampersand as `&amp;amp;`, like this:

    &lt;a href=&quot;http://www.google.com/search?rls=en&amp;amp;q=stack+overflow&quot;&gt;

Is that correct?

Do I encode ampersands in &lt;a href...&gt;?

I&#39;ve been working on a website for a few months, and a lot of times when I&#39;ve been trying to edit something, I have to use `!important`, *for example*:

    div.myDiv { 
        width: 400px !important;
    }

in order to make it display as expected. Is this bad practice? Or is the `!important` command okay to use? Can this cause anything undesired further down the line? 

What are the implications of using &quot;!important&quot; in CSS?

I&#39;m trying to send HTML mail, with PHPMailer, with images.
The body is loaded from a html file, that contains all the info.

When sending the mail, the image does not appear in the body, although I even send the image also as an attachment.

HTML `&lt;img&gt;` tag points to the same place as the place.

PHP:

    $mail-&gt;AddAttachment(&#39;img/2u_cs_mini.jpg&#39;);

How can I make the html point to the attachment so the image can be loaded in the body.

Looking at the example that comes with PHPMailer I do not notice any difference, and in their case the image does appear.


Send email with PHPMailer - embed image in body

Would be a good or bad idea to use localStorage for sensitive data (assuming the current HTML5 implementations)?

What methods can I use to secure the data so that it cannot be read by a person that has access at the client computer?

HTML5 localStorage security

For pages already specified (either by HTTP header, or by meta tag), to have a Content-Type with a UTF-8 charset... is there a benefit of adding `accept-charset=&quot;UTF-8&quot;` to HTML forms?

(I understand the `accept-charset` attribute is broken in IE for ISO-8859-1, but I haven&#39;t heard of a problem with IE and UTF-8. I&#39;m just asking if there&#39;s a benefit to adding it with UTF-8, to help prevent invalid byte sequences from being entered.)

Is there any benefit to adding accept-charset=&quot;UTF-8&quot; to HTML forms, if the page is already in UTF-8?

I&#39;ve made a `CALayer` with an added `CATextLayer` and the text comes out blurry.  In the docs, they talk about &quot;sub-pixel antialiasing&quot;, but that doesn&#39;t mean much to me.  Anyone have a code snippet that makes a `CATextLayer` with a bit of text that is clear?

Here&#39;s the text from Apple&#39;s documentation:

&gt; Note: CATextLayer disables sub-pixel antialiasing when rendering text.
&gt; Text can only be drawn using sub-pixel antialiasing when it is
&gt; composited into an existing opaque background at the same time that
&gt; it&#39;s rasterized. There is no way to draw subpixel-antialiased text by
&gt; itself, whether into an image or a layer, separately in advance of
&gt; having the background pixels to weave the text pixels into. Setting
&gt; the opacity property of the layer to YES does not change the rendering
&gt; mode.

The second sentence implies that one can get good looking text if one `composites` it into an `existing opaque background at the same time that it&#39;s rasterized.`  That&#39;s great, but how do I composite it and how do you give it an opaque background and how do you rasterize  it?

The code they use in their example of a Kiosk Menu is as such: (It&#39;s OS X, not iOS, but I assume it works!)

    NSInteger i;
    for (i=0;i&lt;[names count];i++) {
        CATextLayer *menuItemLayer=[CATextLayer layer];
        menuItemLayer.string=[self.names objectAtIndex:i];
        menuItemLayer.font=@&quot;Lucida-Grande&quot;;
        menuItemLayer.fontSize=fontSize;
        menuItemLayer.foregroundColor=whiteColor;
        [menuItemLayer addConstraint:[CAConstraint
             constraintWithAttribute:kCAConstraintMaxY
                          relativeTo:@&quot;superlayer&quot;
                           attribute:kCAConstraintMaxY
                              offset:-(i*height+spacing+initialOffset)]];
        [menuItemLayer addConstraint:[CAConstraint
             constraintWithAttribute:kCAConstraintMidX
                          relativeTo:@&quot;superlayer&quot;
                           attribute:kCAConstraintMidX]];
        [self.menuLayer addSublayer:menuItemLayer];
    } // end of for loop 

Thanks!

---

EDIT: Adding the code that I actually used that resulted in blurry text.  It&#39;s from a related question I posted about adding a `UILabel` rather than a `CATextLayer` but getting a black box instead.  `http://stackoverflow.com/questions/3818676/adding-a-uilabels-layer-to-a-calayer-and-it-just-shows-black-box`

    CATextLayer* upperOperator = [[CATextLayer alloc] init];
    CGColorSpaceRef space = CGColorSpaceCreateDeviceRGB();
    CGFloat components1[4] = {1.0, 1.0, 1.0, 1.0};
    CGColorRef almostWhite = CGColorCreate(space,components1);
    CGFloat components2[4] = {0.0, 0.0, 0.0, 1.0};
    CGColorRef almostBlack = CGColorCreate(space,components2);
    CGColorSpaceRelease(space);
    upperOperator.string = [NSString stringWithFormat:@&quot;13&quot;];
    upperOperator.bounds = CGRectMake(0, 0, 100, 50);
    upperOperator.foregroundColor = almostBlack;
    upperOperator.backgroundColor = almostWhite;
    upperOperator.position = CGPointMake(50.0, 25.0);
    upperOperator.font = @&quot;Helvetica-Bold&quot;;
    upperOperator.fontSize = 48.0f;
    upperOperator.borderColor = [UIColor redColor].CGColor;
    upperOperator.borderWidth = 1;
    upperOperator.alignmentMode = kCAAlignmentCenter;
    [card addSublayer:upperOperator];
    [upperOperator release];
    CGColorRelease(almostWhite);
    CGColorRelease(almostBlack);

---

EDIT 2:  See my answer below for how this got solved.  sbg.

How to get text in a CATextLayer to be clear

It doesn&#39;t look like it has that attribute, but it&#39;d be really useful to me. 

Is there a way to make the Tkinter text widget read only?

Is it possible to limit a text length to &quot;n&quot; lines using CSS (or cut it when overflows vertically).

`text-overflow: ellipsis;` only works for 1 line text.  

original text:

&gt; Ultrices natoque mus mattis, aliquam, cras in pellentesque  
&gt; tincidunt elit purus lectus, vel ut aliquet, elementum nunc  
&gt; nunc rhoncus placerat urna! Sit est sed! Ut penatibus turpis  
&gt; mus tincidunt! Dapibus sed aenean, magna sagittis, lorem velit

wanted output (2 lines):

&gt; Ultrices natoque mus mattis, aliquam, cras in pellentesque  
&gt; tincidunt elit purus lectus, vel ut aliquet, elementum...


Limit text length to n lines using CSS


I know to vertically align text to the middle of a block, you set the line-height to the same height of the block.

However, if I have a sentence with a word in the middle, that is `2em`. If the entire sentence has a line-height the same as the containing block, then the larger text is vertically aligned but the smaller text is on the same baseline as the larger text.

How can I set it so both sizes of text are vertically aligned, so the larger text will be on a baseline lower than the smaller text?

  

How to vertically align 2 different sizes of text?

I have a text file added as a raw resource. The text file contains text like:

```none
b) IF APPLICABLE LAW REQUIRES ANY WARRANTIES WITH RESPECT TO THE
SOFTWARE, ALL SUCH WARRANTIES ARE 
LIMITED IN DURATION TO NINETY (90)
DAYS FROM THE DATE OF  DELIVERY.

(c) NO ORAL OR WRITTEN INFORMATION OR
ADVICE GIVEN BY  VIRTUAL ORIENTEERING,
ITS DEALERS, DISTRIBUTORS, AGENTS OR
EMPLOYEES SHALL CREATE A WARRANTY OR
IN ANY WAY INCREASE THE SCOPE OF ANY
WARRANTY PROVIDED HEREIN. 

(d) (USA only) SOME STATES DO NOT
ALLOW THE EXCLUSION OF IMPLIED
WARRANTIES, SO THE ABOVE EXCLUSION MAY
NOT  APPLY TO YOU. THIS WARRANTY GIVES
YOU SPECIFIC LEGAL  RIGHTS AND YOU MAY
ALSO HAVE OTHER LEGAL RIGHTS THAT 
VARY FROM STATE TO STATE.
```

On my screen I have a layout like this:

    &lt;LinearLayout  xmlns:android=&quot;http://schemas.android.com/apk/res/android&quot;
    					 android:layout_width=&quot;fill_parent&quot; 
    			    	 android:layout_height=&quot;wrap_content&quot; 
    			    	 android:gravity=&quot;center&quot; 
    			    	 android:layout_weight=&quot;1.0&quot;
    			    	 android:layout_below=&quot;@+id/logoLayout&quot;
    			    	 android:background=&quot;@drawable/list_background&quot;&gt; 
    		    
    		    &lt;ScrollView android:layout_width=&quot;fill_parent&quot;
       						android:layout_height=&quot;fill_parent&quot;&gt;
       						
    					&lt;TextView  android:id=&quot;@+id/txtRawResource&quot; 
    					           android:layout_width=&quot;fill_parent&quot; 
    			    	 		   android:layout_height=&quot;fill_parent&quot;
    			    	 		   android:padding=&quot;3dip&quot;/&gt;
    			&lt;/ScrollView&gt;  
	   
    	&lt;/LinearLayout&gt;

The code to read the raw resource is:

    TextView txtRawResource= (TextView)findViewById(R.id.txtRawResource);

    txtDisclaimer.setText(Utils.readRawTextFile(ctx, R.raw.rawtextsample);

    public static String readRawTextFile(Context ctx, int resId)
    {
        InputStream inputStream = ctx.getResources().openRawResource(resId);

        ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream();

        int i;
        try {
            i = inputStream.read();
            while (i != -1)
            {
                byteArrayOutputStream.write(i);
                i = inputStream.read();
            }
            inputStream.close();
        } catch (IOException e) {
            return null;
        }
        return byteArrayOutputStream.toString();
    }

The text is shown but after each line I get the strange characters `[]`. How can I remove the characters? I think it&#39;s a newline.

Android read text raw resource file

Why is the below item failing? Why does it succeed with &quot;latin-1&quot; codec?


    o = &quot;a test of \xe9 char&quot; #I want this to remain a string as this is what I am receiving
    v = o.decode(&quot;utf-8&quot;)

Which results in:

     Traceback (most recent call last):  
     File &quot;&lt;stdin&gt;&quot;, line 1, in &lt;module&gt;  
     File &quot;C:\Python27\lib\encodings\utf_8.py&quot;,
     line 16, in decode
         return codecs.utf_8_decode(input, errors, True) UnicodeDecodeError:
     &#39;utf8&#39; codec can&#39;t decode byte 0xe9 in position 10: invalid continuation byte

UnicodeDecodeError, invalid continuation byte

I&#39;m not sure what this is called so I&#39;m having trouble searching for it. How can I decode a string with unicode from `http\u00253A\u00252F\u00252Fexample.com` to `http://example.com` with JavaScript? I tried `unescape`, `decodeURI`, and `decodeURIComponent` so I guess the only thing left is string replace.

EDIT: The string is not typed, but rather a substring from another piece of code. So to solve the problem you have to start with something like this:

    var s = &#39;http\\u00253A\\u00252F\\u00252Fexample.com&#39;;

I hope that shows why unescape() doesn&#39;t work.

How do I decode a string with escaped unicode?

I&#39;m trying to get a Python 3 program to do some manipulations with a text file filled with information. However, when trying to read the file I get the following error:
```
Traceback (most recent call last):  
   File &quot;SCRIPT LOCATION&quot;, line NUMBER, in &lt;module&gt;  
     text = file.read()` 
   File &quot;C:\Python31\lib\encodings\cp1252.py&quot;, line 23, in decode  
     return codecs.charmap_decode(input,self.errors,decoding_table)[0]
UnicodeDecodeError: &#39;charmap&#39; codec can&#39;t decode byte 0x90 in position 2907500: character maps to `&lt;undefined&gt;`  
```

UnicodeDecodeError: &#39;charmap&#39; codec can&#39;t decode byte X in position Y: character maps to &lt;undefined&gt;

I have php document signup.php which save the content from form (in form.php document) to MySQL base. The problem arises when I want to reformat the input content. I want do decode UTF-8 charachters like  &#224;-&gt;a.

      $first_name=$_POST[&#39;first_name&#39;];
      $last_name=$_POST[&#39;last_name&#39;];
      $course=$_POST[&#39;course&#39;];
    
      $chain=&quot;pr&#234;t-&#224;-porter&quot;;
    
    $pattern = array(&quot;&#39;&#233;&#39;&quot;, &quot;&#39;&#232;&#39;&quot;, &quot;&#39;&#235;&#39;&quot;, &quot;&#39;&#234;&#39;&quot;, &quot;&#39;&#201;&#39;&quot;, &quot;&#39;&#200;&#39;&quot;, &quot;&#39;&#203;&#39;&quot;, &quot;&#39;&#202;&#39;&quot;, &quot;&#39;&#225;&#39;&quot;, &quot;&#39;&#224;&#39;&quot;, &quot;&#39;&#228;&#39;&quot;, &quot;&#39;&#226;&#39;&quot;, &quot;&#39;&#229;&#39;&quot;, &quot;&#39;&#193;&#39;&quot;, &quot;&#39;&#192;&#39;&quot;, &quot;&#39;&#196;&#39;&quot;, &quot;&#39;&#194;&#39;&quot;, &quot;&#39;&#197;&#39;&quot;, &quot;&#39;&#243;&#39;&quot;, &quot;&#39;&#242;&#39;&quot;, &quot;&#39;&#246;&#39;&quot;, &quot;&#39;&#244;&#39;&quot;, &quot;&#39;&#211;&#39;&quot;, &quot;&#39;&#210;&#39;&quot;, &quot;&#39;&#214;&#39;&quot;, &quot;&#39;&#212;&#39;&quot;, &quot;&#39;&#237;&#39;&quot;, &quot;&#39;&#236;&#39;&quot;, &quot;&#39;&#239;&#39;&quot;, &quot;&#39;&#238;&#39;&quot;, &quot;&#39;&#205;&#39;&quot;, &quot;&#39;&#204;&#39;&quot;, &quot;&#39;&#207;&#39;&quot;, &quot;&#39;&#206;&#39;&quot;, &quot;&#39;&#250;&#39;&quot;, &quot;&#39;&#249;&#39;&quot;, &quot;&#39;&#252;&#39;&quot;, &quot;&#39;&#251;&#39;&quot;, &quot;&#39;&#218;&#39;&quot;, &quot;&#39;&#217;&#39;&quot;, &quot;&#39;&#220;&#39;&quot;, &quot;&#39;&#219;&#39;&quot;, &quot;&#39;&#253;&#39;&quot;, &quot;&#39;&#255;&#39;&quot;, &quot;&#39;&#221;&#39;&quot;, &quot;&#39;&#248;&#39;&quot;, &quot;&#39;&#216;&#39;&quot;, &quot;&#39;œ&#39;&quot;, &quot;&#39;Œ&#39;&quot;, &quot;&#39;&#198;&#39;&quot;, &quot;&#39;&#231;&#39;&quot;, &quot;&#39;&#199;&#39;&quot;);
    
    $replace = array(&#39;e&#39;, &#39;e&#39;, &#39;e&#39;, &#39;e&#39;, &#39;E&#39;, &#39;E&#39;, &#39;E&#39;, &#39;E&#39;, &#39;a&#39;, &#39;a&#39;, &#39;a&#39;, &#39;a&#39;, &#39;a&#39;, &#39;A&#39;, &#39;A&#39;, &#39;A&#39;, &#39;A&#39;, &#39;A&#39;, &#39;o&#39;, &#39;o&#39;, &#39;o&#39;, &#39;o&#39;, &#39;O&#39;, &#39;O&#39;, &#39;O&#39;, &#39;O&#39;, &#39;i&#39;, &#39;i&#39;, &#39;i&#39;, &#39;I&#39;, &#39;I&#39;, &#39;I&#39;, &#39;I&#39;, &#39;I&#39;, &#39;u&#39;, &#39;u&#39;, &#39;u&#39;, &#39;u&#39;, &#39;U&#39;, &#39;U&#39;, &#39;U&#39;, &#39;U&#39;, &#39;y&#39;, &#39;y&#39;, &#39;Y&#39;, &#39;o&#39;, &#39;O&#39;, &#39;a&#39;, &#39;A&#39;, &#39;A&#39;, &#39;c&#39;, &#39;C&#39;); 
    
    $chain = preg_replace($pattern, $replace, $chain);
    
    echo $chain; // print pret-a-porter
    
    $first_name =  preg_replace($pattern, $replace, $first_name);
    
    echo $first_name; // does not change the input!?!


Why it works perfectly for $chain, but for $first_name or $last_name doesnt work?




Also i try

    echo $first_name; // print &#225;&#225;&#225;&#225;&#225;&#225;b&#233;&#233;&#233;&#233;&#233;&#233;bšššš
    $trans = array(&quot;&#225;&quot; =&gt; &quot;a&quot;, &quot;&#233;&quot; =&gt; &quot;e&quot;, &quot;š&quot; =&gt; &quot;s&quot;);
    echo strtr(&quot;&#225;&#225;&#225;&#225;&#225;&#225;b&#233;&#233;&#233;&#233;&#233;&#233;bšššš&quot;, $trans); // print aaaaaabeeeeeebssss
    echo strtr($first_name,$trans);  // print &#225;&#225;&#225;&#225;&#225;&#225;b&#233;&#233;&#233;&#233;&#233;&#233;bšššš

but the problem, as you can see, is same!

PHP replacing special characters like &#224;-&gt;a, &#232;-&gt;e

I need to encode some data in the Base64 encoding in Java. How do I do that? What is the name of the class that provides a Base64 encoder?

---

I tried to use the `sun.misc.BASE64Encoder` class, without success. I have the following line of Java 7 code:

    wr.write(new sun.misc.BASE64Encoder().encode(buf));

I&#39;m using Eclipse. Eclipse marks this line as an error. I imported the required libraries:

    import sun.misc.BASE64Encoder;
    import sun.misc.BASE64Decoder;

But again, both of them are shown as errors. I found [a similar post here][1].

I used Apache Commons as the solution suggested by including:

    import org.apache.commons.*;

and importing the JAR files downloaded from: http://commons.apache.org/codec/

But the problem still exists. Eclipse still shows the errors previously mentioned. What should I do?

  [1]: https://stackoverflow.com/questions/5549464/import-sun-misc-base64encoder-got-error-in-eclipse



Decode & back to & in JavaScript

Javascript Problem Overview

Javascript Solutions

setting multiple column using one update

MySQL's now() +1 day

Attributions