Re: Using two tables

I think you need to have a look at hasMany.

User has many my_files. http://book.cakephp.org/view/1043/hasMany

So something like:

class User extends AppModel {
var $name = 'User';
var $hasMany = 'MyFile';
}

On Jan 30, 10:33 pm, newguy <aimanparv...@gmail.com> wrote:
> Hi
> I am working on implementing file upload functionality in my site, I
> have a table called users which contains user's login information.
> I want to have another table my_files with the following fields in
> which I can store the file uploaded by the user.
>
> `id`, `name`, `created`, `modified'
>
> My database.php file has this:
>
> <?php
> class DATABASE_CONFIG
> {
>    var $default = array('driver'   => 'mysql',
>                         'connect'  => 'mysql_pconnect',
>                         'host'     => 'localhost',
>                         'login'    => 'root',
>                         'password' => 'root',
>                         'database' => 'users' );}
>
> ?>
>
> I want to know how should I include this new table in my code and use
> it to save the uploaded file and its information.
>
> This is my view file for upload option(upload.ctp):
>
> <?php
>     echo $form->create('User', array('action' => 'upload', 'type' =>
> 'file'));
>     echo $form->file('File');
>     echo $form->submit('Upload');
>     echo $form->end();
> ?>
>
> This is my only model file:
> <?php
> class User extends AppModel
> {
>   var $name = 'User';
>   var $otherDB='my_files';
>   var $validate = array(
>     'username' => array(
>     'rule' => 'isUnique',
>     'message' => 'Username not available'
>     ),
>     'password' => array(
>     'rule' => array('minLength',8),
>     'message' => 'Minimum length is 8'
>     ),
>     'email' => array(
>     'rule' =>  array('email',true),
>     'message' => 'Enter valid email address'
>     )
>   );
>
> }
>
> ?>
>
> I have nothing for upload in the controller.
>
> I have read previous posts about using multiple tables but could
> really understand because of my limited knowledge in php/cake.
> Thanks

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.

To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php