Mini conférence “Guides d'ondes”
Mercredi 13 et jeudi 14 avril 2011 à la Tour de Maths, Campus de Beaulieu, Rennes
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 conf_guide order by nom, prenom";
$result=mysql_query($query);
$numrows = mysql_numrows($result);
$query1="SELECT COUNT(NOM) FROM `conf_guide` WHERE `repas1` = 'oui'";
$result1=mysql_query($query1);
$num1 = mysql_result($result1,0,0);
$query2="SELECT * FROM `conf_guide` WHERE `repas2` = 'oui'";
$result2=mysql_query($query2);
$num2 = mysql_numrows($result2);
echo "Liste des participants : ".$numrows." inscrits
\n";
echo "\n";
echo " Nom | Prénom | Labo | Email |
Dîner 13 | Déj. 14 | ";
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"));
echo " \n";
echo " ".$nom." | \n";
echo " ".$prenom." | \n";
echo " ".$labo." | \n";
echo " ".$email." | \n";
echo " ".$repas1." | \n";
echo " ".$repas2." | \n";
echo "
\n";
}
echo " Nb 'oui' | | | |
".$num1." |
".$num2." | ";
echo "
\n";
echo "
\n";
echo "
\n";
?>
Retour au programme