49 thoughts on “CodeIgniter 2 and Doctrine 2 Integration – A working setup (DoctrineIgnited)”

1. acenosekai on February 11, 2011 at 7:50 pm said:

   sorry im noobs…
   how to generate schema with doctrine schema tools

   i use this code but not work……

   $tool = new \Doctrine\ORM\Tools\SchemaTool($em);
   $classes = array(
   $em->getClassMetadata(‘models\User’),
   );
   $tool->createSchema($classes);
2. acenosekai on February 11, 2011 at 7:54 pm said:

   $tool = new \Doctrine\ORM\Tools\SchemaTool($this->em);
   $classes = array(
   $this->em->getClassMetadata(‘models\User’),
   );
   $tool->createSchema($classes);

   i changed $em with $this->em
   and its solved my problem
3. shinee on March 4, 2011 at 2:23 am said:

   I downloaded the file to eclipse, and i get file errors
   please help
4. Bangon Kali on March 6, 2011 at 7:39 am said:

   Hi! I’m trying to use your setup. I’m on Windows XP using Appserv. But I’m encountering problems with the setup. The problem is described below:

   [CODE]
   ErrorException [ Parse Error ]: syntax error, unexpected T_STRING
   FCPATH/application\controllers\home.php [ 45 ]
   40 }
   41
   42 function newuser() {
   43 /* Same as before, except we have to reference our User model
   44 This shows how to add new entries */
   45 $user = new models\User;
   46 $user->setUsername(‘my username’);
   47 $this->em->persist($user);
   48 $this->em->flush();
   49
   50 // Test the new entry, grab the new username
   {PHP internal call} » MY_Exceptions::shutdown_handler()
   [/CODE]
5. Bangon Kali on March 6, 2011 at 9:15 am said:

   Lol! I’m really sorry! It was my bad! I had used an older version of PHP which doesn’t support namespaces! I used PHP 5.3.0 now, and it’s working fine! I also got in to problems because I forgot to enable mod_rewrite for my Apache. Too bad Appserv doesn’t have a version which has a PHP version of lower than Alpha 6 and Greater than 5.3.0 now, so I had to use WAMP. Anyway, i just got used to it!

   TO summarize, here are the important things i failed to take in to consideration in setting up this system:
   1. Use PHP 5.3.0 and above
   2. Enable Apache rewrite_module
   3. Enable PHP short_open_tag

   Thanks for everything!
6. Tim Selaty on March 6, 2011 at 1:56 pm said:

   Ah, yes! Thanks for pointing those out. I’ll update the guide to include your findings.
7. Ege Özcan on March 6, 2011 at 3:21 pm said:

   Thanks a lot for the effort!

   By the way, if your app will need proxies, you have to create a writeable proxies folder under your models folder. It took me hours to realize =))
8. Bangon Kali on March 6, 2011 at 10:51 pm said:

   Guys, I’m having problems using DQL statements with getRepository. For example:

   $users = $this->$em->getRepository(‘models\User’)->findBy(array(‘username’ => ‘asdkfjsdfasd’));

   Yields the following result:
   ErrorException [ Fatal Error ]: Cannot access empty property

   The shorter one:
   $user = $this->em->find(‘models\User’,’1′);

   Has no problems though. How do i use DQL statements properly with doctrine?
9. Tim Selaty on March 6, 2011 at 11:08 pm said:

   Try changing “$this->$em” to “$this->em” to take care of the first error. The second error will come from trying to call the setUsername property on a non-object.

   Try using “$user = $this->em->getRepository(‘models\User’)->findOneBy(array(‘username’ => ‘Bob’));” instead of “findBy” as compared to “findOneBy”. “findBy” will return the result as an array instead of just a straight up object.
10. Tim Selaty on March 6, 2011 at 11:19 pm said:

    What sort of errors are you experiencing?
11. Bangon Kali on March 6, 2011 at 11:30 pm said:

    LoL! Thank you very much! That was so stupid! I didn’t notice it. Thanks!
12. Bangon Kali on March 7, 2011 at 12:26 am said:

    Hi! I have another problem. I’m getting this weired results from these lines of code:

    $posted_username = $this->input->post(‘username’);
    $posted_password = $this->input->post(‘password’);

    $DQLquery = “select a from models\User a WHERE a.username = :name AND a.password = :name2″;
    $query = $this->em->createQuery($DQLquery);
    $query->setParameters(array(
    ‘:name’ => $posted_username,
    ‘:name2′ => $posted_password,
    ));

    $users = $query->getResult(); // array of ForumUser objects

    It said:

    Doctrine\ORM\Query\QueryException [ 0 ]: Invalid parameter: token :name is not defined in the query.
13. Bangon Kali on March 7, 2011 at 12:32 am said:

    Damn! Once again, my bad! I found out there’s an error in the documentation from here http://bit.ly/eN6JcG. Hope this helps others.

    This example was given in the documentation:
    $query = $em->createQuery(‘SELECT u from ForumUser u WHERE (u.username = :name OR u.username = :name2) AND u.id = :id’);
    $query->setParameters(array(
    ‘:name’ => ‘Bob’,
    ‘:name2′ => ‘Alice’,
    ‘:id’ => 321,
    ));
    $users = $query->getResult(); // array of ForumUser objects

    It turned out that the setParameters function should not receive tokens with the colon prefix. The correct way should be:

    $query = $em->createQuery(‘SELECT u from ForumUser u WHERE (u.username = :name OR u.username = :name2) AND u.id = :id’);
    $query->setParameters(array(
    ‘name’ => ‘Bob’,
    ‘name2′ => ‘Alice’,
    ‘id’ => 321,
    ));
    $users = $query->getResult(); // array of ForumUser objects

    I’ll be reporting this as soon as possible to the developers.
14. Haneef on March 25, 2011 at 9:10 am said:

    Thank you so much for providing this integration! It’s making starting up each project much easier and saved me a ton of time!
15. Mohamed Amine on March 25, 2011 at 3:17 pm said:

    Thanks a lot for this great work, It really help me a lot
16. Bangonkali on March 25, 2011 at 3:37 pm said:

    @Hanef, I’m also making an open source integration based on this one. If you have time, you can check it out at Codeplex! http://doctrineigniter.codeplex.com/ I’m planning to make this one widespread. And with community support. If you begin to understand how things work, please join us as one of the developers!
17. dikasths on March 31, 2011 at 7:59 am said:

    Hi! Thanks a lot about the tutorial. It really helped me a lot. I have a question: I’m trying to use Doctrine_Query in one of my controllers and i get an error:
    ErrorException [ Fatal Error ]: Class ‘Doctrine_Query’ not found
    What can i do?

    Thank you in advance. I’m not really experienced.
18. Bangonkali on April 3, 2011 at 6:09 pm said:

    You’re probably using an object that is no longer available on Doctrine 2. The Class Doctrine_Query as discussed on this Official Doctrine Documentation from Version 1.2, I think is no longer available on Version 2. You probably should just use Querybuilder from this Documentation instead http://j.mp/h4pmbK.
19. zark on April 6, 2011 at 5:38 am said:

    I am trying to move the $em->persist and $em->flush into the model so that I can have the model control the saving to the DB..

    I can’t seem to work out how to load the entitymanager in the model though. $this->em = $this->doctrine->em; in the _construct of the model gives Undefined property: models\User::$doctrine

    Do you have any hints for me? Thanks
20. Bangon Kali on April 9, 2011 at 9:24 am said:

    @Zark. If you’re using DoctrineIgniter or this one there’s no need load the model on the entity manager from the construct. I hope this can serve as an example Model.

    
public function setUsername($username) { $this->username = $username; }
public function getUsername() { return $this->username; }

    // Setters and Getters
    public function setPassword($password) { $this->password = $password; }
    public function getPassword() { return $this->password; }

    public function setEmail($email) { $this->email = $email; }
    public function getEmail() { return $this->email; }

    public function setFacebookID($facebook_id) { $this->facebook_id = $facebook_id; }
    public function getFacebookID() { return $this->facebook_id; }

    public function setRefererID($referer_id) { $this->referer_id = $referer_id; }
    public function getRefererID() { return $this->referer_id; }

    // Magic Methods
public function __toString()
{
$retVal = "Username: " . $this->username . " ";
$retVal .= "Password: " . $this->password . " ";
$retVal .= "Email: " . $this->email . " ";
$retVal .= "Facebook ID: " . $this->facebook_id . " ";
$retVal .= "Referer ID: " . $this->referer_id;
return $retVal;
}
}

21. Bangon Kali on April 9, 2011 at 9:27 am said:

    Ok. My bad, Im sorry. That seems to have been messed up in the comment system. I pasted it instead here http://pastebin.com/3xzsAw8d as an example of a model. This is what i’m using in a website I developed last month.
22. zark on April 9, 2011 at 2:54 pm said:

    @Bangon Kali.
    Thanks for reply.
23. Tim Selaty on April 11, 2011 at 1:45 am said:

    I’ve updated your comment Bangon Kali, as the code tags you were using was [code] rather than <code>
24. greg on April 11, 2011 at 5:35 am said:

    for those who get this kind of message: trine ORM Class “not a valid entity or mapped super class” Error …

    just check your caching system.

    I figured out the cause of the problem was the caching system while i was using eAccelerator on MAMP i just turned it to APC which works well now
25. Krzysztof on April 24, 2011 at 6:03 am said:

    I apologize for disturbing the peace, but the problem has outgrown me, absolutely.
    If you can look at:

    https://groups.google.com/group/doctrine-user/browse_thread/thread/23fb347a15a97ae?hl=pl

    Thank You very much for Your help
26. Tim Selaty on April 25, 2011 at 12:27 am said:

    Can I see your User model code? Try pasting it into http://pastebin.com/
27. Krzysztof on April 25, 2011 at 6:26 am said:

    I guess it worked …. Link:
    http://pastebin.com/zZJ5yjkq
28. wu on April 27, 2011 at 4:09 am said:

    Hi im new in CI and Doctrine,

    after making those instructions:

    $obj= new Home;
    $obj->test();
    $obj->newuser();

    I get error:

    ErrorException [ Notice ]: Undefined property: Home::$doctrine

    FCPATH/application\core\MY_Controller.php [ 15 ]
    10 parent::__construct();
    11
    12 /* Instantiate Doctrine’s Entity manage so we don’t have
    13 to everytime we want to use Doctrine */
    14
    15 $this->em = $this->doctrine->em; //focused here
    16 }
    17
    18 }

    FCPATH/application\core\MY_Controller.php [ 15 ] » MY_Exceptions::error_handler(arguments)

    FCPATH/application\controllers\home.php [ 10 ] » MY_Controller->__construct()

    FCPATH/system\core\CodeIgniter.php [ 267 ] » Home->__construct()

    FCPATH/index.php [ 163 ] » require_once(arguments)

    And under this i get results:

    Bob
    my username
    My Test message

    Whats wrong?

    My serv is PHP 5.3.5, mod rewrite and open short tags are enabled
29. Andre on May 10, 2011 at 9:19 am said:

    Thank you so much for an excellent integration!

    It works perfectly! I was able to re-write your example for CRUD in minutes and I’m up and running.

    Your work was really a life saver.

    I wonder if including the models generation libraries and explain how you would generate models in this setup would help others.

    Even a quick post on what to add and where to generate entities could really help me. I have a monster 136 entity schema to hook up and have generated the basic YAML and XML for it, but am stuck at how to generate at least the starting Model classes from YAML or XML… Happy to add the refinement by hand.

    But THANKS! again. Even if I have to hand code and re-factor the models from the unit tests it will be better than trying to set up the integration which you did so well.

    Any ideas?
30. Joseph on May 22, 2011 at 3:51 am said:

    Hey, thanks for the mention in your post. I’ve linked back to this post here: http://wildlyinaccurate.com/codeigniter-2doctrine-2-installation/

    Joseph
    Wildly Inaccurate
31. Tim Selaty on May 22, 2011 at 5:52 am said:

    Thanks!
32. live version on June 19, 2011 at 6:38 pm said:

    Is there a Live Version somewhere that I missed or even some Screenshots?
33. J on June 23, 2011 at 12:25 pm said:

    Thank you so much! I spent days trying to get Doctrine working with Codeigniter by myself and got lost with all the different information for different versions of Doctrine and CI on the web. This is so helpful.
34. Thomas Freewill on July 15, 2011 at 3:53 am said:

    Thank you for this detailed step by step tutorial. The whole Doctrine2 ORM is really good and I enjoy working with it on all of my projects .

    Few weeks ago I also found ORM-Designer (http://www.orm-designer.com) project which enables you do all modeling stuff for Doctrine2 in visual editor instead of writing yaml/xml files. Maybe it will help someone else to work more efficiently as me does
35. egga radiegtya on July 21, 2011 at 1:57 am said:

    please make tutorial about one to many relationship using doctrine. i get error message when doing it.

    ErrorException [ Warning ]: file_put_contents(application//models/proxies\modelsaddressProxy.php) [function.file-put-contents]: failed to open stream: No such file or directory

    I dunno what to do.. Thanks

36. Pingback: CodeIgniter 2/Doctrine 2 Installation « Wildly Inaccurate

37. kerti on August 3, 2011 at 8:45 pm said:

    This is great! Thanks for making my life easier.
    I do have one question, though. How do I use fixtures with it?
38. Tim Selaty on August 3, 2011 at 9:28 pm said:

    Hi Egga,

    Regarding the exception error, it looks like you’ve got two forward slashes in addition to the combination of forward and backward slashes in your file_put_contents() function. I’d start by making sure they’re all forward single slashes.
39. Ariel on August 8, 2011 at 3:35 pm said:

    Hi, first of all, sorry for my english, im from Argentina and don’t speak english very well.
    Thank you for your guide and the set up project.
    Here is the thing, i’ve installed it and works. I have some projects at CodeIgniter, and i recently knew about the “doctrine” and i became crazy , it’s pretty cool.
    So, my question is… looking at the future, when a new version of codeigniters become, will not have a lot of problems for upgrade my projects with the compatibility to Doctrine? May i worry about it?
40. Tim Selaty on August 8, 2011 at 4:14 pm said:

    The makers of CodeIgniter and Doctrine both try pretty hard to make their code backwards compatible. In the case where there’s a complete revision in the programming and functionality of either software, it shouldn’t effect your site’s that you used the old with.

    Think of it this way. CodeIgniter and Doctrine both provide a series of tools to help develop things quicker. That’s their main purpose. If they helped you accomplish that goal In a version 2 release of the code, then it’s accomplished its purpose. If a version 3 of the code comes up, that’s great, but doesn’t mean you have to.. or should in some case.. update your old site’s code to use the new version if there is a risk factor involved.
41. Ariel on August 8, 2011 at 4:25 pm said:

    Ok, it has sense. Thank you.
    Do you know where can i learn to use the doctrine 2? Is any examples (prefer with codeigniter)? If not, i will read the documentation, but i preffer examples.

    Thank you again,
42. egga radiegtya on August 12, 2011 at 8:10 pm said:

    thanks for reply.. u say that i must make all single slashes. but i don’t do anything about that slash.. i just made this function and it automatically call the double slashes

    function getById() {
    $user = $this->em->find(‘models\User’, 1);
    $address = $user->getAddress();
    echo $address->getAddress();
    }

    the relationship is User manyToOne Address

    please help me
43. Tim Selaty on August 15, 2011 at 2:46 am said:

    As an update to all, I’ve deviated from Doctrine and CodeIgniter for now in favor (in my opinion) a more powerful platform to develop in called “Django” written in Python (far superior syntax).

    I recommend everyone check it out and go through the first few pages of the tutorial (even if you don’t follow along with making the code in the examples). The real strength with Django is it’s like combining CodeIgniter, Doctrine 2, CodeIgniter’s Scaffolding (except it’s incredibly secure) all in two files of a hundred lines or so.

    I’ll hopefully be doing a write-up soon of my adventures, or better yet, some video tutorials showcasing some coding from scratch.
44. Tim Selaty on August 15, 2011 at 2:50 am said:

    Egga,

    Without seeing the base of your code or downloading the ZIP to try it out myself, I can provide little programmatic advice from here. However, I would check out the following:

    1. application/models/proxies/modelsaddressProxy.php
    Make sure this file exists in the exact location it’s looking for. Uppercasing, lowercasing, etc.

    2. Is it trying to include the file from your default local PHP path? Sometimes PHP likes to start at a distant include directory included with your PHP installation rather than the folder of the PHP file that is executing the method.

    I’ll need more information or a ZIP to assist further.
45. egga radiegtya on August 15, 2011 at 6:10 pm said:

    Thanks
    application/models/proxies/modelsaddressProxy.php??
    i don’t know is that file exist. i don’t find that file although I redownload your zip pack. where can I upload my file to show you my code? thanks
46. sew on September 22, 2011 at 4:20 am said:

    Hi i was wondering that can i merge doctrine and CI active records to work together? For me the blessing thing in doctrine is optimistic lock mechanism, which i want to use to prevent db integrity issues when saving data. But for simple data selecting , in my opinion AR is enough and comfortable, and maybe there is also a better performance at all against using Doctrine read methods?
    So, for data persistence – Doctrine, for simple data read – AR.

    What do you all thing about this?
47. Sam on November 28, 2011 at 5:09 am said:

    Hi,
    Thanks for the integration pack.
    Trying out this tutorial “http://www.phpandstuff.com/articles/codeigniter-doctrine-scratch-day-4-user-login/comment-page-1#comment-69202″. Doesn’t seem to work.
    1st of all I can’t access another class Current_User::login() as mentioned in the tutorial.It says class not found.

    Thanks for any help.
48. Sharry on March 13, 2012 at 9:51 am said:

    Thank you! This has helped us a great deal!
49. pixma_uy on March 28, 2012 at 6:35 am said:

    Great tutorial thank you!!! I’m new with CI+Doctrine and I need some examples about, how to work with inheritance with only one example with some INSERT, so on, I’m going to be very grateful!!.

    Thanks Diego