";} ?>
"; echo ""; } $customername=$row["firstname"]; if ($row["betweenname"]!="") {$customername=" ".$row["betweenname"];} else {$customername="";} $customername=$row["firstname"].$customername." ".$row["lastname"]; ShowOptions($customername,$gekozen); echo "
"; echo "
".$customername."
"; // Show first image ShowImage($pasfotoname); echo ""; echo ""; if ($row["betweenname"]!="") {echo "";} echo ""; if ($row["christnames"]!="") {echo "";} echo ""; if ($row["cause"]!="-") {echo "";} if ($row["sexe"]!="O") {if ($row["sexe"]=="M") {$sexe="Mannelijk";} else {$sexe="Vrouwelijk";} echo "";} echo "
"; echo "\"Achternaam\"".$row["lastname"]."
\"Tussenvoegsel(s)\""; echo $row["betweenname"]; echo "
\"Roepnaam\""; echo $row["firstname"]; echo "
\"Doop-/artiest"; echo $row["christnames"]; echo "
\"Geboortedatum\""; $Born=$row["born"]; echo $Born; echo "
\"Sterftedatum\""; $Died=$row["died"]; echo $Died; echo "
\"Leeftijd\""; $Age=(substr($Died,0,4)-substr($Born,0,4))-(substr($Died,5,5)
\"Oorzaak\""; echo $row["cause"]; echo "
\"Sexe\"".$sexe."
"; echo "
"; // Show second image if (file_exists($imagename)) {ShowImage($imagename);} echo "
"; if ($row["quote"]!="") {echo "
"; echo "
Quote
\"".$row["quote"]."\"
"; } if (file_exists($audioname)) {echo "
"; echo "
Geluidsfragment
"; echo "Klik hier voor een geluidsfragment van ".$customername.""; echo "
"; } $biografie=nl2br( $row["text"]); if ($biografie=="") {$biografie="Biografie niet beschikbaar. U kunt deze opgeven door hier te klikken.";} echo "
"; echo "
Biografie
".$biografie."
"; if (!$row["hyperlink"]=="") {echo "
"; echo "
In Memoriam Link
"; echo $row["hyperlink"]."
"; } // Zoek de (half)broers en zussen $father=$row["father"]; $mother=$row["mother"]; if ($father!="0" | $mother!="0") {$fulbrotsis=mysqli_query($connection, "SELECT * from customers where father='$father' AND mother='$mother' AND customerID!='$id'") or die(mysqli_error()); $fatbrotsis=mysqli_query($connection, "SELECT * from customers where father='$father' AND (mother!='$mother' OR mother='0') AND customerID!='$id'") or die(mysqli_error()); $motbrotsis=mysqli_query($connection, "SELECT * from customers where mother='$mother' AND (father!='$father' OR father='0') AND customerID!='$id'") or die(mysqli_error()); } // Zoek de kinderen $sexe=$row["sexe"]; switch ($sexe) {case 'M': {$child=mysqli_query($connection, "SELECT * from customers where father='$gekozen'") or die(mysqli_error()); break;} case 'V': {$child=mysqli_query($connection, "SELECT * from customers where mother='$gekozen'") or die(mysqli_error()); break;} case 'O': {$child=mysqli_query($connection, "SELECT * from customers where father='$gekozen' OR mother='$gekozen'") or die(mysqli_error()); break;} } if ($father!="0" | $mother!="0" | mysqli_num_rows($child)!="0") {echo "
"; if ($father!="0") {echo ""; } if ($mother!="0") {echo ""; } if (mysqli_num_rows($child)!="0") {echo ""; } if ($father!="0" | $mother!="0") {echo ""; } echo "
Familie
Vader"; $dummy=mysqli_query($connection, "SELECT * from customers where customerid='$father'") or die(mysqli_error()); $dummyrow=mysqli_fetch_array($dummy); echo ""; if ($dummyrow["betweenname"]!="") {echo $dummyrow["lastname"]." ".$dummyrow["betweenname"].", ".$dummyrow["firstname"];} else {echo $dummyrow["lastname"].", ".$dummyrow["firstname"];} echo "
Moeder"; $dummy=mysqli_query($connection, "SELECT * from customers where customerid='$mother'") or die(mysqli_error()); $dummyrow=mysqli_fetch_array($dummy); echo ""; if ($dummyrow["betweenname"]!="") {echo $dummyrow["lastname"]." ".$dummyrow["betweenname"].", ".$dummyrow["firstname"];} else {echo $dummyrow["lastname"].", ".$dummyrow["firstname"];} echo "
Kinderen"; while ($newrow=mysqli_fetch_array($child)) {echo ""; if ($newrow["betweenname"]!="") {echo $newrow["lastname"]." ".$newrow["betweenname"].", ".$newrow["firstname"];} else {echo $newrow["lastname"].", ".$newrow["firstname"];} echo " "; } echo "
Broer(s)/Zus(sen)"; if ($father!="0" & $mother!="0") {while ($newrow=mysqli_fetch_array($fulbrotsis)) {echo ""; if ($newrow["betweenname"]!="") {echo $newrow["lastname"]." ".$newrow["betweenname"].", ".$newrow["firstname"];} else {echo $newrow["lastname"].", ".$newrow["firstname"];} echo " "; } } if ($father!="0") {while ($newrow=mysqli_fetch_array($fatbrotsis)) {echo ""; if ($newrow["betweenname"]!="") {echo $newrow["lastname"]." ".$newrow["betweenname"].", ".$newrow["firstname"];} else {echo $newrow["lastname"].", ".$newrow["firstname"];} echo " "; } } if ($mother!="0") {while ($newrow=mysqli_fetch_array($motbrotsis)) {echo ""; if ($newrow["betweenname"]!="") {echo $newrow["lastname"]." ".$newrow["betweenname"].", ".$newrow["firstname"];} else {echo $newrow["lastname"].", ".$newrow["firstname"];} echo " "; } } echo "
"; } echo "

Terug

"; mysqli_free_result($result); $result = mysqli_query($connection, "SELECT * from condos where customerid='$gekozen' AND type='1' ORDER BY date DESC") or die(mysqli_error()); if (mysqli_num_rows($result)!="0") {echo "
"; $n=1; while ($row = mysqli_fetch_array($result)) {if ($n=="1") {echo ""; $n=0;} else {echo "";} $n++; } if ($n=="2") {echo "";} if ($n=="3") {echo "";} echo "
Bloemen
";} else {echo "";} echo ""; echo "
"; echo $row["name"].""; echo $row["date"]."
"; echo ""; echo ""; echo "
"; if ($n=="3") {echo "
"; } echo "
"; $result = mysqli_query($connection, "SELECT * from condos where customerid='$gekozen' AND type='0' ORDER BY date DESC") or die(mysqli_error()); echo "
"; if (mysqli_num_rows($result)!="0") {while ($row = mysqli_fetch_array($result)) {echo ""; } } echo "
Medeleven
".$row["name"].""; echo $row["date"]."

".nl2br($row["text"])."
troostplek.nl"; echo date('d-m-Y')."

Sterkte aan alle nabestaanden.
"; echo "
"; ?>
"; echo ""; } } // end if (row[checked]) else{ ?>
Troostplek - Het Internet In-Memoriam
Deze Troostplek (Register) bestaat niet.
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } function ShowOptions($tmp_name,$tmp_gekozen) { echo ""; } ?>