نشرة الأحوال الجوية في <cfoutput>#url.ccity#</cfoutput> الحالة الجوية و التنبؤات بحالة الطقس

select id,arcity,latitude,longitude,importance from worldcities,worldcitiesarabic where fkey=id and importance=1 order by arcity asc select arcity,info1,countrycode,arcountry,latitude,longitude,fkey from worldcities,worldcitiesarabic WHERE fkey=id and id=#id# Update temporaryweather set forecast='#serializeJSON(forecast)#', timestamp='#dateformat(now(),"yyyy-mm-dd")# #timeformat(now(),"HH:mm:ss")#' where city='#trim(cityname)#' select arcity,info1,countrycode,arcountry,latitude,longitude,fkey from worldcities,worldcitiesarabic WHERE fkey=id and (lower(arcity) LIKE '%#lcase(cityname)#%' or lower(arcountry) LIKE '%#lcase(cityname)#%') insert into temporaryweather(forecast,city,request) values ('#serializeJSON(forecast)#','#trim(cityname)#','#coordinates#')
الحالة الجوية في أهم المدن العربية و العالمية
select * from weatherimages where lower(wcondition)='#lcase(trim(forecast.data.current_condition[1].weatherDesc[1].value))#' and lower(wicon)='#lcase(forecast.data.current_condition[1].weatherIconUrl[1].value)#'
#cityname#
#forecast.data.current_condition[1].temp_C# °م  |  #forecast.data.current_condition[1].temp_F# °ف
#imgs.awcondition# #forecast.data.current_condition[1].weatherDesc[1].value#