• warning: Declaration of views_handler_argument::init(&$view, &$options) should be compatible with views_handler::init(&$view, $options) in /var/www/modules/views/handlers/views_handler_argument.inc on line 0.
  • warning: Declaration of views_handler_filter::options_validate(&$form, &$form_state) should be compatible with views_handler::options_validate($form, &$form_state) in /var/www/modules/views/handlers/views_handler_filter.inc on line 0.
  • warning: Declaration of views_handler_filter::options_submit(&$form, &$form_state) should be compatible with views_handler::options_submit($form, &$form_state) in /var/www/modules/views/handlers/views_handler_filter.inc on line 0.
  • warning: Declaration of views_handler_filter_boolean_operator::value_validate(&$form, &$form_state) should be compatible with views_handler_filter::value_validate($form, &$form_state) in /var/www/modules/views/handlers/views_handler_filter_boolean_operator.inc on line 0.
  • warning: Declaration of views_plugin_row::options_validate($form, &$form_state) should be compatible with views_plugin::options_validate(&$form, &$form_state) in /var/www/modules/views/plugins/views_plugin_row.inc on line 0.
  • warning: Declaration of views_plugin_row::options_submit($form, &$form_state) should be compatible with views_plugin::options_submit(&$form, &$form_state) in /var/www/modules/views/plugins/views_plugin_row.inc on line 0.
PROGRAMUL OLIMPIADEI NAŢIONALE DE MATEMATICĂ,
EDIȚIA 66, BUCUREȘTI, 6-10 APRILIE 2015
REZULTATE BARAJ
'; $conn=mysql_connect($hostname_ssmr, $username_ssmr, $password_ssmr); $db_selected =mysql_select_db($database_ssmr,$conn); $sql = "SET NAMES 'utf8'"; mysql_query($sql, $conn); $clasa= $_POST["clasa"]; if(!$clasa) $clasa='0'; $judet=$_POST["judet"]; if(!$judet) $judet='0'; echo "
"; echo "\n"; $query="SELECT distinct clasa from rezultate_baraj order by clasa"; $result=mysql_query($query,$conn); $cateRanduri=mysql_num_rows($result); printf("

Clasa "); $query="SELECT distinct judet from rezultate_baraj order by judet"; $result=mysql_query($query,$conn); $cateRanduri=mysql_num_rows($result); printf(" Judet "); echo "  

"; echo "
"; $query_string=""; if($judet<>"0") $query_string=$query_string.' and judet="'.$judet.'" '; if($clasa<>"0") $query_string=$query_string.' and clasa="'.$clasa.'" '; $query='SELECT nume_prenume, clasa, unitate_localitate,judet,onm_ponderat,b1,b2,b3,b4,b5,total,result FROM rezultate_baraj where 1=1'.$query_string.' order by clasa, total desc'; $result=mysql_query($query,$conn); $cateRanduri=mysql_num_rows($result); if($clasa<>"0") echo '

'.ucfirst($clasa).''; if ($judet<>"0") echo ' Judetul: '.$judet.'

'; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; //tabelul in care pune tot; $crt=0; for($i=0;$i<$cateRanduri;$i++) { $nume_prenume=""; $clasa=""; $unitate_localitate=""; $judet=""; $onm_ponderat=""; $b1=""; $b2=""; $b3=""; $b4=""; $b5=""; $total=""; $lot=""; $nume_prenume=mysql_result($result,$i,0); $clasa=mysql_result($result,$i,1); $unitate_localitate=mysql_result($result,$i,2); $judet=mysql_result($result,$i,3); $onm_ponderat=mysql_result($result,$i,4); $b1=mysql_result($result,$i,5); $b2=mysql_result($result,$i,6); $b3=mysql_result($result,$i,7); $b4=mysql_result($result,$i,8); $b5=mysql_result($result,$i,9); $total=mysql_result($result,$i,10); if($total==-1) $total='Abs'; $lot=mysql_result($result,$i,11); $crt=$crt+1; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; } printf("
Crt.Nume și prenumeClasaUnitatea de înv./localitateaJudețONM%B1B2B3B4B5TotalLOT
'.$crt.'. '.$nume_prenume.' '.$clasa.' '.$unitate_localitate.''.$judet.''.(is_numeric($onm_ponderat)?$onm_ponderat:'Abs.').''.(is_numeric($b1)?$b1:'Abs.').''.(is_numeric($b2)?$b2:'Abs.').''.(is_numeric($b3)?$b3:'Abs.').''.(is_numeric($b4)?$b4:'Abs.').''.(is_numeric($b5)?$b5:'Abs.').''.$total.''.$lot.'
"); mysql_close($conn); ?>