Married Name:' . $mname . ''; } if (empty($_POST["dob"])) { $dob = ""; } else { $dob = test_input($_POST["dob"]); } if (empty($_POST["life"])) { $life = ""; } else { $life = test_input($_POST["life"]); } if (empty($_POST["rip"])) { $rip = ""; } else { $rip = test_input($_POST["rip"]); } if (empty($_POST["obit"])) { $obit = ""; } else { $obit = test_input($_POST["obit"]); } if (empty($_POST["photo"])) { $photo = ""; } else { $photo = test_input($_POST["photo"]); } if (empty($_POST["comment"])) { $comment = ""; } else { $comment = test_input($_POST["comment"]); } // Spouse Data if (empty($_POST["spousefam_id"])) { $spousefam_id = ""; } else { $fspousefam_id = test_input($_POST["spousefam_id"]); } if (empty($_POST["spouseind_id"])) { $spouseind_id = ""; } else { $spouseind_id = test_input($_POST["spouseind_id"]); } if (empty($_POST["spouseind_idfile_id"])) { $spousefile_id = ""; } else { $spousefile_id = test_input($_POST["spousefile_id"]); } if (empty($_POST["spousename"])) { $spousename = ""; } else { $spousename = test_input($_POST["spousename"]); } if (empty($_POST["spousegender"])) { $spousegender = ""; } else { $spousegendergender = test_input($_POST["spousegender"]); } if (empty($_POST["spousedob"])) { $spousedob = ""; } else { $spousedob = test_input($_POST["spousedob"]); } if (empty($_POST["spouserip"])) { $spousrip = ""; } else { $spousrip = test_input($_POST["spousrip"]); } if (empty($_POST["spousobit"])) { $spousobit = ""; } else { $spousobit = test_input($_POST["spousobit"]); } if (empty($_POST["spousphoto"])) { $spousphoto = ""; } else { $spousphoto = test_input($_POST["spousphoto"]); } } function test_input($data) { $data = trim($data); $data = stripslashes($data); $data = htmlspecialchars($data); return $data; } $str = <<

Family Member entry data

EOD; echo $str; echo ""; echo $mnameline; echo ""; if (! $life ) { echo "'; } if ( $comment ) { echo ""; } echo "
Given Name:"; echo $name; echo "
Gender: "; echo $gender; echo "
Family ID: "; echo $fam_id; echo "
Family Side: "; switch ( $famside) { case 0: echo ""; break; case 1: echo ""; break; case 2; echo ""; break; case 3: echo ""; break; case 4; case 5: echo ""; break; case 6: case 7: echo ""; break; default: break; } echo "
Individual ID:"; echo $ind_id; echo "
Photo:
"; echo $photo; echo "
File ID:"; echo $file_id; echo "
DOB: "; echo $dob; echo "
RIP: "; echo $rip; echo '
Obituary : ' . $obit . '
Comment: "; echo $comment; echo "
"; echo "		"; echo ""; echo $mnameline; echo ""; if (! $life ) { echo "'; } if ( $comment ) { echo ""; } echo "
Spouse Name:"; echo $spousename; echo "
Gender: "; echo $spousegender; echo "
Family ID: "; echo $spousefam_id; echo "
Individual ID:"; echo $spouseind_id; echo "
Photo:
"; echo $spousephoto; echo "
File ID:"; echo $spousefile_id; echo "
Spouse DOB: "; echo $spousedob; echo "
RIP: "; echo $spouserip; echo '
Obituary : ' . $spouseobit . '
Comment: "; echo $spousecomment; echo "
"; echo "
"; echo 'INSERT INTO FAM_MEMBER (FAM_ID,IND_ID,GIVEN,BORN,DIED,PHOTO,OBIT) VALUES ('; echo $fam_id . ',"' . $ind_id . '","' . $name . '", CTOD("' . $dob . '"), CTOD("' . $rip . '"),"' . $photo . '","' . $obit . '")'; echo 'INSERT INTO FAM_MEMBER (FAM_ID,IND_ID,GIVEN,BORN,DIED,PHOTO,OBIT) VALUES ('; echo $spousefam_id . ',"' . $spouseind_id . '","' . $spousename . '", CTOD("' . $spousedob . '"), CTOD("' . $spouserip . '"),"' . $spousephoto . '","' . $spouseobit . '")'; ?>