86 lines
2.2 KiB
PHP
86 lines
2.2 KiB
PHP
<?php
|
|
|
|
include_once 'classes/lg-on_Smarty.class.php';
|
|
$smarty = new lgon_Smarty();
|
|
require_once("config.inc.php");
|
|
$templatename = substr(basename($_SERVER['PHP_SELF']),0,-3)."html";
|
|
require_once "language/german.inc.php";
|
|
|
|
$db = dbconnect();
|
|
$query = "SELECT knk, ueberschrift
|
|
FROM knk
|
|
WHERE art = 'H'
|
|
ORDER BY knkid ASC
|
|
";
|
|
|
|
if(isset($_GET['knk']) AND $_GET['knk'] > 0 AND is_numeric($_GET['knk'])){
|
|
$kapitel = $_GET['knk']+3; # +3 da Kapitel 1 mit Container 4 anfängt im HTML
|
|
$smarty->assign('open_kap', $kapitel);
|
|
}
|
|
|
|
|
|
|
|
$zaehler = 0;
|
|
$outer_loop = array();
|
|
|
|
$result = $db->query( $query)
|
|
or die ("Cannot execute query");;
|
|
while ($row = $result->fetch_array()){
|
|
unset($value2);
|
|
$zaehler = $zaehler+1;
|
|
|
|
if(is_numeric(substr($row['knk'],0,1))){
|
|
$query1 = "SELECT number, question
|
|
FROM knk_fa
|
|
WHERE headline ='$row[knk]'
|
|
";
|
|
}else{
|
|
$query1 = "SELECT knk number, ueberschrift question
|
|
FROM knk
|
|
WHERE knk like '$row[knk].%'
|
|
and ueberschrift != 'EXTRAKT'
|
|
";
|
|
}
|
|
#echo $query1."<br><br>";
|
|
$result1 = $db->query( $query1 )
|
|
or die ("Cannot execute query1");;
|
|
|
|
while ($row2 = $result1->fetch_array()){
|
|
if(is_numeric(substr($row2['number'],0,1))){
|
|
# wenn knk mit Zahl beginnt
|
|
$knk_num = 1;
|
|
}else{
|
|
# wenn knk ein Character hat "vorwort"
|
|
$knk_num = 0;
|
|
};
|
|
#$ueberschrift = trim(str_replace("$row2[number]", "", $row2['question']));
|
|
|
|
|
|
# echo "
|
|
# knk: $row2[number]<br>
|
|
# knk_sub: $row2[0]<br>
|
|
# knk_num: $knk_num<br>
|
|
# ueberschrift_sub: $row2[question]<br>
|
|
# ";
|
|
|
|
$row2['knk'] = $row['knk'];
|
|
$row2['knk_sub'] = $row2['number'];
|
|
$row2['knk_num'] = $knk_num;
|
|
$row2['ueberschrift_sub'] = $row2['question'];
|
|
$value2[] = $row2;
|
|
}
|
|
|
|
$row['zaehler'] = $zaehler;
|
|
$row['inner'] = $value2;
|
|
$value[] = $row;
|
|
|
|
}
|
|
#echo "<pre>";
|
|
#print_r($value);
|
|
#echo "</pre>";
|
|
#exit;
|
|
$smarty->assign('outer_loop', $value);
|
|
|
|
|
|
$smarty->display("$template/$templatename");
|
|
?>
|