<?php

include("includes/db.php");
include("functions/functions.php");
include("includes/header.php");
?>

    <section>
        <div class="container">
            <div class="row">
                <?php include("includes/nav.php");?>

                <div class="col-sm-9 padding-right">
                    <div class="features_items"  id="products_box"><!--features_items start-->
                        <h2 class="title text-center">Search Result</h2>

                        <?php
                        if(isset($_GET['search']))
                        {
                            $user_keyword = $_GET['user_query'];

                            $get_products = "select * from products where product_keywords LIKE '%$user_keyword%'";
                            $run_products = mysqli_query($con, $get_products);

                            while($row_products= mysqli_fetch_array($run_products))
                            {
                                $pro_id = $row_products['product_id'];
                                $pro_title = $row_products['product_title'];
                                $pro_cat = $row_products['cat_id'];
                                $pro_brand = $row_products['brand_id'];
                                $pro_desc = $row_products['product_desc'];
                                $pro_price = rupiah($row_products['product_price']);
                                $pro_image = $row_products['product_img1'];

                                echo "
                                <div class='col-sm-4'>
                                <h3>$pro_title</h3>

                                <img src='admin_area/product_images/$pro_image' width='160' height='160'/><br>
                                <p><b>Price: $pro_price</b></p>
                                <a href='details.php?pro_id=$pro_id' class='btn btn-default' style='float:left;'><i class='fa fa-eye'></i>&nbsp;Details</a>
                                <a href='index.php?add_cart=$pro_id'><button class='btn btn-success' style='float:right;'><i class='fa fa-shopping-cart'></i>&nbsp;Add to Cart</button></a>

                                </div>

                                ";
                                    }//while
                                }//if
                                ?>


                            </div><!--features_items Ends-->


                        </div><!--/category-tab-->



                    </div>
                </div>
            </div>
        </section>

        <?php include("includes/footer.php");?>
    </body>
    </html>