anniversaire


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO anniversaire (`j`,`m`,`a`,`nom`,`prenom`,`email`,`pays`,`ville`,`ip`,`valider`) VALUES ('$j','$m','$a','$nom','$prenom','$email','$pays','$ville','$ip','$valider')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `anniversaire` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id_annif = mysql_result($res,$i,"id_annif");
$j = mysql_result($res,$i,"j");
$m = mysql_result($res,$i,"m");
$a = mysql_result($res,$i,"a");
$nom = mysql_result($res,$i,"nom");
$prenom = mysql_result($res,$i,"prenom");
$email = mysql_result($res,$i,"email");
$pays = mysql_result($res,$i,"pays");
$ville = mysql_result($res,$i,"ville");
$ip = mysql_result($res,$i,"ip");
$valider = mysql_result($res,$i,"valider");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `anniversaire` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id_annif=$tablo[$i]['id_annif'];
$j=$tablo[$i]['j'];
$m=$tablo[$i]['m'];
$a=$tablo[$i]['a'];
$nom=$tablo[$i]['nom'];
$prenom=$tablo[$i]['prenom'];
$email=$tablo[$i]['email'];
$pays=$tablo[$i]['pays'];
$ville=$tablo[$i]['ville'];
$ip=$tablo[$i]['ip'];
$valider=$tablo[$i]['valider'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `anniversaire` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id_annif = mysql_result($res,0,"id_annif");
$j = mysql_result($res,0,"j");
$m = mysql_result($res,0,"m");
$a = mysql_result($res,0,"a");
$nom = mysql_result($res,0,"nom");
$prenom = mysql_result($res,0,"prenom");
$email = mysql_result($res,0,"email");
$pays = mysql_result($res,0,"pays");
$ville = mysql_result($res,0,"ville");
$ip = mysql_result($res,0,"ip");
$valider = mysql_result($res,0,"valider");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `anniversaire` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `anniversaire` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

article


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO article (`titre`,`date_creation`,`date_modif`,`article`,`image`,`align`,`visible`,`id_user`,`ip`,`clip`) VALUES ('$titre','$date_creation','$date_modif','$article','$image','$align','$visible','$id_user','$ip','$clip')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `article` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id_blog = mysql_result($res,$i,"id_blog");
$titre = mysql_result($res,$i,"titre");
$date_creation = mysql_result($res,$i,"date_creation");
$date_modif = mysql_result($res,$i,"date_modif");
$article = mysql_result($res,$i,"article");
$image = mysql_result($res,$i,"image");
$align = mysql_result($res,$i,"align");
$visible = mysql_result($res,$i,"visible");
$id_user = mysql_result($res,$i,"id_user");
$ip = mysql_result($res,$i,"ip");
$clip = mysql_result($res,$i,"clip");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `article` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id_blog=$tablo[$i]['id_blog'];
$titre=$tablo[$i]['titre'];
$date_creation=$tablo[$i]['date_creation'];
$date_modif=$tablo[$i]['date_modif'];
$article=$tablo[$i]['article'];
$image=$tablo[$i]['image'];
$align=$tablo[$i]['align'];
$visible=$tablo[$i]['visible'];
$id_user=$tablo[$i]['id_user'];
$ip=$tablo[$i]['ip'];
$clip=$tablo[$i]['clip'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `article` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id_blog = mysql_result($res,0,"id_blog");
$titre = mysql_result($res,0,"titre");
$date_creation = mysql_result($res,0,"date_creation");
$date_modif = mysql_result($res,0,"date_modif");
$article = mysql_result($res,0,"article");
$image = mysql_result($res,0,"image");
$align = mysql_result($res,0,"align");
$visible = mysql_result($res,0,"visible");
$id_user = mysql_result($res,0,"id_user");
$ip = mysql_result($res,0,"ip");
$clip = mysql_result($res,0,"clip");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `article` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `article` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

blog


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO blog (`titre`,`post`,`article`,`image`,`align`,`visible`,`membre`) VALUES ('$titre','$post','$article','$image','$align','$visible','$membre')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `blog` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id = mysql_result($res,$i,"id");
$titre = mysql_result($res,$i,"titre");
$post = mysql_result($res,$i,"post");
$article = mysql_result($res,$i,"article");
$image = mysql_result($res,$i,"image");
$align = mysql_result($res,$i,"align");
$visible = mysql_result($res,$i,"visible");
$membre = mysql_result($res,$i,"membre");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `blog` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id=$tablo[$i]['id'];
$titre=$tablo[$i]['titre'];
$post=$tablo[$i]['post'];
$article=$tablo[$i]['article'];
$image=$tablo[$i]['image'];
$align=$tablo[$i]['align'];
$visible=$tablo[$i]['visible'];
$membre=$tablo[$i]['membre'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `blog` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id = mysql_result($res,0,"id");
$titre = mysql_result($res,0,"titre");
$post = mysql_result($res,0,"post");
$article = mysql_result($res,0,"article");
$image = mysql_result($res,0,"image");
$align = mysql_result($res,0,"align");
$visible = mysql_result($res,0,"visible");
$membre = mysql_result($res,0,"membre");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `blog` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `blog` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

celebrite


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO celebrite (`nom`,`categorie`,`au`,`date_nee`,`j`,`m`,`a`,`pays`,`date_mort`,`image`,`url`,`ok`) VALUES ('$nom','$categorie','$au','$date_nee','$j','$m','$a','$pays','$date_mort','$image','$url','$ok')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `celebrite` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id = mysql_result($res,$i,"id");
$nom = mysql_result($res,$i,"nom");
$categorie = mysql_result($res,$i,"categorie");
$au = mysql_result($res,$i,"au");
$date_nee = mysql_result($res,$i,"date_nee");
$j = mysql_result($res,$i,"j");
$m = mysql_result($res,$i,"m");
$a = mysql_result($res,$i,"a");
$pays = mysql_result($res,$i,"pays");
$date_mort = mysql_result($res,$i,"date_mort");
$image = mysql_result($res,$i,"image");
$url = mysql_result($res,$i,"url");
$ok = mysql_result($res,$i,"ok");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `celebrite` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id=$tablo[$i]['id'];
$nom=$tablo[$i]['nom'];
$categorie=$tablo[$i]['categorie'];
$au=$tablo[$i]['au'];
$date_nee=$tablo[$i]['date_nee'];
$j=$tablo[$i]['j'];
$m=$tablo[$i]['m'];
$a=$tablo[$i]['a'];
$pays=$tablo[$i]['pays'];
$date_mort=$tablo[$i]['date_mort'];
$image=$tablo[$i]['image'];
$url=$tablo[$i]['url'];
$ok=$tablo[$i]['ok'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `celebrite` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id = mysql_result($res,0,"id");
$nom = mysql_result($res,0,"nom");
$categorie = mysql_result($res,0,"categorie");
$au = mysql_result($res,0,"au");
$date_nee = mysql_result($res,0,"date_nee");
$j = mysql_result($res,0,"j");
$m = mysql_result($res,0,"m");
$a = mysql_result($res,0,"a");
$pays = mysql_result($res,0,"pays");
$date_mort = mysql_result($res,0,"date_mort");
$image = mysql_result($res,0,"image");
$url = mysql_result($res,0,"url");
$ok = mysql_result($res,0,"ok");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `celebrite` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `celebrite` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

change


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO change (`date`,`usd`,`gbp`,`chf`,`jpy`,`zar`,`hkd`,`euro`) VALUES ('$date','$usd','$gbp','$chf','$jpy','$zar','$hkd','$euro')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `change` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id = mysql_result($res,$i,"id");
$date = mysql_result($res,$i,"date");
$usd = mysql_result($res,$i,"usd");
$gbp = mysql_result($res,$i,"gbp");
$chf = mysql_result($res,$i,"chf");
$jpy = mysql_result($res,$i,"jpy");
$zar = mysql_result($res,$i,"zar");
$hkd = mysql_result($res,$i,"hkd");
$euro = mysql_result($res,$i,"euro");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `change` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id=$tablo[$i]['id'];
$date=$tablo[$i]['date'];
$usd=$tablo[$i]['usd'];
$gbp=$tablo[$i]['gbp'];
$chf=$tablo[$i]['chf'];
$jpy=$tablo[$i]['jpy'];
$zar=$tablo[$i]['zar'];
$hkd=$tablo[$i]['hkd'];
$euro=$tablo[$i]['euro'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `change` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id = mysql_result($res,0,"id");
$date = mysql_result($res,0,"date");
$usd = mysql_result($res,0,"usd");
$gbp = mysql_result($res,0,"gbp");
$chf = mysql_result($res,0,"chf");
$jpy = mysql_result($res,0,"jpy");
$zar = mysql_result($res,0,"zar");
$hkd = mysql_result($res,0,"hkd");
$euro = mysql_result($res,0,"euro");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `change` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `change` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

cometchat


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO cometchat (`from`,`to`,`message`,`sent`,`read`,`direction`) VALUES ('$from','$to','$message','$sent','$read','$direction')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `cometchat` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id = mysql_result($res,$i,"id");
$from = mysql_result($res,$i,"from");
$to = mysql_result($res,$i,"to");
$message = mysql_result($res,$i,"message");
$sent = mysql_result($res,$i,"sent");
$read = mysql_result($res,$i,"read");
$direction = mysql_result($res,$i,"direction");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `cometchat` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id=$tablo[$i]['id'];
$from=$tablo[$i]['from'];
$to=$tablo[$i]['to'];
$message=$tablo[$i]['message'];
$sent=$tablo[$i]['sent'];
$read=$tablo[$i]['read'];
$direction=$tablo[$i]['direction'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `cometchat` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id = mysql_result($res,0,"id");
$from = mysql_result($res,0,"from");
$to = mysql_result($res,0,"to");
$message = mysql_result($res,0,"message");
$sent = mysql_result($res,0,"sent");
$read = mysql_result($res,0,"read");
$direction = mysql_result($res,0,"direction");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `cometchat` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `cometchat` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

cometchat_announcements


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO cometchat_announcements (`announcement`,`time`,`to`,`recd`) VALUES ('$announcement','$time','$to','$recd')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `cometchat_announcements` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id = mysql_result($res,$i,"id");
$announcement = mysql_result($res,$i,"announcement");
$time = mysql_result($res,$i,"time");
$to = mysql_result($res,$i,"to");
$recd = mysql_result($res,$i,"recd");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `cometchat_announcements` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id=$tablo[$i]['id'];
$announcement=$tablo[$i]['announcement'];
$time=$tablo[$i]['time'];
$to=$tablo[$i]['to'];
$recd=$tablo[$i]['recd'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `cometchat_announcements` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id = mysql_result($res,0,"id");
$announcement = mysql_result($res,0,"announcement");
$time = mysql_result($res,0,"time");
$to = mysql_result($res,0,"to");
$recd = mysql_result($res,0,"recd");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `cometchat_announcements` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `cometchat_announcements` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

cometchat_apehistory


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO cometchat_apehistory (`channel`,`message`,`sent`) VALUES ('$channel','$message','$sent')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `cometchat_apehistory` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id = mysql_result($res,$i,"id");
$channel = mysql_result($res,$i,"channel");
$message = mysql_result($res,$i,"message");
$sent = mysql_result($res,$i,"sent");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `cometchat_apehistory` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id=$tablo[$i]['id'];
$channel=$tablo[$i]['channel'];
$message=$tablo[$i]['message'];
$sent=$tablo[$i]['sent'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `cometchat_apehistory` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id = mysql_result($res,0,"id");
$channel = mysql_result($res,0,"channel");
$message = mysql_result($res,0,"message");
$sent = mysql_result($res,0,"sent");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `cometchat_apehistory` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `cometchat_apehistory` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

cometchat_block


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO cometchat_block (`fromid`,`toid`) VALUES ('$fromid','$toid')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `cometchat_block` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id = mysql_result($res,$i,"id");
$fromid = mysql_result($res,$i,"fromid");
$toid = mysql_result($res,$i,"toid");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `cometchat_block` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id=$tablo[$i]['id'];
$fromid=$tablo[$i]['fromid'];
$toid=$tablo[$i]['toid'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `cometchat_block` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id = mysql_result($res,0,"id");
$fromid = mysql_result($res,0,"fromid");
$toid = mysql_result($res,0,"toid");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `cometchat_block` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `cometchat_block` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

cometchat_chatroommessages


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO cometchat_chatroommessages (`userid`,`chatroomid`,`message`,`sent`) VALUES ('$userid','$chatroomid','$message','$sent')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `cometchat_chatroommessages` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id = mysql_result($res,$i,"id");
$userid = mysql_result($res,$i,"userid");
$chatroomid = mysql_result($res,$i,"chatroomid");
$message = mysql_result($res,$i,"message");
$sent = mysql_result($res,$i,"sent");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `cometchat_chatroommessages` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id=$tablo[$i]['id'];
$userid=$tablo[$i]['userid'];
$chatroomid=$tablo[$i]['chatroomid'];
$message=$tablo[$i]['message'];
$sent=$tablo[$i]['sent'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `cometchat_chatroommessages` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id = mysql_result($res,0,"id");
$userid = mysql_result($res,0,"userid");
$chatroomid = mysql_result($res,0,"chatroomid");
$message = mysql_result($res,0,"message");
$sent = mysql_result($res,0,"sent");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `cometchat_chatroommessages` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `cometchat_chatroommessages` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

cometchat_chatrooms


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO cometchat_chatrooms (`name`,`lastactivity`,`createdby`,`password`,`type`,`vidsession`) VALUES ('$name','$lastactivity','$createdby','$password','$type','$vidsession')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `cometchat_chatrooms` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id = mysql_result($res,$i,"id");
$name = mysql_result($res,$i,"name");
$lastactivity = mysql_result($res,$i,"lastactivity");
$createdby = mysql_result($res,$i,"createdby");
$password = mysql_result($res,$i,"password");
$type = mysql_result($res,$i,"type");
$vidsession = mysql_result($res,$i,"vidsession");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `cometchat_chatrooms` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id=$tablo[$i]['id'];
$name=$tablo[$i]['name'];
$lastactivity=$tablo[$i]['lastactivity'];
$createdby=$tablo[$i]['createdby'];
$password=$tablo[$i]['password'];
$type=$tablo[$i]['type'];
$vidsession=$tablo[$i]['vidsession'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `cometchat_chatrooms` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id = mysql_result($res,0,"id");
$name = mysql_result($res,0,"name");
$lastactivity = mysql_result($res,0,"lastactivity");
$createdby = mysql_result($res,0,"createdby");
$password = mysql_result($res,0,"password");
$type = mysql_result($res,0,"type");
$vidsession = mysql_result($res,0,"vidsession");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `cometchat_chatrooms` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `cometchat_chatrooms` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

cometchat_chatrooms_users


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO cometchat_chatrooms_users (`chatroomid`,`lastactivity`) VALUES ('$chatroomid','$lastactivity')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `cometchat_chatrooms_users` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$userid = mysql_result($res,$i,"userid");
$chatroomid = mysql_result($res,$i,"chatroomid");
$lastactivity = mysql_result($res,$i,"lastactivity");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `cometchat_chatrooms_users` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$userid=$tablo[$i]['userid'];
$chatroomid=$tablo[$i]['chatroomid'];
$lastactivity=$tablo[$i]['lastactivity'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `cometchat_chatrooms_users` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$userid = mysql_result($res,0,"userid");
$chatroomid = mysql_result($res,0,"chatroomid");
$lastactivity = mysql_result($res,0,"lastactivity");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `cometchat_chatrooms_users` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `cometchat_chatrooms_users` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

cometchat_guests


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO cometchat_guests (`name`,`lastactivity`) VALUES ('$name','$lastactivity')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `cometchat_guests` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id = mysql_result($res,$i,"id");
$name = mysql_result($res,$i,"name");
$lastactivity = mysql_result($res,$i,"lastactivity");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `cometchat_guests` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id=$tablo[$i]['id'];
$name=$tablo[$i]['name'];
$lastactivity=$tablo[$i]['lastactivity'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `cometchat_guests` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id = mysql_result($res,0,"id");
$name = mysql_result($res,0,"name");
$lastactivity = mysql_result($res,0,"lastactivity");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `cometchat_guests` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `cometchat_guests` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

cometchat_messages_old


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO cometchat_messages_old (`from`,`to`,`message`,`sent`,`read`,`direction`) VALUES ('$from','$to','$message','$sent','$read','$direction')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `cometchat_messages_old` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id = mysql_result($res,$i,"id");
$from = mysql_result($res,$i,"from");
$to = mysql_result($res,$i,"to");
$message = mysql_result($res,$i,"message");
$sent = mysql_result($res,$i,"sent");
$read = mysql_result($res,$i,"read");
$direction = mysql_result($res,$i,"direction");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `cometchat_messages_old` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id=$tablo[$i]['id'];
$from=$tablo[$i]['from'];
$to=$tablo[$i]['to'];
$message=$tablo[$i]['message'];
$sent=$tablo[$i]['sent'];
$read=$tablo[$i]['read'];
$direction=$tablo[$i]['direction'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `cometchat_messages_old` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id = mysql_result($res,0,"id");
$from = mysql_result($res,0,"from");
$to = mysql_result($res,0,"to");
$message = mysql_result($res,0,"message");
$sent = mysql_result($res,0,"sent");
$read = mysql_result($res,0,"read");
$direction = mysql_result($res,0,"direction");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `cometchat_messages_old` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `cometchat_messages_old` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

cometchat_status


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO cometchat_status (`message`,`status`,`typingto`,`typingtime`) VALUES ('$message','$status','$typingto','$typingtime')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `cometchat_status` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$userid = mysql_result($res,$i,"userid");
$message = mysql_result($res,$i,"message");
$status = mysql_result($res,$i,"status");
$typingto = mysql_result($res,$i,"typingto");
$typingtime = mysql_result($res,$i,"typingtime");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `cometchat_status` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$userid=$tablo[$i]['userid'];
$message=$tablo[$i]['message'];
$status=$tablo[$i]['status'];
$typingto=$tablo[$i]['typingto'];
$typingtime=$tablo[$i]['typingtime'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `cometchat_status` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$userid = mysql_result($res,0,"userid");
$message = mysql_result($res,0,"message");
$status = mysql_result($res,0,"status");
$typingto = mysql_result($res,0,"typingto");
$typingtime = mysql_result($res,0,"typingtime");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `cometchat_status` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `cometchat_status` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

cometchat_videochatsessions


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO cometchat_videochatsessions (`identity`,`timestamp`) VALUES ('$identity','$timestamp')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `cometchat_videochatsessions` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$username = mysql_result($res,$i,"username");
$identity = mysql_result($res,$i,"identity");
$timestamp = mysql_result($res,$i,"timestamp");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `cometchat_videochatsessions` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$username=$tablo[$i]['username'];
$identity=$tablo[$i]['identity'];
$timestamp=$tablo[$i]['timestamp'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `cometchat_videochatsessions` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$username = mysql_result($res,0,"username");
$identity = mysql_result($res,0,"identity");
$timestamp = mysql_result($res,0,"timestamp");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `cometchat_videochatsessions` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `cometchat_videochatsessions` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

commentaire


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO commentaire (`nom`,`auteur`,`email`,`msg`,`date`,`pays`,`siteweb`,`type`,`ip`,`id_user`) VALUES ('$nom','$auteur','$email','$msg','$date','$pays','$siteweb','$type','$ip','$id_user')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `commentaire` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id = mysql_result($res,$i,"id");
$nom = mysql_result($res,$i,"nom");
$auteur = mysql_result($res,$i,"auteur");
$email = mysql_result($res,$i,"email");
$msg = mysql_result($res,$i,"msg");
$date = mysql_result($res,$i,"date");
$pays = mysql_result($res,$i,"pays");
$siteweb = mysql_result($res,$i,"siteweb");
$type = mysql_result($res,$i,"type");
$ip = mysql_result($res,$i,"ip");
$id_user = mysql_result($res,$i,"id_user");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `commentaire` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id=$tablo[$i]['id'];
$nom=$tablo[$i]['nom'];
$auteur=$tablo[$i]['auteur'];
$email=$tablo[$i]['email'];
$msg=$tablo[$i]['msg'];
$date=$tablo[$i]['date'];
$pays=$tablo[$i]['pays'];
$siteweb=$tablo[$i]['siteweb'];
$type=$tablo[$i]['type'];
$ip=$tablo[$i]['ip'];
$id_user=$tablo[$i]['id_user'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `commentaire` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id = mysql_result($res,0,"id");
$nom = mysql_result($res,0,"nom");
$auteur = mysql_result($res,0,"auteur");
$email = mysql_result($res,0,"email");
$msg = mysql_result($res,0,"msg");
$date = mysql_result($res,0,"date");
$pays = mysql_result($res,0,"pays");
$siteweb = mysql_result($res,0,"siteweb");
$type = mysql_result($res,0,"type");
$ip = mysql_result($res,0,"ip");
$id_user = mysql_result($res,0,"id_user");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `commentaire` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `commentaire` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

commentaires


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO commentaires (`nom`,`auteur`,`email`,`texte`,`date`,`ip`) VALUES ('$nom','$auteur','$email','$texte','$date','$ip')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `commentaires` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id = mysql_result($res,$i,"id");
$nom = mysql_result($res,$i,"nom");
$auteur = mysql_result($res,$i,"auteur");
$email = mysql_result($res,$i,"email");
$texte = mysql_result($res,$i,"texte");
$date = mysql_result($res,$i,"date");
$ip = mysql_result($res,$i,"ip");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `commentaires` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id=$tablo[$i]['id'];
$nom=$tablo[$i]['nom'];
$auteur=$tablo[$i]['auteur'];
$email=$tablo[$i]['email'];
$texte=$tablo[$i]['texte'];
$date=$tablo[$i]['date'];
$ip=$tablo[$i]['ip'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `commentaires` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id = mysql_result($res,0,"id");
$nom = mysql_result($res,0,"nom");
$auteur = mysql_result($res,0,"auteur");
$email = mysql_result($res,0,"email");
$texte = mysql_result($res,0,"texte");
$date = mysql_result($res,0,"date");
$ip = mysql_result($res,0,"ip");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `commentaires` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `commentaires` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

dinas_email


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO dinas_email (`dinas_email`,`ip`) VALUES ('$dinas_email','$ip')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `dinas_email` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id = mysql_result($res,$i,"id");
$dinas_email = mysql_result($res,$i,"dinas_email");
$ip = mysql_result($res,$i,"ip");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `dinas_email` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id=$tablo[$i]['id'];
$dinas_email=$tablo[$i]['dinas_email'];
$ip=$tablo[$i]['ip'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `dinas_email` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id = mysql_result($res,0,"id");
$dinas_email = mysql_result($res,0,"dinas_email");
$ip = mysql_result($res,0,"ip");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `dinas_email` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `dinas_email` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

dinas_liens


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO dinas_liens (`photo`,`titre`,`url`,`description`,`type`,`ok`,`ip`) VALUES ('$photo','$titre','$url','$description','$type','$ok','$ip')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `dinas_liens` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id = mysql_result($res,$i,"id");
$photo = mysql_result($res,$i,"photo");
$titre = mysql_result($res,$i,"titre");
$url = mysql_result($res,$i,"url");
$description = mysql_result($res,$i,"description");
$type = mysql_result($res,$i,"type");
$ok = mysql_result($res,$i,"ok");
$ip = mysql_result($res,$i,"ip");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `dinas_liens` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id=$tablo[$i]['id'];
$photo=$tablo[$i]['photo'];
$titre=$tablo[$i]['titre'];
$url=$tablo[$i]['url'];
$description=$tablo[$i]['description'];
$type=$tablo[$i]['type'];
$ok=$tablo[$i]['ok'];
$ip=$tablo[$i]['ip'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `dinas_liens` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id = mysql_result($res,0,"id");
$photo = mysql_result($res,0,"photo");
$titre = mysql_result($res,0,"titre");
$url = mysql_result($res,0,"url");
$description = mysql_result($res,0,"description");
$type = mysql_result($res,0,"type");
$ok = mysql_result($res,0,"ok");
$ip = mysql_result($res,0,"ip");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `dinas_liens` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `dinas_liens` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

dinas_livredor


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO dinas_livredor (`auteur`,`date`,`mail`,`site`,`ville`,`note`,`message`,`ip`) VALUES ('$auteur','$date','$mail','$site','$ville','$note','$message','$ip')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `dinas_livredor` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id = mysql_result($res,$i,"id");
$auteur = mysql_result($res,$i,"auteur");
$date = mysql_result($res,$i,"date");
$mail = mysql_result($res,$i,"mail");
$site = mysql_result($res,$i,"site");
$ville = mysql_result($res,$i,"ville");
$note = mysql_result($res,$i,"note");
$message = mysql_result($res,$i,"message");
$ip = mysql_result($res,$i,"ip");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `dinas_livredor` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id=$tablo[$i]['id'];
$auteur=$tablo[$i]['auteur'];
$date=$tablo[$i]['date'];
$mail=$tablo[$i]['mail'];
$site=$tablo[$i]['site'];
$ville=$tablo[$i]['ville'];
$note=$tablo[$i]['note'];
$message=$tablo[$i]['message'];
$ip=$tablo[$i]['ip'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `dinas_livredor` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id = mysql_result($res,0,"id");
$auteur = mysql_result($res,0,"auteur");
$date = mysql_result($res,0,"date");
$mail = mysql_result($res,0,"mail");
$site = mysql_result($res,0,"site");
$ville = mysql_result($res,0,"ville");
$note = mysql_result($res,0,"note");
$message = mysql_result($res,0,"message");
$ip = mysql_result($res,0,"ip");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `dinas_livredor` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `dinas_livredor` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

dinas_portfolios


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO dinas_portfolios (`photo`,`titre`,`description`,`type`,`ok`,`ip`) VALUES ('$photo','$titre','$description','$type','$ok','$ip')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `dinas_portfolios` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id = mysql_result($res,$i,"id");
$photo = mysql_result($res,$i,"photo");
$titre = mysql_result($res,$i,"titre");
$description = mysql_result($res,$i,"description");
$type = mysql_result($res,$i,"type");
$ok = mysql_result($res,$i,"ok");
$ip = mysql_result($res,$i,"ip");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `dinas_portfolios` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id=$tablo[$i]['id'];
$photo=$tablo[$i]['photo'];
$titre=$tablo[$i]['titre'];
$description=$tablo[$i]['description'];
$type=$tablo[$i]['type'];
$ok=$tablo[$i]['ok'];
$ip=$tablo[$i]['ip'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `dinas_portfolios` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id = mysql_result($res,0,"id");
$photo = mysql_result($res,0,"photo");
$titre = mysql_result($res,0,"titre");
$description = mysql_result($res,0,"description");
$type = mysql_result($res,0,"type");
$ok = mysql_result($res,0,"ok");
$ip = mysql_result($res,0,"ip");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `dinas_portfolios` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `dinas_portfolios` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

divx


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO divx (`nom`,`date`,`pays`,`year`,`nationalite`,`producteur`,`genre`,`duree`,`avec`,`synopsis`,`image`,`fiche`,`note_user`,`note_presse`,`ok`,`filename`,`code`) VALUES ('$nom','$date','$pays','$year','$nationalite','$producteur','$genre','$duree','$avec','$synopsis','$image','$fiche','$note_user','$note_presse','$ok','$filename','$code')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `divx` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id = mysql_result($res,$i,"id");
$nom = mysql_result($res,$i,"nom");
$date = mysql_result($res,$i,"date");
$pays = mysql_result($res,$i,"pays");
$year = mysql_result($res,$i,"year");
$nationalite = mysql_result($res,$i,"nationalite");
$producteur = mysql_result($res,$i,"producteur");
$genre = mysql_result($res,$i,"genre");
$duree = mysql_result($res,$i,"duree");
$avec = mysql_result($res,$i,"avec");
$synopsis = mysql_result($res,$i,"synopsis");
$image = mysql_result($res,$i,"image");
$fiche = mysql_result($res,$i,"fiche");
$note_user = mysql_result($res,$i,"note_user");
$note_presse = mysql_result($res,$i,"note_presse");
$ok = mysql_result($res,$i,"ok");
$filename = mysql_result($res,$i,"filename");
$code = mysql_result($res,$i,"code");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `divx` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id=$tablo[$i]['id'];
$nom=$tablo[$i]['nom'];
$date=$tablo[$i]['date'];
$pays=$tablo[$i]['pays'];
$year=$tablo[$i]['year'];
$nationalite=$tablo[$i]['nationalite'];
$producteur=$tablo[$i]['producteur'];
$genre=$tablo[$i]['genre'];
$duree=$tablo[$i]['duree'];
$avec=$tablo[$i]['avec'];
$synopsis=$tablo[$i]['synopsis'];
$image=$tablo[$i]['image'];
$fiche=$tablo[$i]['fiche'];
$note_user=$tablo[$i]['note_user'];
$note_presse=$tablo[$i]['note_presse'];
$ok=$tablo[$i]['ok'];
$filename=$tablo[$i]['filename'];
$code=$tablo[$i]['code'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `divx` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id = mysql_result($res,0,"id");
$nom = mysql_result($res,0,"nom");
$date = mysql_result($res,0,"date");
$pays = mysql_result($res,0,"pays");
$year = mysql_result($res,0,"year");
$nationalite = mysql_result($res,0,"nationalite");
$producteur = mysql_result($res,0,"producteur");
$genre = mysql_result($res,0,"genre");
$duree = mysql_result($res,0,"duree");
$avec = mysql_result($res,0,"avec");
$synopsis = mysql_result($res,0,"synopsis");
$image = mysql_result($res,0,"image");
$fiche = mysql_result($res,0,"fiche");
$note_user = mysql_result($res,0,"note_user");
$note_presse = mysql_result($res,0,"note_presse");
$ok = mysql_result($res,0,"ok");
$filename = mysql_result($res,0,"filename");
$code = mysql_result($res,0,"code");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `divx` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `divx` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

fichier_boulot


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO fichier_boulot (`date_crea`,`date_mod`,`nom_fic`,`proprio`) VALUES ('$date_crea','$date_mod','$nom_fic','$proprio')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `fichier_boulot` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id = mysql_result($res,$i,"id");
$date_crea = mysql_result($res,$i,"date_crea");
$date_mod = mysql_result($res,$i,"date_mod");
$nom_fic = mysql_result($res,$i,"nom_fic");
$proprio = mysql_result($res,$i,"proprio");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `fichier_boulot` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id=$tablo[$i]['id'];
$date_crea=$tablo[$i]['date_crea'];
$date_mod=$tablo[$i]['date_mod'];
$nom_fic=$tablo[$i]['nom_fic'];
$proprio=$tablo[$i]['proprio'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `fichier_boulot` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id = mysql_result($res,0,"id");
$date_crea = mysql_result($res,0,"date_crea");
$date_mod = mysql_result($res,0,"date_mod");
$nom_fic = mysql_result($res,0,"nom_fic");
$proprio = mysql_result($res,0,"proprio");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `fichier_boulot` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `fichier_boulot` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

forum


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO forum (`nb_reponse`,`id_pere`,`id_principale`,`id_arbo`,`pseudo`,`email`,`sujet`,`message`,`date`,`ip`,`id_forum`,`place`,`vue`,`id_user`) VALUES ('$nb_reponse','$id_pere','$id_principale','$id_arbo','$pseudo','$email','$sujet','$message','$date','$ip','$id_forum','$place','$vue','$id_user')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `forum` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id = mysql_result($res,$i,"id");
$nb_reponse = mysql_result($res,$i,"nb_reponse");
$id_pere = mysql_result($res,$i,"id_pere");
$id_principale = mysql_result($res,$i,"id_principale");
$id_arbo = mysql_result($res,$i,"id_arbo");
$pseudo = mysql_result($res,$i,"pseudo");
$email = mysql_result($res,$i,"email");
$sujet = mysql_result($res,$i,"sujet");
$message = mysql_result($res,$i,"message");
$date = mysql_result($res,$i,"date");
$ip = mysql_result($res,$i,"ip");
$id_forum = mysql_result($res,$i,"id_forum");
$place = mysql_result($res,$i,"place");
$vue = mysql_result($res,$i,"vue");
$id_user = mysql_result($res,$i,"id_user");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `forum` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id=$tablo[$i]['id'];
$nb_reponse=$tablo[$i]['nb_reponse'];
$id_pere=$tablo[$i]['id_pere'];
$id_principale=$tablo[$i]['id_principale'];
$id_arbo=$tablo[$i]['id_arbo'];
$pseudo=$tablo[$i]['pseudo'];
$email=$tablo[$i]['email'];
$sujet=$tablo[$i]['sujet'];
$message=$tablo[$i]['message'];
$date=$tablo[$i]['date'];
$ip=$tablo[$i]['ip'];
$id_forum=$tablo[$i]['id_forum'];
$place=$tablo[$i]['place'];
$vue=$tablo[$i]['vue'];
$id_user=$tablo[$i]['id_user'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `forum` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id = mysql_result($res,0,"id");
$nb_reponse = mysql_result($res,0,"nb_reponse");
$id_pere = mysql_result($res,0,"id_pere");
$id_principale = mysql_result($res,0,"id_principale");
$id_arbo = mysql_result($res,0,"id_arbo");
$pseudo = mysql_result($res,0,"pseudo");
$email = mysql_result($res,0,"email");
$sujet = mysql_result($res,0,"sujet");
$message = mysql_result($res,0,"message");
$date = mysql_result($res,0,"date");
$ip = mysql_result($res,0,"ip");
$id_forum = mysql_result($res,0,"id_forum");
$place = mysql_result($res,0,"place");
$vue = mysql_result($res,0,"vue");
$id_user = mysql_result($res,0,"id_user");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `forum` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `forum` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

forum_cat


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO forum_cat (`titre`,`description`) VALUES ('$titre','$description')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `forum_cat` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id = mysql_result($res,$i,"id");
$titre = mysql_result($res,$i,"titre");
$description = mysql_result($res,$i,"description");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `forum_cat` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id=$tablo[$i]['id'];
$titre=$tablo[$i]['titre'];
$description=$tablo[$i]['description'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `forum_cat` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id = mysql_result($res,0,"id");
$titre = mysql_result($res,0,"titre");
$description = mysql_result($res,0,"description");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `forum_cat` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `forum_cat` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

holydays


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO holydays (`lemois`,`fetedujour`) VALUES ('$lemois','$fetedujour')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `holydays` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$lejour = mysql_result($res,$i,"lejour");
$lemois = mysql_result($res,$i,"lemois");
$fetedujour = mysql_result($res,$i,"fetedujour");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `holydays` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$lejour=$tablo[$i]['lejour'];
$lemois=$tablo[$i]['lemois'];
$fetedujour=$tablo[$i]['fetedujour'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `holydays` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$lejour = mysql_result($res,0,"lejour");
$lemois = mysql_result($res,0,"lemois");
$fetedujour = mysql_result($res,0,"fetedujour");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `holydays` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `holydays` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

jeux


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO jeux (`nom`,`posteur`,`url`,`date`,`clic`,`vote_nb`,`vote_total`,`ip`,`var`,`source`,`email`,`description`,`type`,`valider`) VALUES ('$nom','$posteur','$url','$date','$clic','$vote_nb','$vote_total','$ip','$var','$source','$email','$description','$type','$valider')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `jeux` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id = mysql_result($res,$i,"id");
$nom = mysql_result($res,$i,"nom");
$posteur = mysql_result($res,$i,"posteur");
$url = mysql_result($res,$i,"url");
$date = mysql_result($res,$i,"date");
$clic = mysql_result($res,$i,"clic");
$vote_nb = mysql_result($res,$i,"vote_nb");
$vote_total = mysql_result($res,$i,"vote_total");
$ip = mysql_result($res,$i,"ip");
$var = mysql_result($res,$i,"var");
$source = mysql_result($res,$i,"source");
$email = mysql_result($res,$i,"email");
$description = mysql_result($res,$i,"description");
$type = mysql_result($res,$i,"type");
$valider = mysql_result($res,$i,"valider");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `jeux` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id=$tablo[$i]['id'];
$nom=$tablo[$i]['nom'];
$posteur=$tablo[$i]['posteur'];
$url=$tablo[$i]['url'];
$date=$tablo[$i]['date'];
$clic=$tablo[$i]['clic'];
$vote_nb=$tablo[$i]['vote_nb'];
$vote_total=$tablo[$i]['vote_total'];
$ip=$tablo[$i]['ip'];
$var=$tablo[$i]['var'];
$source=$tablo[$i]['source'];
$email=$tablo[$i]['email'];
$description=$tablo[$i]['description'];
$type=$tablo[$i]['type'];
$valider=$tablo[$i]['valider'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `jeux` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id = mysql_result($res,0,"id");
$nom = mysql_result($res,0,"nom");
$posteur = mysql_result($res,0,"posteur");
$url = mysql_result($res,0,"url");
$date = mysql_result($res,0,"date");
$clic = mysql_result($res,0,"clic");
$vote_nb = mysql_result($res,0,"vote_nb");
$vote_total = mysql_result($res,0,"vote_total");
$ip = mysql_result($res,0,"ip");
$var = mysql_result($res,0,"var");
$source = mysql_result($res,0,"source");
$email = mysql_result($res,0,"email");
$description = mysql_result($res,0,"description");
$type = mysql_result($res,0,"type");
$valider = mysql_result($res,0,"valider");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `jeux` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `jeux` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

livre


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO livre (`auteur`,`date`,`mail`,`site`,`ville`,`note`,`message`,`ipauteur`) VALUES ('$auteur','$date','$mail','$site','$ville','$note','$message','$ipauteur')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `livre` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id = mysql_result($res,$i,"id");
$auteur = mysql_result($res,$i,"auteur");
$date = mysql_result($res,$i,"date");
$mail = mysql_result($res,$i,"mail");
$site = mysql_result($res,$i,"site");
$ville = mysql_result($res,$i,"ville");
$note = mysql_result($res,$i,"note");
$message = mysql_result($res,$i,"message");
$ipauteur = mysql_result($res,$i,"ipauteur");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `livre` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id=$tablo[$i]['id'];
$auteur=$tablo[$i]['auteur'];
$date=$tablo[$i]['date'];
$mail=$tablo[$i]['mail'];
$site=$tablo[$i]['site'];
$ville=$tablo[$i]['ville'];
$note=$tablo[$i]['note'];
$message=$tablo[$i]['message'];
$ipauteur=$tablo[$i]['ipauteur'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `livre` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id = mysql_result($res,0,"id");
$auteur = mysql_result($res,0,"auteur");
$date = mysql_result($res,0,"date");
$mail = mysql_result($res,0,"mail");
$site = mysql_result($res,0,"site");
$ville = mysql_result($res,0,"ville");
$note = mysql_result($res,0,"note");
$message = mysql_result($res,0,"message");
$ipauteur = mysql_result($res,0,"ipauteur");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `livre` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `livre` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

livredor


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO livredor (`auteur`,`date`,`mail`,`site`,`ville`,`note`,`message`,`ipauteur`) VALUES ('$auteur','$date','$mail','$site','$ville','$note','$message','$ipauteur')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `livredor` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id = mysql_result($res,$i,"id");
$auteur = mysql_result($res,$i,"auteur");
$date = mysql_result($res,$i,"date");
$mail = mysql_result($res,$i,"mail");
$site = mysql_result($res,$i,"site");
$ville = mysql_result($res,$i,"ville");
$note = mysql_result($res,$i,"note");
$message = mysql_result($res,$i,"message");
$ipauteur = mysql_result($res,$i,"ipauteur");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `livredor` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id=$tablo[$i]['id'];
$auteur=$tablo[$i]['auteur'];
$date=$tablo[$i]['date'];
$mail=$tablo[$i]['mail'];
$site=$tablo[$i]['site'];
$ville=$tablo[$i]['ville'];
$note=$tablo[$i]['note'];
$message=$tablo[$i]['message'];
$ipauteur=$tablo[$i]['ipauteur'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `livredor` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id = mysql_result($res,0,"id");
$auteur = mysql_result($res,0,"auteur");
$date = mysql_result($res,0,"date");
$mail = mysql_result($res,0,"mail");
$site = mysql_result($res,0,"site");
$ville = mysql_result($res,0,"ville");
$note = mysql_result($res,0,"note");
$message = mysql_result($res,0,"message");
$ipauteur = mysql_result($res,0,"ipauteur");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `livredor` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `livredor` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

mail


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO mail (`nom`,`email`,`sujet`,`msg`,`status`,`date`,`ip`,`id_user`) VALUES ('$nom','$email','$sujet','$msg','$status','$date','$ip','$id_user')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `mail` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id = mysql_result($res,$i,"id");
$nom = mysql_result($res,$i,"nom");
$email = mysql_result($res,$i,"email");
$sujet = mysql_result($res,$i,"sujet");
$msg = mysql_result($res,$i,"msg");
$status = mysql_result($res,$i,"status");
$date = mysql_result($res,$i,"date");
$ip = mysql_result($res,$i,"ip");
$id_user = mysql_result($res,$i,"id_user");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `mail` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id=$tablo[$i]['id'];
$nom=$tablo[$i]['nom'];
$email=$tablo[$i]['email'];
$sujet=$tablo[$i]['sujet'];
$msg=$tablo[$i]['msg'];
$status=$tablo[$i]['status'];
$date=$tablo[$i]['date'];
$ip=$tablo[$i]['ip'];
$id_user=$tablo[$i]['id_user'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `mail` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id = mysql_result($res,0,"id");
$nom = mysql_result($res,0,"nom");
$email = mysql_result($res,0,"email");
$sujet = mysql_result($res,0,"sujet");
$msg = mysql_result($res,0,"msg");
$status = mysql_result($res,0,"status");
$date = mysql_result($res,0,"date");
$ip = mysql_result($res,0,"ip");
$id_user = mysql_result($res,0,"id_user");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `mail` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `mail` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

membre


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO membre (`prenom`,`login`,`pwd`,`niveau`,`pays`,`ville`,`date_naissance`,`site_web`,`date_inscription`,`date_connexion`,`id_user`,`envoi_mail`) VALUES ('$prenom','$login','$pwd','$niveau','$pays','$ville','$date_naissance','$site_web','$date_inscription','$date_connexion','$id_user','$envoi_mail')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `membre` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$nom = mysql_result($res,$i,"nom");
$prenom = mysql_result($res,$i,"prenom");
$login = mysql_result($res,$i,"login");
$pwd = mysql_result($res,$i,"pwd");
$niveau = mysql_result($res,$i,"niveau");
$pays = mysql_result($res,$i,"pays");
$ville = mysql_result($res,$i,"ville");
$date_naissance = mysql_result($res,$i,"date_naissance");
$site_web = mysql_result($res,$i,"site_web");
$date_inscription = mysql_result($res,$i,"date_inscription");
$date_connexion = mysql_result($res,$i,"date_connexion");
$id_user = mysql_result($res,$i,"id_user");
$envoi_mail = mysql_result($res,$i,"envoi_mail");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `membre` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$nom=$tablo[$i]['nom'];
$prenom=$tablo[$i]['prenom'];
$login=$tablo[$i]['login'];
$pwd=$tablo[$i]['pwd'];
$niveau=$tablo[$i]['niveau'];
$pays=$tablo[$i]['pays'];
$ville=$tablo[$i]['ville'];
$date_naissance=$tablo[$i]['date_naissance'];
$site_web=$tablo[$i]['site_web'];
$date_inscription=$tablo[$i]['date_inscription'];
$date_connexion=$tablo[$i]['date_connexion'];
$id_user=$tablo[$i]['id_user'];
$envoi_mail=$tablo[$i]['envoi_mail'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `membre` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$nom = mysql_result($res,0,"nom");
$prenom = mysql_result($res,0,"prenom");
$login = mysql_result($res,0,"login");
$pwd = mysql_result($res,0,"pwd");
$niveau = mysql_result($res,0,"niveau");
$pays = mysql_result($res,0,"pays");
$ville = mysql_result($res,0,"ville");
$date_naissance = mysql_result($res,0,"date_naissance");
$site_web = mysql_result($res,0,"site_web");
$date_inscription = mysql_result($res,0,"date_inscription");
$date_connexion = mysql_result($res,0,"date_connexion");
$id_user = mysql_result($res,0,"id_user");
$envoi_mail = mysql_result($res,0,"envoi_mail");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `membre` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `membre` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

meteo


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO meteo (`ville`,`pays`,`url`,`five-day`,`icon`,`today`) VALUES ('$ville','$pays','$url','$five-day','$icon','$today')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `meteo` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id = mysql_result($res,$i,"id");
$ville = mysql_result($res,$i,"ville");
$pays = mysql_result($res,$i,"pays");
$url = mysql_result($res,$i,"url");
$five-day = mysql_result($res,$i,"five-day");
$icon = mysql_result($res,$i,"icon");
$today = mysql_result($res,$i,"today");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `meteo` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id=$tablo[$i]['id'];
$ville=$tablo[$i]['ville'];
$pays=$tablo[$i]['pays'];
$url=$tablo[$i]['url'];
$five-day=$tablo[$i]['five-day'];
$icon=$tablo[$i]['icon'];
$today=$tablo[$i]['today'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `meteo` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id = mysql_result($res,0,"id");
$ville = mysql_result($res,0,"ville");
$pays = mysql_result($res,0,"pays");
$url = mysql_result($res,0,"url");
$five-day = mysql_result($res,0,"five-day");
$icon = mysql_result($res,0,"icon");
$today = mysql_result($res,0,"today");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `meteo` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `meteo` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

news


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO news (`titre`,`id_user`,`date`,`article`,`image`,`legende`,`valide`,`date_deb`,`date_fin`,`date_maj`,`pe_pa_valider`) VALUES ('$titre','$id_user','$date','$article','$image','$legende','$valide','$date_deb','$date_fin','$date_maj','$pe_pa_valider')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `news` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id = mysql_result($res,$i,"id");
$titre = mysql_result($res,$i,"titre");
$id_user = mysql_result($res,$i,"id_user");
$date = mysql_result($res,$i,"date");
$article = mysql_result($res,$i,"article");
$image = mysql_result($res,$i,"image");
$legende = mysql_result($res,$i,"legende");
$valide = mysql_result($res,$i,"valide");
$date_deb = mysql_result($res,$i,"date_deb");
$date_fin = mysql_result($res,$i,"date_fin");
$date_maj = mysql_result($res,$i,"date_maj");
$pe_pa_valider = mysql_result($res,$i,"pe_pa_valider");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `news` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id=$tablo[$i]['id'];
$titre=$tablo[$i]['titre'];
$id_user=$tablo[$i]['id_user'];
$date=$tablo[$i]['date'];
$article=$tablo[$i]['article'];
$image=$tablo[$i]['image'];
$legende=$tablo[$i]['legende'];
$valide=$tablo[$i]['valide'];
$date_deb=$tablo[$i]['date_deb'];
$date_fin=$tablo[$i]['date_fin'];
$date_maj=$tablo[$i]['date_maj'];
$pe_pa_valider=$tablo[$i]['pe_pa_valider'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `news` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id = mysql_result($res,0,"id");
$titre = mysql_result($res,0,"titre");
$id_user = mysql_result($res,0,"id_user");
$date = mysql_result($res,0,"date");
$article = mysql_result($res,0,"article");
$image = mysql_result($res,0,"image");
$legende = mysql_result($res,0,"legende");
$valide = mysql_result($res,0,"valide");
$date_deb = mysql_result($res,0,"date_deb");
$date_fin = mysql_result($res,0,"date_fin");
$date_maj = mysql_result($res,0,"date_maj");
$pe_pa_valider = mysql_result($res,0,"pe_pa_valider");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `news` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `news` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

news_gasy


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO news_gasy (`news_name`,`news_link`,`date_maj`,`id_link`,`link`,`title`,`detail`) VALUES ('$news_name','$news_link','$date_maj','$id_link','$link','$title','$detail')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `news_gasy` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id = mysql_result($res,$i,"id");
$news_name = mysql_result($res,$i,"news_name");
$news_link = mysql_result($res,$i,"news_link");
$date_maj = mysql_result($res,$i,"date_maj");
$id_link = mysql_result($res,$i,"id_link");
$link = mysql_result($res,$i,"link");
$title = mysql_result($res,$i,"title");
$detail = mysql_result($res,$i,"detail");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `news_gasy` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id=$tablo[$i]['id'];
$news_name=$tablo[$i]['news_name'];
$news_link=$tablo[$i]['news_link'];
$date_maj=$tablo[$i]['date_maj'];
$id_link=$tablo[$i]['id_link'];
$link=$tablo[$i]['link'];
$title=$tablo[$i]['title'];
$detail=$tablo[$i]['detail'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `news_gasy` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id = mysql_result($res,0,"id");
$news_name = mysql_result($res,0,"news_name");
$news_link = mysql_result($res,0,"news_link");
$date_maj = mysql_result($res,0,"date_maj");
$id_link = mysql_result($res,0,"id_link");
$link = mysql_result($res,0,"link");
$title = mysql_result($res,0,"title");
$detail = mysql_result($res,0,"detail");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `news_gasy` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `news_gasy` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

newsletters


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO newsletters (`pseudo`,`prenom`,`email`,`pass`,`rubrique`,`tel`,`adresse`,`ville`,`pays`,`inscrit`) VALUES ('$pseudo','$prenom','$email','$pass','$rubrique','$tel','$adresse','$ville','$pays','$inscrit')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `newsletters` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id = mysql_result($res,$i,"id");
$pseudo = mysql_result($res,$i,"pseudo");
$prenom = mysql_result($res,$i,"prenom");
$email = mysql_result($res,$i,"email");
$pass = mysql_result($res,$i,"pass");
$rubrique = mysql_result($res,$i,"rubrique");
$tel = mysql_result($res,$i,"tel");
$adresse = mysql_result($res,$i,"adresse");
$ville = mysql_result($res,$i,"ville");
$pays = mysql_result($res,$i,"pays");
$inscrit = mysql_result($res,$i,"inscrit");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `newsletters` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id=$tablo[$i]['id'];
$pseudo=$tablo[$i]['pseudo'];
$prenom=$tablo[$i]['prenom'];
$email=$tablo[$i]['email'];
$pass=$tablo[$i]['pass'];
$rubrique=$tablo[$i]['rubrique'];
$tel=$tablo[$i]['tel'];
$adresse=$tablo[$i]['adresse'];
$ville=$tablo[$i]['ville'];
$pays=$tablo[$i]['pays'];
$inscrit=$tablo[$i]['inscrit'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `newsletters` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id = mysql_result($res,0,"id");
$pseudo = mysql_result($res,0,"pseudo");
$prenom = mysql_result($res,0,"prenom");
$email = mysql_result($res,0,"email");
$pass = mysql_result($res,0,"pass");
$rubrique = mysql_result($res,0,"rubrique");
$tel = mysql_result($res,0,"tel");
$adresse = mysql_result($res,0,"adresse");
$ville = mysql_result($res,0,"ville");
$pays = mysql_result($res,0,"pays");
$inscrit = mysql_result($res,0,"inscrit");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `newsletters` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `newsletters` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

playlist


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO playlist (`nom_playlist`,`id_user`) VALUES ('$nom_playlist','$id_user')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `playlist` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id = mysql_result($res,$i,"id");
$nom_playlist = mysql_result($res,$i,"nom_playlist");
$id_user = mysql_result($res,$i,"id_user");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `playlist` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id=$tablo[$i]['id'];
$nom_playlist=$tablo[$i]['nom_playlist'];
$id_user=$tablo[$i]['id_user'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `playlist` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id = mysql_result($res,0,"id");
$nom_playlist = mysql_result($res,0,"nom_playlist");
$id_user = mysql_result($res,0,"id_user");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `playlist` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `playlist` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

playlist_liste


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO playlist_liste (`id_playlist`,`id_clip`,`id_user`) VALUES ('$id_playlist','$id_clip','$id_user')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `playlist_liste` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id = mysql_result($res,$i,"id");
$id_playlist = mysql_result($res,$i,"id_playlist");
$id_clip = mysql_result($res,$i,"id_clip");
$id_user = mysql_result($res,$i,"id_user");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `playlist_liste` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id=$tablo[$i]['id'];
$id_playlist=$tablo[$i]['id_playlist'];
$id_clip=$tablo[$i]['id_clip'];
$id_user=$tablo[$i]['id_user'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `playlist_liste` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id = mysql_result($res,0,"id");
$id_playlist = mysql_result($res,0,"id_playlist");
$id_clip = mysql_result($res,0,"id_clip");
$id_user = mysql_result($res,0,"id_user");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `playlist_liste` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `playlist_liste` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

radio


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO radio (`nom`,`embed_flash`,`site`,`format`,`description`,`logo`,`wnp`,`itunes`,`real`,`wmp`,`flash`) VALUES ('$nom','$embed_flash','$site','$format','$description','$logo','$wnp','$itunes','$real','$wmp','$flash')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `radio` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id = mysql_result($res,$i,"id");
$nom = mysql_result($res,$i,"nom");
$embed_flash = mysql_result($res,$i,"embed_flash");
$site = mysql_result($res,$i,"site");
$format = mysql_result($res,$i,"format");
$description = mysql_result($res,$i,"description");
$logo = mysql_result($res,$i,"logo");
$wnp = mysql_result($res,$i,"wnp");
$itunes = mysql_result($res,$i,"itunes");
$real = mysql_result($res,$i,"real");
$wmp = mysql_result($res,$i,"wmp");
$flash = mysql_result($res,$i,"flash");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `radio` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id=$tablo[$i]['id'];
$nom=$tablo[$i]['nom'];
$embed_flash=$tablo[$i]['embed_flash'];
$site=$tablo[$i]['site'];
$format=$tablo[$i]['format'];
$description=$tablo[$i]['description'];
$logo=$tablo[$i]['logo'];
$wnp=$tablo[$i]['wnp'];
$itunes=$tablo[$i]['itunes'];
$real=$tablo[$i]['real'];
$wmp=$tablo[$i]['wmp'];
$flash=$tablo[$i]['flash'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `radio` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id = mysql_result($res,0,"id");
$nom = mysql_result($res,0,"nom");
$embed_flash = mysql_result($res,0,"embed_flash");
$site = mysql_result($res,0,"site");
$format = mysql_result($res,0,"format");
$description = mysql_result($res,0,"description");
$logo = mysql_result($res,0,"logo");
$wnp = mysql_result($res,0,"wnp");
$itunes = mysql_result($res,0,"itunes");
$real = mysql_result($res,0,"real");
$wmp = mysql_result($res,0,"wmp");
$flash = mysql_result($res,0,"flash");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `radio` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `radio` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

recette


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO recette (`titre`,`ingredients`,`preparation`,`poster`,`email`,`siteweb`,`nbpersonne`,`tppreparation`,`tpcuisson`,`difficulte`,`type`,`pays`,`ip`,`photo`) VALUES ('$titre','$ingredients','$preparation','$poster','$email','$siteweb','$nbpersonne','$tppreparation','$tpcuisson','$difficulte','$type','$pays','$ip','$photo')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `recette` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id = mysql_result($res,$i,"id");
$titre = mysql_result($res,$i,"titre");
$ingredients = mysql_result($res,$i,"ingredients");
$preparation = mysql_result($res,$i,"preparation");
$poster = mysql_result($res,$i,"poster");
$email = mysql_result($res,$i,"email");
$siteweb = mysql_result($res,$i,"siteweb");
$nbpersonne = mysql_result($res,$i,"nbpersonne");
$tppreparation = mysql_result($res,$i,"tppreparation");
$tpcuisson = mysql_result($res,$i,"tpcuisson");
$difficulte = mysql_result($res,$i,"difficulte");
$type = mysql_result($res,$i,"type");
$pays = mysql_result($res,$i,"pays");
$ip = mysql_result($res,$i,"ip");
$photo = mysql_result($res,$i,"photo");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `recette` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id=$tablo[$i]['id'];
$titre=$tablo[$i]['titre'];
$ingredients=$tablo[$i]['ingredients'];
$preparation=$tablo[$i]['preparation'];
$poster=$tablo[$i]['poster'];
$email=$tablo[$i]['email'];
$siteweb=$tablo[$i]['siteweb'];
$nbpersonne=$tablo[$i]['nbpersonne'];
$tppreparation=$tablo[$i]['tppreparation'];
$tpcuisson=$tablo[$i]['tpcuisson'];
$difficulte=$tablo[$i]['difficulte'];
$type=$tablo[$i]['type'];
$pays=$tablo[$i]['pays'];
$ip=$tablo[$i]['ip'];
$photo=$tablo[$i]['photo'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `recette` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id = mysql_result($res,0,"id");
$titre = mysql_result($res,0,"titre");
$ingredients = mysql_result($res,0,"ingredients");
$preparation = mysql_result($res,0,"preparation");
$poster = mysql_result($res,0,"poster");
$email = mysql_result($res,0,"email");
$siteweb = mysql_result($res,0,"siteweb");
$nbpersonne = mysql_result($res,0,"nbpersonne");
$tppreparation = mysql_result($res,0,"tppreparation");
$tpcuisson = mysql_result($res,0,"tpcuisson");
$difficulte = mysql_result($res,0,"difficulte");
$type = mysql_result($res,0,"type");
$pays = mysql_result($res,0,"pays");
$ip = mysql_result($res,0,"ip");
$photo = mysql_result($res,0,"photo");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `recette` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `recette` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

rencontre_user


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO rencontre_user (`civilite`,`cherche`,`age`,`taille`,`poid`,`plan`,`pays`,`ville`,`activite`,`status`,`passion`,`deteste`,`annonce`,`email`,`condition`,`pseudo`,`pass`,`image`,`v_photo`,`v_mail`,`date_d`,`date_f`) VALUES ('$civilite','$cherche','$age','$taille','$poid','$plan','$pays','$ville','$activite','$status','$passion','$deteste','$annonce','$email','$condition','$pseudo','$pass','$image','$v_photo','$v_mail','$date_d','$date_f')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `rencontre_user` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id_temp = mysql_result($res,$i,"id_temp");
$civilite = mysql_result($res,$i,"civilite");
$cherche = mysql_result($res,$i,"cherche");
$age = mysql_result($res,$i,"age");
$taille = mysql_result($res,$i,"taille");
$poid = mysql_result($res,$i,"poid");
$plan = mysql_result($res,$i,"plan");
$pays = mysql_result($res,$i,"pays");
$ville = mysql_result($res,$i,"ville");
$activite = mysql_result($res,$i,"activite");
$status = mysql_result($res,$i,"status");
$passion = mysql_result($res,$i,"passion");
$deteste = mysql_result($res,$i,"deteste");
$annonce = mysql_result($res,$i,"annonce");
$email = mysql_result($res,$i,"email");
$condition = mysql_result($res,$i,"condition");
$pseudo = mysql_result($res,$i,"pseudo");
$pass = mysql_result($res,$i,"pass");
$image = mysql_result($res,$i,"image");
$v_photo = mysql_result($res,$i,"v_photo");
$v_mail = mysql_result($res,$i,"v_mail");
$date_d = mysql_result($res,$i,"date_d");
$date_f = mysql_result($res,$i,"date_f");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `rencontre_user` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id_temp=$tablo[$i]['id_temp'];
$civilite=$tablo[$i]['civilite'];
$cherche=$tablo[$i]['cherche'];
$age=$tablo[$i]['age'];
$taille=$tablo[$i]['taille'];
$poid=$tablo[$i]['poid'];
$plan=$tablo[$i]['plan'];
$pays=$tablo[$i]['pays'];
$ville=$tablo[$i]['ville'];
$activite=$tablo[$i]['activite'];
$status=$tablo[$i]['status'];
$passion=$tablo[$i]['passion'];
$deteste=$tablo[$i]['deteste'];
$annonce=$tablo[$i]['annonce'];
$email=$tablo[$i]['email'];
$condition=$tablo[$i]['condition'];
$pseudo=$tablo[$i]['pseudo'];
$pass=$tablo[$i]['pass'];
$image=$tablo[$i]['image'];
$v_photo=$tablo[$i]['v_photo'];
$v_mail=$tablo[$i]['v_mail'];
$date_d=$tablo[$i]['date_d'];
$date_f=$tablo[$i]['date_f'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `rencontre_user` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id_temp = mysql_result($res,0,"id_temp");
$civilite = mysql_result($res,0,"civilite");
$cherche = mysql_result($res,0,"cherche");
$age = mysql_result($res,0,"age");
$taille = mysql_result($res,0,"taille");
$poid = mysql_result($res,0,"poid");
$plan = mysql_result($res,0,"plan");
$pays = mysql_result($res,0,"pays");
$ville = mysql_result($res,0,"ville");
$activite = mysql_result($res,0,"activite");
$status = mysql_result($res,0,"status");
$passion = mysql_result($res,0,"passion");
$deteste = mysql_result($res,0,"deteste");
$annonce = mysql_result($res,0,"annonce");
$email = mysql_result($res,0,"email");
$condition = mysql_result($res,0,"condition");
$pseudo = mysql_result($res,0,"pseudo");
$pass = mysql_result($res,0,"pass");
$image = mysql_result($res,0,"image");
$v_photo = mysql_result($res,0,"v_photo");
$v_mail = mysql_result($res,0,"v_mail");
$date_d = mysql_result($res,0,"date_d");
$date_f = mysql_result($res,0,"date_f");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `rencontre_user` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `rencontre_user` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

service


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO service (`nom`,`lieu`,`historique`,`objectif`,`email`,`email_aff`,`site`,`fax`,`tel`,`image`,`id_cat`,`date`,`ip`,`id_user`,`pwd`,`valider`) VALUES ('$nom','$lieu','$historique','$objectif','$email','$email_aff','$site','$fax','$tel','$image','$id_cat','$date','$ip','$id_user','$pwd','$valider')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `service` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id_service = mysql_result($res,$i,"id_service");
$nom = mysql_result($res,$i,"nom");
$lieu = mysql_result($res,$i,"lieu");
$historique = mysql_result($res,$i,"historique");
$objectif = mysql_result($res,$i,"objectif");
$email = mysql_result($res,$i,"email");
$email_aff = mysql_result($res,$i,"email_aff");
$site = mysql_result($res,$i,"site");
$fax = mysql_result($res,$i,"fax");
$tel = mysql_result($res,$i,"tel");
$image = mysql_result($res,$i,"image");
$id_cat = mysql_result($res,$i,"id_cat");
$date = mysql_result($res,$i,"date");
$ip = mysql_result($res,$i,"ip");
$id_user = mysql_result($res,$i,"id_user");
$pwd = mysql_result($res,$i,"pwd");
$valider = mysql_result($res,$i,"valider");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `service` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id_service=$tablo[$i]['id_service'];
$nom=$tablo[$i]['nom'];
$lieu=$tablo[$i]['lieu'];
$historique=$tablo[$i]['historique'];
$objectif=$tablo[$i]['objectif'];
$email=$tablo[$i]['email'];
$email_aff=$tablo[$i]['email_aff'];
$site=$tablo[$i]['site'];
$fax=$tablo[$i]['fax'];
$tel=$tablo[$i]['tel'];
$image=$tablo[$i]['image'];
$id_cat=$tablo[$i]['id_cat'];
$date=$tablo[$i]['date'];
$ip=$tablo[$i]['ip'];
$id_user=$tablo[$i]['id_user'];
$pwd=$tablo[$i]['pwd'];
$valider=$tablo[$i]['valider'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `service` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id_service = mysql_result($res,0,"id_service");
$nom = mysql_result($res,0,"nom");
$lieu = mysql_result($res,0,"lieu");
$historique = mysql_result($res,0,"historique");
$objectif = mysql_result($res,0,"objectif");
$email = mysql_result($res,0,"email");
$email_aff = mysql_result($res,0,"email_aff");
$site = mysql_result($res,0,"site");
$fax = mysql_result($res,0,"fax");
$tel = mysql_result($res,0,"tel");
$image = mysql_result($res,0,"image");
$id_cat = mysql_result($res,0,"id_cat");
$date = mysql_result($res,0,"date");
$ip = mysql_result($res,0,"ip");
$id_user = mysql_result($res,0,"id_user");
$pwd = mysql_result($res,0,"pwd");
$valider = mysql_result($res,0,"valider");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `service` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `service` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

service_cat


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO service_cat (`categorie`,`info`) VALUES ('$categorie','$info')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `service_cat` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id = mysql_result($res,$i,"id");
$categorie = mysql_result($res,$i,"categorie");
$info = mysql_result($res,$i,"info");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `service_cat` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id=$tablo[$i]['id'];
$categorie=$tablo[$i]['categorie'];
$info=$tablo[$i]['info'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `service_cat` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id = mysql_result($res,0,"id");
$categorie = mysql_result($res,0,"categorie");
$info = mysql_result($res,0,"info");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `service_cat` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `service_cat` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

service_photo


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO service_photo (`id_service`,`photo`,`label`) VALUES ('$id_service','$photo','$label')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `service_photo` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id = mysql_result($res,$i,"id");
$id_service = mysql_result($res,$i,"id_service");
$photo = mysql_result($res,$i,"photo");
$label = mysql_result($res,$i,"label");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `service_photo` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id=$tablo[$i]['id'];
$id_service=$tablo[$i]['id_service'];
$photo=$tablo[$i]['photo'];
$label=$tablo[$i]['label'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `service_photo` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id = mysql_result($res,0,"id");
$id_service = mysql_result($res,0,"id_service");
$photo = mysql_result($res,0,"photo");
$label = mysql_result($res,0,"label");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `service_photo` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `service_photo` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

skyblog


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO skyblog (`descr`,`pwd`,`date`,`ip`,`url`,`skyblog`,`image`,`valider`,`page`,`counter`,`vote_nb`,`vote_total`,`email`,`statut`) VALUES ('$descr','$pwd','$date','$ip','$url','$skyblog','$image','$valider','$page','$counter','$vote_nb','$vote_total','$email','$statut')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `skyblog` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id = mysql_result($res,$i,"id");
$descr = mysql_result($res,$i,"descr");
$pwd = mysql_result($res,$i,"pwd");
$date = mysql_result($res,$i,"date");
$ip = mysql_result($res,$i,"ip");
$url = mysql_result($res,$i,"url");
$skyblog = mysql_result($res,$i,"skyblog");
$image = mysql_result($res,$i,"image");
$valider = mysql_result($res,$i,"valider");
$page = mysql_result($res,$i,"page");
$counter = mysql_result($res,$i,"counter");
$vote_nb = mysql_result($res,$i,"vote_nb");
$vote_total = mysql_result($res,$i,"vote_total");
$email = mysql_result($res,$i,"email");
$statut = mysql_result($res,$i,"statut");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `skyblog` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id=$tablo[$i]['id'];
$descr=$tablo[$i]['descr'];
$pwd=$tablo[$i]['pwd'];
$date=$tablo[$i]['date'];
$ip=$tablo[$i]['ip'];
$url=$tablo[$i]['url'];
$skyblog=$tablo[$i]['skyblog'];
$image=$tablo[$i]['image'];
$valider=$tablo[$i]['valider'];
$page=$tablo[$i]['page'];
$counter=$tablo[$i]['counter'];
$vote_nb=$tablo[$i]['vote_nb'];
$vote_total=$tablo[$i]['vote_total'];
$email=$tablo[$i]['email'];
$statut=$tablo[$i]['statut'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `skyblog` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id = mysql_result($res,0,"id");
$descr = mysql_result($res,0,"descr");
$pwd = mysql_result($res,0,"pwd");
$date = mysql_result($res,0,"date");
$ip = mysql_result($res,0,"ip");
$url = mysql_result($res,0,"url");
$skyblog = mysql_result($res,0,"skyblog");
$image = mysql_result($res,0,"image");
$valider = mysql_result($res,0,"valider");
$page = mysql_result($res,0,"page");
$counter = mysql_result($res,0,"counter");
$vote_nb = mysql_result($res,0,"vote_nb");
$vote_total = mysql_result($res,0,"vote_total");
$email = mysql_result($res,0,"email");
$statut = mysql_result($res,0,"statut");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `skyblog` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `skyblog` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

t_ami_2


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO t_ami_2 (`moi`,`autre`) VALUES ('$moi','$autre')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `t_ami_2` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id_ami = mysql_result($res,$i,"id_ami");
$moi = mysql_result($res,$i,"moi");
$autre = mysql_result($res,$i,"autre");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `t_ami_2` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id_ami=$tablo[$i]['id_ami'];
$moi=$tablo[$i]['moi'];
$autre=$tablo[$i]['autre'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `t_ami_2` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id_ami = mysql_result($res,0,"id_ami");
$moi = mysql_result($res,0,"moi");
$autre = mysql_result($res,0,"autre");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `t_ami_2` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `t_ami_2` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

t_coeur_2


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO t_coeur_2 (`id_temp_e`,`pseudo_e`,`date`,`id_temp_r`,`pseudo_r`) VALUES ('$id_temp_e','$pseudo_e','$date','$id_temp_r','$pseudo_r')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `t_coeur_2` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id_coeur = mysql_result($res,$i,"id_coeur");
$id_temp_e = mysql_result($res,$i,"id_temp_e");
$pseudo_e = mysql_result($res,$i,"pseudo_e");
$date = mysql_result($res,$i,"date");
$id_temp_r = mysql_result($res,$i,"id_temp_r");
$pseudo_r = mysql_result($res,$i,"pseudo_r");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `t_coeur_2` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id_coeur=$tablo[$i]['id_coeur'];
$id_temp_e=$tablo[$i]['id_temp_e'];
$pseudo_e=$tablo[$i]['pseudo_e'];
$date=$tablo[$i]['date'];
$id_temp_r=$tablo[$i]['id_temp_r'];
$pseudo_r=$tablo[$i]['pseudo_r'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `t_coeur_2` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id_coeur = mysql_result($res,0,"id_coeur");
$id_temp_e = mysql_result($res,0,"id_temp_e");
$pseudo_e = mysql_result($res,0,"pseudo_e");
$date = mysql_result($res,0,"date");
$id_temp_r = mysql_result($res,0,"id_temp_r");
$pseudo_r = mysql_result($res,0,"pseudo_r");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `t_coeur_2` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `t_coeur_2` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

t_mail_2


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO t_mail_2 (`to`,`from`,`status`,`objet`,`message`,`date`,`sup_from`,`sup_to`) VALUES ('$to','$from','$status','$objet','$message','$date','$sup_from','$sup_to')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `t_mail_2` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id_mail = mysql_result($res,$i,"id_mail");
$to = mysql_result($res,$i,"to");
$from = mysql_result($res,$i,"from");
$status = mysql_result($res,$i,"status");
$objet = mysql_result($res,$i,"objet");
$message = mysql_result($res,$i,"message");
$date = mysql_result($res,$i,"date");
$sup_from = mysql_result($res,$i,"sup_from");
$sup_to = mysql_result($res,$i,"sup_to");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `t_mail_2` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id_mail=$tablo[$i]['id_mail'];
$to=$tablo[$i]['to'];
$from=$tablo[$i]['from'];
$status=$tablo[$i]['status'];
$objet=$tablo[$i]['objet'];
$message=$tablo[$i]['message'];
$date=$tablo[$i]['date'];
$sup_from=$tablo[$i]['sup_from'];
$sup_to=$tablo[$i]['sup_to'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `t_mail_2` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id_mail = mysql_result($res,0,"id_mail");
$to = mysql_result($res,0,"to");
$from = mysql_result($res,0,"from");
$status = mysql_result($res,0,"status");
$objet = mysql_result($res,0,"objet");
$message = mysql_result($res,0,"message");
$date = mysql_result($res,0,"date");
$sup_from = mysql_result($res,0,"sup_from");
$sup_to = mysql_result($res,0,"sup_to");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `t_mail_2` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `t_mail_2` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

t_rencontre_2


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO t_rencontre_2 (`civilite`,`cherche`,`age`,`taille`,`poid`,`plan`,`pays`,`ville`,`activite`,`status`,`passion`,`deteste`,`annonce`,`email`,`condition`,`pseudo`,`pass`,`image`,`v_photo`,`v_mail`,`date_d`,`date_f`,`date_inscr`,`pass_temp`,`confirm`,`date_f_chat`,`nb_coeur`) VALUES ('$civilite','$cherche','$age','$taille','$poid','$plan','$pays','$ville','$activite','$status','$passion','$deteste','$annonce','$email','$condition','$pseudo','$pass','$image','$v_photo','$v_mail','$date_d','$date_f','$date_inscr','$pass_temp','$confirm','$date_f_chat','$nb_coeur')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `t_rencontre_2` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id_temp = mysql_result($res,$i,"id_temp");
$civilite = mysql_result($res,$i,"civilite");
$cherche = mysql_result($res,$i,"cherche");
$age = mysql_result($res,$i,"age");
$taille = mysql_result($res,$i,"taille");
$poid = mysql_result($res,$i,"poid");
$plan = mysql_result($res,$i,"plan");
$pays = mysql_result($res,$i,"pays");
$ville = mysql_result($res,$i,"ville");
$activite = mysql_result($res,$i,"activite");
$status = mysql_result($res,$i,"status");
$passion = mysql_result($res,$i,"passion");
$deteste = mysql_result($res,$i,"deteste");
$annonce = mysql_result($res,$i,"annonce");
$email = mysql_result($res,$i,"email");
$condition = mysql_result($res,$i,"condition");
$pseudo = mysql_result($res,$i,"pseudo");
$pass = mysql_result($res,$i,"pass");
$image = mysql_result($res,$i,"image");
$v_photo = mysql_result($res,$i,"v_photo");
$v_mail = mysql_result($res,$i,"v_mail");
$date_d = mysql_result($res,$i,"date_d");
$date_f = mysql_result($res,$i,"date_f");
$date_inscr = mysql_result($res,$i,"date_inscr");
$pass_temp = mysql_result($res,$i,"pass_temp");
$confirm = mysql_result($res,$i,"confirm");
$date_f_chat = mysql_result($res,$i,"date_f_chat");
$nb_coeur = mysql_result($res,$i,"nb_coeur");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `t_rencontre_2` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id_temp=$tablo[$i]['id_temp'];
$civilite=$tablo[$i]['civilite'];
$cherche=$tablo[$i]['cherche'];
$age=$tablo[$i]['age'];
$taille=$tablo[$i]['taille'];
$poid=$tablo[$i]['poid'];
$plan=$tablo[$i]['plan'];
$pays=$tablo[$i]['pays'];
$ville=$tablo[$i]['ville'];
$activite=$tablo[$i]['activite'];
$status=$tablo[$i]['status'];
$passion=$tablo[$i]['passion'];
$deteste=$tablo[$i]['deteste'];
$annonce=$tablo[$i]['annonce'];
$email=$tablo[$i]['email'];
$condition=$tablo[$i]['condition'];
$pseudo=$tablo[$i]['pseudo'];
$pass=$tablo[$i]['pass'];
$image=$tablo[$i]['image'];
$v_photo=$tablo[$i]['v_photo'];
$v_mail=$tablo[$i]['v_mail'];
$date_d=$tablo[$i]['date_d'];
$date_f=$tablo[$i]['date_f'];
$date_inscr=$tablo[$i]['date_inscr'];
$pass_temp=$tablo[$i]['pass_temp'];
$confirm=$tablo[$i]['confirm'];
$date_f_chat=$tablo[$i]['date_f_chat'];
$nb_coeur=$tablo[$i]['nb_coeur'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `t_rencontre_2` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id_temp = mysql_result($res,0,"id_temp");
$civilite = mysql_result($res,0,"civilite");
$cherche = mysql_result($res,0,"cherche");
$age = mysql_result($res,0,"age");
$taille = mysql_result($res,0,"taille");
$poid = mysql_result($res,0,"poid");
$plan = mysql_result($res,0,"plan");
$pays = mysql_result($res,0,"pays");
$ville = mysql_result($res,0,"ville");
$activite = mysql_result($res,0,"activite");
$status = mysql_result($res,0,"status");
$passion = mysql_result($res,0,"passion");
$deteste = mysql_result($res,0,"deteste");
$annonce = mysql_result($res,0,"annonce");
$email = mysql_result($res,0,"email");
$condition = mysql_result($res,0,"condition");
$pseudo = mysql_result($res,0,"pseudo");
$pass = mysql_result($res,0,"pass");
$image = mysql_result($res,0,"image");
$v_photo = mysql_result($res,0,"v_photo");
$v_mail = mysql_result($res,0,"v_mail");
$date_d = mysql_result($res,0,"date_d");
$date_f = mysql_result($res,0,"date_f");
$date_inscr = mysql_result($res,0,"date_inscr");
$pass_temp = mysql_result($res,0,"pass_temp");
$confirm = mysql_result($res,0,"confirm");
$date_f_chat = mysql_result($res,0,"date_f_chat");
$nb_coeur = mysql_result($res,0,"nb_coeur");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `t_rencontre_2` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `t_rencontre_2` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

t_visite_2


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO t_visite_2 (`moi`,`date`,`autre`) VALUES ('$moi','$date','$autre')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `t_visite_2` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id_v = mysql_result($res,$i,"id_v");
$moi = mysql_result($res,$i,"moi");
$date = mysql_result($res,$i,"date");
$autre = mysql_result($res,$i,"autre");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `t_visite_2` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id_v=$tablo[$i]['id_v'];
$moi=$tablo[$i]['moi'];
$date=$tablo[$i]['date'];
$autre=$tablo[$i]['autre'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `t_visite_2` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id_v = mysql_result($res,0,"id_v");
$moi = mysql_result($res,0,"moi");
$date = mysql_result($res,0,"date");
$autre = mysql_result($res,0,"autre");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `t_visite_2` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `t_visite_2` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

user_boulot


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO user_boulot (`login`,`nom`,`prenom`,`email`,`pwd`,`niveau`,`tel`,`mobile`,`fax`,`adresse`,`actif`,`vitrine`,`societe`,`cp`,`ville`,`pays`,`web`,`logo`,`photo`,`description`,`rubriques_partenaire`) VALUES ('$login','$nom','$prenom','$email','$pwd','$niveau','$tel','$mobile','$fax','$adresse','$actif','$vitrine','$societe','$cp','$ville','$pays','$web','$logo','$photo','$description','$rubriques_partenaire')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `user_boulot` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id = mysql_result($res,$i,"id");
$login = mysql_result($res,$i,"login");
$nom = mysql_result($res,$i,"nom");
$prenom = mysql_result($res,$i,"prenom");
$email = mysql_result($res,$i,"email");
$pwd = mysql_result($res,$i,"pwd");
$niveau = mysql_result($res,$i,"niveau");
$tel = mysql_result($res,$i,"tel");
$mobile = mysql_result($res,$i,"mobile");
$fax = mysql_result($res,$i,"fax");
$adresse = mysql_result($res,$i,"adresse");
$actif = mysql_result($res,$i,"actif");
$vitrine = mysql_result($res,$i,"vitrine");
$societe = mysql_result($res,$i,"societe");
$cp = mysql_result($res,$i,"cp");
$ville = mysql_result($res,$i,"ville");
$pays = mysql_result($res,$i,"pays");
$web = mysql_result($res,$i,"web");
$logo = mysql_result($res,$i,"logo");
$photo = mysql_result($res,$i,"photo");
$description = mysql_result($res,$i,"description");
$rubriques_partenaire = mysql_result($res,$i,"rubriques_partenaire");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `user_boulot` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id=$tablo[$i]['id'];
$login=$tablo[$i]['login'];
$nom=$tablo[$i]['nom'];
$prenom=$tablo[$i]['prenom'];
$email=$tablo[$i]['email'];
$pwd=$tablo[$i]['pwd'];
$niveau=$tablo[$i]['niveau'];
$tel=$tablo[$i]['tel'];
$mobile=$tablo[$i]['mobile'];
$fax=$tablo[$i]['fax'];
$adresse=$tablo[$i]['adresse'];
$actif=$tablo[$i]['actif'];
$vitrine=$tablo[$i]['vitrine'];
$societe=$tablo[$i]['societe'];
$cp=$tablo[$i]['cp'];
$ville=$tablo[$i]['ville'];
$pays=$tablo[$i]['pays'];
$web=$tablo[$i]['web'];
$logo=$tablo[$i]['logo'];
$photo=$tablo[$i]['photo'];
$description=$tablo[$i]['description'];
$rubriques_partenaire=$tablo[$i]['rubriques_partenaire'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `user_boulot` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id = mysql_result($res,0,"id");
$login = mysql_result($res,0,"login");
$nom = mysql_result($res,0,"nom");
$prenom = mysql_result($res,0,"prenom");
$email = mysql_result($res,0,"email");
$pwd = mysql_result($res,0,"pwd");
$niveau = mysql_result($res,0,"niveau");
$tel = mysql_result($res,0,"tel");
$mobile = mysql_result($res,0,"mobile");
$fax = mysql_result($res,0,"fax");
$adresse = mysql_result($res,0,"adresse");
$actif = mysql_result($res,0,"actif");
$vitrine = mysql_result($res,0,"vitrine");
$societe = mysql_result($res,0,"societe");
$cp = mysql_result($res,0,"cp");
$ville = mysql_result($res,0,"ville");
$pays = mysql_result($res,0,"pays");
$web = mysql_result($res,0,"web");
$logo = mysql_result($res,0,"logo");
$photo = mysql_result($res,0,"photo");
$description = mysql_result($res,0,"description");
$rubriques_partenaire = mysql_result($res,0,"rubriques_partenaire");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `user_boulot` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `user_boulot` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

useragentsb


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO useragentsb (`nombrepages`,`ordre`) VALUES ('$nombrepages','$ordre')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `useragentsb` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$user_agent = mysql_result($res,$i,"user_agent");
$nombrepages = mysql_result($res,$i,"nombrepages");
$ordre = mysql_result($res,$i,"ordre");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `useragentsb` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$user_agent=$tablo[$i]['user_agent'];
$nombrepages=$tablo[$i]['nombrepages'];
$ordre=$tablo[$i]['ordre'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `useragentsb` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$user_agent = mysql_result($res,0,"user_agent");
$nombrepages = mysql_result($res,0,"nombrepages");
$ordre = mysql_result($res,0,"ordre");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `useragentsb` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `useragentsb` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>

vote


<?
//INSERER MYSQL

if ($act=="ajouter") {
$ip = $REMOTE_ADDR;
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "INSERT INTO vote (`email`,`pass`) VALUES ('$email','$pass')";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "insertion avec succès"; }
} // fin act ajouter
?>

<?
//RESULTAT MYSQL PLUSIEURS
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `vote` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$i=0;
while ($i < $nb){
$id = mysql_result($res,$i,"id");
$email = mysql_result($res,$i,"email");
$pass = mysql_result($res,$i,"pass");
?>

<?
$i++;
}
?>

<?
//RESULTAT DANS UN TABLEAU
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req20 = "SELECT * FROM `vote` WHERE 1";
//--- R&eacute;sultat ---//
$res20 = mysql_query($req20);
while($data = mysql_fetch_assoc($res20))
{
$tablo[]=$data; //--- mettre les donn&eacute;es dans un tableau
}
$nbcol=2; //--- d&eacute;termine le nombre de colonnes

echo "<table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">";
$nb20=count($tablo);
for($i=0;$i<$nb20;$i++){
//--- les valeurs que l'on souhaite afficher
$id=$tablo[$i]['id'];
$email=$tablo[$i]['email'];
$pass=$tablo[$i]['pass'];
if($i%$nbcol==0)
echo "<tr>";
echo "<td>";
echo "$nom";
echo "</td>";
if($i%$nbcol==($nbcol-1))
echo "</tr>";
}
echo "</table>";
?>
<?
<?

//RESULTAT MYSQL SIMPLE
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "SELECT * FROM `vote` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
$nb = mysql_numrows($res);
$id = mysql_result($res,0,"id");
$email = mysql_result($res,0,"email");
$pass = mysql_result($res,0,"pass");

?>

<?
//UPDATE MYSQL
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter &agrave; la base de donn&eacute;es");
$req = "UPDATE `` FROM `vote` WHERE 1";
$res = mysql_query($req) or die(mysql_error());
?>


<?
//SUPPRIMER MYSQL
if ($act=="supprimer") {
mysql_connect($mysqlhost,$mysqluser,$mysqlpass) or die("Impossible de se connecter à la base de données");
mysql_select_db("$mysqlbdd") or die("Impossible de se connecter à la base de données");
$req = "DELETE FROM `vote` WHERE 1 AND `id` like '$id'";
$res = mysql_query($req) or die(mysql_error());
if(!$res) { $ALERT = "Une erreur s\'est produite"; } else { $ALERT = "suppression effectuée avec succès"; $redir="ok"; }
} // fin act supprimer
?>