<!--php index code Start-->

<?php
include("includes/db.php");
?>
<!DOCTYPE HTML>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>My Shop</title>
<link rel="stylesheet" href="styles/style.css" media="all" />
</head>

<body>

    <!--Main Contanier Start-->
    <div class="main_wrapper">

        <!--Header Starts-->
        <div class="header_wrapper">
            <img src="images/Karis Shop Logo Neu 700x100 entwurf 3.jpg" style="float:left;">
            <img src="images/cropped-banner41.jpg" style="float:right;">                   
        </div>
        <!--Header Ends-->

        <!--Navaganation Bar starts-->
        <div id="navbar">

            <ul id="menu">
                <li><a href="#">Home</a></li>
                <li><a href="#">All Products</a></li>
                <li><a href="#">My Account</a></li>
                <li><a href="#">Sign up</a></li>
                <li><a href="#">Shoppin Cart</a></li>
                <li><a href="#">Contact Us</a></li>            

            </ul>

            <div id="form">
            <form method="get" action="results.php" enctype="multipart/form-data">

            <input type="text" name="user_query" placeholder="Serch a Product"/>
            <input type="submit" name="search" value="search" />

            </form>
            </div> 

        </div>
        <!--Navaganation Bar Ends-->


        <div class="content_wrapper">

            <div id="left_sidebar">

                <div id="sidebar_title">Categories</div>

                <ul id="cats">

                    <?php

                    $get_cats = "select * from categories";

                    $run_cats = mysqli_query($dbcon, $get_cats);

                    while ($row_cats=mysqli_fetch_array($run_cats)){

                        $cat_id = $row_cats['cat_id'];
                        $cat_title = $row_cats['cat-title'];

                    echo "<li><a href='index.php?cat=$cat_id'>$cat_title</a></li>";

                    }
                ?>
                </ul>

                <div id="sidebar_title">Brands</div>

                <ul id="cats">
                <?php

                    $get_brands = "select * from brands";

                    $run_brands = mysqli_query($con, $get_brands);

                    while ($row_brands=mysqli_fetch_array($run_brands)){

                        $brand_id = $row_brands['brand_id'];
                        $brand_title = $row_brands['brand-title'];

                    echo "<li><a href='index.php?brand=$brand_id'>$brand_title</a></li>";

                    }
                ?>                 

                </ul>
            </div>

            <div id="right_content">right content</div>


        </div>


        <div class="footer">

        <h1 style="color:#000; padding-top:30px; text-align:center;">© 2014 - By Moskat Sharif</h1>

        </div>



    </div>
    <!--Main Contanier End-->

</body>
</html>

<!--php index code end-->



<!--style Start-->


@charset "utf-8";
/* CSS Document */
/* http://meyerweb.com/eric/tools/css/reset/ 
   v2.0 | 20110126
   License: none (public domain)
*/

html, body, div, span, applet, object, iframe,
h1, h2, h3, h4, h5, h6, p, blockquote, pre,
a, abbr, acronym, address, big, cite, code,
del, dfn, em, img, ins, kbd, q, s, samp,
small, strike, strong, sub, sup, tt, var,
b, u, i, center,
dl, dt, dd, ol, ul, li,
fieldset, form, label, legend,
table, caption, tbody, tfoot, thead, tr, th, td,
article, aside, canvas, details, embed, 
figure, figcaption, footer, header, hgroup, 
menu, nav, output, ruby, section, summary,
time, mark, audio, video {
    margin: 0;
    padding: 0;
    border: 0;
    vertical-align: baseline;
}
/* HTML5 display-role reset for older browsers */
article, aside, details, figcaption, figure, 
footer, header, hgroup, menu, nav, section {
    display: block

}

body{background:#39C;}

.main_wrapper {

    width:1000px;
    height:auto;
    margin:auto;    

    }

.header_wrapper {
    width:1000px;
    height:100px;
    background:#FFF;
    }

    #navbar {
        width:1000px;
        height:50px;
        background:#999;
        color:#FFF;     
        }
    #menu {
        padding:0;
        line-height:36px;
        margin-top:5px;
        float:left;
        }
    #menu li {
        list-style:none;
        display:inline;
        }

    #menu a{
        color:#FFF;
        text-decoration:none;
        font-size:20px;
        margin:5px;
        padding:10px;
        }
    #menu a:hover {
        text-decoration:underline;
        color:#333;
        font-weight:bolder;

        }
        #form {float:right; line-height:50px; padding-right:5px;}

    .content_wrapper{
        Width:1000px;
        height:600px;
        background:#F96;
        }

        #right_content{
        Width:800px;
        height:600px;
        background:#FCC;
        float:right;
        }

        #left_sidebar{
        Width:200px;
        height:600px;
        background:#000;
        float:left;
        }

        .footer {
        width:1000px;
        height:100px;
        background:#999;
        color:#FFF;
        clear:both;
        }

        #sidebar_title {
        background:#FFF;
        color:#000;
        padding:10px;
        font-size:22px;
        font-family:"Palatino Linotype", "Book Antiqua", Palatino, serif;
        }

        #cats{
            text-align:center;
            padding:10px;
            }
            #cats li {list-style:none; margin:8px;}
            #cats a {color:#FFF; font-size:20px; text-decoration:none; margin:5px;}
            #cats a:hover {color:#F39; text-decoration:underline; font-weight:bold;}


   <!--style end-->         

<!--db php Start-->            

<?php

$dbcon = mysqli_connect("localhost","root","","myshop");

?>

<!--db php end-->

You could really help us out by explaining what should be happening but isn't.
What error are you getting?

commented: Thank you for your reply actually my problem is PHP from local system not able to connect to mysql server +0
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.