Méthode d'éléments finis et applications avec Mélina.
Journées en l'honneur de Daniel Martin
Vendredi 10 et samedi 11 décembre 2010 à la Vicomté, Dinard.
function minmaj($chaine) {
$sString=$chaine;
$sString = str_replace ('-', '¿ ', mb_strtolower($chaine, 'UTF-8'));
$sString = ucwords ($sString);//Pour ceux qui à l'origine sont précédés par des '-'
$sString = str_replace ('¿ ', '-', $sString);
return $sString;
}
@mysql_connect("mysql-1.univ-rennes1.fr","vis_databaseanum","9ex7mIckZ") or die("Echec de connexion au serveur");
mysql_query("use databaseanum");
$query="select * from atelier_melina_2010 order by nom, prenom";
$result=mysql_query($query);
$numrows = mysql_numrows($result);
$query1="SELECT COUNT(NOM) FROM `atelier_melina_2010` WHERE `repas1` = 'oui'";
$result1=mysql_query($query1);
$num1 = mysql_result($result1,0,0);
$query2="SELECT * FROM `atelier_melina_2010` WHERE `repas2` = 'oui'";
$result2=mysql_query($query2);
$num2 = mysql_numrows($result2);
$query3="SELECT * FROM `atelier_melina_2010` WHERE `repas3` = 'oui'";
$result3=mysql_query($query3);
$num3 = mysql_numrows($result3);
$query4="SELECT * FROM `atelier_melina_2010` WHERE `nuit` = 'oui'";
$result4=mysql_query($query4);
$num4 = mysql_numrows($result4);
echo "Liste des participants : ".$numrows." inscrits
\n";
echo "\n";
echo " Nom | Prénom | Labo | Email |
Déj. 10 | Dîner 10 | Nuit 10 | Déj. 11 | ";
echo "
\n";
$type="pair";
for ($i=0;$i<$numrows;$i++)
{if ($type=="impair")
$type="pair";
else
$type="impair";
$nom = minmaj((trim(mysql_result($result,$i,"nom"))));
$prenom = (minmaj((trim(mysql_result($result,$i,"prenom")))));
/* $labo = utf8_encode(trim(mysql_result($result,$i,"labo"))); */
$labo = trim(mysql_result($result,$i,"labo"));
$email = trim(mysql_result($result,$i,"email"));
$email = str_replace("@","[at]",$email);
$tel = trim(mysql_result($result,$i,"tel"));
$comment = trim(mysql_result($result,$i,"commentaire"));
$repas1 = trim(mysql_result($result,$i,"repas1"));
$repas2 = trim(mysql_result($result,$i,"repas2"));
$repas3 = trim(mysql_result($result,$i,"repas3"));
$nuit = trim(mysql_result($result,$i,"nuit"));
echo " \n";
echo " ".$nom." | \n";
echo " ".$prenom." | \n";
echo " ".$labo." | \n";
echo " ".$email." | \n";
echo " ".$repas1." | \n";
echo " ".$repas2." | \n";
echo " ".$nuit." | \n";
echo " ".$repas3." | \n";
echo "
\n";
}
echo " Nb 'oui' | | | |
".$num1." |
".$num2." |
".$num4." |
".$num3." | ";
echo "
\n";
echo "
\n";
echo "
\n";
?>
Retour au programme