195 lines
5.4 KiB
PHP
195 lines
5.4 KiB
PHP
<?php
|
|
function dbconnect() //--Prozedur - kein return-Wert
|
|
{
|
|
#mysql_connect("localhost", "web360", "60050101") or die("Couldn't connect. Please contact your
|
|
# database administrator!");
|
|
#mysql_select_db("leitgedanken");
|
|
$db = @new mysqli( 'localhost', 'root', '', 'leitgedanken' );
|
|
return $db;
|
|
}
|
|
|
|
$suchmuster = array();
|
|
$suchmuster[0] = '/ $/';
|
|
$suchmuster[1] = '/<\/p>$/';
|
|
$suchmuster[2] = '/<p>$/';
|
|
$suchmuster[3] = '/<br>$/';
|
|
$suchmuster[4] = '/<li> /';
|
|
|
|
|
|
$ersetzungen = array();
|
|
$ersetzungen[0] = '';
|
|
$ersetzungen[1] = '';
|
|
$ersetzungen[2] = '';
|
|
$ersetzungen[3] = '';
|
|
$ersetzungen[4] = '<li>';
|
|
|
|
/* So holt man die eigentliche Antworten raus
|
|
echo "<pre>";
|
|
echo "Answer: ".trim(preg_replace($suchmuster, $ersetzungen, preg_replace("%(\r\n)|(\r)%", "",extractStringBetween('"answer":"', '"', $text)[0])))."<br>";
|
|
echo "Description 2: ".trim(preg_replace($suchmuster, $ersetzungen, preg_replace("%(\r\n)|(\r)%", "",extractStringBetween('"description2":"', '"', $text)[0])))."<br>";
|
|
echo "Description : ".trim(preg_replace($suchmuster, $ersetzungen, preg_replace("%(\r\n)|(\r)%", "",extractStringBetween('"description":"', '"', $text)[0])))."<br>";
|
|
echo "Reference: ".trim(preg_replace($suchmuster, $ersetzungen, preg_replace("%(\r\n)|(\r)%", "",extractStringBetween('"reference":"', '"', $text)[0])))."<br>";
|
|
echo "</pre>";
|
|
*/
|
|
|
|
|
|
|
|
|
|
|
|
#echo "<hr>";
|
|
#echo "<pre>";
|
|
##echo var_dump(extractStringBetween('"', '":"', $text));
|
|
#echo "</pre>";
|
|
|
|
/* tags suchen
|
|
$db = dbconnect();
|
|
$query = "SELECT title, document, custom_integer1
|
|
FROM page
|
|
WHERE tree_id = '2507'
|
|
AND custom_integer1 > 0
|
|
AND custom_integer1 <= 750
|
|
ORDER by custom_integer1 ASC";
|
|
|
|
$result = $db->query( $query)
|
|
or die ("Cannot execute query");
|
|
$delnr="";
|
|
|
|
while ($row = $result->fetch_array()){
|
|
|
|
$size = count(extractStringBetween('"', '":"', $row['document']));
|
|
for($i=0; $i<$size; $i++){
|
|
$tag = trim(str_replace(',"','',extractStringBetween('"', '":"', $row['document'])[$i]));
|
|
|
|
$result2 = $db->query( "SELECT count(*) Anz FROM tags WHERE tag = '$tag'" );
|
|
$row2 = $result2->fetch_array();
|
|
if($row2['Anz'] == 0){
|
|
$sql1 = $db->query("INSERT INTO tags ( tag, custom_integer1 ) VALUES ('$tag', '$row[custom_integer1]')");
|
|
}
|
|
}
|
|
}
|
|
*/
|
|
|
|
|
|
$db = dbconnect();
|
|
$query = "SELECT knkfa_id, number, question, answer, reference, description, description2
|
|
FROM knk_fa
|
|
ORDER by number ASC";
|
|
|
|
$result = $db->query( $query)
|
|
or die ("Cannot execute query");
|
|
$delnr="";
|
|
|
|
|
|
|
|
|
|
|
|
echo "
|
|
<html>
|
|
<head>
|
|
<meta http-equiv=\"Content-Type\" content=\"text/html; charset=windows-1252\">
|
|
<link rel=\"stylesheet\" href=\"templates/standard/css/styles_pc.php\" type=\"text/css\">
|
|
<script type='text/javascript' src='overlib/overlib.js'></script>
|
|
<title>{$men_titel}</title>
|
|
|
|
<SCRIPT LANGUAGE='JAVASCRIPT' TYPE='TEXT/JAVASCRIPT'>
|
|
<!--
|
|
var win=null;
|
|
function bib_link_lokal1(mypage,myname,w,h,pos,infocus){
|
|
if(pos==\"random\"){myleft=(screen.width)?Math.floor(Math.random()*(screen.width-w)):100;mytop=(screen.height)?Math.floor(Math.random()*((screen.height-h)-75)):100;}
|
|
if(pos==\"center\"){myleft=(screen.width)?(screen.width-w)/2:100;mytop=(screen.height)?(screen.height-h)/2:100;}
|
|
else if((pos!='center' && pos!=\"random\") || pos==null){myleft=0;mytop=20}
|
|
settings=\"width=\" + w + \",height=\" + h + \",top=\" + mytop + \",left=\" + myleft + \",scrollbars=auto,location=no,directories=no,status=no,menubar=no,toolbar=no,resizable=no\";
|
|
win=window.open(mypage,myname,settings);
|
|
win.focus();
|
|
}
|
|
// -->
|
|
</script>
|
|
|
|
<base target=\"main\">
|
|
<style type=\"text/css\">
|
|
|
|
h1 { font-weight: bold;
|
|
color: #000066;
|
|
font-size: 16px; }
|
|
.answer {
|
|
margin:0 auto;
|
|
margin-left: 35px;
|
|
margin-right: 35px;
|
|
}
|
|
.reference {
|
|
background-color: #cce6ff;
|
|
margin:0 auto;
|
|
margin-left: 35px;
|
|
margin-right: 35px;
|
|
}
|
|
.description {
|
|
background-color: #d1e0e0;
|
|
margin:0 auto;
|
|
margin-left: 35px;
|
|
margin-right: 35px;
|
|
}
|
|
</style>
|
|
</head>
|
|
|
|
<body leftmargin=\"20\" rightmargin=\"20\">
|
|
<br>
|
|
<br>
|
|
<br>
|
|
";
|
|
while ($row = $result->fetch_array()){
|
|
|
|
$answer = trim(preg_replace($suchmuster, $ersetzungen, $row['answer']));
|
|
$reference = trim(preg_replace($suchmuster, $ersetzungen, $row['reference']));
|
|
$description = trim(preg_replace($suchmuster, $ersetzungen, $row['description']));
|
|
$description2 = trim(preg_replace($suchmuster, $ersetzungen, $row['description2']));
|
|
$sql1 = $db->query("UPDATE knk_fa
|
|
SET answer='$answer'
|
|
,reference='$reference'
|
|
,description='$description'
|
|
,description2='$description2'
|
|
WHERE knkfa_id='$row[knkfa_id]'
|
|
");
|
|
echo"
|
|
|
|
<a name=\"$row[number]\"><h1>$row[number] $row[question]</h1></a>
|
|
<div class=\"answer\">
|
|
|$row[answer]|<br>
|
|
</div>
|
|
";
|
|
|
|
if($row['reference'] != ''){
|
|
echo"
|
|
<br>
|
|
<div class=\"reference\">
|
|
$row[reference]
|
|
</div>
|
|
";
|
|
}
|
|
|
|
if($row['description'] != ''){
|
|
echo "
|
|
<br>
|
|
<div class=\"description\">
|
|
$row[description]
|
|
</div>
|
|
";
|
|
}
|
|
|
|
if($row['description2'] != ''){
|
|
echo "
|
|
<br>
|
|
<div class=\"description\">
|
|
$row[description2]
|
|
</div>
|
|
";
|
|
}
|
|
echo"
|
|
<p>
|
|
|
|
";
|
|
}
|
|
echo "
|
|
</body>
|
|
</html>";
|
|
?>
|