Family Tree Website using PHP & MySQL

Our family website was created using MS FrontPage 98. It has only individual pages and a Large Family Tree. We've grown to the point where it is impractical to make and maintain individual pages. I am looking to convert the website to a PHP interface to a MySQL database. Pages for individuals would be created "on the fly" with information from the database. We want to keep the look and feel as it currently exists, but we want to be able to make adds, moves, and changes to a page much easier. The website is located at: [_http://www.williamsonfamily.info_][1] and I strongly suggest that you to review it before bidding on this job. ## Deliverables + The existing “Family Tree?? should be the centerpiece of the website. It is located at [_[login to view URL]][2]; I don’t know how you would create it in PHP. + Every name on the Family Tree must have a hyperlink to a page. + We’d like for the website to have a button to create a PDF (on demand) of the Family Tree that viewers could download. + Each page needs a button to create a PDF (on demand) of a page. + An option on the page to view it as a “Family Tree?? that shows their place on the “tree??. + All pages must share a uniform background that closely resembles the "wallpaper" currently used. + Use Bookman Old Style, 10 to 12 point size. We need to be able to **BOLD** certain words and **COLOR** certain others. + All pages for individual people must include these items: + FULL NAME in UC & LC, **Large Bold **18 Point. + Full lineage, as shown on existing website. + Birthdate + Where Born + Married (date & info) + Military + Occupation + Religion + Known Medical Conditions + Date Of Death + Final Resting Place + Links To Pages Associated With This Person + Misc. Notes + Source References + Horizontal Line + Pictures & Documents + Data entry people should be able to hyperlink any word, phrase, or picture. + Information in most fields is TEXT of varying length. + We need a counter at the bottom of each page. + Needs an alphabetical list of “Associated Surnames??. Clicking a name should bring up a family tree for that family. + Pictures are displayed with associated text field. + All pages should have a horizontal bar (like on the existing website) between pictures. Account for in the database: + Multiple marriages, marriage date(s), and physical locations + Adopted children + Need 10 data entry accts and 2 Admin accounts. + Admins have full control of database, an easy way to backup / restore database. The ability to add, remove, or change Data Entry accounts. + Create a SEARCH Part of the Family Tree. It needs the ability to search the database and get a report based on a name and up to five (5) keywords in any field is required. We should allow a range to be searched. + All pages include “Radio Button?? for “Show Pictures?? and another for “Don’t show pictures??. “Show Pictures?? button is _pre-selected_. How will the “Back Button?? respond? We do NOT expect the coder to enter data, except for the test data needed to verify their own work. 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform The website uses a UNIX server. Your software will use PHP to interact with the MySQL database that you create.