hi everyone,
So i have to do some kind of a visual table to see who is in vacation. But the problem is that I am a beginner in PHP and all kind of web programming. So if anybody knows how SPIP works with PHP and can help me.
here i my code :
[php]<?php
inclure(“squelettes/sql.php”);
inclure(“squelettes/form.php”);
inclure(“squelettes/auth.php”);
if (!$link = connexion_sql())
{
print("\n");
return;
}
else
{
print("<table class=“annuaire”>\n" .
“
“\t
“\t
“\t
“\t
$query = "SELECT id_membre,LOWER(membre.nom) AS nom," .
"DATE_FORMAT(arrivee,'%e/%c/%Y') AS arrivee, DATE_FORMAT(depart, '%e/%c/%Y') AS depart," .
"LOWER(prenom) AS prenom,telephone" .
"FROM membre" .
"ORDER by membre.nom;";
$resource = requete_sql($query);
while($membre = mysql_fetch_assoc($resource))
{
print(">\n" . htmlspecialchars($membre["nom"]) . "</a></td>\n" .
"\t<td>" . htmlspecialchars($membre["prenom"]) . "</td>\n" .
"\t<td>" . htmlspecialchars($membre["arrivée"]) . "</td>\n" .
"\t<td>" . htmlspecialchars($membre["depart"]) . "</td>\n" . "\n");
}
}
?>[/php]