MYSQL + PHP : "error in SQL syntax" when updating table using array and variables
How can I prevent SQL injection in PHP?
How do I capture the moon and its surrounding context? I wanted to photograph the full moon against a beautiful deep blue sky. I ended up with blown-out highlights of the moon:    So I switched to spot metering and captured the moon, losing the blue sky in the process:    I want a single photo that shows both the moon and the surrounding context (in this case, the blue sky). Doing an exposure fusion in Photomatix Essentials did not help:    Nor did HDR fusion (again in Photomatix):    Notice that the detail in the moon was lost in both cases, and the sky was also messed up in both cases: exposure fusion lost the beautiful blue color, while HDR created more texture than was actually present in the sky. I toggled Photomatix's option to remove ghosts, but that didn't help, either.  How do I photograph the moon together with its surrounding context (in this case, the blue sky, but in other cases, a tree, buildings, etc) without blowing highlights or shadows? I'm using a Sony NEX-5R, with the longest focal length lens I have, and with manual focus when needed.  Thinking I should fuse the photos manually, I tried opening the images as layers in Acorn, with the darker photo on top and with opacity set to 50%, and tried all 15 - 20 blending modes (normal, dodge, lighter, darker, multiply and so on), but none of them seemed to work. I'm afraid I don't know enough to use layers effectively. What blending mode and opacity and order of layers should I use for this task?  I don't have Photoshop, but do have Lightroom 5, Acorn and Nik Collection.  (In case you are about to recommend software, please note my requirements: I use a Mac, I would be willing to pay $20-30, and I don't want to use command-line software.) How to change color of the text in TextView on hover like in css? I have this  problem with Ubuntu 16.04 LTS. All programs and all menus have black boarders and Terminal is displayed black:    The problem appeared after installing  tool and installing all Kali Tools. Novel about alien conquerers who conduct games to select servants I read this maybe 10-15 years ago.   Aliens have conquered earth. Possibly quite some time before the time then novel is set in. They have built their own cities. They conduct periodic athletic competitions for humans similar to the current olympics. The winners are take into the city to act as servants to the masters. The protagonist is part of a human resistance movement who is competing in the games. The plan is to infiltrate the city, gather intel and escape. He wins, get in, finally has to kill his master and escape down a waste disposal system which ends up outside the city.   Anybody knows which one I am talking about? Battery Ampere-hour rating vs Battery Amps (not an experienced user) I have almost no experience whatsoever with the technicals of electronics so this is probably a very easy question for someone who does.  Do you know if a battery with a 200Ah rating can put out 200A for one hour or are there limitations? According to this website's third paragraph (), you can.     For example, an average automotive battery might have a capacity of about 70 amp-hours, specified at a current of 3.5 amps. This means that the amount of time this battery could continuously supply a current of 3.5 amps to a load would be 20 hours (70 amp-hours / 3.5 amps). But let’s suppose that a lower-resistance load were connected to that battery, drawing 70 amps continuously. Our amp-hour equation tells us that the battery should hold out for exactly 1 hour (70 amp-hours / 70 amps), but this might not be true in real life. With higher currents, the battery will dissipate more heat across its internal resistance, which has the effect of altering the chemical reactions taking place within. Chances are, the battery would fully discharge some time before the calculated time of 1 hour under this greater load.   But wouldn't that mean you could hook up a 200Ah battery and ask it to put out 12000A for one minute or 720000A for a second?  That seems very unrealistic, lol.  I'm trying to find the proper kind of off grid battery that can power a microwave through a 3000 watt power inverter.  The microwave needs 1800 watts and the battery needs to be 12 volts so that would mean I need about 150 amps, I'm wondering if a battery with a 200Ah rating could do it? Tikzpicture-figure: Order plot data (asc/desc)? I am using a tikzpicture for plotting. the values I want to plot are typical (X,Y) pairs. The x-value is an uninteresting id-value. I want to order the bins ascending/descending according to the y-value, but how do I do that? The figure seems to automatically take the x-values for ordering, how can I override that? (I am not particularly fixed to tikzpicture - its just the first thing that actually worked and displayed the plot....) Following minimal-working example, how could I achieve a reordering according to the y-value?  \documentclass{article} \usepackage[english]{babel} \usepackage[T1]{fontenc} \usepackage[utf8]{inputenc} \usepackage{relsize} \usepackage{times} \usepackage{url} \usepackage{latexsym} \usepackage{graphicx} \usepackage{colortbl} \usepackage{color} \usepackage{caption} \usepackage{pgfplots, pgfplotstable} \usetikzlibrary{arrows} \usepackage{amsmath} \usepackage{multirow} \usepackage{booktabs}  \usepackage{filecontents} \definecolor{OgAns}{rgb}{0, 0.8, 0.4}  \begin{filecontents}{testdata.dat} 1   30 2   44 4   26 3   39 \end{filecontents}  \begin{document} \begin{figure} \begin{tikzpicture}         \begin{axis}[                ybar stacked,             ymin=0,             ymax=100,             bar width=5pt,             legend style={at={(0.35, -0.4)},anchor=south west},             legend columns=-1                       ]           \addplot[ybar,fill=OgAns]  file {testdata.dat};          \end{axis}     \end{tikzpicture} \end{figure}   \end{document} How can I (in order of preference, descending):   Disable file-server access to a specific share for a user or group based on the time of day. Disable file-server access entirely for a user or group based on the time of day Disable file-server access entirely (server-scope) based on the time of day. This is not at all related to Remote Desktop/RDP access.   For example, Bob is in the group WorkHours. The share "Documents" grants access to users in the group WorkHours. How do I deny access to all files in the share "Documents" from 7PM to midnight, every day, automatically? What's a word for someone who is constantly asking for same thing? How can I distribute a native executable for a Python program? How to uninstall Intel Linux Graphics Installer and revert to default drivers Do opposite categories always exist? How do I create bookmarks with pdfLaTeX? I'm using MiKTeX and using pdfLaTeX. I can generate the PDF, but there are no bookmarks. In the .tex-file it is using:  \chapter \section \subsection   (with labels)  I originally used make with sphinx to output LaTeX. It must work somewhat or I wouldn't get the PDF. When I say bookmarks, I mean when you are in Acrobat and the left side has the Bookmarks panel.  I am reading   But I am not sure where to apply this.  EDIT:  I applied this, \usepackage{bookmark}, and got bookmarks, but I never get the subsection bookmarks. IndentationError: unindent does not match any outer indentation level What to do to switch to biblatex? Because of the great answers posted around in the site, I'm finally considering to do the switch and move to biblatex. So, the question is what do I have to do?  To give the question some focus, assume that I already have a somewhat largish .bib file and a bunch of documents using natbib for my references. What do I have to change in my existing .bib and .tex files?  And what about coauthors? Would it be reasonably simple to instruct them how to work with the new documents using biblatex? Do they have to install new software/packages as well? Does the series $\sum_{n=1}^{\infty}|x|^\sqrt n$ converge pointwise? If it then what would be the sum? This is a continued discussion from () by return count only.     Problem      Given four lists A, B, C, D of integer values, compute how many tuples   (i, j, k, l) there are such that A[i] + B[j] + C[k] + D[l] is zero.      To make problem a bit easier, all A, B, C, D have same length of N   where \$0 \le N \le 500\$. All integers are in the range of \$-2^{28}\$ to \$2^{28} - 1\$   and the result is guaranteed to be at most \$2^{31} - 1\$.      Example:      Input:  A = [ 1, 2] B = [-2,-1] C = [-1, 2] D = [ 0, 2]       Output:  2       Explanation:      The two tuples are:         (0, 0, 0, 1) -> A[0] + B[0] + C[0] + D[1] = 1 + (-2) + (-1) + 2 = 0   (1, 1, 0, 0) -> A[1] + B[1] + C[0] + D[0] = 2 + (-1) + (-1) + 0 = 0      I'm wondering if there are any ideas to have a solution less than \$O(n^2)\$ time complexity.  Source code in Python 2.7,  from collections import defaultdict def four_sum(A, B, C, D):     sum_map = defaultdict(int)     result = 0     for i in A:         for j in B:             sum_map[i+j] += 1     for i in C:         for j in D:             if -(i+j) in sum_map:                 result += sum_map[-(i+j)]      return result  if __name__ == "__main__":     A = [1, 2]     B = [-2, -1]     C = [-1, 2]     D = [0, 2]     print four_sum(A,B,C,D) # and ## in macros What type of path in shebang is more preferable? Is Cyclops’ mutant power just an organic version of Iron Man's repulsor tech? They occupy the same universe so we have to assume the same physics apply. Iron Man's repulsor tech is described as an inertia-less one-way kinetic blast. At higher energy levels, it can can even disintegrate matter in front of it. Cyclops’ eye beams are described exactly the same way. Is there any place in comics or the animation where the two beams are shown to have different powers? Can a Muggle inadvertently create a horcrux-like object? I think that we have it well-established (regardless of whether or not one sees this as flawed logic) that Harry is not a Horcrux.  A Horcrux has to be made intentionally, and the recipient is cursed and classified as an "evil object," etc.  Neither of which is true for Harry - so, as stated by JKR herself, Harry is not a Horcrux as such.  But the fact remains that murder can, in fact, accidentally create something that shares a key property of the Horcrux: the soul splits, attaches itself to the nearest recipient, and lingers inside.  As it does in Harry's case.  So my question is: is this only true for wizards?  A Muggle cannot utilize a spell to create a Horcrux.  But, if a Horcrux-like object / being can be created accidentally through murder without intentional Horcrux-creating spells, can this also happen in the case of a Muggle committing murder?    Can a Muggle commit murder, have their soul split, and have the piece of the soul inadvertently attach itself to something nearby without any Horcrux-creating spell being cast?