Файл: upload/pages/help/solutions/solutions.php
Строк: 37
<?php
require_once ($_SERVER['DOCUMENT_ROOT'] . '/core/core.php');
$breadcrumbs = generateBreadcrumbs([
['/', 'Главная'],
['#', 'База знаний']
]);
$html = $breadcrumbs['html'];
$json_ld = $breadcrumbs['json_ld'];
$breadcrumbs = generateBreadcrumbs([
['/', 'Главная'],
['#', 'База знаний']
]);
// Формируем дерево категорий → секций → вопросов
$categories_data = [];
$categories_q = dbquery("SELECT * FROM solutions_category ORDER BY id");
while ($cat = FetchAssoc($categories_q)) {
$sections_arr = [];
$sections_q = dbquery("SELECT * FROM solutions_section WHERE category = ? ORDER BY id", [$cat['id']]);
while ($sec = FetchAssoc($sections_q)) {
$questions_arr = [];
$questions_q = dbquery("SELECT * FROM solutions_question WHERE section = ? ORDER BY id", [$sec['id']]);
while ($q = FetchAssoc($questions_q)) {
$questions_arr[] = [
'id' => $q['id'],
'question' => chars($q['question'])
];
}
$sections_arr[] = [
'name' => chars($sec['name']),
'questions' => $questions_arr
];
}
$categories_data[] = [
'name' => chars($cat['name']),
'sections' => $sections_arr
];
}
$page_html = $view->render('pages/help/solutions/solutions.html', [
'breadcrumbs_html' => $breadcrumbs['html'],
'breadcrumbs_json' => $breadcrumbs['json_ld'],
'categories' => $categories_data,
'home' => homeLink()
]);
require_once ($_SERVER['DOCUMENT_ROOT'] . '/layout.php');
?>