<?php 
include('../admin/inc/conn.php');
$ip_address=$_SERVER['REMOTE_ADDR'];  
$ipdat = @json_decode(file_get_contents("http://www.geoplugin.net/json.gp?ip=" . $ip_address));
$city_name='' . $ipdat->geoplugin_region . "";
$find_store_data=($_POST['find_store_data']);
$store_sql = $con ->query("SELECT * FROM `store` WHERE `address` LIKE '%".$city_name."%' AND status=1 LIMIT 3");   
while($store_data = $store_sql ->fetch_assoc()){                                              
?>

<div class="col-md-4">
    <div class="store-select">
        <div class="image">
            <div class="img">
                <?php
                    $gallery= $con ->query("SELECT * FROM store_image Where store_id='".$store_data['id']."' LIMIT 1");
                    $gallery_data = $gallery ->fetch_assoc();
                ?>
                <img src="<?php echo STORE_SITE_PATH.$gallery_data['image']; ?>" class="img-responsive">
            </div>
            <div class="title">
                <p><?php echo $store_data['title'] ?></p>
            </div>
            <div class="radio">
                <input type="radio" class="form-check-input" name="store_id" id="store-<?php echo $store_data['id'] ?>" value="<?php echo $store_data['id'] ?>" required>
            </div>
        </div>
        <div class="address">
            <p><?php echo $store_data['address'] ?></p>
        </div>
        <div class="contact">
        <?php
            $state_data= mysqli_fetch_array(mysqli_query($con,"SELECT * FROM states WHERE state_id='".$store_data['state']."'"));
            $city_data= mysqli_fetch_array(mysqli_query($con,"SELECT * FROM cities WHERE city_id='".$store_data['city']."'"));
        ?>
            <span><?php echo $city_data['city_name'].', '.$state_data['state_name']; ?></span> -<span style="margin-left:10px;"><a href="tel:<?php echo $store_data['phone']; ?>"><i class="fa fa-phone"></i> <?php echo $store_data['phone']; ?></a></span>
        </div>
        
    </div>
    <div class="view-store">
            <a class="default-button" href="<?php echo SITE_PATH ?>store/<?php echo $store_data['slug'] ?>"><span>View Store<i class="fa fa-eye"></i></span></a>
        </div>
</div>

<?php } ?>