getDistrictData();
break;
case "getMOStypeData":
getMOStypeData();
break;
case "getProductSubGroupData":
getProductSubGroupData();
break;
case "getformulationData":
getformulationData();
break;
case "getItemListData":
getItemListData();
break;
case "getCountryData":
getCountryData();
break;
case "getCaseTypeMasterData":
getCaseTypeMasterData();
break;
case "getCountryRegionsData":
getCountryRegionsData();
break;
case "getYearData":
getYearData();
break;
case "getProfileParamData":
getProfileParamData();
break;
case "getFundingSourceData":
getFundingSourceData();
<?php
include_once "./commonlib.php";
$conn = getConnection("ibabymall");
$ary = getCountryData($conn, $country_data);
echo json_encode($ary);
</div>
<div class="owloo_ranking">
<?php
include 'ranking_fb_page/list_page_country_engagement.php';
?>
</div>
</div>
<h1 class="owloo_main_title_h1 owloo_align_center owloo_fb_engagement_title">
Datos de <?php
echo $country_data['nombre'];
?>
en Facebook
</h1>
<div class="owloo_fb_fan_page_country_description">
<?php
$country_data_num = getCountryData($country_data['code']);
?>
<?php
echo $country_data['nombre'];
?>
cuenta con <?php
echo owloo_number_format($country_data_num['total_user']);
?>
usuarios, de los cuáles el <?php
echo owlooFormatPorcent($country_data_num['total_female'], $country_data_num['total_user']);
?>
% son mujeres y <?php
echo owlooFormatPorcent($country_data_num['total_male'], $country_data_num['total_user']);
?>
son hombres.<br/>
Actualmente se encuentra en la posición <?php
<?php
$ultimas_12_semanas = get_city_date_last_update(5 + 8);
$cont = 1;
$sql = "SELECT fc.id_city id_city, fc.name nombre, total_user, total_female, total_male, c.id_country, c.code code, c.name name\n\t\t\t\tFROM record_city rc \n\t\t\t\t\tJOIN facebook_city fc \n\t\t\t\t\t\tON rc.id_city = fc.id_city \n\t\t\t\t\tJOIN country c \n\t\t\t\t\t\tON fc.id_country = c.id_country \n\t\t\t\tWHERE date = STR_TO_DATE('" . CITY_DATE_LAST_UPDATE . "','%Y-%m-%d') \n\t\t\t\t\tAND c.code LIKE '" . $countryCode . "'\n\t\t\t\tORDER BY 3 DESC\n\t\t\t\t";
$res = mysql_query($sql) or die(mysql_error());
$country = getCountryData($countryCode);
$cityMayorAudiencia = array();
while ($fila = mysql_fetch_assoc($res)) {
if ($cont <= 5) {
$cityMayorAudiencia[] = array('id_city' => $fila['id_city'], 'nombre' => substr($fila['nombre'], 0, strpos($fila['nombre'], ',')), 'total_user' => $fila['total_user'], 'total_female' => $fila['total_female'], 'total_male' => $fila['total_male']);
} else {
break;
}
$cont++;
}
mysql_data_seek($res, 0);
