"; sleep(5); }
++$i;
}
echo 'FINALIZADO
';
}
if(isset($_GET['cp']) || isset($_GET['q']) || isset($_GET['country']) || isset($_GET['cs']) || isset($_GET['town']) || isset($_GET['region'])) {
/*
town = colonia
region = estado
country_string = municipio
*/
if(isset($_GET['cp']))
{
$zip_code = mysql_real_escape_string( $_GET['cp'] );
$where = 'postcode = \'' . $zip_code . '\' ||';
}
elseif(isset($_GET['q']))
{
$keyword = mysql_real_escape_string( $_GET['q'] );
$where = 'region LIKE \'%'.$keyword.'%\' || town LIKE \'%'.$keyword.'%\' || country_string LIKE \'%'.$keyword.'%\' ||';
}
if(isset($_GET['town']))
{
$town = mysql_real_escape_string(str_replace('-', ' ', trim($_GET['town'])));
$where = 'town = \''.$town.'\' &&';
}
if(isset($_GET['cs']))
{
$cs = mysql_real_escape_string(str_replace('-', ' ', trim($_GET['cs'])));
$where .= 'country_string = \''.$cs.'\' &&';
}
if(isset($_GET['region']) && !empty($_GET['region']))
{
$region = mysql_real_escape_string(str_replace('-', ' ', trim($_GET['region'])));
$where .= 'region = \''.$region.'\'';
$where .= (!isset($_GET['cr']) ? ' GROUP BY country_string' : '').' ||';
}
$where = substr($where, 0, -2);
function zipcode() {
global $zip_code, $keyword, $where;
$type = isset($_GET['cp']) ? 'cp' : 'text';
if($type == 'cp' && strlen( $zip_code ) < 3) {
echo 'Tu código postal debe tener algo mal
';
return null;
}
if ($type == 'cp' && !is_string( $zip_code )) {
echo 'Tu código postal esta mal.
';
return null;
}
//$where = $type == 'cp' ? 'postcode = \'' . $zip_code . '\'' : 'region LIKE \'%'.$keyword.'%\' || town LIKE \'%'.$keyword.'%\' || country_string LIKE \'%'.$keyword.'%\' LIMIT 50';
$query = mysql_query('SELECT postcode, town, region, country, country_string, eastings, northings FROM zip_codes WHERE '.$where);
$check_postcode_row = mysql_num_rows( $query );
if ($check_postcode_row == 0) {
echo 'La búsqueda no produjo resultados
';
}
else {
echo ''.$check_postcode_row.' resultados
| Código Postal |
Colonia, Pueblo o Sector |
Estado |
Prefijo País |
CD, Municipio o delegación |
Pais |
';
while ($row = mysql_fetch_array( $query )) {
$region_url = empty($zip_code) ? '&cs='.str_replace(' ', '-', $row['country_string']).'&cr=1' : '';
//$region_url = isset($_GET['cs']) ? '&town='.str_replace(' ', '-', $row['town']) : $region;
$region_url = isset($_GET['cs']) ? '' : $region;
$town_url = isset($_GET['region']) ? '®ion='.str_replace(' ', '-', $row['region']).'&cr=1' : '';
$cs_url = isset($_GET['region']) ? '®ion='.str_replace(' ', '-', $row['region']).'&cr=1' : '';
echo '| ' . $row['postcode'] . ' | ' . $row['town'] . ' | ' . $row['region'] . ' | ' . $row['country'] . ' | ' . $row['country_string'] . ' ' . $row['eastings'] . '' . $row['northings'] . ' | México |
';
}
echo '
';
}
return $zip_code;
}
}
function getRegions()
{
$query = mysql_query('SELECT DISTINCT(region) AS region FROM zip_codes');
$count = mysql_num_rows( $query );
if ($count == 0) {
$html = 'No hay estados
';
} else {
$html = '';
$i = 1;
while($row = mysql_fetch_assoc($query)) {
$html .= '| ' . $row['region'] . ' | ';
if ( fmod($i, 5) == 0) {
$html .= '
';
}
++$i;
}
$html .= '
';
}
return $html;
}
?>