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);