<!--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-->
sharifmoskat 0 Newbie Poster
hericles 289 Master Poster Featured Poster
sharifmoskat commented: Thank you for your reply actually my problem is PHP from local system not able to connect to mysql server +0
diafol
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.