$art|
weid -> $weid|
eid -> $eid|
thema_kurz -> $thema_kurz|
template1 -> $template1|
";
$db = dbconnect();
if($art=="lueexeg"){
$result_exeg1a = $db->query("SELECT count(*) Anz
FROM wort_exegese
WHERE verweis='$weid'
AND beschreibung != ''");
$row_exeg1a = $result_exeg1a->fetch_array();
if($row_exeg1a['Anz']>1){
$query_exeg2 = "SELECT weid, wort, beschreibung, verweis
FROM wort_exegese
WHERE verweis='$weid'
AND beschreibung != ''";
$result_exeg2 = $db->query( $query_exeg2)
or die ("Cannot execute query: result_exeg2");
$zaehler_exeg=1;
$exegese = "";
while ($row_exeg2 = $result_exeg2->fetch_array()){
$exegese .= "
|
$zaehler_exeg
|
$row_exeg2[beschreibung]
|
";
$zaehler_exeg=$zaehler_exeg+1;
}
$exegese .= "
";
}else{
$result_exeg3 = $db->query("SELECT beschreibung
FROM wort_exegese
WHERE weid='$weid'");
$row_exeg3 = $result_exeg3->fetch_array();
$exegese = $row_exeg3['beschreibung'];
}
$exegese=preg_replace("/\n/", "", $exegese);
$exegese=preg_replace("/\r/", "", $exegese);
$exegese= preg_replace('/\s{2,}/sm',' ',$exegese,PREG_SET_ORDER); //Mehr als zwei leerzeichen entfernen
$exegese = str_replace (array('"'), array("""), $exegese);
$exegese = str_replace (array("'"), array("\'"), $exegese);
$result_lue1 = $db->query("SELECT thema
FROM lue_quelle
WHERE eid='$eid'");
$row_lue1 = $result_lue1->fetch_array();
$thema = $row_lue1['thema'];
$repl="$thema_kurz
";
}
if($art=="exeg"){
$result_exeg1a = $db->query("SELECT count(*) Anz
FROM wort_exegese
WHERE verweis='$weid'
AND beschreibung != ''");
$row_exeg1a = $result_exeg1a->fetch_array();
if($row_exeg1a['Anz']>1){
$query_exeg2 = "SELECT weid, wort, beschreibung, verweis
FROM wort_exegese
WHERE verweis='$weid'
AND beschreibung != ''";
$result_exeg2 = $db->query( $query_exeg2)
or die ("Cannot execute query: result_exeg2");
$zaehler_exeg=1;
$exegese = "";
while ($row_exeg2 = $result_exeg2->fetch_array()){
$exegese .= "
|
$zaehler_exeg
|
$row_exeg2[beschreibung]
|
";
$zaehler_exeg=$zaehler_exeg+1;
}
$exegese .= "
";
}else{
$result_exeg1 = $db->query("SELECT beschreibung
FROM wort_exegese
WHERE weid='$weid'");
$row_exeg1 = $result_exeg1->fetch_array();
$exegese = $row_exeg1['beschreibung'];
}
$exegese=preg_replace("/\n/", "", $exegese);
$exegese=preg_replace("/\r/", "", $exegese);
$exegese= preg_replace('/\s{2,}/sm',' ',$exegese,PREG_SET_ORDER); //Mehr als zwei leerzeichen entfernen
$exegese = str_replace (array('"'), array("""), $exegese);
$exegese = str_replace (array("'"), array("\'"), $exegese);
$repl="$thema_kurz";
}
if($art=="lue"){
$result_lue1 = $db->query("SELECT thema
FROM lue_quelle
WHERE eid='$eid'");
$row_lue1 = $result_lue1->fetch_array();
#echo "$row_lue1[thema] --> $eid
\n";
$thema = $row_lue1['thema'];
$repl="$thema_kurz";
#$repl ="";
}
return $repl;
}
$botschaft = "Die Erscheinung __exeg-38-0__ in Wort und Sakrament erfassen.";
$exeg_wort = "Christi";
$template = "standard";
$botschaft=preg_replace_callback("/__(lue|exeg|lueexeg)-([0-9]*)-([0-9]*)__/", function ($m) use (&$exeg_wort,&$template) { return makepopup($m[1], $m[2], $m[3], "$exeg_wort", "$template");}, $botschaft);
echo $botschaft;
?>