I want to fetch rows from mysql database with filter by near by and the limit of distance

up vote
0
down vote

favorite

I want to fetch rows from MySql database with filter by near by and the limit of distance. I have created a query that is working fine for fetching the data near by, but I want to add a condition for distance limitation, that means If I want rows which have location of 20 km distance.
This is the query that is working for near by.

$lat="";

$lon="";

$sql="SELECT *, 

  111.111 *

    DEGREES(ACOS(COS(RADIANS(".$lat."))

         * COS(RADIANS(Lat))

         * COS(RADIANS(".$lon." - Lon))

         + SIN(RADIANS(".$lat."))

         * SIN(RADIANS(Lat)))) AS d

FROM Table

ORDER BY d"

php mysql location

share|improve this question

asked yesterday

Romil Singh Tomar

137

add a comment | 

up vote
0
down vote

favorite

I want to fetch rows from MySql database with filter by near by and the limit of distance. I have created a query that is working fine for fetching the data near by, but I want to add a condition for distance limitation, that means If I want rows which have location of 20 km distance.
This is the query that is working for near by.

$lat="";

$lon="";

$sql="SELECT *, 

  111.111 *

    DEGREES(ACOS(COS(RADIANS(".$lat."))

         * COS(RADIANS(Lat))

         * COS(RADIANS(".$lon." - Lon))

         + SIN(RADIANS(".$lat."))

         * SIN(RADIANS(Lat)))) AS d

FROM Table

ORDER BY d"

php mysql location

share|improve this question

asked yesterday

Romil Singh Tomar

137

add a comment | 

up vote
0
down vote

favorite

up vote
0
down vote

favorite

I want to fetch rows from MySql database with filter by near by and the limit of distance. I have created a query that is working fine for fetching the data near by, but I want to add a condition for distance limitation, that means If I want rows which have location of 20 km distance.
This is the query that is working for near by.

$lat="";

$lon="";

$sql="SELECT *, 

  111.111 *

    DEGREES(ACOS(COS(RADIANS(".$lat."))

         * COS(RADIANS(Lat))

         * COS(RADIANS(".$lon." - Lon))

         + SIN(RADIANS(".$lat."))

         * SIN(RADIANS(Lat)))) AS d

FROM Table

ORDER BY d"

php mysql location

share|improve this question

asked yesterday

Romil Singh Tomar

137

I want to fetch rows from MySql database with filter by near by and the limit of distance. I have created a query that is working fine for fetching the data near by, but I want to add a condition for distance limitation, that means If I want rows which have location of 20 km distance.
This is the query that is working for near by.

$lat="";

$lon="";

$sql="SELECT *, 

  111.111 *

    DEGREES(ACOS(COS(RADIANS(".$lat."))

         * COS(RADIANS(Lat))

         * COS(RADIANS(".$lon." - Lon))

         + SIN(RADIANS(".$lat."))

         * SIN(RADIANS(Lat)))) AS d

FROM Table

ORDER BY d"

php mysql location

php mysql location

share|improve this question

asked yesterday

Romil Singh Tomar

137

share|improve this question

asked yesterday

Romil Singh Tomar

137

share|improve this question

share|improve this question

asked yesterday

Romil Singh Tomar

137

asked yesterday

Romil Singh Tomar

137

asked yesterday

Romil Singh Tomar

137

137

add a comment | 

add a comment | 

1 Answer
1

active

oldest

votes

up vote
0
down vote



accepted

You can use HAVING Clause to achieve this

$sql="SELECT *, 

  111.111 *

    DEGREES(ACOS(COS(RADIANS(".$lat."))

         * COS(RADIANS(Lat))

         * COS(RADIANS(".$lon." - Lon))

         + SIN(RADIANS(".$lat."))

         * SIN(RADIANS(Lat)))) AS d

FROM Table HAVING d <= 20

ORDER BY d"

share|improve this answer

answered yesterday

Amit Sahu

22116

• 
  
  
  

  
  

  
  
  
  
  
  

  
  (or WHERE 111.111 * ... <=20)
  – Strawberry
  yesterday
  
  
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  Thanks, It's working
  – Romil Singh Tomar
  yesterday
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

 

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53372372%2fi-want-to-fetch-rows-from-mysql-database-with-filter-by-near-by-and-the-limit-of%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

active

oldest

votes

active

oldest

votes

up vote
0
down vote



accepted

You can use HAVING Clause to achieve this

$sql="SELECT *, 

  111.111 *

    DEGREES(ACOS(COS(RADIANS(".$lat."))

         * COS(RADIANS(Lat))

         * COS(RADIANS(".$lon." - Lon))

         + SIN(RADIANS(".$lat."))

         * SIN(RADIANS(Lat)))) AS d

FROM Table HAVING d <= 20

ORDER BY d"

share|improve this answer

answered yesterday

Amit Sahu

22116

• 
  
  
  

  
  

  
  
  
  
  
  

  
  (or WHERE 111.111 * ... <=20)
  – Strawberry
  yesterday
  
  
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  Thanks, It's working
  – Romil Singh Tomar
  yesterday
  

  
  
  
  

add a comment | 

up vote
0
down vote



accepted

You can use HAVING Clause to achieve this

$sql="SELECT *, 

  111.111 *

    DEGREES(ACOS(COS(RADIANS(".$lat."))

         * COS(RADIANS(Lat))

         * COS(RADIANS(".$lon." - Lon))

         + SIN(RADIANS(".$lat."))

         * SIN(RADIANS(Lat)))) AS d

FROM Table HAVING d <= 20

ORDER BY d"

share|improve this answer

answered yesterday

Amit Sahu

22116

• 
  
  
  

  
  

  
  
  
  
  
  

  
  (or WHERE 111.111 * ... <=20)
  – Strawberry
  yesterday
  
  
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  Thanks, It's working
  – Romil Singh Tomar
  yesterday
  

  
  
  
  

add a comment | 

up vote
0
down vote



accepted

up vote
0
down vote



accepted

You can use HAVING Clause to achieve this

$sql="SELECT *, 

  111.111 *

    DEGREES(ACOS(COS(RADIANS(".$lat."))

         * COS(RADIANS(Lat))

         * COS(RADIANS(".$lon." - Lon))

         + SIN(RADIANS(".$lat."))

         * SIN(RADIANS(Lat)))) AS d

FROM Table HAVING d <= 20

ORDER BY d"

share|improve this answer

answered yesterday

Amit Sahu

22116

You can use HAVING Clause to achieve this

$sql="SELECT *, 

  111.111 *

    DEGREES(ACOS(COS(RADIANS(".$lat."))

         * COS(RADIANS(Lat))

         * COS(RADIANS(".$lon." - Lon))

         + SIN(RADIANS(".$lat."))

         * SIN(RADIANS(Lat)))) AS d

FROM Table HAVING d <= 20

ORDER BY d"

share|improve this answer

answered yesterday

Amit Sahu

22116

share|improve this answer

share|improve this answer

answered yesterday

Amit Sahu

22116

answered yesterday

Amit Sahu

22116

answered yesterday

Amit Sahu

22116

22116

• 
  
  
  

  
  

  
  
  
  
  
  

  
  (or WHERE 111.111 * ... <=20)
  – Strawberry
  yesterday
  
  
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  Thanks, It's working
  – Romil Singh Tomar
  yesterday
  

  
  
  
  

add a comment | 

• 
  
  
  

  
  

  
  
  
  
  
  

  
  (or WHERE 111.111 * ... <=20)
  – Strawberry
  yesterday
  
  
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  Thanks, It's working
  – Romil Singh Tomar
  yesterday
  

  
  
  
  

(or WHERE 111.111 * ... <=20)
– Strawberry
yesterday

(or WHERE 111.111 * ... <=20)
– Strawberry
yesterday

1

1

Thanks, It's working
– Romil Singh Tomar
yesterday

Thanks, It's working
– Romil Singh Tomar
yesterday

add a comment | 

 

draft saved

draft discarded

 

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53372372%2fi-want-to-fetch-rows-from-mysql-database-with-filter-by-near-by-and-the-limit-of%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

Name

Name

Email

Required, but never shown

Email

Required, but never shown

Email

Required, but never shown

Email

Required, but never shown

Name

Name

Email

Required, but never shown

Email

Required, but never shown

Email

Required, but never shown

Email

Required, but never shown

This page is only for reference, If you need detailed information, please check here