The equivalent of MySQL&#39;s `NOW()` is Doctrine DQL&#39;s **`CURRENT_TIMESTAMP()`**.

`CURRENT_DATE()` only returns the date part.

Reference: [DQL date/time related functions][1]


  [1]: https://www.doctrine-project.org/projects/doctrine-orm/en/2.7/reference/dql-doctrine-query-language.html#line-number-c2439321397191dde881faa94a3a33ab0aeff984-14

CURRENT_TIMESTAMP() uses database timezone, which could lead to weird issues.
More simple way - you can use parameter and bind new \DateTime() to it (so you will use php timezone)

It will not work for command line of course, but I suppose that you plan to use it in controller/service/repository/etc..

I ran a heap dump on my program.  When I opened it in the memory analyzer tool, I found that the `java.lang.ref.Finalizer` for `org.logicalcobwebs.proxool.ProxyStatement` was taking up a lot of memory.  Why is this so?

![screenshot][1]


  [1]: http://i.stack.imgur.com/Qzd3I.png
 

is memory leak? why java.lang.ref.Finalizer eat so much memory

All,
I&#39;m using the jQuery UI for the date picker. I&#39;m trying to check with javascript though that the date the user has entered is in the past. Here is my form code:

    &lt;input type=&quot;text&quot; id=&quot;datepicker&quot; name=&quot;event_date&quot; class=&quot;datepicker&quot;&gt;

Then how would I check this with Javascript to make sure it isn&#39;t a date in the past? Thanks

Check if date is in the past Javascript

    $ php app/console doctrine:query:dql &#39;SELECT NOW()&#39;

 
&gt;  [Doctrine\ORM\Query\QueryException]
&gt;  [Syntax Error] line 0, col 7: Error: Expected known function, got &#39;now&#39; 

How can I use MySQL&#39;s `NOW()` function with Doctrine&#39;s DQL?

How can I use now() in Doctrine 2 DQL?

<pre><code class="hljs language-shell">$ php app/console doctrine:query:dql 'SELECT NOW()'
</code></pre>
> [Doctrine\ORM\Query\QueryException]
> [Syntax Error] line 0, col 7: Error: Expected known function, got 'now'
How can I use MySQL's <code>NOW()</code> function with Doctrine's DQL?

I am aware of this command:

    GRANT ALL PRIVILEGES
    ON database.*
    TO &#39;user&#39;@&#39;yourremotehost&#39;
    IDENTIFIED BY &#39;newpassword&#39;;

But then it only allows me to grant a particular IP address to access this remote MySQL database. What if I want it so that any remote host can access this MySQL database? How do I do that? Basically I am making this database public so everyone can access it.

grant remote access of MySQL database from any IP address

How would I go about deleting all records from a MySQL table from before a certain date, where the date column is in DATETIME format?

An example datetime is `2011-09-21 08:21:22`.

Deleting records before a certain date

    ...
    user_id INTEGER NOT NULL, 
	CONSTRAINT fk_user_meta FOREIGN KEY (user_id)
		REFERENCES users (id) ON DELETE CASCADE ON UPDATE RESTRICT

I know from [here][1] that ON DELETE CASCADE means that if I delete a row from the users table, then the associated row from the user meta table will be removed too. But what does  ON UPDATE RESTRICT do?


  [1]: http://www.techonthenet.com/oracle/foreign_keys/foreign_delete.php

What does ON UPDATE RESTRICT do?

MySQL 5.1.31 running on Windows XP.

From the **local** MySQL server (192.168.233.142) I can connect as root as follows:

    &gt;mysql --host=192.168.233.142 --user=root --password=redacted

From a **remote** machine (192.168.233.163), I can see that the mysql port is open:

    # telnet 192.168.233.142 3306
    Trying 192.168.233.142...
    Connected to 192.168.233.142 (192.168.233.142).

But when trying to connect to mysql from the **remote** machine, I receive:

    # mysql --host=192.168.233.142 --user=root --password=redacted
    ERROR 1045 (28000): Access denied for user &#39;root&#39;@&#39;192.168.233.163&#39; (using password: YES)

I have only 2 entries in mysql.user:

    Host         User     Password
    --------------------------------------
    localhost    root     *blahblahblah
    %            root     [same as above]

What more do I need to do to enable remote access?

**EDIT**

As suggested by Paulo below, I tried replacing the mysql.user entry for % with an IP specific entry, so my user table now looks like this:

    Host             User     Password
    ------------------------------------------
    localhost        root     *blahblahblah
    192.168.233.163  root     [same as above]

I then restarted the machine, but the problem persists.

Enable remote MySQL connection: ERROR 1045 (28000): Access denied for user

When working in XAMPP with phpmyadmin, after creating a table I have the option to click &quot;relation view&quot; after clicking on the structure tab. See below:

![enter image description here][1]

However anytime when I create a table with my host phpmyadmin, I dont have the option to select &quot;relation view&quot; See below:

![enter image description here][2]

Is there anyway of enabling this? Currently I have to set up relationships in xampp and export to my host phpmyadmin for it to work. 


  [1]: http://i.stack.imgur.com/SdQOf.png
  [2]: http://i.stack.imgur.com/mdV8D.png

How to enable relation view in phpmyadmin

How can I display a string that contains HTML tags in twig template?

My PHP variable contains this html and text:

    $word = &#39;&lt;b&gt; a word &lt;/b&gt;&#39;;

When I do this in my twig template:

    {{ word }}

I get this:

    &amp;lt;b&amp;gt; a word &amp;lt;b&amp;gt;

I want this instead:

    &lt;b&gt; a word &lt;/b&gt;

Is it possible to get this easily?

How to display string that contains HTML in twig template?

When I read docs about repositories, it is often to work with entities &amp; collection but in a &quot;read-only&quot; manner.

There are never examples where repositories have methods like `insertUser(User $user)` or `updateUser(User $user)`.

However, when using SOA, Service should not be working with Entity Manager (that&#39;s right, isn&#39;t it?) so: 

1. Should my service be aware of the global EntityManager?
2. Should my service know only about the used Repositories (let&#39;s say, UserRepository &amp; ArticleRepository)

From that both questions, another one, should my service ever explicitly `persist()` &amp; `flush()` my entities ?



Are Doctrine2 repositories a good place to save my entities?

I&#39;ve searched a lot on the net how to access the global `$_SESSION` array from TWIG template and found this: `{{app.session.get(&#39;index&#39;)}}`, but when I&#39;m calling it, it returns an empty string. I have a `$_SESSION[&#39;filter&#39;][&#39;accounts&#39;]` and I&#39;m getting this error when calling `{{app.session.get(&#39;filter&#39;).accounts}}`: `Item &quot;accounts&quot; for &quot;&quot; does not exist`. What I&#39;m doing wrong?

Accessing session from TWIG template

What does ~ mean in the YML configuration file in Symfony 2?

For example:

    NotBlank: ~

What does ~ mean in the YML configuration file in Symfony 2?

I have a form containing several fields. One of them is a Datetime field. How to define a default value for that field? 

I&#39;ve tried setting a value on the related entity, in controller, in constructor and __construct :

    $myEntity = new MyEntity();
    $myEntity-&gt;setMyDate(new \DateTime());
    $form = $this-&gt;createForm(new AddMyEntity(), $myEntity);

Not working. 


Tried to define the `$data` variable in the buildForm : 


    $builder-&gt;add(&#39;myDate&#39;, &#39;date&#39;, array(
        &#39;format&#39; =&gt; \IntlDateFormatter::SHORT,
        &#39;input&#39; =&gt; &#39;datetime&#39;,
        &#39;widget&#39; =&gt; &#39;single_text&#39;,
        &#39;data&#39; =&gt; new \DateTime(&quot;now&quot;));

Not working either. 
Any ideas, Symfony2 community?


EDIT : Adding entity on demand of faost. 

    /**
     * @ORM\Column(name=&quot;myDate&quot;, type=&quot;datetime&quot;)
     * @Assert\NotBlank()
     */
    private $myDate;

Set default value on Datetime field in symfony2 form

I trying to write a query (with subquery) but i don&#39;t know how set a limit in my subquery.
My query:

  

    $query_ids = $this-&gt;getEntityManager()
          -&gt;createQuery(
            &quot;SELECT e_.id
            FROM MuzichCoreBundle:Element e_
            WHERE [...]
            GROUP BY e_.id&quot;)
         -&gt;setMaxResults(5)
        ;

    $query_select = &quot;SELECT e
          FROM MuzichCoreBundle:Element e 
          WHERE e.id IN (&quot;.$query_ids-&gt;getDql().&quot;)
          ORDER BY e.created DESC, e.name DESC&quot;
        ;

    $query = $this-&gt;getEntityManager()
          -&gt;createQuery($query_select)
          -&gt;setParameters($params)
        ;

But **-&gt;setMaxResults(5)** doesn&#39;t work. No &#39;LIMIT&#39; in the SQL query. Can we do simple LIMIT with doctrine 2 ?

Set LIMIT with doctrine 2?

Let&#39;s suppose I retrieve an entity `$e` and modify its state with setters:

    $e-&gt;setFoo(&#39;a&#39;);
    $e-&gt;setBar(&#39;b&#39;);

Is there any possibility to retrieve an array of fields that have been changed?

In case of my example I&#39;d like to retrieve `foo =&gt; a, bar =&gt; b` as a result

PS: yes, I know I can modify all the accessors and implement this feature manually, but I&#39;m looking for some handy way of doing this

Is there a built-in way to get all of the changed/updated fields in a Doctrine 2 entity

Let&#39;s say I have entity `$e`. Is there any generic way to store it as another row, which would have the same entity data but another primary key?

Why I need this: I&#39;m implementing some sort of [Temporal Database][1] schema and instead of updating the row I just need to create another one.


  [1]: http://en.wikipedia.org/wiki/Temporal_database

How to re-save the entity as another row in Doctrine 2

I&#39;m using Doctrine&#39;s QueryBuilder to build a query, and I want to get the total count of results from the query.   


    $repository = $em-&gt;getRepository(&#39;FooBundle:Foo&#39;);

    $qb = $repository-&gt;createQueryBuilder(&#39;n&#39;)
            -&gt;where(&#39;n.bar = :bar&#39;)
            -&gt;setParameter(&#39;bar&#39;, $bar);
    
    $query = $qb-&gt;getQuery();
    
    //this doesn&#39;t work
    $totalrows = $query-&gt;getResult()-&gt;count();

I just want to run a count on this query to get the total rows, but not return the actual results.  (After this count query, I&#39;m going to further modify the query with maxResults for pagination.)   



Count Rows in Doctrine QueryBuilder

I am developing an application using Symfony2 and doctrine 2. I would like to know how can I get the currently logged in user&#39;s Id. 

Symfony getting logged in user&#39;s id

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**



Content Type	Original Author	Original Content on Stackoverflow
Question	Eduardo	View Question on Stackoverflow
Solution 1 - Mysql	BenMorel	View Answer on Stackoverflow
Solution 2 - Mysql	Andrew Zhilin	View Answer on Stackoverflow

How can I use now() in Doctrine 2 DQL?

Mysql Problem Overview

Mysql Solutions

Solution 1 - Mysql

Solution 2 - Mysql

Check if date is in the past Javascript

is memory leak? why java.lang.ref.Finalizer eat so much memory

Attributions