Try this:

    $sql = &quot;SELECT *
        FROM albums
        WHERE name NOT IN ( &#39;&quot; . implode( &quot;&#39;, &#39;&quot; , $ban_album_names ) . &quot;&#39; )&quot;;

The MySQL CODE is

    SELECT * FROM albums WHERE name NOT IN (&#39;Wall&#39;, &#39;Profile&#39;, &#39;Cover&#39;, &#39;Instagram&#39;)



How can I create a blank png UIImage in Objective C programmatically (let&#39;s say 36x36 px)?

Thanks :)

How to create a blank transparent png in Objective-C?

I develop plugins for WordPress. It uses some jquery in the user side (themes) as a jquery plugin.
The problem is, when there is an javascript error with other plugins made by other autors, my plugin&#39;s javascript fails to execute.

And the worst thing is people consider that there is a serious fault with my plugin even though it works 100% fine with error handling conditional statements. But it is actually due to some other javascript syntax errors of some other WP plugin/theme authors.

Is there a way to continue execute my plugin JS ignoring other JS errors. Or can i have suggestions to handle this problem ??

![enter image description here][1]


  [1]: http://i.stack.imgur.com/WH3qU.png

Ignore javascript syntax errors in a page and continue executing the script

I would like to exclude these albums, that has name:

    $ban_album_names = array(&#39;Wall&#39;, &#39;Profile&#39;, &#39;Cover&#39;, &#39;Instagram&#39;);

How do I write correctly,

    SELECT * FROM albums WHERE name NOT IN ???

How can I make it look in the array, and if the name matches it should != the row

MySQL where NOT IN name array?

I would like to exclude these albums, that has name:
<pre><code class="hljs language-ini">$ban_album_names = array('Wall', 'Profile', 'Cover', 'Instagram');
</code></pre>
How do I write correctly,
<pre><code class="hljs language-sql">SELECT * FROM albums WHERE name NOT IN ???
</code></pre>
How can I make it look in the array, and if the name matches it should != the row

How do you prevent multiple clients from using the same session ID? I&#39;m asking this because I want to add an extra layer of security to prevent session hijacking on my website. If a hacker somehow figures out another user&#39;s session ID and makes requests with that SID, how can I detect that there are different clients sharing a single SID on the server and then reject the hijack attempt?

**EDIT**

I have accepted Gumbo&#39;s answer after careful consideration because I&#39;ve come to the realization that what I&#39;m asking for is impossible due to the restrictions of a *stateless HTTP protocol*. I forgot about what is perhaps the most fundamental principle of HTTP, and now that I think about this question seems a bit trivial.

Let me elaborate what I mean:

After User A logs in on example.com, he is given some random session ID, for simplicity&#39;s sake, let it be &#39;abc123&#39;. This session ID is stored as a cookie on the client side and is validated with a server-side session to ensure the user who logged in remains logged in as he moves from one webpage to another. This cookie of course would not need to exist if HTTP were not stateless. For that reason, if User B steals User A&#39;s SID, and creates a cookie on his computer with the value &#39;abc123&#39;, he would have successfully hijacked User A&#39;s session, but there is simply no way for the server to legitimately recognize that User B&#39;s request is any different from User A&#39;s requests, and therefore the server has no reason to reject any request. Even if we were to list the sessions that were already active on the server and try to see if someone is accessing a session that is already active, how can we determine that it is another user who is accessing the session illegitimately and not the same user who is already logged in with a session ID, but simply trying to make another request with it (ie navigate to a different webpage). We can&#39;t. Checking the user agent? Can be spoofed - but good as a Defense in Depth measure nevertheless. IP Address? Can change for legitimate reasons - but instead of not checking for the IP address at all, I suggest checking something like the first two octets of the IP, as even a user on a data plan network who constantly has a changing IP for perfectly legitimate reasons would only usually have the last two octets of their IP change.

In consclusion, it is the stateless HTTP that condemns us to never being able to fully protect our websites from session hijacking, but good practices (like the ones Gumbo has provided) will be good enough to prevent a good majority of session attacks. Trying to protect sessions from hijacking by denying multiple requests of the same SID is therefore simply ludicrous, and would defeat the whole purpose of sessions.

Preventing session hijacking

I used **python -m SimpleHTTPServer**, but the PHP files don&#39;t execute instead they just been downloaded.

I heard about [WPHP][1] in an old [post][2]. But I don&#39;t know how to use it.
How I can work with it ?


  [1]: http://pythonpaste.org/wphp/
  [2]: https://stackoverflow.com/questions/9900706/simple-python-server-similar-to-simplehttpserver-but-with-php-support

Python SimpleHTTPServer with PHP

I need to round down a decimal in PHP to two decimal places so that:

    49.955

becomes...

    49.95

I have tried **number_format**, but this just rounds the value to **49.96**. I cannot use **substr** because the number may be smaller (such as 7.950). I&#39;ve been unable to find an answer to this so far.

Any help much appreciated.

PHP How do I round down to two decimal places?

I&#39;ve created a taxonomy.php page in my WordPress theme folder. I would like to get the current term id for a function. 
How can I get this?

`get_query_var(&#39;taxonomy&#39;)` only returns the term slug, I want the ID

How to get the current taxonomy term ID (not the slug) in WordPress?

I need to send a pdf with mail, is it possible? 


    $to = &quot;xxx&quot;;
    $subject = &quot;Subject&quot; ;
    $message = &#39;Example message with &lt;b&gt;html&lt;/b&gt;&#39;;
    $headers  = &#39;MIME-Version: 1.0&#39; . &quot;\r\n&quot;;
    $headers .= &#39;Content-type: text/html; charset=iso-8859-1&#39; . &quot;\r\n&quot;;
    $headers .= &#39;From: xxx &lt;xxx&gt;&#39; . &quot;\r\n&quot;;
    mail($to,$subject,$message,$headers);

What am I missing?

Send attachments with PHP Mail()?

How can I find the most frequent value in a given column in an SQL table?

For example, for this table it should return `two` since it is the most frequent value:

    one
    two
    two
    three


Find most frequent value in SQL column

What is the best method to copy the data from a table in one database to a table in another database when the databases are under different users?


I know that I can use

    INSERT INTO database2.table2 SELECT * from database1.table1

But here the problem is that both `database1` and `database2` are under different MySQL users. So `user1` can access `database1` only and `user2` can access `database2` only. Any idea?


Easiest way to copy a table from one database to another?

I am storing a `DATETIME` field in a table. Each value looks something like this:
&gt; 2012-09-09 06:57:12

I am using this syntax:
        
    date(&quot;Y-m-d H:i:s&quot;);


Now my question is, while fetching the data, how can get both date and time ***separately***, using a single MySQL query?

Date like &quot;**2012-09-09**&quot; and time like &quot;**06:57:12**&quot;. 
 

How to separate DATE and TIME from DATETIME in MySQL?

I have a table like this:

    TITLE          |   DESCRIPTION
    ------------------------------------------------
    test1          |   value blah blah value
    test2          |   value test
    test3          |   test test test
    test4          |   valuevaluevaluevaluevalue

I am trying to figure out how to return the number of times a string occurs in each of the DESCRIPTION&#39;s.

So, if I want to count the number of times &#39;value&#39; appears, the sql statement will return this:

    TITLE          |   DESCRIPTION                  |   COUNT
    ------------------------------------------------------------
    test1          |   value blah blah value        |   2
    test2          |   value test                   |   1
    test3          |   test test test               |   0
    test4          |   valuevaluevaluevaluevalue    |   5

Is there any way to do this? I do not want to use php at all, just mysql.


Count the number of occurrences of a string in a VARCHAR field?

How would I round down to the nearest integer in MySQL?

Example: `12345.7344 rounds to  12345`

mysql&#39;s `round()` function rounds up.

I don&#39;t know how long the values nor the decimal places will be, could be 10 digits with 4 decimal places, could be 2 digits with 7 decimal places. 

How to round down to nearest integer in MySQL?

I have a table called Products which obviously contains products.
However, I need to create related products. So what I&#39;ve done is create a junction table called product_related which has two PKs. ProductID from Products table and RelatedID also from Products table.

I already use EF and have set up everything on other tables. How should I add this properly in order to create a relationship with products as such:
`product.Products.Add(product object here)`. Of course here `product` represent a product object that I&#39;ve fetched from the db using `db.Products.FirstOr...`.

How should I do this properly ? A many to many to the same table?

Thanks.

EntityFramework Same Table Many to Many Relationship

I have a table with 3 columns like this:  

    +------------+---------------+-------+  
    | Country_id | country_title | State |  
    +------------+---------------+-------+    

There are many records in this table. Some of them have `state` and some other don&#39;t. Now, imagine these records:  

    1 | Canada  | Alberta  
    2 |  Canada | British  Columbia  
    3 | Canada  | Manitoba  
    4 | China   |

I need to have country names without any duplicate. Actually I need their `id` and `title`, What is the best SQL command to make this? I used `DISTINCT` in the form below but I could not achieve an appropriate result.  

    SELECT DISTINCT title,id FROM tbl_countries ORDER BY title
My desired result is something like this:  

    1, Canada  
    4, China

How to select records without duplicate on just one field in SQL?

I thought it was `CONTAINS`, but that&#39;s not working for me. 

I&#39;m looking to do this:

    IF CONTAINS(@stringVar, &#39;thisstring&#39;)
       ...

I have to run one `select` or another, depending on whether that variable contains a string and I can&#39;t figure out how to get it to work. All the examples I&#39;m seeing are using columns in the contains. 

Thanks in advance.

How can I tell if a VARCHAR variable contains a substring?

I have a table `test(id,name)`.

I need to insert values like:  `user&#39;s log`, `&#39;my user&#39;`, `customer&#39;s`.

     insert into test values (1,&#39;user&#39;s log&#39;);
     insert into test values (2,&#39;&#39;my users&#39;&#39;);
     insert into test values (3,&#39;customer&#39;s&#39;);

I am getting an error if I run any of the above statements.

If there is any method to do this correctly please share. I don&#39;t want any prepared statements.

Is it possible using sql escaping mechanism?



Content Type	Original Author	Original Content on Stackoverflow
Question	Karem	View Question on Stackoverflow
Solution 1 - Php	hjpotter92	View Answer on Stackoverflow
Solution 2 - Php	catalinux	View Answer on Stackoverflow

MySQL where NOT IN name array?

Php Problem Overview

Php Solutions

Solution 1 - Php

Solution 2 - Php

Ignore javascript syntax errors in a page and continue executing the script

How to create a blank transparent png in Objective-C?

Attributions