Filter product.

<?php
include("Database.php");
$sql="select * from department";
$sql2="select * from sub_department";
$sql3="select * from brand";
$sql4="select * from frame_type";
$sql5="select * from lens_type";

?>
<!DOCTYPE HTML>
<html>
<head>
<title>Tulip</title>
<link rel="stylesheet" type="text/css" href="css/style.css" />
<link href="csss/bootstrap.css" rel='stylesheet' type='text/css' />
<script type='text/javascript' src="jss/jquery-1.11.1.min.js"></script>
<!-- Custom Theme files -->
<link href="csss/style.css" rel='stylesheet' type='text/css' />
<!-- Custom Theme files -->
<meta name="viewport" content="width=device-width, initial-scale=1">
<script type="application/x-javascript"> addEventListener("load", function() { setTimeout(hideURLbar, 0); }, false); function hideURLbar(){ window.scrollTo(0,1); } </script>
<!--webfont-->
<link href='http://fonts.googleapis.com/css?family=Open+Sans' rel='stylesheet' type='text/css'>
<!-- start menu -->
<link href="csss/megamenu.css" rel="stylesheet" type="text/css" media="all" />
<script type="text/javascript" src="jss/megamenu.js"></script>
<script>$(document).ready(function(){$(".megamenu").megamenu();});</script>
<script src="jss/menu_jquery.js"></script>
<!-- the jScrollPane script -->
<script type="text/javascript" src="jss/jquery.jscrollpane.min.js"></script>
<script type="text/javascript" id="sourcecode">
$(function()
{
$('.scroll-pane').jScrollPane();
});

</script>
</head>
<body>
<!-- header_top -->
<div class="top_bg" style="background:#450003;
  border-bottom-color:#8B070A;
  border-bottom-style:solid;
  border-bottom-width:2px;
  padding:16px 0;">
<div class="container cf">
          <div class="row" style="margin-left:75px;">
                <div class="pages-menu fleft">
            <ul>
                <li><a href="http://www.tuliphitech.com/tuliphi-tech.jpg">Home</a></li>
                    <li><a href="http://www.tuliphitech.com/tuliphi-tech.jpg">About Us</a></li>
                    <li><a href="http://www.tuliphitech.com/tuliphi-tech.jpg">Testimonials</a></li>
                    <li><a href="http://www.tuliphitech.com/tuliphi-tech.jpg">FAQ</a></li>
                    <li><a href="http://www.tuliphitech.com/tuliphi-tech.jpg">Help?</a></li>
                    <li><a href="http://www.tuliphitech.com/tuliphi-tech.jpg">Sign Up</a></li>
                </ul>
            </div>
         
            <div class="search12">
                        <input name="" type="text" class="sch" placeholder="Search the Store"  />
                     
                       
                     
                    </div>
             
             
             
             
             
                </div>
              </div>
</div>
<!-- header -->
<div class="header_bg" style="height:200px;">
<div class="container">
<div class="header">
<div class="logo">
<a href="index.html"><img src="images/logo2.png" alt=""/> </a>
</div>
<!-- start header_right -->
<div class="header_right">
<div class="create_btn">

</div>
<ul class="icon1 sub-icon1 profile_img">


</ul>
<ul class="icon1 sub-icon1 profile_img">

</ul>

<div class="clearfix"></div>
</div>
<!-- start header menu -->
<ul class="megamenu skyblue" style="">

<li class="grid"><a class="color2" href="#">Men</a>
<div class="megapanel">
<div class="row">
<div class="col1">
<div class="h_nav">
<h4>shop</h4>
<ul>
<li><a href="women.html">new arrivals</a></li>

</ul>
</div>
</div>
<div class="col1">
<div class="h_nav">
<h4>help</h4>
<ul>
<li><a href="women.html">trends</a></li>

</ul>
</div>
</div>
<div class="col1">
<div class="h_nav">
<h4>my company</h4>
<ul>
<li><a href="women.html">trends</a></li>

</ul>
</div>
</div>
<div class="col1">
<div class="h_nav">
<h4>account</h4>
<ul>
<li><a href="women.html">login</a></li>

</ul>
</div>
</div>
<div class="col1">
<div class="h_nav">
<h4>my company</h4>
<ul>
<li><a href="women.html">trends</a></li>

</ul>
</div>
</div>
<div class="col1">
<div class="h_nav">
<h4>popular</h4>
<ul>
<li><a href="women.html">new arrivals</a></li>

</ul>
</div>
</div>
</div>
<div class="row">
<div class="col2"></div>
<div class="col1"></div>
<div class="col1"></div>
<div class="col1"></div>
<div class="col1"></div>
</div>
    </div>
</li>
<li class="active grid"><a class="color4" href="#">Women</a>
<div class="megapanel">
<div class="row">
<div class="col1">
<div class="h_nav">
<h4>shop</h4>
<ul>
<li><a href="women.html">new arrivals</a></li>

</ul>
</div>
</div>
<div class="col1">
<div class="h_nav">
<h4>help</h4>
<ul>
<li><a href="women.html">trends</a></li>

</ul>
</div>
</div>
<div class="col1">
<div class="h_nav">
<h4>my company</h4>
<ul>
<li><a href="women.html">trends</a></li>

</ul>
</div>
</div>
<div class="col1">
<div class="h_nav">
<h4>account</h4>
<ul>
<li><a href="women.html">login</a></li>

</ul>
</div>
</div>
<div class="col1">
<div class="h_nav">
<h4>my company</h4>
<ul>
<li><a href="women.html">trends</a></li>

</ul>
</div>
</div>
<div class="col1">
<div class="h_nav">
<h4>popular</h4>
<ul>
<li><a href="women.html">new arrivals</a></li>

</ul>
</div>
</div>
</div>
<div class="row">
<div class="col2"></div>
<div class="col1"></div>
<div class="col1"></div>
<div class="col1"></div>
<div class="col1"></div>
</div>
    </div>
</li>
<li><a class="color5" href="#">Frames</a>
<div class="megapanel">
<div class="row">
<div class="col1">
<div class="h_nav">
<h4>shop</h4>
<ul>
<li><a href="women.html">new arrivals</a></li>

</ul>
</div>
</div>
<div class="col1">
<div class="h_nav">
<h4>help</h4>
<ul>
<li><a href="women.html">trends</a></li>

</ul>
</div>
</div>
<div class="col1">
<div class="h_nav">
<h4>my company</h4>
<ul>
<li><a href="women.html">trends</a></li>

</ul>
</div>
</div>
<div class="col1">
<div class="h_nav">
<h4>account</h4>
<ul>
<li><a href="women.html">login</a></li>

</ul>
</div>
</div>
<div class="col1">
<div class="h_nav">
<h4>my company</h4>
<ul>
<li><a href="women.html">trends</a></li>

</ul>
</div>
</div>
<div class="col1">
<div class="h_nav">
<h4>popular</h4>
<ul>
<li><a href="women.html">new arrivals</a></li>

</ul>
</div>
</div>
</div>
<div class="row">
<div class="col2"></div>
<div class="col1"></div>
<div class="col1"></div>
<div class="col1"></div>
<div class="col1"></div>
</div>
    </div>
</li>
<li><a class="color6" href="#">Eye Glasses</a>
<div class="megapanel">
<div class="row">
<div class="col1">
<div class="h_nav">
<h4>shop</h4>
<ul>
<li><a href="women.html">new arrivals</a></li>

</ul>
</div>
</div>
<div class="col1">
<div class="h_nav">
<h4>help</h4>
<ul>
<li><a href="women.html">trends</a></li>

</ul>
</div>
</div>
<div class="col1">
<div class="h_nav">
<h4>my company</h4>
<ul>
<li><a href="women.html">trends</a></li>

</ul>
</div>
</div>
<div class="col1">
<div class="h_nav">
<h4>account</h4>
<ul>
<li><a href="women.html">login</a></li>

</ul>
</div>
</div>
<div class="col1">
<div class="h_nav">
<h4>my company</h4>
<ul>
<li><a href="women.html">trends</a></li>

</ul>
</div>
</div>
<div class="col1">
<div class="h_nav">
<h4>popular</h4>
<ul>
<li><a href="women.html">new arrivals</a></li>

</ul>
</div>
</div>
</div>
<div class="row">
<div class="col2"></div>
<div class="col1"></div>
<div class="col1"></div>
<div class="col1"></div>
<div class="col1"></div>
</div>
    </div>
</li>
<li><a class="color7" href="#">Sun Glasses</a>
<div class="megapanel">
<div class="row">
<div class="col1">
<div class="h_nav">
<h4>shop</h4>
<ul>
<li><a href="women.html">new arrivals</a></li>

</ul>
</div>
</div>
<div class="col1">
<div class="h_nav">
<h4>help</h4>
<ul>
<li><a href="women.html">trends</a></li>

</ul>
</div>
</div>
<div class="col1">
<div class="h_nav">
<h4>my company</h4>
<ul>
<li><a href="women.html">trends</a></li>

</ul>
</div>
</div>
<div class="col1">
<div class="h_nav">
<h4>account</h4>
<ul>
<li><a href="women.html">login</a></li>

</ul>
</div>
</div>
<div class="col1">
<div class="h_nav">
<h4>my company</h4>
<ul>
<li><a href="women.html">trends</a></li>

</ul>
</div>
</div>
<div class="col1">
<div class="h_nav">
<h4>popular</h4>
<ul>
<li><a href="women.html">new arrivals</a></li>

</ul>
</div>
</div>
</div>
<div class="row">
<div class="col2"></div>
<div class="col1"></div>
<div class="col1"></div>
<div class="col1"></div>
<div class="col1"></div>
</div>
     </div>
</li>
<li><a class="color8" href="#">Contact Lenses</a>
<div class="megapanel">
<div class="row">
<div class="col1">
<div class="h_nav">
<h4>shop</h4>
<ul>
<li><a href="women.html">new arrivals</a></li>

</ul>
</div>
</div>
<div class="col1">
<div class="h_nav">
<h4>help</h4>
<ul>
<li><a href="women.html">trends</a></li>

</ul>
</div>
</div>
<div class="col1">
<div class="h_nav">
<h4>my company</h4>
<ul>
<li><a href="women.html">trends</a></li>

</ul>
</div>
</div>
<div class="col1">
<div class="h_nav">
<h4>account</h4>
<ul>
<li><a href="women.html">login</a></li>

</ul>
</div>
</div>
<div class="col1">
<div class="h_nav">
<h4>my company</h4>
<ul>
<li><a href="women.html">trends</a></li>

</ul>
</div>
</div>
<div class="col1">
<div class="h_nav">
<h4>popular</h4>
<ul>
<li><a href="women.html">new arrivals</a></li>

</ul>
</div>
</div>
</div>
<div class="row">
<div class="col2"></div>
<div class="col1"></div>
<div class="col1"></div>
<div class="col1"></div>
<div class="col1"></div>
</div>
      </div>
</li>
<li><a class="color9" href="#">Accessories</a>
<div class="megapanel">
<div class="row">
<div class="col1">
<div class="h_nav">
<h4>shop</h4>
<ul>
<li><a href="women.html">new arrivals</a></li>

</ul>
</div>
</div>
<div class="col1">
<div class="h_nav">
<h4>help</h4>
<ul>
<li><a href="women.html">trends</a></li>

</ul>
</div>
</div>
<div class="col1">
<div class="h_nav">
<h4>my company</h4>
<ul>
<li><a href="women.html">trends</a></li>

</ul>
</div>
</div>
<div class="col1">
<div class="h_nav">
<h4>account</h4>
<ul>
<li><a href="women.html">login</a></li>

</ul>
</div>
</div>
<div class="col1">
<div class="h_nav">
<h4>my company</h4>
<ul>
<li><a href="women.html">trends</a></li>

</ul>
</div>
</div>
<div class="col1">
<div class="h_nav">
<h4>popular</h4>
<ul>
<li><a href="women.html">new arrivals</a></li>

</ul>
</div>
</div>
</div>
<div class="row">
<div class="col2"></div>
<div class="col1"></div>
<div class="col1"></div>
<div class="col1"></div>
<div class="col1"></div>
</div>
     </div>
</li>
<li><a class="color10" href="contact.html">Contact</a>
<div class="megapanel">
<div class="row">
<div class="col3">
<div class="h_nav">
<h4>contact us</h4>
</div>
<form class="contact">
<label for="name">Name</label>
<input id="name" type="text"/>
<label for="email">E-mail</label>
<input id="email" type="text"/>
<label for="message">Message</label>
<textarea rows="8" id="message"></textarea>
<input type="submit" value="Send"/>
</form>
</div>
<div class="col3">
</div>
</div>
</div>
</li>
 </ul>
</div>
</div>
</div>
<!-- content -->
<div class="container">
<div class="women_main">
<!-- start sidebar -->
<div class="col-md-3">
 <div class="w_sidebar">
<div class="w_nav1">
<h4>All</h4>
<ul>
<li><a href="women.html">Men</a></li>
<li><a href="#">Women</a></li>
<li><a href="#">Child</a></li>
<li><a href="#">Adult</a></li>

</ul>
</div>
<h3>filter by</h3>
<section  class="sky-form">
<h4>category</h4>
<div class="row1 scroll-pane">
<div class="col col-4">

</div>
<div class="col col-4">
<?php
$ret=mysql_query($sql);
while($row=mysql_fetch_array($ret))
{
?>
<label ><i></i><a href="newproduct.php?catid=<?php echo $row[0];?>"><?php echo $row[1];?></a></label>
<?php
}
?>
</div>
</div>
</section>
<section  class="sky-form">
<h4>Sub-Category</h4>
<div class="row1 scroll-pane">
<div class="col col-4">

</div>
<div class="col col-4">
<?php
$ret1=mysql_query($sql2);
while($row1=mysql_fetch_array($ret1))
{
?>
<label ><i></i><a href="newproduct.php?catid=<?php echo $_REQUEST['catid'];?>&subcatid=<?php echo $row1[0];?>"><?php echo $row1[1];?></a></label>
<?php
}

?>
</div>
</div>
</section>
<section class="sky-form">
<h4>colour</h4>
<ul class="w_nav2">
<li><a class="color1" href="#"></a></li>
<li><a class="color2" href="#"></a></li>
<li><a class="color3" href="#"></a></li>
<li><a class="color4" href="#"></a></li>
<li><a class="color5" href="#"></a></li>
<li><a class="color6" href="#"></a></li>
<li><a class="color7" href="#"></a></li>
<li><a class="color8" href="#"></a></li>
<li><a class="color9" href="#"></a></li>
<li><a class="color10" href="#"></a></li>
<li><a class="color12" href="#"></a></li>
<li><a class="color13" href="#"></a></li>
<li><a class="color14" href="#"></a></li>
<li><a class="color15" href="#"></a></li>
<li><a class="color5" href="#"></a></li>
<li><a class="color6" href="#"></a></li>
<li><a class="color7" href="#"></a></li>
<li><a class="color8" href="#"></a></li>
<li><a class="color9" href="#"></a></li>
<li><a class="color10" href="#"></a></li>
</ul>
</section>
<section  class="sky-form">
<h4>Brands</h4>
<div class="row1 scroll-pane">
<div class="col col-4">

</div>
<div class="col col-4">
<?php
$ret3=mysql_query($sql3);
while($row3=mysql_fetch_array($ret3))
{
?>
<label ><i></i>
<a href="newproduct.php?catid=<?php echo $_REQUEST['catid'];?>&subcatid=<?php echo $_REQUEST['subcatid'];?>&brandid=<?php echo $row3[0];?>"><?php echo $row3[1];?></a></label>
<?php
}?>
</div>
</div>
</section>
<section class="sky-form">
<h4>Frame-Type</h4>
<div class="row1 scroll-pane">
<div class="col col-4">

</div>
<div class="col col-4">
<?php
$ret4=mysql_query($sql4);
while($row4=mysql_fetch_array($ret4))
{
?>
<label ><i></i><a href=""><?php echo $row4[1];?></a></label>
<?php
}?>
</div>
</div>
</section>
<section class="sky-form">
<h4>Temple-Size</h4>
<div class="row1 scroll-pane">
<div class="col col-4">

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

<label ><i></i><a href="">111-115</a></label>
<label><i></i><a href="">116-120</a></label>
<label ><i></i><a href="">121-125</a></label>
<label ><i></i><a href="">126-130</a></label>
<label ><i></i><a href="">131-135</a></label>
<label ><i></i><a href="">136-140</a></label>
<label ><i></i><a href="">141-145</a></label>
<label ><i></i><a href="">146-150</a></label>
</div>
</div>
</section>

<section class="sky-form">
<h4>Size and Bridge</h4>
<div class="row1 scroll-pane">
<div class="col col-4">

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

<label  style="display:block;"><i></i><a href="">41</a></label>
                                <label style="display:block;"><i></i><a href="">42</a></label>
                                <label style="display:block;"><i></i><a href="">43</a></label>
                                <label style="display:block;"><i></i><a href="">46</a></label>
                                <label style="display:block;"><i></i><a href="">47</a></label>
                                <label style="display:block;"><i></i><a href="">48</a></label>
                                <label style="display:block;"><i></i><a href="">49</a></label>
                                <label style="display:block;"><i></i><a href="">50</a></label>
                             

</div>
</div>
</section>
     
        <section class="sky-form">
<h4>Price Range</h4>
<div class="row1 scroll-pane">
<div class="col col-4">

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

<label ><i></i><a href="">All</a></label>
<label ><i></i><a href="">Less Than Rs 500</a></label>
                                <label ><i></i><a href="">Rs501 - Rs1000</a></label>
                                <label ><i></i><a href="">Rs1001- Rs2000</a></label>
                                <label ><i></i><a href="">Rs2001 - Rs3000</a></label>
                                <label ><i></i><a href="">Rs3000 +</a></label>

</div>
</div>
</section>
     
<section class="sky-form">
<h4>Lens-Type</h4>
<div class="row1 scroll-pane">
<div class="col col-4">

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

<?php
$ret5=mysql_query($sql5);
while($row5=mysql_fetch_array($ret5))
{
?>
<label ><i></i><a href=""><?php echo $row5[1];?></a></label>
<?php
}?>

</div>
</div>
</section>
</div>
   </div>
<!-- start content -->
<div class="col-md-9 w_content">
<div class="women">
<a href="#"><h4>Mens Lenses - <span>45 itemms</span> </h4></a>
<ul class="w_nav">

    </ul>
    <div class="clearfix"></div>
</div>
<?php
include("productrows.php");
?>


</div>
<div class="clearfix"></div>

<!-- end content -->
</div>
</div>
<!-- footer_top -->
 <div style="margin-top:150px;">
       <?php
  include("footer.php");
  ?>
              </div>
            </div>  
        </div>
</body>
</html>


productrows.php





<!-- grids_of_4 -->
<?php

$sql6="select * from product WHERE `Department_ID`='".$_GET['catid']."'";
if($_GET['catid']<>'')
{
$sql6 .=" and  `Department_ID`='".$_GET['catid']."'";
}
if($_GET['subcatid']<>'')
{
$sql6 .=" and  `Sub_DepartmentID`='".$_GET['subcatid']."'";
}
if($_GET['brandid']<>'')
{
$sql6 .=" and  Brand_ID ='".$_GET['brandid']."'";
}
$ret6=mysql_query($sql6);
$co=mysql_query("select * from product");
$nums=mysql_num_rows($co);
while($row6=mysql_fetch_array($ret6))
{
?>
<div class="grid1_of_4">
<div class="content_box"><a href="details.php?id=<?php echo $row6['ID'];?>">
   <div class="view view-fifth">
    <img src="upload/product/<?php echo $row6[18];?>" class="img-responsive" alt=""/>
    <div class="mask">
                       <div class="info">Quick View</div>
           </div>
   </a>
  </div>
   <h4><a href="details.php?id=<?php echo $row6['ID'];?>"><?php echo $row6[1];?>-Glass</a></h4>
    <p>It is a long established fact that a reader</p>
    Rs. <?php echo $row6[4];?>
  </div>
</div>
<?php
}
?>
<!-- end grids_of_4 -->

















Popular posts from this blog

Simple Sign up design. Android.

Image
<?xml version="1.0" encoding="utf-8"?> <androidx.constraintlayout.widget.ConstraintLayout xmlns:android="http://schemas.android.com/apk/res/android"     xmlns:app="http://schemas.android.com/apk/res-auto"     xmlns:tools="http://schemas.android.com/tools"     android:layout_width="match_parent"     android:layout_height="match_parent"     app:layout_behavior="@string/appbar_scrolling_view_behavior"     tools:context=".Signup"     tools:showIn="@layout/activity_signup">     <ScrollView         android:layout_width="fill_parent"         android:layout_height="fill_parent"         android:fillViewport="true"         tools:ignore="MissingConstraints">     <LinearLayout         android:layout_width="fill_parent"         android:layout_height="fill_parent"         android:orientation="vertic
Read more

Cart page design in android.

Image
<?xml version="1.0" encoding="utf-8"?> <androidx.constraintlayout.widget.ConstraintLayout xmlns:android="http://schemas.android.com/apk/res/android"     xmlns:app="http://schemas.android.com/apk/res-auto"     xmlns:tools="http://schemas.android.com/tools"     android:layout_width="match_parent"     android:layout_height="match_parent"     app:layout_behavior="@string/appbar_scrolling_view_behavior"     tools:context=".Cart"     tools:showIn="@layout/activity_cart">     <LinearLayout         android:id="@+id/activity_cart_list"         xmlns:android="http://schemas.android.com/apk/res/android"         xmlns:tools="http://schemas.android.com/tools"         android:layout_width="match_parent"         android:layout_height="match_parent"         android:orientation="vertical"         android:weightSu
Read more

Set Date on jDateChooser and retrieve record from database.

 d5  = ((JTextField)jDateChooser1.getDateEditor().getUiComponent()).getText();         SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); Calendar c = Calendar.getInstance();         try {             c.setTime(sdf.parse(d5));         } catch (ParseException ex) {             Logger.getLogger(Commity.class.getName()).log(Level.SEVERE, null, ex);         } c.add(Calendar.MONTH, 1);  // number of days to add d5 = sdf.format(c.getTime()); System.out.println(""+d5);         try {             java.util.Date date = new SimpleDateFormat("yyyy-MM-d").parse(String.valueOf(d5));             jDateChooser1.setDate(date);                    } catch (ParseException ex) {             Logger.getLogger(Commity.class.getName()).log(Level.SEVERE, null, ex);         }         try         {     Class.forName("com.mysql.jdbc.Driver");     java.sql.Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3305/commity",
Read more