samra Posted August 13, 2015 Share Posted August 13, 2015 I want to create a family tree site in php. That site should be able to display the parent and child nodes along with their spouse. I also need to display relation between the member of any nodes level to any other person on the basis of their common ancestor in the tree. Now am totally at loss regarding the db schmea. so far i have created a table named family_tree which include the following fields: family_id name spouse_name parent_level (e.g 1,2,2 so on nodes levels) children it all seems quite vague sort of thing to me. dont know where exactly should be proceeding. how many tables i will be needing? how these tables should be related? please reply. thanks Link to comment https://forums.phpfreaks.com/topic/297772-creating-family-tree-in-php/ Share on other sites More sharing options...
Barand Posted August 13, 2015 Share Posted August 13, 2015 perhaps +---------------+ | family_tree | +---------------+ | family_id | | firstname | | surname | | gender | | spouse_id | | mother_id | | father_id | +---------------+ Link to comment https://forums.phpfreaks.com/topic/297772-creating-family-tree-in-php/#findComment-1518732 Share on other sites More sharing options...
samra Posted August 13, 2015 Author Share Posted August 13, 2015 thanks for your reply. searching for the common ancestor can work out too with this single table? am just a newbie in php, just know CRUD so far. Link to comment https://forums.phpfreaks.com/topic/297772-creating-family-tree-in-php/#findComment-1518733 Share on other sites More sharing options...
Barand Posted August 13, 2015 Share Posted August 13, 2015 Search following the id links for matching ids Link to comment https://forums.phpfreaks.com/topic/297772-creating-family-tree-in-php/#findComment-1518738 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.