Tiens regarde comment je fais pour modifier les news de mon site c'est très simple :
lien pour la modif de la news n° X
<a href=\"#nowhere\" onclick=\"ouvrepopup('news_upd.php?id_news=". $r['numero'] . "')\">Modifier</a>
la popup de modification :
==========================================
news_upd.php
------------------------------------------
<?php
session_start();
?>
<html>
<head>
<script language="Javascript">
<!--
function comptage(f) {
var txt=f.news_input.value;
var nb=txt.length;
f.nbcar.value=nb+1;
}
function controle_form() {
if (document.zeform.news_input.value=="") {alert("Ou est votre texte ... ?");return false;}
return true;
}
//-->
</script>
</head>
<body>
<form name = "zeform" method="post" action="news_upd_go.php" onSubmit="return controle_form()">
<input type="hidden" name="id_news_input" value="<? echo $_REQUEST['id_news']; ?>">
<P>Type :
<select NAME="type_input">
<option VALUE="C">Club
<?php
// connection bdd
$c = @mysql_connect('sql.free.fr','esc15.tennis','tdm850') or die('connexion impossible');
@mysql_select_db('base',$c) or die('selection impossible');
// requete sql 1
$sql1 = "select equipe from Connexion where upper(capitaine) = '" . strtoupper($est_admin) . "' ";
// parcours et affichage des résultats
if($p = @mysql_query($sql1,$c)){
while($r = @mysql_fetch_array($p)){
$ze_equipe = $r['equipe'];
}
}
if ($ze_equipe != "C") {
echo "<option value='" . $ze_equipe . "'>Equipe n° " . $ze_equipe;
}
?>
</select>
</P>
<textarea name="news_input" cols="28" rows="14" onkeypress="comptage(this.form)"><?php
if ($_REQUEST['id_news'] != "") {
// requete sql 2
$sql2 = "select news from News where numero = '" . $_REQUEST['id_news'] . "' ";
// parcours et affichage des résultats
if($p = @mysql_query($sql2,$c)){
while($r = @mysql_fetch_array($p)){
echo $r['news'];
}
}
}
// fermeture bdd
@mysql_close($c);
?></textarea><br>
<input type="text" name="nbcar" size=5> (2000 char. max)
<P><input type="submit" value=" Poster " name="submit_button"></P>
</form>
</body>
</html>
la feuille php qui fait les modifs en base et recharge la page d'origine :
==========================================
news_upd_go.php
------------------------------------------
<html>
<body>
<?php
// connection bdd
$c = @mysql_connect('sql.free.fr','esc15.tennis','tdm850') or die('connexion impossible');
@mysql_select_db('base',$c) or die('selection impossible');
// execution sql 1
$sql1_query = mysql_query("
UPDATE
News
SET
type = '" . $_REQUEST['type_input'] . "',
news= '" . trim(substr($_REQUEST['news_input'], 0, 2000)) . "'
WHERE
numero = " . $_REQUEST['id_news_input']
) or die (mysql_error());
// fermeture bdd
@mysql_close($c);
?>
<script language="JavaScript">
<!--
window.opener.location.reload();
self.close();
//-->
</script>
</body>
</html>
