public static function getRoutesByUser($conn, $userid) { $stmt = $conn->prepare("SELECT *,astext(the_geom) FROM walkroutes WHERE userid=?"); $stmt->bindParam(1, $userid); return Walkroute::getRoutesFromQuery($conn, $stmt); }