PHP Find Nearest Location using Latitude and Longitude Example

[ad_1]

How to find nearest location using latitude and longitude in php. In this tutorial, you will learn how to find nearest location using latitude and longitude in php.

Sometimes, you need to get nearest location using latitude and longitude in PHP application. So, this tutorial will help you step by step on how to find nearest location using latitude and longitude in php.

How to Find Nearest Location using Latitude and Longitude In PHP

If you want to create find nearest location using latitude and longitude in php app. So, follow the following steps:

  • Step 1 – Connecting to MySQL database
  • Step 2 – Create Get Latitude and Longitude Form
  • Step 3 – Display Nearest Locations in Table

Step 1 – Connecting to MySQL database

In this step, you will create a file name db.php and update the below code into your file.

The following code is used to create a MySQL database connection in PHP. And also, you can use this php code for fetch, insert, update or delete records from MySQL database with and without ajax:

<?php
	$host='localhost';
	$username='root';
	$password='';
	$dbname = "my_db";
	$conn=mysqli_connect($host,$username,$password,"$dbname");
	if(!$conn)
        {
          die('Could not Connect MySql Server:' .mysql_error());
        }
?>

Step 2 – Create Get Latitude and Longitude Form

In this step, create form to get latitude and longitude form user.

So, create index.php file and add the following code into file:

<!doctype html>
<html lang="en">
   <head>
      <meta charset="utf-8">
      <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  
      <title>How to Find Nearest Location using Latitude and Longitude In PHP</title>
       <!-- CSS -->
      <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
   </head>
   <body>
      <div class="container mt-5">
          <div class="card">
            <div class="card-header text-center">
              How to Find Nearest Location using Latitude and Longitude In PHP
            </div>
            <div class="card-body">
              <form action="location.php" method="post">

                <div class="form-group">
                  <label for="exampleInputEmail1">Latitude</label>
                  <input type="text" name="lat" class="form-control" required="">
                </div>                                

                <div class="form-group">
                  <label for="exampleInputEmail1">Longitude</label>
                  <input type="text" name="long" class="form-control" required="">
                </div>

                <input type="submit" name="submit" class="btn btn-primary">
              </form>
            </div>
          </div>
      </div>

   </body>
</html>

Step 3 – Display Nearest Locations in Table

In this step, fetch data nearest location using lat and long from the database. And display locations in html table.

So, create location.php and add the following code into it:

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>PHP Find Nearest Location using Latitude and Longitude Example</title>
</head>
<body>
        <div class="container">
            <div class="row">
                <div class="col-lg-12 mx-auto">
                    <div class="page-header clearfix">
                        <h2 class="pull-left">Location List</h2>
                    </div>
                    <?php

                       require_once "db.php";

                        if (isset($_POST['submit'])) {

                            $lat = $_POST['lat'];
                            $long = $_POST['long'];

                            $sql = "SELECT * , (3956 * 2 * ASIN(SQRT( POWER(SIN(( $lat - LatOnTable) *  pi()/180 / 2), 2) +COS( $lat * pi()/180) * COS(LatOnTable * pi()/180) * POWER(SIN(( $long - LongOnTable) * pi()/180 / 2), 2) ))) as distance  
                                from locations  
                                having  distance <= 10 
                                order by distance";

                            $result = mysqli_query($conn, $sql);

                        }
                    ?>


                    <?php
                    if (mysqli_num_rows($result) > 0) {
                    ?>
                      <table class='table table-bordered table-striped'>
                      
                      <tr>
                        <td>Address</td>
                      </tr>
                    <?php
                    $i=0;
                    while($row = mysqli_fetch_array($result)) {
                    ?>
                    <tr>
                        <td><?php echo $row["address"]; ?></td>
                    </tr>
                    <?php
                    $i++;
                    }
                    ?>
                    </table>
                     <?php
                    }
                    else{
                        echo "No result found";
                    }
                    ?>

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

</body>
</html>

Conclusion

How to find the nearest location using latitude and longitude in PHP. In this tutorial, you have learned how to find the nearest location using latitude and longitude in PHP.

Recommended PHP Tutorials

If you have any questions or thoughts to share, use the comment form below to reach us.

[ad_2]

Jaspreet Singh Ghuman

Jaspreet Singh Ghuman

Jassweb.com/

Passionate Professional Blogger, Freelancer, WordPress Enthusiast, Digital Marketer, Web Developer, Server Operator, Networking Expert. Empowering online presence with diverse skills.

jassweb logo

Jassweb always keeps its services up-to-date with the latest trends in the market, providing its customers all over the world with high-end and easily extensible internet, intranet, and extranet products.

GSTIN is 03EGRPS4248R1ZD.

Contact
Jassweb, Rai Chak, Punjab, India. 143518
Item added to cart.
0 items - 0.00