C:\gystdoit\famed\familygpslookup.php.txt       Friday   January 27th, 2017   3:09:56 PM     
works great next step is to create classes for family andd fam_member
use code below to write methods (functions) for the class
use the function __constructor to handle initialization activities - call methods to calc derived properties that are reported below
portrait
child portrait
branch link
... 
<?php //  familygpslookup.php  - incorporate all phases of family/fammember select and feedback in one self calling php file
  require 'age.php';
  require 'branch.php';
  require 'famside.php';
  require 'childfamid.php';
//  require 'spouserip.php';
 require_once 'login.php';
 require_once 'fmpick.php';
 require_once 'fampick.php';

$famid = $indid =  $out = $famout  = '';

//  process Family search on Fam ID 

  if (isset($_POST['famid'])) 
     { $famid = sanitizeString($_POST['famid']);
  $link = mysqli_connect($hn, $un, $pw, $db);

/* check connection */
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}
/* create a prepared statement */
if ($stmt = mysqli_prepare($link, "SELECT  fam_id, surname,father_id,father,mother_id,mother,wed_date,photo from family member WHERE fam_id=?")) {

    /* bind parameters for markers */
    mysqli_stmt_bind_param($stmt, "s",$famid);

    /* execute query */
    mysqli_stmt_execute($stmt);

    /* bind result variables */
    mysqli_stmt_bind_result($stmt, $fam_id, $surname, $father_id, $father, $mother_id, $mother, $wed_date,$photo );

    /* fetch value */
    mysqli_stmt_fetch($stmt);

  echo $str;

$logo =  <<<_END3
<img src="../family/family.jpg"  height="80" vspace="5" hspace="20" /> 
_END3;

//$spousedied = spouserip( $fam_id);
$portraitname = 'Children of ' . $father .  '<br> and ' . $mother; 
$portrait = '../family/' . $surname . '_' . $fam_id . '_portrait.svg';
if ( $wed_date == '0000-00-00' ) {
        $age = ' ';
        $wed_date = '';
     }  else {
       $spousedied = '0000-00-00';
       $age = age( $wed_date , $spousedied);
         $age =    $age . ' Years';
  }
$famtype = famside( $fam_id);
if ($famtype == 'D') {
    $border = 'purple';
   } else {
   $border = ($famtype == 'F') ? 'red' : 'blue';
}

$branch = substr( $fam_id,0,1);
$branchoutline = '<a href="../family/Branch_' . $branch . '_outline.htm" > Branch </a>';

 $famout = $famout . '<table border="5" style="border-color:' . $border . '"  >';

$famout = $famout . sprintf("<tr><th>Branch  </th><td>  <b> %s </b>  </td></tr>   \n", $branchoutline );

  $famout = $famout . sprintf("<tr><th>ID  </th><td> Fam ID:  <i> %s </i> <br><br> Father: <i>  %s </i>  <br /><br />   Mother:  <i> %s  </i></td></tr>   \n", $fam_id, $father_id, $mother_id );

   $famout = $famout . sprintf("<tr><th>Name  </th> <td>Father: <b>  %s </b> <br /><br />   Mother:  <b> %s  </b></td></tr>   \n", $father, $mother );

   $famout = $famout . sprintf("<tr><th> Married </th> <td><i> %s </i> %s  <i> %s </i>  </td></tr>   \n", $wed_date,$logo, $age );

 if ( $photo) $famout = $famout  . sprintf("<tr><th> Photo </th> <td> <img src='../family/%s ' height=200 > <h4> %s </h4> </td></tr> \n",  $photo, $photo );

   $famout = $famout  . sprintf(" <tr><th> Portrait </th> <td> <a href=' %s '> %s </a></td></tr>   \n",   $portrait, $portraitname);

  $famout = $famout . '</table>';

    /* close statement */
    mysqli_stmt_close($stmt);
}

/* close connection */
mysqli_close($link);
 
      }
 
//  process Fam_Member search on Ind ID 


  if (isset($_POST['indid'])) 
     { $indid = sanitizeString($_POST['indid']);
$link = mysqli_connect($hn, $un, $pw, $db);

/* check connection */
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}
/* create a prepared statement */
if ($stmt = mysqli_prepare($link, "SELECT fam_id , ind_id , given , married , born, died, male , photo , obit  FROM fam_member WHERE ind_id=?")) {

    /* bind parameters for markers */
    mysqli_stmt_bind_param($stmt, "s",$indid);

    /* execute query */
    mysqli_stmt_execute($stmt);

    /* bind result variables */
    mysqli_stmt_bind_result($stmt, $fam_id , $ind_id , $given , $married , $born , $died, $male , $photo , $obit );

    /* fetch value */
    mysqli_stmt_fetch($stmt);

  echo $str;

$portraitname =   $portrait = '';
$pos = strpos($ind_id, '.0');   // if nonblood use married name for portrait
if ( $pos ) {
            if ($male = "T") {
                    $fullname = explode( " ",$given);
                      $surname = $fullname[ count($fullname) - 1 ];
                     $portraitname = 'Children of ' . $given; 
                   $portrait = '../family/' . $surname . '_' . $fam_id . '_portrait.svg';
                                   }
           if ($married) {
                     $fullname = explode( " ",$married);
                    $surname = $fullname[ count($fullname) - 1 ];
                     $portraitname = 'Children of  ' . $married; 
                    $portrait = '../family/' . $surname . '_' . $fam_id . '_portrait.svg';
                   }
         } else {
             $fullname = explode( " ",$given);
             $surname = $fullname[ count($fullname) - 1 ];
            $portraitname = 'Siblings of ' . $given; 
           $portrait = '../family/' . $surname . '_' . $fam_id . '_portrait.svg';

       if ($male = "T") {
                       $fullname = explode( " ",$given);
                    $surname = $fullname[ count($fullname) - 1 ];
                     $childportraitname = 'Children of  ' . $given; 
                  $childfamid = childfamid( $ind_id);
                    $childportrait = '../family/' . $surname . '_' . $childfamid . '_portrait.svg';
                  } else {
                    $fullname = explode( " ",$married);
                      $surname = $fullname[ count($fullname) - 1 ];
                     $childportraitname = 'Children of ' . $given; 
                     $childfamid = childfamid( $ind_id);
           $childportrait = '../family/' . $surname . '_' . $childfamid . '_portrait.svg';
              }
}
$age = age( $born , $died);
$famtype = famside( $ind_id);

if ($famtype == 'D') {
    $border = 'purple';
   } else {
   $border = ($famtype == 'F') ? 'red' : 'blue';
}
$branch = substr( $fam_id,0,1);
$branchoutline = '<a href="../family/Branch_' . $branch . '_outline.htm" > Branch </a>';


 $out = $out . '<table border="5" style="border-color:' . $border . '"  >';
 $out = $out .  sprintf("<tr><th>Branch  </th><td>  <b> %s </b>  </td></tr>   \n", $branchoutline );

  $out = $out . sprintf("<tr><th> ID  </th><td> Fam: <i>  %s </i>  <br /><br />  Individual:  <i> %s  </i></td></tr>   \n", $fam_id , $ind_id );

   $out = $out . sprintf("<tr><th>Given  </th> <td><h2> %s  </h2>   </td></tr>   \n", $given );

if ( $married)    $out = $out . sprintf("<tr><th> Married </th> <td><h2> %s </h2> </tr>  \n", $married);

      $out = $out . sprintf("<tr><th> Dates  </th> <td> Birth: <i> %s </i> ",  $born );

if ( $died != '0000-00-00')  {
        $out = $out . sprintf(" <br><br> Died:  <i style='color:red;'> %s </i></td></tr>  </tr>  \n" , $died);
     $out = $out . sprintf(" <tr><th> Obituary </th> <td> <a href='../family/%s  '> %s </td></tr>   \n",   $obit, $obit);
         }
     else
        {   $out = $out . "</td></tr> \n";
         }

  $out = $out . sprintf("<tr><th> Age </th> <td> <h3> %s </h3> </td></tr> \n",  $age );
   $out = $out . sprintf("<tr><th> Photo </th> <td> <img src='../family/%s ' height=100 > <h4> %s </h4> </td></tr> \n",  $photo, $photo );

$out = $out . sprintf(" <tr><th> Portrait </th> <td> <a href=' %s '> %s </a>  <br /> <br /> <a href=' %s '> %s </a>    </td></tr>   \n",   $portrait, $portraitname,$childportrait, $childportraitname);

 $gender =  ( $male == 'T'  )  ? 'Male' : 'Female';
  $out = $out . sprintf("<tr><th> Gender </th> <td> <h3> %s </h3> </td></tr></table> \n", $gender  );

    /* close statement */
    mysqli_stmt_close($stmt);
}

/* close connection */
mysqli_close($link);

 
      }  

  $out =   (isset($_POST['indid'])) ?  $out  : '    ';
 $famout = (isset($_POST['famid']))  ?  $famout :  '     ';
 
  echo <<<_END
<html>
  <head>
    <title>Family GPS Lookup </title>
<link rel="stylesheet" type="text/css" href="SPC.CSS" />
  </head>
  <body>
     
     <TABLE BORDER=1 > <TR><TD>
  
        
     
      <form method="post" action="familygpslookup.php">
             

<TABLE BORDER=1 > 
<TR><TH> Family </TH>
</TR>
<TR>
<TD> Family ID  <input type="text" name="famid"  class="famid" size="7">
  </TD>
</TR><TR>
<TD>  $fampicklist 
</TD>
</TR><TR>
<TD> <h2>  Family GPS</h2> 
 </TD>
</TR>  <tr><TH> Family Member  </TH></tr>
<tr><td>  Individual ID <input type="text" name="indid" class="indid" size="7">   
</td>
</TR><TR>
<td>  $picklist   
  </td>
</TR><TR>
<td> <input type="submit" value="Search">
</td></tr>
</TABLE>

<i>Search Family and/or 
<br>Family Member table
<br>on ID number </i>
      </form>
        
</TD><TD>
   
<TABLE BORDER=1 ><TR><TH> Family </TH><TH> Family Member  </TH>
</TR><TR><TD>  <b>$famout</b> </TD><TD>  <b>$out</b> </TD>
</TR></TABLE>
</TD><TD>
<b>$filesout</b>

</TD></TR></TABLE>
  </body>
</html>
_END;

  function sanitizeString($var)
  {
    $var = stripslashes($var);
    $var = strip_tags($var);
    $var = htmlentities($var);
    return $var;
  }
?>