You can add a comment to a column name or entire table with the &quot;options&quot; argument to the annotation; eg:

    /**
     * @ORM\Column(type=&quot;string&quot;, options={&quot;comment&quot;:&quot;The string to show in the dropdown &quot;})
     */

for a column, or for a table:

    /**
     * @ORM\Entity
     * @ORM\Table(name=&quot;application&quot;, options={&quot;comment&quot;:&quot;Funding applications&quot;});
     */

Note however this will not add comments to an existing table or column, you have to delete the table from the DB and rebuild it. If it&#39;s just adding comments, you could rename the table, create the new table, and import data from the original.

Source: [Doctrine documentation][1]

  [1]: http://doctrine-orm.readthedocs.org/en/latest/reference/annotations-reference.html#column

&gt; **Possible Duplicate:**  
&gt; [JSLint: was used before it was defined](https://stackoverflow.com/questions/9621162/jslint-was-used-before-it-was-defined)  

&lt;!-- End of automatically inserted text --&gt;

I run `JSlint` and saw errors like that:

&lt;pre&gt;&#39;foo&#39; is not defined.
var x = foo();&lt;/pre&gt;

`foo` is a function defined in another `JavaScript` file `foo.js`. As I understand there is no &quot;import / require&quot; directives in `JavaScript` to reference the `foo` function defined in another source file.

How can I fix this error repoted by `JSlint`? 


How to fix &quot;foo is not defined&quot; error reported by JSlint?

I want to resize the image taken from the iOS camera on the client side with HTML5 Canvas but I keep running in this weird bug where the image has a wrong ratio if bigger than ~1.5mb

It works on the desktop but not in the latest iOS version with the media upload API.

You can see an example here: http://jsbin.com/ekuros/1

Any idea how to fix this please? Is this a memory issue?

    $(&#39;#file&#39;).on(&#39;change&#39;, function (e) {
        var file = e.currentTarget.files[0];
        var reader = new FileReader();
        reader.onload = function (e) {
            var image = $(&#39;&lt;img/&gt;&#39;);
            image.on(&#39;load&#39;, function () {
                var square = 320;
                var canvas = document.createElement(&#39;canvas&#39;);
    
                canvas.width = square;
                canvas.height = square;
                
                var context = canvas.getContext(&#39;2d&#39;);
                context.clearRect(0, 0, square, square);
                var imageWidth;
                var imageHeight;
                var offsetX = 0;
                var offsetY = 0;
    
                if (this.width &gt; this.height) {
                    imageWidth = Math.round(square * this.width / this.height);
                    imageHeight = square;
                    offsetX = - Math.round((imageWidth - square) / 2);
                } else {
                    imageHeight = Math.round(square * this.height / this.width);
                    imageWidth = square;    
                    offsetY = - Math.round((imageHeight - square) / 2);            
                }
                
                context.drawImage(this, offsetX, offsetY, imageWidth, imageHeight);
                var data = canvas.toDataURL(&#39;image/jpeg&#39;);
                
                var thumb = $(&#39;&lt;img/&gt;&#39;);
                thumb.attr(&#39;src&#39;, data);
                $(&#39;body&#39;).append(thumb);
            });
            image.attr(&#39;src&#39;, e.target.result);
        };
        reader.readAsDataURL(file);
    });

HTML5 Canvas drawImage ratio bug iOS

I would like to add a *column description* (also called a &quot;*comment*&quot;) to a column defined by a Doctrine2 entity but can&#39;t find any information on how to do it using the `@Column annotation` without possibly breaking Doctrine&#39;s SchemaTool.

If I use the `columnDefinition` attribute of the `@Column annotation` like 

    @Column(type=&quot;string&quot; columnDefinition=&quot;COMMENT &#39;This is a column comment&#39;&quot;)

the [annotations reference][1] states

&gt; SchemaTool will not detect changes on the column correctly anymore if you use “columnDefinition”.

So is there a way to define a column description without breaking the SchemaTool?

The only clue I got was [this pull request][2] which ended in &quot;*This was solved in different ways.*&quot;.

  [1]: http://docs.doctrine-project.org/projects/doctrine-orm/en/2.0.x/reference/annotations-reference.html#annref-column
  [2]: https://github.com/doctrine/doctrine2/pull/217

How to add column descriptions (comments) in Doctrine2

I would like to add a column description (also called a "comment") to a column defined by a Doctrine2 entity but can't find any information on how to do it using the <code>@Column annotation</code> without possibly breaking Doctrine's SchemaTool.
If I use the <code>columnDefinition</code> attribute of the <code>@Column annotation</code> like
<pre><code class="hljs language-python">@Column(type="string" columnDefinition="COMMENT 'This is a column comment'")
</code></pre>
the <a href="http://docs.doctrine-project.org/projects/doctrine-orm/en/2.0.x/reference/annotations-reference.html#annref-column" target="_blank" rel="noopener noreferrer">annotations reference</a> states
> SchemaTool will not detect changes on the column correctly anymore if you use “columnDefinition”.
So is there a way to define a column description without breaking the SchemaTool?
The only clue I got was <a href="https://github.com/doctrine/doctrine2/pull/217" target="_blank" rel="noopener noreferrer">this pull request</a> which ended in "This was solved in different ways.".

This question started out with me not understanding why I couldn&#39;t pass variables to a symfony2 global helper function (service), but thanks to people brighter than I, I realized my error was about trying to use the security_context from within a class that didn&#39;t have it injected so...

This is the final result, the code that works. I found no better way of making this helpful to the comunity.

This is how you can get the user and other data from security_context from within a global function or helper function in symfony2.

I have the following class and function:

    &lt;?php
    namespace BizTV\CommonBundle\Helper;
    
    use Symfony\Component\DependencyInjection\ContainerInterface as Container;
    
    class globalHelper {    
    
    private $container;
    
    public function __construct(Container $container) {
        $this-&gt;container = $container;
    }   

        //This is a helper function that checks the permission on a single container
        public function hasAccess($container)
        {
            $user = $this-&gt;container-&gt;get(&#39;security.context&#39;)-&gt;getToken()-&gt;getUser();
            
            //do my stuff
        }     
    }

...defined as a service (in app/config/config.yml) like this...

    #Registering my global helper functions            
    services:
      biztv.helper.globalHelper:
        class: BizTV\CommonBundle\Helper\globalHelper
        arguments: [&#39;@service_container&#39;]

Now, in my controller I call on this function like this...

    public function createAction($id) {
        
        //do some stuff, transform $id into $entity of my type...

        //Check if that container is within the company, and if user has access to it.
        $helper = $this-&gt;get(&#39;biztv.helper.globalHelper&#39;);
        $access = $helper-&gt;hasAccess($entity);


How to access service container in symfony2 global helper function (service)?

I&#39;m playing around with **Symfony2**, and I have problems including **CSS** and **JS** files in **Twig** template.

I have a bundle named `Webs/HomeBundle` inside which I have `HomeController` with `indexAction` that renders a twig template file:

    public function indexAction()
    {
        return $this-&gt;render(&quot;WebsHomeBundle:Home:index.html.twig&quot;);
    }
So this is easy. Now what I want to do, is to include some CSS and JS files inside this Twig template. Template looks like this:

    &lt;!DOCTYPE html&gt;
    &lt;html&gt;
    &lt;head&gt;  
        {% block stylesheets %}
            &lt;link href=&quot;{{ asset(&#39;css/main.css&#39;) }}&quot; type=&quot;text/css&quot; rel=&quot;stylesheet&quot; /&gt;
        {% endblock %}
    &lt;/head&gt;
    &lt;body&gt;
    &lt;/body&gt;
    &lt;/html&gt;
The file I would like to include, `main.css` file is located in: 

    Webs/HomeController/Resources/public/css/main.css
So my question is basically, how the hell do I include simple CSS file inside Twig template?

I&#39;m using Twig `asset()` function and it just doesn&#39;t hit the right CSS path. Also, I run this command in console: 

    app/console assets:install web
This created a new folder

    /web/bundles/webshome/...
this is just linking to the

    src/Webs/HomeController/Resources/public/
right?

# Questions
1. Where do you place your **asset** files, JS, CSS, and images? Is it OK to put them in `Bundle/Resources/public` folder? Is that the right location for them?
2. How do you include these **asset** files in your Twig template using asset function? If they are in public folder, how can I include them?
3. Should I configure something else?

How to include CSS file in Symfony 2 and Twig?

I&#39;m trying to do the pagination, but there is an error:

&gt;[Syntax Error] line 0, col 57: Error: Expected end of string, got &#39;limit&#39;

I&#39;m not quite sure if this is the right syntax (and logic) to make my query:

&lt;!-- language: php --&gt;

    public function getFriendsFromTo ($user, $limit, $offset)
    {
         return $this-&gt;getEntityManager()
            -&gt;createQuery(&#39;SELECT f FROM EMMyFriendsBundle:Friend f WHERE f.user=&#39;.$user.&#39; limit &#39;.$limit. &#39;offset&#39; .$offset)
            -&gt;getResult();
    }

Friends and users are related manyToOne and oneToMany, so in the friends table there is a field - user_id.

This is in my controller:

&lt;!-- language: php --&gt;

    $user = $this-&gt;get(&#39;security.context&#39;)-&gt;getToken()-&gt;getUser();
    $id = $user-&gt;getId();
    
    $friends = $user-&gt;getFriends();
    $result = count($friends)
    $FR_PER_PAGE = 7;
    $pages = $result/$FR_PER_PAGE;
            
    $em = $this-&gt;getDoctrine()-&gt;getEntityManager();
    $friends = $em-&gt;getRepository(&#39;EMMyFriendsBundle:Friend&#39;)
             -&gt;getFriendsFromTo($id, $FR_PER_PAGE, $page*$FR_PER_PAGE); 

I know that it&#39;s stupid and even wrong (especially the third parameter to be `$page*$FR_PER_PAGE`), but I just wanted to try if the query works, and it didn&#39;t.

Use Limit and Offset in Doctrine2 query

When I am trying to use the TWIG `{% javascript %}` tag to link to my `.js` file it return me with the following exception :

    An exception has been thrown during the compilation of a template (&quot;You must add CompetitiongameBundle to the assetic.bundle config to use the {% javascripts %} tag in CompetitiongameBundle:game:index.html.twig.&quot;) in &quot;CompetitiongameBundle:game:index.html.twig&quot;.

 My `index.html.twig` looks like :

    {% javascripts &#39;CompetitiongameBundle/Resources/views/public/js/*&#39;%}
    	&lt;script type=&quot;text/javascript&quot; src=&quot;{{ asset_url }}&quot; &gt;&lt;/script&gt;
    {% endjavascripts %}
    Hello {{ name }}!
    
    &lt;a href=&#39;{{ nexturl }}&#39; &gt;Login&lt;/a&gt;

My Bundle is already present in the config file when I do :
 

    php app/console config:dump-reference assetic

How can I fix this ?

How do I fix &quot;Add myBundle to the asseticBundle config&quot; symfony2 exception?

I need to inject two objects into `ImageService`. One of them is an instance of `Repository/ImageRepository`, which I get like this: 

    $image_repository = $container-&gt;get(&#39;doctrine.odm.mongodb&#39;)
        -&gt;getRepository(&#39;MycompanyMainBundle:Image&#39;);

So how do I declare that in my services.yml? Here is the service:

	namespace Mycompany\MainBundle\Service\Image;

	use Doctrine\ODM\MongoDB\DocumentRepository;

	class ImageManager {
		private $manipulator;
		private $repository;

		public function __construct(ImageManipulatorInterface $manipulator, DocumentRepository $repository) {
			$this-&gt;manipulator = $manipulator;
			$this-&gt;repository = $repository;
		}
	
		public function findAll() {
			return $this-&gt;repository-&gt;findAll();
		}

		public function createThumbnail(ImageInterface $image) {
			return $this-&gt;manipulator-&gt;resize($image-&gt;source(), 300, 200);
		}
	}


How to inject a repository into a service in Symfony?

I am using the `findBy()` method on a Doctrine repository:

    $entities = $repository-&gt;findBy(array(&#39;type&#39;=&gt; &#39;C12&#39;));

How can I order the results?

How to order results with findBy() in Doctrine

I am developing my application using Zend Framework 2 and Doctrine 2. 

While writting annotations, I am unable to understand the difference between `mappedBy` and `inversedBy`.

When should I use `mappedBy`?

When should I use `inversedBy`?

When should I use neither?

Here is an example:

     /**
     *
     * @ORM\OneToOne(targetEntity=&quot;\custMod\Entity\Person&quot;, mappedBy=&quot;customer&quot;)
     * @ORM\JoinColumn(name=&quot;personID&quot;, referencedColumnName=&quot;id&quot;)
     */
    protected $person;
    
    /**
     *
     * @ORM\OneToOne(targetEntity=&quot;\Auth\Entity\User&quot;)
     * @ORM\JoinColumn(name=&quot;userID&quot;, referencedColumnName=&quot;id&quot;)
     */
    protected $user;
    
    /**
     *
     * @ORM\ManyToOne (targetEntity=&quot;\custMod\Entity\Company&quot;, inversedBy=&quot;customer&quot;)
     * @ORM\JoinColumn (name=&quot;companyID&quot;, referencedColumnName=&quot;id&quot;)
     */
    protected $company;

I did a quick search and found the following, but I am still confused: 

- [example 1][1]
- [example 2][2]
- [example 3][3]


  [1]: https://stackoverflow.com/questions/3328836/problem-understanding-relation-mapping-in-doctrine-2
  [2]: http://docs.doctrine-project.org/projects/doctrine-mongodb-odm/en/latest/reference/bidirectional-references.html
  [3]: http://docs.doctrine-project.org/en/2.0.x/reference/association-mapping.html

What is the difference between inversedBy and mappedBy?

I want to do composite unique key in doctrine.
Those are my fields: 

```lang-php
/**
 * @var string $videoDimension
 *
 * @Column(name=&quot;video_dimension&quot;, type=&quot;string&quot;, nullable=false)
 */
private $videoDimension;

/**
 * @var string $videoBitrate
 *
 * @Column(name=&quot;video_bitrate&quot;, type=&quot;string&quot;, nullable=false)
 */
private $videoBitrate;
```

How can I show doctrine, that those combined together are composite unique key?

Doctrine and composite unique keys

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?

Content Type	Original Author	Original Content on Stackoverflow
Question	flu	View Question on Stackoverflow
Solution 1 - Symfony	ChrisNY	View Answer on Stackoverflow

How to add column descriptions (comments) in Doctrine2

Symfony Problem Overview

Symfony Solutions

Solution 1 - Symfony

HTML5 Canvas drawImage ratio bug iOS

How to fix "foo is not defined" error reported by JSlint?

Attributions