include("menu.php");
?>
include("titrenews.php");
?>
$pass = $_POST['pass'];
if ($pass!="446tbFty")
{
?>
Entrez le mot de passe administrateur :
}
else
{
if ($_POST['submit'] == "Supprimer")
$action = 2;
if ($_POST['submit'] == "Modifier")
$action = 3;
if (empty($action))
$action = $_POST['action'];
if (empty($id))
$id = $_POST['id'];
if (empty($news))
$news = $_POST['news'];
if (empty($titre))
$titre = $_POST['titre'];
if (empty($pass))
$pass = $_POST['pass'];
if (($action == 1 || $action == 4) && empty($news))
$enews = 1;
else
$enews = 0;
if (($action == 1 || $action == 4) && empty($titre))
$etitre = 1;
else
$etitre = 0;
if ($action == 4 && ($enews || $etitre))
$action = 3;
if ($action == 1 && ($enews || $etitre))
$action = 0;
include('config/base.php');
if ($action == 1)
{
$db =
mysql_connect($mysql_host,$mysql_user,$mysql_password) or die ("erreur
de connexion");
mysql_select_db($mysql_base,$db) or die ("erreur de
connexion base");
mysql_query("INSERT Into news (titre, news, date) VALUES
('".mysql_real_escape_string($_POST['titre'], $db)."','".mysql_real_escape_string($_POST['news'], $db)."', NOW())") or die ("erreur requête" . mysql_error());
mysql_close();
$titre="";
$news="";
}
if ($action == 2)
{
$db =
mysql_connect($mysql_host,$mysql_user,$mysql_password) or die ("erreur
de connexion");
mysql_select_db($mysql_base,$db) or die ("erreur de
connexion base");
mysql_query("DELETE FROM news WHERE id='$id'") or die
("erreur requète");
$req = mysql_query("SELECT * from news Order by id Asc")
or die ("erreur requete");
while( $contenu = mysql_fetch_array ($req))
{
$tempid=$contenu['id']-1;
if ($contenu['id']>$id)
mysql_query("UPDATE news SET id='$tempid' WHERE
id='$contenu[id]'");
}
mysql_close();
$titre="";
$news="";
}
if ($action == 3)
{
$db =
mysql_connect($mysql_host,$mysql_user,$mysql_password) or die ("erreur
de connexion");
mysql_select_db($mysql_base,$db) or die ("erreur de
connexion base");
$req = mysql_query("SELECT * from news WHERE id='$id'") or
die ("erreur requete");;
$contenu = mysql_fetch_array ($req);
mysql_close();
$titre=$contenu['titre'];
$news=$contenu['news'];
?>
Modifier une news :