PHP MYSQL

DYNAMIC MENU WITH PHP MYSQL

(very simple example)

MENU TABLE item_id    | INTEGER PRIMARY KEY item_text | VARCHAR item_link | VARCHAR

DATABASE MENU TABLE

01

DUMMY ENTRIES  1  | home  | /  2  | blog    | /blog/  3  | shop   | /shop/

PHP GET MENU ITEMS

02

CONNECT TO DATABASE $pdo = new PDO("mysql:host=HOST; dbname=NAME;charset=utf8mb4", USER, PASSWORD);

GET ALL MENU ITEMS $stmt = $pdo->prepare("SELECT * FROM `menu`"); $stmt->execute(); $menu = $stmt->fetchAll();

<nav><?php foreach ($menu as $i) {   echo "<a href='". $i['item_link'] ."'>";   echo $i['item_text'];   echo "</a>"; } ?></nav>

DRAW THE HTML MENU

03