You forgot the `%` signs around the word:

&lt;!-- language: php --&gt;

    -&gt;setParameter(&#39;word&#39;, &#39;%&#39;.$word.&#39;%&#39;)

Below are some additional steps you can take to further sanitise input data.

You should escape the term that you insert between the percentage signs:

    -&gt;setParameter(&#39;word&#39;, &#39;%&#39;.addcslashes($word, &#39;%_&#39;).&#39;%&#39;)

The percentage sign &#39;%&#39; and the symbol underscore &#39;_&#39; are interpreted as wildcards by `LIKE`. If they&#39;re not escaped properly, an attacker might construct arbitrarily complex queries that can cause a denial of service attack. Also, it might be possible for the attacker to get search results he is not supposed to get. A more detailed description of attack scenarios can be found here: https://stackoverflow.com/a/7893670/623685


    array=(a b c d)
I would like to add a character before each element of the array in order to have this

    array=(^a ^b ^c ^d)
An easy way to do that is to loop on array elements and change values one by one

    for i in &quot;${#array[@]}&quot;
    do
        array[i]=&quot;^&quot;array[i]
    done
But I would like to know if there is any way to do the same thing without looping on the array as I have to do the same instruction on all elements.

Thanks in advance.


How to change values of bash array elements without loop

In my HTML5 page, I have a div with `mousemove` event as follows:

	$(&#39;#canvas&#39;).mousemove(function(e){
		xpos = e.offsetX;
		ypos = e.offsetY;
		$(&#39;#mouse&#39;).html(&quot;X : &quot; + xpos + &quot; ; Y : &quot; + ypos);
	});

It works fine with Google Chrome. But in Firefox, both the are giving the value `undefined`. I have checked it by using Firebug, that is, logged the `e` object to console. Both `offsetX` and `offsetY` are found to be `undefined`.

When I searched in Google, there was a solution saying I should use `layerX` and `layerY`, if both `offsetX` and `offsetY` are undefined.
But from Firebug, I was not able to find it. And even I had given it a try like this:

    xpos = (e.offsetX==undefined)?e.layerX:e.offsetX;
    ypos = (e.offsetY==undefined)?e.layerY:e.offsetY;

But that&#39;s also giving `undefined` as values.

I am using the most recent jQuery - v1.8.2. And I am testing in my Firefox v14.0.1

Any ideas or suggestions?

---
**EDIT**

Thanks to dystroy and vusan for helping me. The solution to the above issue is as follows:

**SOLUTION**

    $(&#39;#canvas&#39;).mousemove(function(e){
      $(&#39;#cursor&#39;).show();
      if(e.offsetX==undefined) // this works for Firefox
      {
        xpos = e.pageX-$(&#39;#canvas&#39;).offset().left;
        ypos = e.pageY-$(&#39;#canvas&#39;).offset().top;
      }				
      else                     // works in Google Chrome
      {
        xpos = e.offsetX;
        ypos = e.offsetY;
      }
      $(&#39;#mouse&#39;).html(&quot;X : &quot; + xpos + &quot; ; Y : &quot; + ypos);
    });


HTML5 with jQuery - e.offsetX is undefined in Firefox

I have this code for query: 

    $repository = $em-&gt;getRepository(&#39;AcmeCrawlerBundle:Trainings&#39;);
           $query = $repository-&gt;createQueryBuilder(&#39;p&#39;)
                   -&gt;where(&#39;p.title LIKE :word&#39;)
                   -&gt;orWhere(&#39;p.discription LIKE :word&#39;)
                   -&gt;setParameter(&#39;word&#39;, $word)
                   -&gt;getQuery();
    $trainings = $query-&gt;getResult();

The problem is: even if matches exist, they not found by this query. I used this code to see full sql: 

    print_r(array(
            &#39;sql&#39;        =&gt; $query-&gt;getSQL(),
            &#39;parameters&#39; =&gt; $query-&gt;getParameters(),
            ));

And what I&#39;ve got:

    FROM Trainings t0_ WHERE t0_.title LIKE ? OR t0_.discription LIKE ? [parameters] =&gt; Array ( [word] =&gt; Spoken ) 
(last part of query)
Tell me please what to change?

Doctrine 2 Query with LIKE

I have this code for query:
<pre><code class="hljs language-ini">$repository = $em->getRepository('AcmeCrawlerBundle:Trainings');
 $query = $repository->createQueryBuilder('p')
 ->where('p.title LIKE :word')
 ->orWhere('p.discription LIKE :word')
 ->setParameter('word', $word)
 ->getQuery();
$trainings = $query->getResult();
</code></pre>
The problem is: even if matches exist, they not found by this query. I used this code to see full sql:
<pre><code class="hljs language-ini">print_r(array(
 'sql' => $query->getSQL(),
 'parameters' => $query->getParameters(),
 ));
</code></pre>
And what I've got:
<pre><code class="hljs language-sql">FROM Trainings t0_ WHERE t0_.title LIKE ? OR t0_.discription LIKE ? [parameters] => Array ( [word] => Spoken ) 
</code></pre>
(last part of query)
Tell me please what to change?

I already have a function in SQL Server 2005 as:

    ALTER function [dbo].[fCalculateEstimateDate] (@vWorkOrderID numeric)
    Returns varchar(100)  AS
    Begin
      &lt;Function Body&gt;
    End

I want to modify this function to accept addition optional parameter @ToDate. I am going to add logic in function if @Todate Provided then do something else continue with existing code.

I modified the function as:

    ALTER function [dbo].[fCalculateEstimateDate] (@vWorkOrderID numeric,@ToDate DateTime=null)
    Returns varchar(100)  AS
    Begin
      &lt;Function Body&gt;
    End

Now I can call function as:

    SELECT dbo.fCalculateEstimateDate(647,GETDATE())

But it gives error on following call:

    SELECT dbo.fCalculateEstimateDate(647)

as

&gt; An insufficient number of arguments were supplied for the procedure or
&gt; function dbo.fCalculateEstimateDate.

which as per my understanding should not happen.

Am I missing anything?
Thanks in advance.

Alter a SQL server function to accept new optional parameter

MySQL very slow for alter table query

I am wondering how to write this query.

I know this actual syntax is bogus, but it will help you understand what I am wanting.
I need it in this format, because it is part of a much bigger query.

    SELECT distributor_id, 
    COUNT(*) AS TOTAL, 
    COUNT(*) WHERE level = &#39;exec&#39;, 
    COUNT(*) WHERE level = &#39;personal&#39;

I need this all returned in one query. 

Also, it need to be in one row, so the following won&#39;t work:

    &#39;SELECT distributor_id, COUNT(*)
    GROUP BY distributor_id&#39;



How to get multiple counts with one SQL query?

Is it that a primary key is the selected candidate key chosen for a given table?

What is the difference between a candidate key and a primary key?

How do you write in the Rails way?
I have a model - Managers.
I want to delete all records from Managers that meet the condition that manager_level is 5.

Thank you.

Rails - Delete all Records that Meet a Condition

Is it possible to retrieve all variables inside a Twig template with PHP? 


Example someTemplate.twig.php:

    Hello {{&#160;name }}, 
    your new email is {{&#160;email }}


Now I want to do something like this: 

    $template = $twig-&gt;loadTemplate(&#39;someTemplate&#39;);
    $variables = $template-&gt;getVariables();

$variables should now contain &quot;name&quot; and &quot;email&quot;.

The reason I want to do this is that I am working on a CMS system 
where my twig templates and variables are dynamically set by my users
and they also fill the variables through an API. 

I want to set default values to not-set variables and therefore I 
need a list of all variables that exist inside the template…



How to retrieve all Variables from a Twig Template?

I have Symfony2 running on an Ubuntu Server 12.04 (64-bit) VM (VirtualBox).  The host is a MacBook pro.  For some reason I am getting really long request times in development mode (app_dev.php).  I know its slower in dev mode, but I&#39;m talking 5-7 seconds per request (sometimes even slower).  On my Mac I get request times of 200ms or so in development mode.

After looking at my timeline in the Symfony2 profiler, I noticed that ~95% of the request time is &quot;initialization time&quot;.  What is this?  What are some reasons it could be so slow?

This issue only applies to Symfony2 in dev mode, not any other sites I&#39;m running on the VM, and not even to Symfony2 in production mode.

I saw this (http://stackoverflow.com/questions/11162429/whats-included-in-the-initialization-time-in-the-symfony2-web-profiler), but it doesn&#39;t seem to answer my questions.

Symfony2 Slow Initialization Time

I&#39;m trying to download a file when a user clicks on download link.

In Controller:

        $response = new Response();
        $response-&gt;headers-&gt;set(&#39;Content-type&#39;, &#39;application/octect-stream&#39;);
        $response-&gt;headers-&gt;set(&#39;Content-Disposition&#39;, sprintf(&#39;attachment; filename=&quot;%s&quot;&#39;, $filename));
        $response-&gt;headers-&gt;set(&#39;Content-Length&#39;, filesize($filename));

        return $response;

This is opening the dialog box to save the file, but it says the file is 0 bytes.
And changing it to:

            $response = new Response();
            $response-&gt;headers-&gt;set(&#39;Content-type&#39;, &#39;application/octect-stream&#39;);
            $response-&gt;headers-&gt;set(&#39;Content-Disposition&#39;, sprintf(&#39;attachment; filename=&quot;%s&quot;&#39;, $filename));
            $response-&gt;headers-&gt;set(&#39;Content-Length&#39;, filesize($filename));
            $response-&gt;headers-&gt;set(&#39;Content-Transfer-Encoding&#39;, &#39;binary&#39;);
            $response-&gt;setContent(readfile($filename));

            return $response;

I get a bunch of weird characters instead of the file download dialog box.

Finally, switching the &quot;setContent&quot; line to:

        $response-&gt;setContent(file_get_contents($filename));

It returns a PHP error:

&gt;Fatal error: Allowed memory size...

Any clues on how to achieve this?
I&#39;ve done it before in PHP (wihtout MVC), but I don&#39;t know what can be missing to do it through Symfony2...

Maybe the solution is setting the memory_limit in PHP.INI, but I guess it&#180;s not the best practice...

Symfony2 - Force file download

How can I limit the length of the text, e.g., 50, and put three dots in the display?



    {% if myentity.text|length &gt; 50 %}
    
    {% block td_text %} {{ myentity.text}}{% endblock %}
    
    {%endif%}

symfony 2 twig limit the length of the text and put three dots

I have had to use the 

    app/console cache:clear  command
to solve a problem when generating an entity.

I am now unable to load my homepage on :

      http://localhost/projet_etienne/web/app_dev.php
it says :
&gt;RuntimeException: Failed to write cache file &quot;/var/www/projet_etienne/app/cache/dev/classes.php&quot;.

I don&#39;t understand much about this cache business!

In my `app/cache` folder, I got a `dev`, a `dev_new`, a `dev_old` folder. Is that normal?

the

    app/console cache:clear
generates by the way a :
&gt;[ErrorException]
Warning: rename(/var/www/projet_etienne/app/cache/dev,/var/www/projet_etien  
      ne/app/cache/dev_old): Directory not empty in /var/www/projet_etienne/vendo  
     r/symfony/symfony/src/Symfony/Bundle/FrameworkBundle/Command/CacheClearComm  
     and.php line 77   

please help!

symfony2 : failed to write cache directory

In the [Doctrine docs][1] they mention that there exists a few different strategies for the `@GeneratedValue` annotation:

 - `AUTO`
 - `SEQUENCE`
 - `TABLE`
 - `IDENTITY`
 - `UUID`
 - `CUSTOM`
 - `NONE`

Would someone please explain the differences between all thees strategies?

  [1]: http://docs.doctrine-project.org/en/latest/reference/annotations-reference.html#annref-generatedvalue

The differences between GeneratedValue strategies

How do I do 

    WHERE id != 1

In Doctrine?

I have this so far

    $this-&gt;getDoctrine()-&gt;getRepository(&#39;MyBundle:Image&#39;)-&gt;findById(1);

But how do I do a &quot;do not equals&quot;?

This maybe daft, but I cannot find any reference to this?

Thanks

Doctrine findBy &#39;does not equal&#39;

I have created an entity `A` with `OneToMany` relation to `B`, which have relation `OneToMany` to `C`.

I have to clone this `A` entity and set it in database with new id. Also all deep relations should be cloned with new ids too.

What have I tried is to set `A` id to `null`:

    $A = clone $A_original;
    $A-&gt;setId(null);
    $em-&gt;persist($A);

It creates new record in `A` table, but does not in `B` and `C`.

What should I do to make a full copy of `A` entity ?

Deep clone Doctrine entity with related entities

I have an entity that looks like this:

    /**
     * @Gedmo\Tree(type=&quot;nested&quot;)
     * @ORM\Table(name=&quot;categories&quot;)
     * @ORM\Entity()
     */
    class Category extends BaseCategory
    {
    
        /**
        * @ORM\OneToMany(targetEntity=&quot;Category&quot;, mappedBy=&quot;parent&quot;)
        */
        protected $children;
    
    	/**
        * @Gedmo\TreeParent
        * @ORM\ManyToOne(targetEntity=&quot;Category&quot;, inversedBy=&quot;children&quot;)
        * @ORM\JoinColumn(name=&quot;parent_id&quot;, referencedColumnName=&quot;id&quot;, onDelete=&quot;SET NULL&quot;)
        */
        protected $parent;
    
    }

and I am trying to run a query like this:

    $qb = $this-&gt;em-&gt;createQueryBuilder()
                -&gt;select(&#39;c.parent&#39;)
                -&gt;from(&#39;Category&#39;, &#39;c&#39;);
    
    $result = $qb-&gt;getQuery()-&gt;getArrayResult();

However, I am getting the following error:

    [Semantical Error] ... Error: Invalid PathExpression. Must be a StateFieldPathExpression. 


How can I select the parent_id field from my table. I have tried a bunch of variations and even if I do something like this:

    $qb = $this-&gt;em-&gt;createQueryBuilder()
                -&gt;select(&#39;c&#39;)
                -&gt;from(&#39;Category&#39;, &#39;c&#39;);

I get all fields in the table **except** for the parent_id. This seems like Doctrine is getting in the way. How can I query for this parent_id field? or better yet how can I get **all** fields in the table including the **parent_id**



Symfony2 and Doctrine - Error: Invalid PathExpression. Must be a StateFieldPathExpression

    [Doctrine\ORM\ORMException]   
    The EntityManager is closed.  


After I get a DBAL exception when inserting data, EntityManager closes and I&#39;m not able to reconnect it. 

I tried like this but it didn&#39;t get a connection.

    $this-&gt;em-&gt;close();
    $this-&gt;set(&#39;doctrine.orm.entity_manager&#39;, null);
    $this-&gt;set(&#39;doctrine.orm.default_entity_manager&#39;, null);
    $this-&gt;get(&#39;doctrine&#39;)-&gt;resetEntityManager();
    $this-&gt;em = $this-&gt;get(&#39;doctrine&#39;)-&gt;getEntityManager();



Anyone an idea how to reconnect?

Content Type	Original Author	Original Content on Stackoverflow
Question	user1581663	View Question on Stackoverflow
Solution 1 - Sql	Elnur Abdurrakhimov	View Answer on Stackoverflow
Solution 2 - Sql	robert	View Answer on Stackoverflow

Doctrine 2 Query with LIKE

Sql Problem Overview

Sql Solutions

Solution 1 - Sql

Solution 2 - Sql

HTML5 with jQuery - e.offsetX is undefined in Firefox

How to change values of bash array elements without loop

Attributions