place.php

<?php

include('../../includes/config.php');

$country = $_POST['country'];

$state = $_POST['state'];

$city = $_POST['city'];

if($city !='')

{

$sql = mysqli_query($conn,"SELECT * FROM iv_mem_details WHERE iv_mem_city = '$city' AND iv_mem_type='Officer' AND iv_mem_temp_delt_dis='ON'");

}

else if($state !='')

{

$sql = mysqli_query($conn,"SELECT * FROM iv_mem_details WHERE iv_mem_state = '$state' AND iv_mem_type='Officer' AND iv_mem_temp_delt_dis='ON'");

}

else

{

$sql = mysqli_query($conn,"SELECT * FROM iv_mem_details WHERE iv_mem_country = '$country' AND iv_mem_type='Officer' AND iv_mem_temp_delt_dis='ON'");

}

$count = mysqli_num_rows($sql);

if($count==0) echo "<div class='alert alert-danger w-100 text-center'>No Results Found</div>";

else

{

$i = 1;

while($row = mysqli_fetch_assoc($sql))

{

<?php

if($row['iv_mem_thump_photo']!='')

{

<a class="elem w-100 border-0" style="background:transparent;"
            				href="assets/images/members/thump_images/<?php echo $row['iv_mem_thump_photo'] ?>"
            				title="<?php echo $row['iv_mem_thump_photo'] ?>"
            				data-lcl-thumb="assets/images/members/thump_images/<?php echo $row['iv_mem_thump_photo'] ?>">
                <img src="assets/images/members/thump_images/<?php echo $row['iv_mem_thump_photo'] ?>"

alt="<?php echo $row['iv_mem_thump_photo'] ?>" class="w-100" height="230px"></a>

<?php

} else {

<?php } ?>

</div>

View Profile

</div>

</a>

</div>

</li>

<?php

$i++;

}

docroot: /home/induvedam/public_html

curdir: /home/induvedam/public_html/ajax/officer_search

	.	61
	..	4096
X	keyword.php	2082
X	pincode.php	2199
X	place.php	2337