2. PHPRunner General questions
  3. Pedigree Tree Design
This topic is locked

Pedigree Tree Design

 		2/23/2016 6:28:45 AM
PHPRunner General questions
M
 mhollibush author

I will apologize up front, as I am new to all of this,
I bought PHPRunner this last weekend in hopes I would be able to learn how to setup a database website.

I have gotten pretty far in to the project, but now I am stumped.
I have a pedigree database and have the main layout set up.
I am looking for guidance on how to build a pedigree tree that will show the ancestry
on the details page of the Dog, I want to include the pedigree tree based on the dogid
each dog in the database has an id, and then that dog has a sire_id and dam_id associated with it
Admin 2/23/2016

This is not an easy task. The two main issues are:

  1. Prepare all data for the selected dog. I would guess this will require several SQL queries to execute.
  2. Handle the display part. This might be even more trickier as you need to create something fully custom.
    A few examples of how people doing that.
  3. Using Google Visualization API:

    https://developers.google.com/chart/interactive/docs/gallery/orgchart?csw=1#Example
  4. Use pure HTML tables approach as this page does:

    http://www.pedigreequery.com/malibu2
    In either case a serious amount of coding will be required.
M
 		mhollibush author 2/23/2016



This is not an easy task. The two main issues are:

  1. Prepare all data for the selected dog. I would guess this will require several SQL queries to execute.
  2. Handle the display part. This might be even more trickier as you need to create something fully custom.
    A few examples of how people doing that.
  3. Using Google Visualization API:

    https://developers.google.com/chart/interactive/docs/gallery/orgchart?csw=1#Example
  4. Use pure HTML tables approach as this page does:

    http://www.pedigreequery.com/malibu2
    In either case a serious amount of coding will be required.


I kind of figured it would be a massive project, I am willing to take it on... just looking for pointers, and it looks as though you are pointing me in the right direction. Thanks
S
 		snuffi01 2/23/2016

HI,

Maybe you could use this service: http://yuml.me/diagram/class/draw

Myself have had my thoughts to try it out but havent had the time.

I guess that the tricky part is to make the syntax to work in PHPRunner as it uses squarebrackets...
/ Kristian
jadachDevClub member 2/23/2016

I have done projects like this before.

I use Xlinesoft's products to maintain the back-end database administration of all listings (the admin site).

For the public facing bracket view as you are showing, I build another application outside of Xlinesoft's products to deliver. In my case it is a combination of ASPRunner.Net and Visual Studio. Together, the sky is the limit.
M
 		mhollibush author 2/24/2016



HI,

Maybe you could use this service: http://yuml.me/diagram/class/draw

Myself have had my thoughts to try it out but havent had the time.

I guess that the tricky part is to make the syntax to work in PHPRunner as it uses squarebrackets...
/ Kristian


Being a beginner at this, I am sure that I haven't thought out the whole process, and it will take some time to put this together and learn as I go.

any pointers are sure to help, Thanks
M
 		mhollibush author 2/24/2016



I have done projects like this before.

I use Xlinesoft's products to maintain the back-end database administration of all listings (the admin site).

For the public facing bracket view as you are showing, I build another application outside of Xlinesoft's products to deliver. In my case it is a combination of ASPRunner.Net and Visual Studio. Together, the sky is the limit.


I would be interested in how you did it ( examples )

I am by no means a sql or php person,
I bought PHPRunner in hopes it would simplify the process, I am learning that you still need some knowledge of SQL and PHP <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=78870&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />

I have a long way to go in order to get the basics understood