prefix."Stores"; $response = ''; function parseToXML($htmlStr) { $xmlStr=str_replace('<','<',$htmlStr); $xmlStr=str_replace('>','>',$xmlStr); $xmlStr=str_replace('"','"',$xmlStr); $xmlStr=str_replace("'",''',$xmlStr); $xmlStr=str_replace("&",'&',$xmlStr); return $xmlStr; } // Get parameters from URL $center_lat = $_GET["lat"]; $center_lng = $_GET["lng"]; $radius = $_GET["radius"]; $distType = $_GET["distType"]; $newRadius = 0; $storeName = $_GET['storeName']; if($distType == 'miles') { $newRadius = intval($radius) * 1.6; } else { $newRadius = intval($radius); } // Search the rows in the markers table if($storeName == '' || $storeName == 'false') { $query = sprintf("SELECT Street, City, Province, PostalCode, Name, Latitude, Longitude, Country, Phone, PreferredStore, CustomInfo, ( 6371 * acos( cos( radians('%s') ) * cos( radians( Latitude ) ) * cos( radians( Longitude ) - radians('%s') ) + sin( radians('%s') ) * sin( radians( Latitude ) ) ) ) AS distance FROM %s HAVING distance < '%s' ORDER BY PreferredStore DESC, distance ASC", mysql_real_escape_string($center_lat), mysql_real_escape_string($center_lng), mysql_real_escape_string($center_lat), $table_name, mysql_real_escape_string($newRadius)); } else { $query = sprintf("SELECT Street, City, Province, PostalCode, Name, Latitude, Longitude, Country, Phone, PreferredStore, CustomInfo, ( 6371 * acos( cos( radians('%s') ) * cos( radians( Latitude ) ) * cos( radians( Longitude ) - radians('%s') ) + sin( radians('%s') ) * sin( radians( Latitude ) ) ) ) AS distance FROM %s WHERE Name LIKE '%%%s%%' HAVING distance < '%s' ORDER BY PreferredStore DESC, distance ASC", mysql_real_escape_string($center_lat), mysql_real_escape_string($center_lng), mysql_real_escape_string($center_lat), $table_name, mysql_real_escape_string($storeName), mysql_real_escape_string($newRadius)); } $result = $wpdb->get_results($query); if (!$result) { die("Invalid query: " . mysql_error()); } // Start XML file, echo parent node echo "\n"; // Iterate through the rows, printing XML nodes for each foreach($result AS $row) { $distance = 0; if($distType == 'miles') { $distance = $row->distance * 0.6; } else { $distance = $row->distance; } $fullAddress = $row->Street.', '.$row->City.', '.$row->Province.', '.$row->PostalCode.', '.$row->Country; // ADD TO XML DOCUMENT NODE echo '\n"; } // End XML file echo "\n"; ?>