How can I JSON_decode arrays that has been treated with mysqli_real_escape_string, htmlspecialchars,strip_tags?
How can I prevent SQL injection in PHP?
GetFeatureInfo from Image WMS How to pack the game files into one without using any file compressor? Well, one example is this file of the game The Sims 2 for PS2: quickdat.arc. The file contains this .arc extension, but it's no one an archive file and it contains some data of the game inside. How can I do this? Put so many files in one?  How to do something like this? All the game files inside one without using a file compressor? How does the Battle Booster work? I received the 80% battle point booster. It has 500 minutes on it and says the booster is only consumed when battle points are earned. Does this mean I can play 500 minutes of matches during a week and earning the bonus points? Or does it wear off in 500 minutes after equipping it?  Also it says my team is granted a 16% bonus. Does this stack? Do i get another 16% if I and another player wears it? Since it's a new item with the present chest it would be wise to use it later if the bonus does not stack. Analytic continuation of a power series 2 Another Qual question here,  For the function $$\sum_{n=0}^\infty z^{2^n}$$,  Prove the following:  i) $f$ converges to a function analytic in the open unit disk $D$,  ii) $f(z) =z+f(z^2)$ and  iii) $f(z)$ can not be analytically continued past any point on the unit circle.  I can even see (ii) very easily, but I can not see how can I prove rigorously (i) and  (iii). Help please. Why is Steam only showing me "Buy" instead of "Play" option for a game shared via Family Sharing? I thought the whole point of Family Sharing was so that multiple copies of the game didn't have to be bought. I have no problem downloading the game, but instead of "Play", my only option once it's downloaded is "Buy". Am I missing something? LEFT JOIN vs. LEFT OUTER JOIN in SQL Server What is the difference between LEFT JOIN and LEFT OUTER JOIN? $$ x^2+2(1+a)x+(3a^2+4ab+4b^2+2)=0$$  I tried to make an inequality using the discriminant and I simplified it to get $$a^2+2ab+b^2+\frac{1}{2}≤0$$  But I don't know how to solve this. Has a free neutron ever been shown to absorb/emit/interact with a photon? Protons only 'interact with' very high-energy photons, whether inside a nucleus or free, right?  I'm assuming the same about neutrons....  Neutrons have a small magnetic moment and a slight electric 'moment' (dipole?), correct?  They are sometimes considered to consist of a negative charge surrounding a positive charge?  I would assume that neutrons, in a nucleus or free, interact with photons even less often than protons, and that the gamma photon has to have an even higher energy than one interacting with a proton....  Lastly, I have read about 'photodisintegration', in which a nucleon is kicked out of a nucleus by a gamma ray.  It seems to happen to neutrons sometimes...  But, I am mostly curious about experimental evidence of free neutrons interacting with photons, how often it happens compared to free protons, and whether the interacting photon's energy has to be extremely high, higher even than a photon interacting with a proton... We are beginning to go down the path of mobile browser support for an enterprise e-commerce webapp (Java/Servlet based).  Of course there are many decisions to be made, but it seems to me the cornerstone is to be able to reliably detect mobile browsers, and make decisions on the content to be returned accordingly.  Is there a standard way to make this determination (quickly) based on the http request, and ideally glean more information about the given browser and device making the request (screen size, html capabilities, etc?).  I would also appreciate any supplemental information that would be of use from someone who has gone down this path of taking an existing large scale enterprise webapp and architect-ing out mobile browser support from the development side.  [edit] I certainly understand the request header and the information about a database of standard user agents is a great help.  For those talking about 'other' request header properties, if you could include similar standardized name / resource of values that would be a big help.  [edit] Several users have proposed solutions that involve a call over the wire to some web service that will do the detection.  While I'm sure this works, it is not a good solution for an enterprise e-commerce site for two reasons: 1) speed.  A call over the wire for every page request to a third party would have huge performance implications.  2) dependency/legal.  We'd tie our website response time and key functionality to their service, which is horrible for legal and risk reasons. How do I drag and drop files into an application? I've seen this done in Borland's  environment, but I'm not sure how to go about it for a C# application I'm working on. Are there best practices or gotchas to look out for? Over the years I have slowly developed a  that validates MOST email addresses correctly, assuming they don't use an IP address as the server part.  I use it in several PHP programs, and it works most of the time.  However, from time to time I get contacted by someone that is having trouble with a site that uses it, and I end up having to make some adjustment (most recently I realized that I wasn't allowing 4-character TLDs).  What is the best regular expression you have or have seen for validating emails?  I've seen several solutions that use functions that use several shorter expressions, but I'd rather have one long complex expression in a simple function instead of several short expression in a more complex function. Printing out Stack Overflow/Exchange Q&As including comments? Is there any option with 'ls' command that I see only the directories? Sometimes, I need to check only the directories not files. Is there any option with the command ls? Or is there any utility for doing that?  EDIT: I'm using Mac OS X, and ls -d gives me . even though I have directories. What is the standard error of the sample standard deviation? I read from  that the standard error of the sample variance is  $$SE_{s^2} = \sqrt{\frac{2 \sigma^4}{N-1}}$$  What is the standard error of the sample standard deviation?  I'd be tempted to guess and say that $SE_{s} = \sqrt{SE_{s^2}}$ but I am not sure. Georeferencing old map in QGIS? I have an old map over a part of Laos and wondering how do I georeference the map with the help of the Grid lines and other Longitude and Latitude information on the scanned map? I have searched for information on the internet and tried many times. My scanned map wont overly correctly on the base map. Any base map would be fine. As long as I can check the result.  Do I add X/East and Y/North values from the grid line crossings as marked and written in some parts of the map? How do I begin georeferencing this map? Do I have to add zeros after the two digits? For example if the Easting is 24 (its in KM right? Do I add like three/four zeros to convert it to meters?  I georeferenced the map with the option "From Map Canvas" in the georeferencer tool and I succeeded but I want to know the coordinate of a point on my old scanned map and write them as X/East and Y/North to georeference the map.   I hope I am not babbling and someone understands what I mean!  We can set the CRS to WGS84, EPSG:4326. How to export and import mysql database with its data using php script? Proving that cardinality of the reals = cardinality of $[0,1]$ Homework problem, intro to topology. Here's what I've done so far. Am I on the right track? And, how would you advise me to proceed from here?  I have already established that $\left |[0,1] \right | = \left |[0,1) \right|$. Now I wish to show that $\left |[0,1) \right| = \left |\mathbb{R} \right |$. I will try to do this by constructing a bijection $f: [0,1) \rightarrow \mathbb{R}$.  Given $x \in [0,1)$, consider the following countably infinite subset of $\mathbb{R}$: $x^c = \{x+1, x-1, x+2,x-2,x+3,x-3,\ldots   \}$.  Then we have that $$ \bigcup_{x \in [0,1)} x^c = \mathbb{R}, $$ and if $x_1, x_2 \in [0,1)$ with $x_1 \neq x_2$, then $x_1^c \cap x_2^c = \varnothing$. Textarea CSS issue on "needs moderator attention" To reproduce:   Click Flag (question or answer) Click other (needs moderator attention)   The textarea is too wide:  StackOverflow        AskUbuntu        StackExchange        Most probably affects other sites, but didn't check. I think it's enough. :-)  Reproducing on:   Chromium Version 40.0.2214.111 Ubuntu 15.04 (64-bit) Google Chrome Version 41.0.2272.76 (64-bit) Firefox 36.0   (I'm using Ubuntu 15.04) uwsgi errno 24 too many open files on CentOS / nginx WhatsApp for Ubuntu Phone? Does someone know if there already is a WhatsApp Version for Ubuntu Phone? I decided to install Ubuntu on my Android, but I don't want to use my phone without WhatsApp.