ORM and PHP class design 1

[SPrelewicz]

I am doing an application where I have essentialy a class per table of my mySQL database. I am stuck at a one-to-many and how to implement the classes.

Specifics:
I have a property table (and class), and an apartment table(and class). The apartment table has a foreign key property_id to the property it belongs to. Currently, when I instantiate an apartment, I have a new Property being created as a property attribute. Thus, I can get the properties information by $apartment->property->get_property_name, etc...

Okay, that part seems correct. Now, if I have a property and I want to get all the apartments of that property when I instantiate the property object, I run into proplems. In the constructor I have $property->apartments = new apartmentCollector(). [I use a collector class for lists]. It hanges here, as it seems to get caught when the APARTMENT is instantiating a new Property, but I am instantiating the apartment from Property(). Makes sense?

Does anyone have any advice on how to do this properly?

Thank you,
Scott

This may not seem to PHP, but I am using PHP, and am looking for examples *in* php

 

[SPrelewicz]

As a follow up, since I'm asking for advice...

Should I be implementing in some way so that in the example above I could just do something like $apartment->get_property_name() without calling it from the property object. If so, how? Just have a function in apartment called get_property_name() and have it return $this->property->property_name, or is there a better way? This sint an inheritance situation, so that wouldnt work.

 

[Xaqte]

Just use CSS...

You can search this forum:

http://www.tek-tips.com/threadminder.cfm?pid=215&page=1

Or you can check out this thread for starts:
thread215-1285953

 

[Miros]

Pass the property into the apartment constructor and set it instead of creating a new property.

 

[SPrelewicz]

Ahh, yes Miros, that makes sense. I'll give that a go and see if my OO design falls into place.

Thank you.

Scott

 

[jpadie]

I'm completely flummoxed by Xacte's post.

 

[Xaqte]

Sorry, posted in wrong thread...

I don't know what I was thinking