Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • Discussion on Database Access and Object-relational mapping(ORM) in cakephp 3

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 842
    Comment on it

    Hi Readers,
    Welcome to FindNerd, today we are going to Discussion on Database Access and ORM in CakePHP 3.

    The new version of CakePHP comes with lots of new features and changes in it.

    To access the database in CakePHP 3 there are two main objects.

    1-Table objects.
    2- Entities
    .

    Let me explain one by one

    1-Table objects : It provides the access to the collection of data.

    2- Entities : It provides the access to the row record level data.

    ORM is also an important feature for making relation in the database.

    For the using ORM in cakephp3 for conventions the database then you have to the following the process.

    Load data from table articles.

    <?php 
         use Cake\ORM\TableRegistry;
        $articles = TableRegistry::get('Articles');
        $query = $articles->find();
        foreach ($query as $row)
        {
        echo $row->title;
        }
    
    ?>

    If you want to apply method you can direct go to the model of that table and code there.

    namespace App\Model\Table;

    Now when you have concrete table classes you can create concrete entity class.

    <?php 
    
         use Cake\ORM\Table;
        class ArticlesTable extends Table {
        }
    ?>

    Now let  define accessor and mutator method.

    namespace App\Model\Entity;

    Now you can load the entities

    <?php 
         use Cake\ORM\Entity;
        class Article extends Entity {
        }
    
    ?>

     Now an instance of ArticlesTable.

     <?php 
        $articles = TableRegistry::get('Articles');
        $query = $articles->find();
        foreach ($query as $row) {
        // Each row is now an instance of our Article class.
        echo $row->title; }
     ?>

     

 0 Comment(s)

Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: