Dear Michael Rocker,
Please see my answer for your questions

1. A model cannot have multiple table, but the functionality is satisfied
using puseudo-relationship of tables & associations



"A model is generally an access point to the database, and more
specifically, to a certain table in the database.
By default, each model uses the table who's name is plural of its own, i.e.
a 'User' model uses the 'users' table."


But some tweaks like :

class DummyModel extends Model
{
    var $useTable = false;

    public function ReadData()
    {
        // select table
        if($a == 1)
            $this->setSource('tableName1');
        else if($a == 2)
            $this->setSource('tableName2');
        // ...
        else if($a == N)
            $this->setSource('tableNameN');

        // now perform operations with selected table
        return $this->find('all');
    }
}


may work .

2 . A controller may have multiple models like

   // add this in your controller
   var $uses = array('Model2','Model3');

3 . Do you guys have any resources on designing databases so I can then
reflect that onto CakePHP?

    please check this URLs :
http://stackoverflow.com/questions/1530350/database-tools-for-cakephp

http://bakery.cakephp.org/articles/Frank/2008/07/29/database_design_and_cakephp

4 . are there any resources or more information on the model associations?

    Please Refer Manual of CakePHP ...


If you have still doubts , share your code and ask questions . I already
done an online examination project,
so I can help you with code.

With Warm Wishes,

ANES P A



https://www.facebook.com/anesp <http://www.facebook.com/anesp>
Email : [email protected]


On Tue, Aug 27, 2013 at 10:58 PM, Michael Roker <[email protected]> wrote:

> Hi folks, this is my new post. I am new to CakePHP, and to be honest I
> love it. However, I am definitely confused when it comes to the
> models/tables and associations. I am now working on a small project which
> is an online exam application. I've read the models section , in particular
> the models assocation but still very confused. I have some questions.
>
> For my 'objects' I have Users,Questions,Tests,TestScores. I am confused
> firstly that I have a UsersController, and a QuestionsController and not
> sure if I can have multiple models per controller. If this is true, then I
> can only have one table per Model? Do you guys have any resources on
> designing databases so I can then reflect that onto CakePHP? Lastly, are
> there any resources or more information on the model associations?
>
> I hope I didn't violate any policies being a new user and all.
>
> Thanks!
>
> --
> Like Us on FaceBook https://www.facebook.com/CakePHP
> Find us on Twitter http://twitter.com/CakePHP
>
> ---
> You received this message because you are subscribed to the Google Groups
> "CakePHP" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To post to this group, send email to [email protected].
> Visit this group at http://groups.google.com/group/cake-php.
> For more options, visit https://groups.google.com/groups/opt_out.
>

-- 
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

--- 
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/groups/opt_out.

Reply via email to