Foreign Key Has Many

Yii 1.1 General Discussion
1

hi ter,

i have two table

User

id,

name,

emel,

password,

Contact

name,

address,

hp,

tel,

relation,

user_id(fk)

The issue is,a user can have more contact details.

how to define in model that contact has many to user table.

also how to insert contact data(multiple rows) in controller?

any idea pls suggest ?

2

hi, please read:

http://www.yiiframework.com/wiki/428/drills-search-by-a-has_many-relation/

3

ok,tq for the reply.

anyhow the above link shows only for retieval data from database.

how bout insert data into db?

4

You can do it manually for example:




$user = new User

$user->user_name = 'user1'

$user->first_name = 'FirstName'

$user->address->address_line_1 = '10 Downing Street'

$user->address->postcode = 'SW1A 2AA'

$user->address->save();

$user->address_is=$user->address->primaryKey;

$user->save()

or You can use some extension:

http://www.yiiframework.com/extension/activerecord-relation-behavior/

5

hi ter,

based on ur code i able to understand partially.

how to do, basde on below example i would like to add on data into rows with multiple data but column name is the same.

such as,

$user = new User

$user->user_name = ‘user1’

$user->first_name = ‘Abrham’

$user->address->address_line_1 = ‘10 Downing Street’

$user->address->postcode = ‘SW1A 2AA’

$user->address->save();

$user->address_is=$user->address->primaryKey;

$user->save()

$user->user_name = ‘user2’

$user->first_name = ‘JOhn’

$user->address->address_line_1 = ‘1 USA Street’

$user->address->postcode = ‘HJH D333A’

$user->address->save();

$user->address_is=$user->address->primaryKey;

$user->save()

means i would like to insert these data into two rows wih at same time without overriding it.(like append)

Thanks