How to use Variable in Sql query in wordpress?

Question

Here, I'am using this following function: Working in wordpress site.

    function wp_retrieve_information($latitude, $longitude){
    global $wpdb;
    $sql= "SELECT user_email, 
   ( 3959 * acos( cos( radians($latitude) ) * cos( radians( user_lat ) ) 
   * cos( radians(user_long) - radians($longitude)) + sin(radians($latitude)) 
   * sin( radians(user_lat)))) AS distance 
    FROM $wpdb->users 
    having distance < 10";
    $test= $wpdb->get_results($sql) or die(mysql_error());
    //print_r($test);
    foreach ($test as $row) {
    echo $row['user_email'];
    echo $row['distance'];

    }
    return true;
}

Here i'am using $latitude and $longitude as variable in sql query but when I try to call this function website is get totally blank.. may I know where i'am doing the mistake.

Z . · Accepted Answer · 2015-03-12 19:15:35Z

1

change radians($latitude) to radians(" + $latitude + "), same with the other one

answered Mar 12, 2015 at 19:15

Z .

12.8k2 gold badges34 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

akash ujjwal Over a year ago

Thank you for your reply but after trying the above solution, now i'am getting some error i.e You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '133.9667' at line 1

akash ujjwal Over a year ago

and if i'am using constant value at the place of variables then its working fine.. but i need dynamic values.

Z . Over a year ago

echo your sql after constructing it and paste it here

akash ujjwal Over a year ago

Array ( [0] => stdClass Object ( [user_email] => [email protected] [user_range] => 5 [distance] => 0 ) [1] => stdClass Object ( [user_email] => [email protected] [user_range] => 5 [distance] => 0 ) [2] => stdClass Object ( [user_email] => [email protected] [user_range] => 5 [distance] => 0 ) [3] => stdClass Object ( [user_email] => [email protected] [user_range] => 5 [distance] => 0 ) [4] => stdClass Object ( [user_email] => [email protected] [user_range] => 5 [distance] => 0 ) )

akash ujjwal Over a year ago

thanks for your effort i got my answer from this link :-stackoverflow.com/questions/21168422/…

Collectives™ on Stack Overflow

How to use Variable in Sql query in wordpress?

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related