I use doctrine with symfony, and this is how I do:

&lt;code&gt;where(&#39;a.vertical_id is NULL&#39;);&lt;/code&gt;

If you are using Symfony 2 and above, you can use this code:

    -&gt;where($qb-&gt;expr()-&gt;isNull(&#39;a.vertical_id&#39;));

Reference:  
http://docs.doctrine-project.org/projects/doctrine-orm/en/latest/reference/query-builder.html#the-expr-class

There is no option in the file menu to rename a workspace.  Is the recommended practice to close eclipse, rename the folder, and re-open? I worry about some potential dangling references in configuration files corrupting my workspace/projects...
 
Thanks!

eclipse workspace: how to rename workspace

What is the alternative to `\n` (for new line) in a `MsgBox()`?


How to use \n new line in VB msgbox() ...?

I am using Doctrine 1.1 in Zend. I am trying to write a query that will return records that have a null value in a certain column.

		$q = Doctrine_Query::create()
		-&gt;select(&#39;a.*&#39;)
		-&gt;from(&#39;RuleSet a&#39;)
        -&gt;where(&#39;a.vertical_id = ?&#39;, null);

		$ruleset_names_result = $q-&gt;execute(array(), Doctrine::HYDRATE_ARRAY);

I have three records in the ruleset table which have a _NULL_ value in the vertical_id column yet the query doest not find these.

Appreciate the help.

Sid.

How to specify null value as filter in a Doctrine query?

I am using Doctrine 1.1 in Zend. I am trying to write a query that will return records that have a null value in a certain column.
<pre><code class="hljs language-css">	$q = Doctrine_Query::create()
	->select('a.*')
	->from('RuleSet a')
 ->where('a.vertical_id = ?', null);

	$ruleset_names_result = $q->execute(array(), Doctrine::HYDRATE_ARRAY);
</code></pre>
I have three records in the ruleset table which have a NULL value in the vertical_id column yet the query doest not find these.
Appreciate the help.
Sid.

How do I split a string by `.` delimiter in PHP? For example, if I have the string `&quot;a.b&quot;`, how do I get `&quot;a&quot;`? 

PHP: Split string

I am trying to decode a JSON string into an array but i get the following error.

&gt; Fatal error: Cannot use object of type
&gt; stdClass as array in
&gt; C:\wamp\www\temp\asklaila.php on line
&gt; 6

Here is the code:

    &lt;?php
    $json_string = &#39;http://www.domain.com/jsondata.json&#39;;
    
    $jsondata = file_get_contents($json_string);
    $obj = json_decode($jsondata);
    print_r($obj[&#39;Result&#39;]);
    ?&gt;

json_decode to array

I am downloading a JSON file from an online source and and when it runs through the loop I am getting this error:

&gt; Fatal error: Maximum execution time of 30 seconds exceeded in C:\wamp\www\temp\fetch.php on line 24

Fatal error: Maximum execution time of 30 seconds exceeded

What is the utility of the [global keyword][1]?

Are there any reasons to prefer one method to another?

 - Security?
 - Performance?
 - Anything else?

Method 1:

    function exempleConcat($str1, $str2)
    {
      return $str1.$str2;
    }

Method 2:

    function exempleConcat()
    {
      global $str1, $str2;
      return $str1.$str2;
    }

When does it make sense to use `global`?

For me, it [appears to be dangerous][2]... but it may just be a lack of knowledge.  I am interested in **documented** (e.g. with example of code, link to documentation...) technical reasons.

Thanks in advance!

---

### Bounty

This is a nice general question about the topic, I (@Gordon) am offering a bounty to get additional answers. Whether your answer is in agreement with mine or gives a different point of view doesn&#39;t matter. Since the `global` topic comes up every now and then, we could use a good &quot;canonical&quot; answer to link to.

  [1]: http://www.php.net/manual/en/language.variables.scope.php#language.variables.scope.global
  [2]: http://www.php.net/manual/en/language.variables.scope.php#language.variables.scope.references

PHP global in functions

Could someone please explain, with examples, what is meant by loop `break 2` or `continue 2` in PHP? What does it mean when `break` or `continue` is followed by a number?

What is meant by a number after &quot;break&quot; or &quot;continue&quot; in PHP?

Out of habit for checking null pointers, I have sometimes written:

    MyClass * c = someBasePtr ? dynamic_cast&lt;MyClass*&gt;(someBasePtr) : 0;
    if (c) {...

In effect, checking for a null pointer before passing to dynamic cast, and also checking the return.

I then read in the MSDN documentation 

&gt; A null pointer value is converted to
&gt; the null pointer value of the
&gt; destination type by dynamic_cast.

It appears then that I could remove the ?: construct safely.  Is this C++ *portable*?

Such that the new code would be

    MyClass * c = dynamic_cast&lt;MyClass*&gt;(someBasePtr);
    if (c) {...

Of course presuming that *someBasePtr* is either null or valid, i.e. not *wild* pointing to garbage...

Portably safe to pass NULL/zero to dynamic_cast?

I have added three methods with parameters:

    public static  void doSomething(Object obj) {
		System.out.println(&quot;Object called&quot;);
	}
	
	public static  void doSomething(char[] obj) {
		System.out.println(&quot;Array called&quot;);
	}

	public static  void doSomething(Integer obj) {
		System.out.println(&quot;Integer called&quot;);
	}

When I am calling `doSomething(null)` , then compiler throws error as **ambiguous methods**. So is the issue because `Integer` and `char[]` methods or `Integer` and `Object` methods?

Method Overloading for null argument

Let&#39;s say you have a method or a cmdlet that returns something, but you don&#39;t want to use it and you don&#39;t want to output it. I found these two ways:

    Add-Item &gt; $null

    [void]Add-Item

    Add-Item | Out-Null

What do you use? Which is the better/cleaner approach? Why?


What&#39;s the better (cleaner) way to ignore output in PowerShell?

I&#39;m trying to get the element with getElementById(), but it returns null even though the element exists. What am I doing wrong?

    &lt;html&gt;
	&lt;head&gt; 
		&lt;title&gt;blah&lt;/title&gt;
		&lt;script type=&quot;text/javascript&quot;&gt;
            alert(document.getElementById(&quot;abc&quot;));
		&lt;/script&gt;
	&lt;/head&gt; 
	&lt;body&gt;
		&lt;div id=&quot;abc&quot;&gt;

		&lt;/div&gt;
	&lt;/body&gt;
&lt;/html&gt;



getElementById() returns null even though the element exists

Is there a universal JavaScript function that checks that a variable has a value and ensures that it&#39;s not `undefined` or `null`? I&#39;ve got this code, but I&#39;m not sure if it covers all cases:

    function isEmpty(val){
        return (val === undefined || val == null || val.length &lt;= 0) ? true : false;
    }

Is there a standard function to check for null, undefined, or blank variables in JavaScript?

My entity uses this annotation for it&#39;s ID:

&lt;!-- language: lang-php --&gt;

    /**
     * @orm:Id
     * @orm:Column(type=&quot;integer&quot;)
     * @orm:GeneratedValue(strategy=&quot;AUTO&quot;)
     */
    protected $id;

From a clean database, I&#39;m importing in existing records from an older database and trying to keep the same IDs.  Then, when adding new records, I want MySQL to auto-increment the ID column as usual.

Unfortunately, it appears Doctrine2 completely ignores the specified ID.

- - -

**New Solution**

Per recommendations below, the following is the preferred solution:

&lt;!-- language: lang-php --&gt;

    $this-&gt;em-&gt;persist($entity);
    
    $metadata = $this-&gt;em-&gt;getClassMetaData(get_class($entity));
    $metadata-&gt;setIdGeneratorType(\Doctrine\ORM\Mapping\ClassMetadata::GENERATOR_TYPE_NONE);
    $metadata-&gt;setIdGenerator(new \Doctrine\ORM\Id\AssignedGenerator());


**Old Solution**

Because Doctrine pivots off of the ClassMetaData for determining the generator strategy, it has to be modified after managing the entity in the EntityManager:

&lt;!-- language: lang-php --&gt;

    $this-&gt;em-&gt;persist($entity);
    
    $metadata = $this-&gt;em-&gt;getClassMetaData(get_class($entity));
    $metadata-&gt;setIdGeneratorType(\Doctrine\ORM\Mapping\ClassMetadata::GENERATOR_TYPE_NONE);

    $this-&gt;em-&gt;flush();

I just tested this on MySQL and it worked as expected, meaning Entities with a custom ID were stored with that ID, while those without an ID specified used the `lastGeneratedId() + 1`.

Explicitly set Id with Doctrine when using &quot;AUTO&quot; strategy

**NOTE : if what I want is not possible, a &quot;not possible&quot; answer will be accepted**

In the [Doctrine 2 documentation about **inheritance mapping**][1], it says there are 2 ways :

 - Single table inheritance (STI)
 - Class table inheritance (CTI)

For both, there is the warning :

&gt; If you use a STI/CTI entity as a many-to-one or one-to-one entity **you should never use one of the classes at the upper levels** of the inheritance hierachy as “targetEntity”, only those that have no subclasses. Otherwise Doctrine CANNOT create proxy instances of this entity and will ALWAYS load the entity eagerly.

So, how can I proceed **to use inheritance with an association to the base (abstract) class** ? (and keep the performance of course)


----------


Example
-------

A user has many `Pet` (abstract class extended by `Dog` or `Cat`).

What I want to do :

    class User {
        /**
         * @var array(Pet) (array of Dog or Cat)
         */
        private $pets;
    }

Because of the warning in Doctrine documentation, I should do that :

    class User {
        /**
         * @var array(Dog)
         */
        private $dogs;
        /**
         * @var array(Cat)
         */
        private $cats;
    }

**This is annoying, because I loose the benefits of inheritance !**

*Note : I didn&#39;t add the Doctrine annotations for the mapping to DB, but you can understand what I mean* 

  [1]: http://www.doctrine-project.org/docs/orm/2.0/en/reference/inheritance-mapping.html

Doctrine 2 Inheritance Mapping with Association

Can someone tell me how to get all entities of one type which are marked with &quot;EDIT&quot; ACL permission?

I would like to build a query with the Doctrine EntityManager.

Symfony2: how to get all entities of one type which are marked with &quot;EDIT&quot; ACL permission?

I&#39;m developing game app and using Symfony 2.0. I have many AJAX requests to the backend. And more responses is converting entity to JSON. For example: 

    class DefaultController extends Controller
    {           
        public function launchAction()
        {   
            $user = $this-&gt;getDoctrine()
                         -&gt;getRepository(&#39;UserBundle:User&#39;)                
                         -&gt;find($id);
     
            // encode user to json format
            $userDataAsJson = $this-&gt;encodeUserDataToJson($user);
            return array(
                &#39;userDataAsJson&#39; =&gt; $userDataAsJson
            );            
        }
       
        private function encodeUserDataToJson(User $user)
        {
            $userData = array(
                &#39;id&#39; =&gt; $user-&gt;getId(),
                &#39;profile&#39; =&gt; array(
                    &#39;nickname&#39; =&gt; $user-&gt;getProfile()-&gt;getNickname()
                )
            );
            
            $jsonEncoder = new JsonEncoder();        
            return $jsonEncoder-&gt;encode($userData, $format = &#39;json&#39;);
        }
    }

And all my controllers do the same thing: get an entity and encode some of its fields to JSON. I know that I can use normalizers and encode all entitities. But what if an entity has cycled links to other entity? Or the entities graph is very big? Do you have any suggestions? 

I think about some encoding schema for entities... or using `NormalizableInterface` to avoid cycling..,

How to encode Doctrine entities to JSON in Symfony 2.0 AJAX application?

How do I use Doctrine in a service container?

The Code just causes an error message &quot;Fatal error: Call to undefined method ...::get()&quot;.

    &lt;?php
        
    namespace ...\Service;

    use Doctrine\ORM\EntityManager;
    use ...\Entity\Header;

    class dsdsf
    { 
        protected $em;

        public function __construct(EntityManager $em)
        {
            $this-&gt;em = $em;
        }
	
        public function create()
        {
            $id = 10;
            $em = $this-&gt;get(&#39;doctrine&#39;)-&gt;getEntityManager();
            $em-&gt;getRepository(&#39;...&#39;)-&gt;find($id);
        }
    }

services.yml

    service:
        site:
            class: ...\Service\Site

Symfony2 Use Doctrine in Service Container

    $ 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?

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	Mr B	View Question on Stackoverflow
Solution 1 - Php	Johannes	View Answer on Stackoverflow
Solution 2 - Php	John Carlos Espitia Rivera	View Answer on Stackoverflow

How to specify null value as filter in a Doctrine query?

Php Problem Overview

Php Solutions

Solution 1 - Php

Solution 2 - Php

How to use \n new line in VB msgbox() ...?

eclipse workspace: how to rename workspace

Attributions