Same request Mysql/Php not same result

They give different results because those queries are not the same. They have different latitudes and longitudes.

For example the latitude in one is ‘43.2832512’ but in the other it’s 43.5586. They aren’t even the same data type.

The long/lat in your prepare statement is for a park to the east of marseille, the one in your SQL query though is in the town of coudoux, ~36km away to the north west:

enter image description here

Related Posts:

  1. Get url of product’s images (woocommerce)
  2. How can i create a WooCommerce product programatically or using sql query?
  3. Programmatically adding product attributes to WP / Woo commerce
  4. Woocommerce PHP site that shows table with orders from specific category
  5. How to select from two different tables to display orders list with custom column from other table
  6. How to delete all customer user account that haven’t placed a single order?
  7. 600k of option_name “c_facebook_background_product_sync_job”
  8. DELETE WooCommerce Order data from database
  9. Get decimal from product price with Mysql
  10. WooCommerce – 500k Jump in Order Number?
  11. Deleted products from woocommerce are still in the database
  12. How to merge 2 accounts with same email address after merge of 2 woocommerce databases
  13. Update WooCommerce stock status with SQL query if stock value is greater than 0
  14. Update a list of product to featured if product have meta value (Mysql not wpquery)
  15. MySQL error or data corruption after database migration
  16. Query product’s image path by category WooCommerce database?
  17. Update a user meta key based on WooCommerce product purchase
  18. Mysql query – amount spent by customer
  19. How Fragile Is DB if I Upload Completely Updated Files
  20. In woocommerce some products have empty options, but how to check this
  21. PHP Warning: Error while sending QUERY packet
  22. Update WooCommerce Short Description using SQL
  23. Export Woocomerce Image Product URL
  24. To many WooCommmerce related transients in WordPress options table
  25. How to add a new endpoint in woocommerce
  26. Slow Loading Attribute Select – WooCommerce Backend
  27. Display orders instead of woocommerce my account dashboard for logged in users [closed]
  28. Detect whether a page is a product subcategory page?
  29. Get WooCommerce Email Classes in Backend
  30. Use Hooks to Limit One Comment Per User Per Post – Hide Form if Already Commented
  31. WooCommerce is slow with many categories [closed]
  32. How to remove recurring totals information for a particular subscription product? [closed]
  33. WordPress codex: apply_filters – clarification on creating a new hook on the fly. How do we use it?
  34. Woocommerce – Move product without price a the end
  35. How to get all attributes with their terms related to specific Woocommerce product category [closed]
  36. Extra row / text field to a product page (WooCommerce)
  37. woocommerce_email_attachments filter arguments [closed]
  38. Child theme dosn’t overwrite WooCommerce (version 3.4.7)
  39. How to Show Single Product – 4 Data by ID in Custom Page without over-riding the existing Woo-Commerce
  40. WOOCommerce redirect after registration to account details
  41. How can I add an additional action button into the woocommerce admin order page?
  42. How to add a custom text for order confirmation email template woocommerce
  43. woocomerce is serving OR Relation instead of AND on taxonomy product_tag
  44. Woocommerce Subscriptions – Set Billing Interval/Period
  45. WooCommerce with ACF: custom fields per product variation
  46. Woocommerce checkout page reload on up dating shipping method
  47. change wp_login url and redirect users at the same time
  48. How to clear woocommerce checkout form after pageload
  49. Is there a plugin available for recurring orders in Woocommerce? [closed]
  50. call_user_func_array() error in class-wp-hook.php
  51. Error after woocommerce update from 2.6 to 3.5 [closed]
  52. Send billing info from woocommerce checkout page to paypal checkout form
  53. Check if a category has a parent category in WooCommerce REST API
  54. Remove a higher quantity from stock according to a variation
  55. Dropdown menu not displaying WordPress
  56. Woocommerce product editor does not add br
  57. How can I edit the Woocommerce product widget html class?
  58. Can’t show Woocommerce product category description
  59. Create new email in WooCommerce
  60. Display vendor phone number on single product page
  61. 3 Different Prices for Woocommerce Product
  62. Unable to add product to the cart
  63. How to create a WooCommerce Product filter based on PHP foreach
  64. Use ID as slug for product category by default in WooCommerce?
  65. Woocommerce : Add name filed of checkout page to buyers wordpress display name
  66. WooCommerce return 404 in the product page
  67. How to remove Calendar on Woocommerce Category Pages
  68. Collapsible product categories on sidebar?
  69. Adding a second button next to the shop button Woocommerc [closed]
  70. How to set subcategory in Woocommerce?
  71. Woocommerce – How to Show product tags in shop page
  72. Bulk edit orders to ‘wc-processing’ status
  73. Woocommerce Order Reports MYSQL
  74. woocommerce price filter not working when change currency
  75. With what hook do I remove WooCommerce existing Product Data Tab form fields?
  76. After update Woocommerce shop page not showing products
  77. Add youtube embed to woocommerce variations
  78. WooCommerce – Large number of product variations (200+)
  79. Add custom link/pop up under variations dropdown
  80. Problem in woocommerce.The option “Add product image” is gone.Please help me!
  81. Woocommerce: Some action hooks not firing inside class [closed]
  82. WooCommerce: Conditional Tag for Wishlist Page
  83. Display x number of terms and exclude hidden
  84. Hide woocommerce login form
  85. How to move WooCommerce Product Data Box below Title Box in Edit
  86. Create a WordPress Database query to find users who purchased specific product through WooCommerce [closed]
  87. How to show Woocommerce add to cart form for variable product on custom location [closed]
  88. Adding more information to a Content Product Category
  89. Woocommerce | Product page seems differently on my 2 websites
  90. How to change “reply to” email address for specific Woocommerce products
  91. Woocommerce API REST search by multiple keywords
  92. woocommerce change tax rate with checkbox
  93. How to handle WordPress account for terminated employee
  94. WooCommerce Pruduct and Category Grid costumization [closed]
  95. Error: DNS_PROBE_FINISHED_NXDOMAIN WordPress / Woocommerce
  96. Calculate order end date based on date and number of weeks ACF fields
  97. Football kit management system in WordPress
  98. Display List of Products With Missing Attribute?
  99. Removing unwanted role after purchase
  100. How to Filter Products Based on Categories on the Cart Page?