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:
