Thread: [Phpgedview-talk] need help with table structure
Brought to you by:
canajun2eh,
yalnifj
From: Kyle M. <mat...@gm...> - 2007-05-06 22:42:17
|
My family is attempting to organize our genealogical information on the internet. We are using three sites. We're using PhpGedView<http://www.familyhistory.mathews2000.com/gedview>to organize the normal genealogical information. Then a wiki to organize stories <http://www.familyhistory.mathews2000.com> / autobiographies and other such text. And then Gallery to organize photos<http://www.familyhistory.mathews2000.com/gallery>of our ancestors. We're pleased with the setup, especially PhpGedView, but are working on fixes to improve the sites. One thing I'm working on is with the wiki. Each ancestor has their own wiki page from which is linked all stories related to them. We want each ancestor page to have on it basic biographical information (birth, marriage, death, etc.). To ensure that the information is accurate we want to import the data to the wiki from PhpGedView. Right now we're just taking the person's PhpGedView page and placing it in an IFrame on the wiki. That works, but it's slow and has too much information. What I'm trying to do now is write a php script which will pull only the information we need off the PhpGedView database and place it in the wiki. I've got part of it working -- I can get the dates off the database but am confused how to get the places associated with those dates off the database. I've looked through the documentation but couldn't find anything useful. If it is there, someone please point it out to me. Else, just point me toward the code which performs this function in PhpGedView. This is my first PHP project but I can read PHP code alright. Thanks in advance, Kyle Mathews |
From: peter <pet...@hc...> - 2007-05-08 08:16:31
|
Kyle, DB2 is a IBM product, you can find information, http://www-306.ibm.com/software/sw-bycategory/subcategory/SWB30.html The opensource information from IBM, http://www-128.ibm.com/developerworks/ibm/osource/ May be this pages can help you. Regards, Peter Al Kyle Mathews schreef: > My family is attempting to organize our genealogical information on the > internet. We are using three sites. We're using PhpGedView > <http://www.familyhistory.mathews2000.com/gedview> to organize the > normal genealogical information. Then a wiki to organize stories > <http://www.familyhistory.mathews2000.com> / autobiographies and other > such text. And then Gallery to organize photos > <http://www.familyhistory.mathews2000.com/gallery> of our ancestors. > > We're pleased with the setup, especially PhpGedView, but are working on > fixes to improve the sites. One thing I'm working on is with the wiki. > Each ancestor has their own wiki page from which is linked all stories > related to them. We want each ancestor page to have on it basic > biographical information (birth, marriage, death, etc.). To ensure that > the information is accurate we want to import the data to the wiki from > PhpGedView. Right now we're just taking the person's PhpGedView page > and placing it in an IFrame on the wiki. That works, but it's slow and > has too much information. > > What I'm trying to do now is write a php script which will pull only the > information we need off the PhpGedView database and place it in the > wiki. I've got part of it working -- I can get the dates off the > database but am confused how to get the places associated with those > dates off the database. > > I've looked through the documentation but couldn't find anything > useful. If it is there, someone please point it out to me. Else, just > point me toward the code which performs this function in PhpGedView. > This is my first PHP project but I can read PHP code alright. > > Thanks in advance, > Kyle Mathews > > > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------- > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > > > ------------------------------------------------------------------------ > > _______________________________________________ > Phpgedview-talk mailing list > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phpgedview-talk |
From: Kyle M. <mat...@gm...> - 2007-05-08 13:28:01
|
Sorry, I must not of been clear enough. I need help understanding the database schema for phpgedview, how to retrieve the place names for different dates. E.g. if John Smith was born April 1, 1823, how can I retrieve off the database where he was born? Could someone please just tell me where in the existing phpgedview code this is done so I can duplicate that? Thanks, Kyle On 5/8/07, peter <pet...@hc...> wrote: > > Kyle, > > DB2 is a IBM product, you can find information, > http://www-306.ibm.com/software/sw-bycategory/subcategory/SWB30.html > > The opensource information from IBM, > http://www-128.ibm.com/developerworks/ibm/osource/ > > May be this pages can help you. > > Regards, Peter Al > > > Kyle Mathews schreef: > > My family is attempting to organize our genealogical information on the > > internet. We are using three sites. We're using PhpGedView > > <http://www.familyhistory.mathews2000.com/gedview> to organize the > > normal genealogical information. Then a wiki to organize stories > > <http://www.familyhistory.mathews2000.com> / autobiographies and other > > such text. And then Gallery to organize photos > > <http://www.familyhistory.mathews2000.com/gallery> of our ancestors. > > > > We're pleased with the setup, especially PhpGedView, but are working on > > fixes to improve the sites. One thing I'm working on is with the wiki. > > Each ancestor has their own wiki page from which is linked all stories > > related to them. We want each ancestor page to have on it basic > > biographical information (birth, marriage, death, etc.). To ensure that > > the information is accurate we want to import the data to the wiki from > > PhpGedView. Right now we're just taking the person's PhpGedView page > > and placing it in an IFrame on the wiki. That works, but it's slow and > > has too much information. > > > > What I'm trying to do now is write a php script which will pull only the > > information we need off the PhpGedView database and place it in the > > wiki. I've got part of it working -- I can get the dates off the > > database but am confused how to get the places associated with those > > dates off the database. > > > > I've looked through the documentation but couldn't find anything > > useful. If it is there, someone please point it out to me. Else, just > > point me toward the code which performs this function in PhpGedView. > > This is my first PHP project but I can read PHP code alright. > > > > Thanks in advance, > > Kyle Mathews > > > > > > ------------------------------------------------------------------------ > > > > > ------------------------------------------------------------------------- > > This SF.net email is sponsored by DB2 Express > > Download DB2 Express C - the FREE version of DB2 express and take > > control of your XML. No limits. Just data. Click to get it now. > > http://sourceforge.net/powerbar/db2/ > > > > > > ------------------------------------------------------------------------ > > > > _______________________________________________ > > Phpgedview-talk mailing list > > Php...@li... > > https://lists.sourceforge.net/lists/listinfo/phpgedview-talk > > ------------------------------------------------------------------------- > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ > Phpgedview-talk mailing list > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phpgedview-talk > |