Menampilkan navbar dari database kategori di mysql

Beranda

...

Website, Webmaster, Webdeveloper
Menampilkan navbar dari database kategori di mysql

clonningdash

01-10-2018 02:15

Menampilkan navbar dari database kategori di mysql

Halo gan sesuai dengan judul, ane mau bertanya ,ane disini punya db dengan table kategori dan sub kategori ..

nah kategori dan sub kategori ini jadi dalam satu table yang ditandai sbagai pembedanya melalui id .

berikut table nya .

m_kategori terdiri dari
id
sub_id(sub kategori)
nama
gambar
deskripsi
wkt_input
wkt_update
admin_input
admin_update

nah ane mau ngebuat menu navbar ini dipanggil dari id kategori, nah ketika kursor digeser muncul dropdwon yang isi nya subkategori dari kategori tertentu.

Contoh : ane punya kategori namanya (animal),nah kategori animal ane mau tampilkan dinavbar, dan nnti saat kursor digeser ke animal muncul dropdown dengan sub kategori dari (animal) yaitu (singa.macan,kodok,badak).

nah nnti menu navbar disamping nya sama ke diatas cuma beda kategori dan subkategori nya .

kurang lebih seperti itu, mohon banttuannya gan ..

berikut header.phpnya

Code:

<?php

error_reporting(0);

if($pracon != "1"){

 include "koneksi2.php";

}



include "webneed.php";



$infop = mysql_fetch_array(mysql_query("SELECT * FROM owner_profil"));



$namap = $infop['nama'];

$alamatp = $infop['alamat'];

$no_telp = $infop['no_telp'];

$faxp = $infop['fax'];

$emailp = $infop['email'];

$email_csp = $infop['email_cs'];

$email_supportp = $infop['email_support'];

$info_perusahaanp = $infop['info_perusahaan'];



$titleinfo = "HOME";

if($title != ""){

 $titleinfo = $title;

}else{

 $titleinfo = "E-COMMERCE"; 

}

$searchText = $_GET['st'];



$praimg = "home/$webneed_logo_website200";

if($pragambarpn != ""){

 $praimg = "produk/".$pragambarpn;

}

?>

<!DOCTYPE html>

<html lang="id">

<head>

    <meta charset="utf-8">

    <meta name="viewport" content="width=device-width, initial-scale=1.0">

    <meta name="description" content="<?php echo $webneed_deskripsi_web_simple; ?>">

    <meta name="author" content="<?php echo $webneed_nama_web; ?>">

    <title><?php echo $titleinfo; ?> | <?php echo $webneed_nama_web; ?></title>

    <link href="css/bootstrap.min.css" rel="stylesheet">

    <link href="css/font-awesome.min.css" rel="stylesheet">

    <link href="css/prettyPhoto.css" rel="stylesheet">

    <link href="css/price-range.css" rel="stylesheet">

    <link href="css/animate.css" rel="stylesheet">

 <link href="css/main.css" rel="stylesheet">

 <link href="css/responsive.css" rel="stylesheet">

    <link rel="stylesheet" href="css/star-rating.css" media="all" rel="stylesheet" type="text/css"/>

    <!--[if lt IE 9]>

    [removed][removed]

    [removed][removed]

    <![endif]-->       

    <link rel="shortcut icon" href="images/ico/<?php echo $webneed_logo_icon; ?>">

    <meta property="og:image" content="http://<?php echo $webneed_domain_web; ?>/images/<?php echo $praimg; ?>" />

    <meta property="og:title" content="<?php echo $titleinfo; ?>" />

    <meta property="og:description" content="<?php echo $webneed_deskripsi_web_simple; ?>" />

    

    

    <style>

 div.modal div.modal-backdrop {

 z-index: 0;

 }

 </style>

    

    [removed]

 function validateForm() {

 var x = document.getElementById("st").value;

 if (x == null || x == "") {

 return false;

 }else{

 return true;

 }

 }

 [removed]

</head><!--/head-->



<body>

 <header id="header"><!--header-->

 <div class="header_top"><!--header_top-->

 <div class="container">

 <div class="row">

 <div class="col-sm-6">

 <div class="contactinfo">

 <ul class="nav nav-pills">

 <li><a href="#"><i class="fa fa-phone"></i> <?php echo $no_telp; ?></a></li>

 <li><a href="#"><i class="fa fa-envelope"></i> <?php echo $email_csp; ?></a></li>

 </ul>

 </div>

 </div>

 <div class="col-sm-6">

 <div class="social-icons pull-right">

 <ul class="nav navbar-nav">

                            <?php

 $medsosq = mysql_query("SELECT * FROM owner_medsos");

 while($medsos = mysql_fetch_array($medsosq)){

 $deskripsimed = $medsos['deskripsi'];

 $gambarmed = $medsos['gambar'];

 $urlmed = $medsos['url'];

 echo "<li><a ><img /></a></li>";

 }

 ?>

 </ul>

 </div>

 </div>

 </div>

 </div>

 </div><!--/header_top-->

 

 <div class="header-middle"><!--header-middle-->

 <div class="container">

 <div class="row">

 <div class="col-sm-8">

 <div class="logo pull-left">

 <a href="index.php"><img src="images/home/<?php echo $webneed_logo_website; ?>" alt="" width="100%"/></a>

 </div>

 </div>

 <div class="col-sm-4">

 <div class="shop-menu pull-right">

 <ul class="nav navbar-nav">

                            <?php

 $email_user = $_SESSION['email_user'];

 $id_user = $_SESSION['id_user'];

 $nama_user = $_SESSION['nama_user'];

 $email_user = $_SESSION['email_user'];

 $no_tlp_user = $_SESSION['no_tlp_user'];

 if($email_user == ""){

 echo "<li><a ><i class="fa fa-lock"></i> Login / Register</a></li>";

 }else{

 $cartcount = mysql_fetch_array(mysql_query("SELECT COUNT(id) AS count FROM cart WHERE cart.id_user = '".$_SESSION['id_user']."'"));

 echo "

 <li><a ><i class="fa fa-user"></i> $email_user</a></li>

 <li><a ><i class="fa fa-shopping-cart"></i> Cart <span class="badge">$cartcount[count]</span></a></li>

 <li><a ><i class="fa fa-list"></i> Transaksi</a></li>

 <li><a ><i class="fa fa-lock"></i> Logout</a></li>

 "; 

 }

 ?>

 

 </ul>

 </div>

 </div>

 </div>

 </div>

 </div><!--/header-middle-->

 

 <div class="header-bottom"><!--header-bottom-->

 <div class="container">

 <div class="row">

 <div class="col-sm-9">

 <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="mainmenu pull-left">

 <ul class="nav navbar-nav collapse navbar-collapse">

 <li><a href="index.php" class="active">Home</a></li>

 <li class="dropdown"><a href="#">Books<i class="fa fa-angle-down"></i></a>

                                    <ul role="menu" class="sub-menu">

                                        <?php

 $katq = mysql_query("SELECT * FROM m_kategori WHERE sub_id '2'");

 while($kat = mysql_fetch_array($katq)){

 $idkat = $kat['id'];

 $namakat = $kat['nama'];

 echo "<li><a>$namakat</a></li>";

 }

 ?>

                                    </ul>

                                </li> 

 <li class="dropdown"><a href="#">Subject<i class="fa fa-angle-down"></i></a>

                                    <ul role="menu" class="sub-menu">

                                        <?php

 $subjekq = mysql_query("SELECT * FROM m_subjek");

 while($subjek = mysql_fetch_array($subjekq)){

 $idsubjek = $subjek['id'];

 $namasubjek = $subjek['nama'];

 echo "<li><a >$namasubjek</a></li>";

 }

 ?>

                                    </ul>

                                </li> 

 <li><a href="contact.php">Contact</a></li>

                                

 </ul>

 </div>

 </div>

 <div class="col-sm-3">

 <div class="search_box pull-right">

                        <form name="searchForm" action="list.php">

 <input type="text" placeholder="Search" id="st" name="st" value="<?php echo $searchText; ?>"/>

                        </form>

 </div>

 </div>

 </div>

 </div>

 </div><!--/header-bottom-->

 </header><!--/header-->

Terimakasih gann

1.4K

Kutip

Balasan

Komentar yang asik ya

Mari bergabung, dapatkan informasi dan teman baru!

Website, Webmaster, Webdeveloper

23.3KThread•4.4KAnggota

Urutkan

Terlama

Komentar yang asik ya