include("conectare.php"); include("top_page.php"); include("paging.php"); $sql="select count(*) from inscriere where tip='1'"; $res=mysql_query($sql); $totprof=mysql_result($res ,0 ,'count(*)'); ?>
Participanti cadre didactice () |
Pentru ordonare apasati pe un cap de tabel (Ex: Autori). vezi lista studenti |
Nr. crt. | Titlul lucrarii | Autori | Sectiunea | Facultatea |
".$i." | ".$row['titlul']." | ".$row['autori']." | ".$row['sectiunea']." | ".$row['fac']." |
".$i." | ".$row['titlul']." | ".$row['autori']." | ".$row['sectiunea']." | ".$row['fac']." |
// OUTPUT PAGING SYSTEM (COULD ALSO DO IT BEFORE WE OUTPUT THE PAGE CONTENT) if ($page == "1") // THIS IS THE FIRST PAGE - THERE IS NO PREVIOUS PAGE echo ""; else // NOT THE FIRST PAGE, LINK TO THE PREVIOUS PAGE if(isset($_GET['order'])) { echo "Precedenta "; } else { echo "Precedenta "; } for ($i = 1; $i <= $numPages; $i++) { if ($i != "1") { // THIS IS THE FIRST PAGE - THERE IS NO PREVIOUS PAGE echo " "; } if ($i == $page) { echo "$i"; } else { if(isset($_GET['order'])) { echo "$i"; } else { echo "$i"; } } } if ($page == $numPages) { // THIS IS THE LAST PAGE - THERE IS NO NEXT PAGE echo ""; } else { // NOT THE LAST PAGE, LINK TO THE NEXT PAGE if(isset($_GET['order'])) { echo " Urmatoarea"; } else { echo " Urmatoarea"; } } ?> |
$sql="select count(*) from inscriere";
$res=mysql_query($sql);
$tot=mysql_result($res ,0 ,'count(*)');
$sql="select count(*) from inscriere where tip='1'";
$res=mysql_query($sql);
$totprof=mysql_result($res ,0 ,'count(*)');
$sql="select count(*) from inscriere where tip='0'";
$res=mysql_query($sql);
$totst=mysql_result($res ,0 ,'count(*)');
$sql="select count(*) from inscriere where tip='1' and fac='FACULTATEA DE STIINTE JURIDICE'";
$res=mysql_query($sql);
$drept=mysql_result($res ,0 ,'count(*)');
$sql="select count(*) from inscriere where tip='1' and fac='FACULTATEA DE STIINTE ECONOMICE'";
$res=mysql_query($sql);
$mk=mysql_result($res ,0 ,'count(*)');
$sql="select count(*) from inscriere where tip='1' and fac='FACULTATEA DE MEDICINA GENERALA SI DENTARA'";
$res=mysql_query($sql);
$med=mysql_result($res ,0 ,'count(*)');
$sql="select count(*) from inscriere where tip='1' and fac='FACULTATEA DE STIINTE UMANISTE, POLITICE SI ADMINISTRATIVE'";
$res=mysql_query($sql);
$supa=mysql_result($res ,0 ,'count(*)');
$sql="select count(*) from inscriere where tip='1' and fac='FACULTATEA DE PSIHOLOGIE SI STIINTE ALE EDUCATIEI'";
$res=mysql_query($sql);
$psiho=mysql_result($res ,0 ,'count(*)');
$sql="select count(*) from inscriere where tip='1' and fac='FACULTATEA DE STIINTE ALE NATURII'";
$res=mysql_query($sql);
$bio=mysql_result($res ,0 ,'count(*)');
$sql="select count(*) from inscriere where tip='1' and fac='FACULTATEA DE INGINERIE'";
$res=mysql_query($sql);
$ing=mysql_result($res ,0 ,'count(*)');
$sql="select count(*) from inscriere where tip='1' and fac='FACULTATEA DE INFORMATICA'";
$res=mysql_query($sql);
$inf=mysql_result($res ,0 ,'count(*)');
$sql="select count(*) from inscriere where tip='1' and fac='BIBLIOTECA CENTRALA UNIVERSITARA TUDOR ARGHEZI'";
$res=mysql_query($sql);
$bibl=mysql_result($res ,0 ,'count(*)');
$sql="select count(*) from inscriere where tip='1' and fac='FACULTATEA DE EDUCATIE FIZICA SI SPORT'";
$res=mysql_query($sql);
$sport=mysql_result($res ,0 ,'count(*)');
print "Total lucrari inscrise ".$tot;
print " "; print "Sectiunea Studenti ".$totst." lucrari inscrise."; print " "; print "Sectiunea Cadre didactice ".$totprof; print " lucrari inscrise. "; print "Facultatea de Stinte Juridice ".$drept.""; print " "; print "Facultatea de Stiinte Economice ".$mk.""; print " "; print "Facultatea de Medicina Generala si Dentara ".$med.""; print " "; print "Facultatea de Stiinte Umaniste, Politice si Administrative ".$supa.""; print " "; print "Facultatea de Psihologie si stiinte ale Educatiei ".$psiho.""; print " "; print "Facultatea de Stiinte ale Naturii ".$bio.""; print " "; print "Facultatea de Inginerie ".$ing.""; print " "; print "Facultatea de Informatica ".$inf.""; print " "; print "Facultatea de Educatie fizica si Sport ".$sport.""; print " "; print "Biblioteca centarla Universitara Tudor Arghezi ".$bibl.""; ?> |