Beautiful horizontal menu in php and mysql. §2

"; // Start the inner list if there were no children yet
$ul = true; // Set the flag
}
echo printItem($items[$key], $items, $children); // Recursively output all child elements
}
echo "";
}
?>



Menu



foreach ($items as $item) (
if (!$item["parent_id"]) echo printItem($item, $items, $childrens); // Display all top level elements
}
?>




This code is fully working, however, you should understand that no one writes like this (in particular, output through echo HTML tags). And your task is to take the algorithm from this code, but not the code itself. And then connect this algorithm to your engine. I have tried to carefully comment the output code multilevel menu in PHP and MySQL, but, of course, it is not the most transparent and requires quite good initial knowledge. If you still don't know PHP and MySQL, then first I strongly recommend going through this

The menu of a site in php, which is controlled by php scripts, has its own characteristics. These are not just absolute or relative links, although this may well be the case, but, as a rule, dynamically generated sidebar link blocks with sections and subsections and link blocks from the internal pages of the site themselves. A dynamically generated menu is very convenient, because it can be inserted anywhere on the site and, most importantly, at the right time. That is, when moving to different sections and subsections, you can dynamically expand and different blocks menu. Moreover, they can be different not only in content, but also in form and design. In a static site, it is also quite possible to do such feints, but it will cost additional files templates and a lot of other tricks. While a site written in php does not require any of this. The template will remain as it was. Everything will be controlled by one or more simple php scripts.

In order to verify this, it is enough to write a php script to dynamically generate a menu, for example, the first heading and force it to expand the menu of this heading through the previously written script. The rest of the rubrics can be formed in a similar way. Moreover, the code of the script itself will not change much. Only the text file will change, which will define the names of the links and the links themselves. The code for such a script is given below.

// Menu builder
$menu = @file($rubric1_menu);
$lines = count($menu);
for ($i = 0; $i< $lines; $i++)
{
list($menu_link,$menu_name,$menu_title)=explode("::", $menu[$i]);
if($page == rub1_part1 and $i == 0) ($refcolor = "style="color:#cc0000"";)
elseif($page == rub1_part2 and $i == 1) ($refcolor = "style="color:#cc0000"";)
elseif($page == rub1_part3 and $i == 2) ($refcolor = "style="color:#cc0000"";)
else ($refcolor = "";)
$rubric1.="

• ".$menu_name."
";
}
?>

In order for such a script to work, a text file is needed in which the names of the menu links, the links themselves and their title will be stored. It is not difficult to create such a file, it is enough to execute the File -> New command from the Dreamweaver main menu, create a new html document, as described earlier, check and, if necessary, change the encoding of the new file to UTF-8, and then save it under the name rubric1.dat in the data folder previously created for it. The full path to this file will be D:/Mysitephp/data/rubric1.dat. The contents of the file below are the links themselves, their names and their titles (tips). In addition, in order to run given script to work, it must be connected using the function include() in the main.php template engine.

Rub1_part1::Section 1::Section 1 of rubric 1::
rub1_part2::Section 2::Section 2 rubric 1::
rub1_part3::Section 3::Section 3 rubric 1::


In addition, you must also create a small script with settings that will store full address site, the path to the folders of the pages and meta descriptions of the site, the path to the files of the site menu and connect it using the function include() in the main.php template engine. To do this, you need to create a new php file, and save it under a name such as settings.php in the php folder. The full path to the file will be D:/Mysitephp/php/setings.php and its content is shown below.

# folder with html documents
$doctemplates = "templates";
# full path to script directory
$turl="http://mysitephp.ru";
# database with data
$rubric1_menu = "data/rubric1.dat";
?>

How does the php script for menu generation work? First to the $menu variable using the function file() the content of the text file rubric1.dat is placed. Then the function count() counts the number of lines in a text file and functions list() and explode() in the cycle, the menu itself is unfolded, where by the method of gluing lines (dot operation . ) strings of links with their names and titles are formed, which is then placed in the $rubric1 variable. Next, the templating script, where the menu script is connected by the function include(), moves the contents of the $rubric1 variable to Right place site using the previously described function repl().

Such a menu will not work yet, since it contains only the links themselves with all the necessary attributes, but there is no script that would ensure the transition to these links and the opening of the site pages that will correspond to these links. This php script we'll take it further.

Further it is possible the project updated by a script of formation of the menu. You can also download the updated project on the page that will open after registration and activation free subscription on the panel on the right. The page address must be saved. It is on this page that links to download project updates, various useful scripts, programs, lessons and video tutorials on circuitry, programming and site building will appear in the future. for newbies.

The downloaded site php project updated with new scripts can now be compared with what happened as a result of the above actions. Further, in order to eliminate discrepancies, it will be useful to completely replace the project with the downloaded one, perform the operation, start the Denwer server, type mysitephp.ru in the browser window and see what came of it. In the upper left part of the template, the menu of the first section should expand, as shown in the picture below.



Go and melt in your favorite social network

Because it exposes the contents of the menu.php module. Below will be presented own development menu in PHP, which was written from scratch in notepad.

This code will be especially useful for dynamic sites that have self-written engines. I will offer two versions of the code that have minor differences (which difference will be explained later).

To begin with, I will give an approximate structure of the site for which this menu is suitable. The site structure should look like this (classic view):

/index.html /section_1/ /razdel_1/articles_1.html /razdel_1/articles_2.html ... /razdel_2/ /razdel_2/articles_1.html /razdel_2/articles_2.html ... ... ... /razdel_N/articles_2 .html

The site may also contain subsections for sections:

/section_1/podzaderl_1/ /section_1/podzaderl_1/articles_1.html /section_1/podzaderl_1/articles_2.html ... /section_1/podzaderl_2/articles_1.html /section_1/podzaderl_2/articles_2.html

This structure will also work for our menu with only minor differences.

I suggest creating a separate file for the menu in php. For example, menu.php would be a great name for such a file. To implement the menu, CSS menu styling is also introduced to make it more or less beautiful right away. Naturally, this style is given for reference only, since the designs of the sites are very different.

CSS menu style code:

.menu ( height:42px; padding:0 0 0 16px; background:url(images/spacer.png) repeat; ) .menu li ( display:block; float:left; ) .menu li.active ( background: #000011 ; ) .menu a ( color:#FFF; display:block; line-height:42px; text-decoration:none; padding:0 14px; ) .menu a:hover ( background:url(images/spacer.png) repeat ; )

Now, let's take a look at the first menu implementation in PHP, which is a bit of a simplification.

The first version of the menu code in PHP

\n"; for ($i=0;$i ": "

"; echo " ".$array_menu[$i]["name"]."

\n"; ) echo "

The menu can be divided into two parts. The first one contains an information array $array_menu , which contains the names of our sections with links to sections. Is there a way to add this data to the database? mySQL data, but there is no particular point in this, since the sample is very small, so this will not affect the speed of work.

The second part contains the menu output via for loop. The loop compares the website address with the address from the $array_menu array. If there is a match, then we display the next section of the menu with a special class active:

The order in the array will be preserved when displaying the menu on the site. That is, the array must be filled in the order in which you want to display the menu.

Note:
In case the URLs (addresses) of the sections heading look like:
/section_1
or such
/section_1/name_razdela.html
then in array_menu you need to write the exact match:
$array_menu[$i]["url"]="/section_1"
or for the second case:
$array_menu[$i]["url"]="/section_1/nazvanie_razdela.html";

How does the first menu option work?
It only highlights the menu if you are at the section heading address. For example, if the page address is /section_1/articles_1.html , then the menu will not be highlighted in any way.

The second version of the code is a modified version of the first and provides for the possibility of highlighting the menu even in articles that are in sections.

The second version of the menu code in PHP

"; for ($i=0;$i ": "

"; echo "".$array_menu[$i]["title"]."

"; ) else ( echo ($URL) == ($array_menu[$i]["url"]) ? "

": "

"; echo "".$array_menu[$i]["title"]."

"; ) ) echo ""; ?>

Not a single site is complete without navigation, or as the "site menu" is also called. So the site menu can be single-level and multi-level in the form of a tree. If there are no particular difficulties in terms of implementation with a single-level menu, then when creating a multi-level menu, you need to think carefully.

The most important thing in this task is to design a database for our multi-level menu. Let's create a Categories table with three fields id, title, parent where:

• ID- identifier
• Title- Menu name
• parent- Default category parent 0

The field is responsible for branching the menu parent if parent = 0, then this category is the parent category. In order to add children to the parent category, you need to specify in the parent field ID the desired parent. For example:

Tables with categories

As can be seen from the table, the parent category Cars there are two descendants Mazda and Honda related by field parent. And the category Motorcycles two offspring are kawasaki and harley. At the same time, the category Boats has no descendants. I hope you understand how to link categories.

Next, we move from words to practice. Let's create the Categories table.

The algorithm of work consists of the following:

Creating a database connection

Writing a function to get data from the Categories table

We get an array like this, where the array key is the category ID.

Array Tree Function by Tommy Lacroix

Getting an array in the form of a tree

Whole script

".showCat($category["children"]) ."