<?php 
require('connection.php');

?>
<!DOCTYPE html>
<html lang="en">
<head>
	<meta charset="utf-8">
	<meta http-equiv="X-UA-Compatible" content="IE=edge">
	<meta name="viewport" content="width=device-width, initial-scale=1">
	<meta name="description" content="Orison Solutions Ltd.- A Software With Trust.">
	<meta name="author" content="root">
	<title> Orison Solutions Ltd.</title>
	<link rel="shortcut icon" href="assets/images/fav.png">
    <link href="https://fonts.googleapis.com/css?family=Roboto:400,500,700,900&amp;display=swap" rel="stylesheet">
    <link href="https://fonts.googleapis.com/css2?family=Poppins:wght@300;400;500;600;700&amp;display=swap" rel="stylesheet"> 
    <link rel="stylesheet" href="assets/css/bootstrap.min.css">
    <link rel="stylesheet" href="assets/css/all.min.css">
    <link rel="stylesheet" href="assets/css/animate.min.css">
    <link rel="stylesheet" href="assets/webfonts/flaticon/flaticon.css">
    <link rel="stylesheet" href="assets/css/jquery.fancybox.min.css">
    <link rel="stylesheet" href="assets/css/layerslider.css">
    <link rel="stylesheet" href="assets/css/owl.carousel.min.css">
    <link rel="stylesheet" href="assets/css/template.css">
    <link rel="stylesheet" href="assets/css/style.css">
    <link rel="stylesheet" href="assets/css/category/startup.css">
</head>
<body>

<div id="page_wrapper">
    <header class="nav-on-top fixed-bg-white">
        <div class="navigation-header">
            <div class="container-fluid container-xl-ninety min-xl-px-10">
                <div class="row">
                    <div class="col-md-12">
                        <nav class="navbar navbar-expand-lg nav-secondary nav-primary-hover nav-down-line-active py-2">
                            <a class="navbar-brand" href="index.php"><img class="nav-logo" src="assets/images/logo/orison.png" alt="Image not found !"></a>
                            <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarSupportedContent" aria-controls="navbarSupportedContent" aria-expanded="false" aria-label="Toggle navigation">
                            <span class="navbar-toggler-icon flaticon-menu flat-small text-primary"></span>
                            </button>
                            <div class="collapse navbar-collapse" id="navbarSupportedContent">
                                <ul class="navbar-nav mx-auto">
                                    <li class="nav-item dropdown">
                                        <a class="nav-link dropdown-toggle" href="index.php">Home</a>
                                      
                                    </li>
                                    <li class="nav-item dropdown">
                                        <a class="nav-link dropdown-toggle" href="#">About</a>
                                        <ul class="dropdown-menu">
                                            <li><a class="dropdown-item" href="about.php">About Us</a></li>
                                            <li><a class="dropdown-item" href="mission.php">Mission & Vission</a></li>
                                        
                                        </ul>
                                    </li>
                                   
                                    <li class="nav-item dropdown">
                                        <a class="nav-link dropdown-toggle" href="#">Services</a>
                                        <ul class="dropdown-menu">
                                         
                                             <?php
   $sql = "SELECT * FROM categories where status='1'";
$result = mysqli_query($con, $sql);

if (mysqli_num_rows($result) > 0) {
  // output data of each row
  while($row = mysqli_fetch_assoc($result)) {?>
     <li><a href="services.php?id=<?php echo $row['id']?>" class="dropdown-item"><?php echo $row['categories']?> </a></li>
 <?php }
} else {
  echo "0 results";
}
?>

                                        </ul>
                                    </li>
                                    <li class="nav-item">
                                        <a class="nav-link" href="#">Product</a>
                                    </li>
                                    <li class="nav-item dropdown">
                                        <a class="nav-link dropdown-toggle" href="contact.php">Contact Us</a>
                                       
                                    </li>
                                    
                                </ul>
                               
                            </div>
                        </nav>
                    </div>
                </div>
            </div>
        </div>
    </header>
    <!-- Header Section End -->

	<!-- breadcrumb Start -->
	<div class="full-row bg-secondary" style="padding: 150px 0;">
		<div class="container">
			<div class="row">
				<div class="col-lg-12 text-center">
                    <h2 class="text-primary">
<?php
                         $id=$_GET['id'];
 $sql="select * from categories where id='$id'";
 $result=mysqli_query($con,$sql);
 $row=mysqli_fetch_assoc($result);




                        echo $row['categories'] ?></h2>
                    <nav aria-label="breadcrumb" class="d-table mx-auto">
                        <ol class="breadcrumb mb-0 bg-transparent p-0">
                          <li class="breadcrumb-item"><a href="index.php">Home</a></li>
                          <li class="breadcrumb-item active" aria-current="page"><?php echo $row['categories']  ?></li>
                        </ol>
                      </nav>
                </div>
			</div>
		</div>
	</div>
	<!-- breadcrumb End -->

    <!-- Cart Section Start -->
   <div class="full-row">
        <div class="container">
            <div class="row">
                <div class="col woocommerce-product">
                    <div class="woocommerce-thumb">
                        <div class="woocommerce-single">
                            
                        
                            
                        <div class="row mt-5 mx-0">
                            <div class="col-lg-12"><h3 class="mb-4">Related Products</h3></div>
                            <?php 
                          
                             $sql1="select * from product where categories='$id'";
                                $result1=mysqli_query($con,$sql1);
                              while($row1 = mysqli_fetch_assoc($result1)){?>

                            <div class="col-lg-4 col-md-6 product type-product mb-30 transation">
                                <div class="border border-extra4 p-4 rounded">
                                    <div class="product-img bg-transparent">
                                        <a href="#" class="product-link">
                                            <span class="fas fa-heart text-gray"></span>
                                            <img src="admin/images/<?php echo $row1['image'];?>" alt="image not found!">
                                        </a>
                                    </div>
                                    <div class="product-detail">
                                        <a href="#" class="product-link">
                                            <h2 class="woocommerce-loop-product__title"><?php echo $row1['name'] ?></h2>
                                        </a>
                                       
                                    </div>
                                    
                                </div>
                            </div>
                            <?php } ?>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <!-- Cart Section Start -->

    

    <!-- Footer Section Start -->
    <footer class="full-row pb-3 transation bg-gray">
        <div class="container">
            <div class="row">
                <div class="col-lg-3 col-md-6">
                    <div class="footer-widget mb-5">
                        <h3 class="widget-title mb-4">About</h3>
                        <p>Orison Solutions Limited is a leading technology enabler in East Africa. We provide international technologies & products with in-country post implementation & maintenance support. </p>
                        <div class="footer-widget media-widget-round-white-primary-shadow mt-3">
                            <a href="#"><i class="fab fa-facebook-f"></i></a>
                            <a href="#"><i class="fab fa-instagram"></i></a>
                            <a href="#"><i class="fab fa-twitter"></i></a>
                        </div>
                    </div>
                </div>
                <div class="col-lg-3 col-md-6">
                    <div class="footer-widget contact-widget mb-5">
                        <h3 class="widget-title mb-4">Contact</h3>
                        <ul>
                           <p>Orison Solutions Ltd. ,<br> Plot 83, Tufnell Drive,  <br>Ground Floor, PO Box 108157, <br>Kampala Uganda</p>
                            <p class="mb-3">Email: Uganda@Orisonsol.com <br> Email: Info@Orisonsol.com</p>
                        </ul>
                    </div>
                </div>
                <div class="col-lg-3 col-md-6">
                    <div class="footer-widget footer-nav mb-5">
                        <h3 class="widget-title mb-4">Quick Links</h3>
                        <ul>
                        <li><a href="index.php">Home</a></li>
                        <li><a href="about.php">About Us</a></li>
                        <li><a href="#">Services</a></li>
                        <li><a href="contact.php">Contact Us</a></li>
                        </ul>
                    </div>
                </div>
                <div class="col-lg-3 col-md-6">
                    <div class="footer-widget post-widget mb-5">
                        <h3 class="widget-title mb-4">Office Hours</h3>
                        <ul>
                        <li>Mon - Fri: 9:00am - 5:00pm</li>
                       
                        </ul>
                    </div>
                </div>
            </div>
        </div>
    </footer>
    <!-- Footer Section End -->

    <!-- Copyright Section Start -->
    <div class="copyright text-default pb-3">
        <div class="container">
            <hr class="mt-0">
            <div class="row">
                <div class="col-sm-6">
                    <span>© 2022 Orison Solutions Ltd. All rights reserved.</span>
                </div>
                <div class="col-sm-6">
                    <span class="float-sm-right">Made with love by <a href="https://softlifetechnologies.com/" target="_blank">  Softlife Technologies Pvt. Ltd.</a></span>
                </div>
            </div>
        </div>
    </div>
    <!-- Copyright Section End -->

    <!-- Scroll to top -->
    <a href="#" class="bg-primary text-white" id="scroll"><i class="fa fa-angle-up"></i></a>
    <!-- End Scroll To top -->

</div><!-- Page Wrapper End -->
    
    <!--===============================================================================================-->
    <!-- All Javascript Plugin File here -->
    <script src="assets/js/jquery.min.js"></script>
    <script src="assets/js/popper.min.js"></script>
    <script src="assets/js/bootstrap.min.js"></script>
    <script src="assets/js/jquery.fancybox.min.js"></script>
    <script src="assets/js/owl.carousel.min.js"></script> 
    <script src="assets/js/wow.js"></script>
    <script src="assets/js/paraxify.js"></script>
    <script src="assets/js/mixitup.min.js"></script>
    <script src="assets/js/custom.js"></script>

    <!-- use for map style --> 
    <script src="https://maps.googleapis.com/maps/api/js?key=AIzaSyBPZ-Erd-14Vf2AoPW2Pzlxssf6-2R3PPs"></script>
    <script src="assets/js/map.scripts.js"></script>
    <script>
    (function($){	
        var _latitude = 36.596165;
        var _longitude = -97.062988;
        init(_latitude, _longitude);
    })(jQuery);
    </script>
</body>
</html>