Сруктура таблицы
MariaDB [CMS]> SELECT * from nav_menu;
+----+-------------------+------------------------+-----------------------------------+----------+-- ---------+------------+
| id | menu_order | url | icon | link | link_down | link_right |
+----+------------+------------------------+-----------------------------------+----------+--------- --+------------+
| 1 | 1 | / | <i class="fa fa-home"></i> | Home | | |
| 2 | 2 | /?action=E-mail_Help | <i class="fa fa-envelope-o"></i> | E-mail | | |
| 3 | 3 | /?action=E-mail_Help
| <i class="fa fa-info-circle"></i> | | About | |
| 5 | 4 | / | <i class="fa fa-life-ring"></i> | | | About 1 |
| 6 | 5 | / | <i class="fa fa-life-ring"></i> | | | About 2 |
| 7 | 6 | / | | | Help | |
| 8 | 7 | / | | About us | | |
+----+------------+------------------------+-----------------------------------+----------+--------- --+------------+
7 rows in set (0.07 sec)
Пример кода
global $db;
echo "<div class=\"row\">
<!-- Navigation
================================================== -->
<div class=\"navbar navbar-default navbar-static-top\" role=\"navigation\">
<div class=\"navbar-header\">
<button type=\"button\" class=\"navbar-toggle\" data-toggle=\"collapse\" data-target=\".navbar-collapse\">
<span class=\"sr-only\">Toggle navigation</span>
<span class=\"icon-bar\"></span>
<span class=\"icon-bar\"></span>
<span class=\"icon-bar\"></span>
</button>
</div>
<div class=\"navbar-collapse collapse\">
<ul class=\"nav navbar-nav\">\n";
// Get content from the navigation table
if (! $db->Query("SELECT * FROM `nav_menu` ORDER BY `menu_order` ASC ")) $db->Kill();
// --- Loop through the records -------------------------------------
while ($row = $db->Row()) {
/*
* Tag for repeat cleaning
*/
$dropdown = "<ul class=\"dropdown-menu\">";
/*
* If $row->link returned
*/
if($row->link == true){
/*
* Extracting menu link row
*/
echo "<li><a href=\"$row->url\">$row->link</a>\n";
}
/*
* if $row->link_down returning
*/
if($row->link_down == true){
echo $dropdown;
echo "<li><a href=\"$row->url\">$row->link_down</a>\n";
}
/*
* if $row->link_right returned
*/
if ($row->link_right == true){
echo $dropdown;
echo "<li><a href=\"$row->url\">$row->link_right</a>\n";
}
}
echo "</div>
</div>
</div>
Может кто подскажет как избежать повторения кода $dropdown = "<ul class=\"dropdown-menu\">"; а то уже запарился биться над этим вариантом... постоянно идет выхлоп этого тэга