Urgent! Persistent PHP/MySQLcollections...

[sroughley]

Hey all.

I'm working on a project to a very tight deadline and have just realised that I will need to implement OO PHP for the Web-Interface to the application (we'd use JSP, but we haven't got the time to deal with configuration and licensing and we already have PHP and MySQL installed and ready to run).

So I'm trying to figure out a way of accomplishing one-to-many or many-to-many persistent-object relationships in PHP, using MySQL. In Java this is accomplished using Collections (public Collection className = new TreeSet(), but I was wondering how you guys feel that this is best accomplished in PHP/MySQL? I'm not too worried about code examples. The theory will be more than enough here.

Thank you for your time and help!

Regards.

Steve.

[aaron_karp]

I'm not totally sure if this is what you're looking for, but here's what I do when I'm doing 1:many and many:may relationships.

I give each of my tables in the MySQL database an ID column. This ID corresponds to the ID column of another table. I.e. I have a list of books in one table, and the AID (author ID) column there corresponds to the ID column of my Authors table. Thus many books can have the same AID (one:many). I also have a table listing email addresses of the authors, since some authors have many email addresses. Each email address also has an AID column that links it to the author.

Hope this helps....

[sroughley]

Cheers for the reply. That's how I usually do it with a relational database, but I am trying to achieve a similar thing here with Objects instead.

Regards.

Steve.