J'ai une page qui me permet de modifier des paragraphes de textes, avec donc des textaera généré en boucle, pour autant d'entrées qu'il y'a dans ma bdd. Et lorsque je clic sur le bouton submit pour soumettre le formulaire, rien ne se passe. le bouton submit reste enfoncé une demi seconde, puis rien.
J'ai l'impression que cela pourrait venir de l'utilisation de l'editeur de texte pour les textarea..
la page entiere :
[php]
<?php
session_start();
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Extranet goodgame</title>
<link href="../style.css" rel="stylesheet" type="text/css" />
</head>
<body>
<?php
include ("../connexion.php");
include("FCKeditor/fckeditor.php");
if (isset($_POST['authentification']) && $_POST['authentification']=='submit') {
$login = $_POST['login'];
$pass = $_POST['pass'];
$sql = "SELECT pass FROM users WHERE login='$login'";
$query = mysql_query($sql);
$result = mysql_fetch_array($query);
if($result['pass']==md5($pass)) {
$_SESSION['login'] = $login;
}
else {
echo ("<center><font face=\"verdana\" color=\"#FF0000\" size=\"2\">login/pass incorrects.</font></center><br><br>");
}
}
if (isset($_SESSION['login'])) {
?>
<!-- DEBUT BANNIERE -->
<?php
include ("inc_top.php");
?>
<!-- FIN BANNIERE -->
<!-- DEBUT LOCATION + TRI -->
<div class="table-location">
<table width="990" border="0">
<tr>
<td width="773"> You are there :
<a href="index.php" class="location">Home</a>
> <a href="edit_paragraph.php" class="location">Edit paragraph</a>
</td>
</tr>
</table>
</div>
<!-- FIN LOCATION + TRI -->
<!-- DEBUT DU MENU -->
<?php
include ("inc_menu.php");
?>
<!-- FIN DU MENU -->
<!-- DEBUT CONTENU -->
<div class="box01_back">
<div class="box02">
<!-- DEBUT MODULE ARTICLE -->
<div class="contenu-titre">
- Edit a paragraph -
</div>
<div class="contenu-texte">
<form action="edit_paragraph.php" name="edit" method="get">
<?php
if (isset($_GET['sub']) && $_GET['sub']=="Submit") {
$max = $_GET['max'];
while ($max>=1) {
$id_article = $_GET['article'];
$id = $_GET['id'.$max];
$titre = addslashes($_GET['titre'.$max]);
$texte = addslashes($_GET['texte'.$max]);
$jour = $_GET['jour'.$max];
$mois = $_GET['mois'.$max];
$annee = $_GET['annee'.$max];
$sql_mois = "SELECT * FROM mois WHERE id_mois='$mois'";
$query_mois = mysql_query($sql_mois);
$result_mois = mysql_fetch_array($query_mois) OR die("Erreur : ".mysql_error());
$sql_annee = "SELECT * FROM annee WHERE id_annee='$annee'";
$query_annee = mysql_query($sql_annee);
$result_annee = mysql_fetch_array($query_annee) OR die("Erreur : ".mysql_error());
$date = $result_annee['annee']."-".$mois."-".$jour;
$sql = "UPDATE textes SET titre='$titre', texte='$texte', date='$date' WHERE id_texte='$id'";
$query = mysql_query($sql) OR die("Erreur :".mysql_error());
$max = $max-1;
}
echo ("Data successfully updated.<br /><br />");
//REDIRECTION JS, 1 seconde
/*
echo "<SCRIPT LANGUAGE='JavaScript'>\n
function redirect() {\n
window.location='edit_article.php'\n
}\n
setTimeout('redirect()',1000);\n
</SCRIPT>\n";
exit();
*/
}
?>
<table width="500" border="0">
<tr>
<td valign="top">Catégorie :</td>
<td><select name="categorie" onChange="submit()">
<option>Sélectionnez une catégorie</option>
<?php
$sql = "SELECT * FROM categorie";
$query = mysql_query($sql);
while ($result = mysql_fetch_array($query)) {
?>
<option value="<?php echo $result['id_categorie']; ?>"
<?php
if (isset($_GET['categorie'])) {
$cat = $_GET['categorie'];
if ($result['id_categorie']==$cat) {
echo ("selected");
}
}
?>
>
<?php echo stripslashes($result['nom']); ?>
</option>
<?php
}
?>
</select>
<br /><br />
</td>
</tr>
<?php
if (isset($_GET['categorie'])) {
$cat = $_GET['categorie'];
?>
<tr>
<td valign="top">Article :</td>
<td><select name="article" onChange="submit()">
<option>Sélectionnez un article</option>
<?php
$count = 1;
$sql = "SELECT * FROM articles WHERE id_categorie='$cat'";
$query = mysql_query($sql);
while ($result = mysql_fetch_array($query)) {
?>
<option value="<?php echo $result['id_article']; ?>"
<?php
if (isset($_GET['article'])) {
$article = $_GET['article'];
if ($result['id_article']==$article) {
echo ("selected");
}
}
?>
>
<?php echo stripslashes($result['nom']); ?>
</option>
<?php
}
?>
</select>
<br /><br />
</td>
</tr>
<?php
if (isset($_GET['article'])) {
$count = 1;
$sql_select = "SELECT * FROM textes WHERE id_article='$article'";
$query_select = mysql_query($sql_select);
while ($result_select = mysql_fetch_array($query_select)) {
?>
<tr>
<td>Title :</td>
<td>
<input type="hidden" name="id<?php echo $count ?>" value="<?php echo $result_select['id_texte']; ?>" />
<input type="text" name="titre<?php echo $count ?>" value="<?php echo stripslashes($result_select['titre']); ?>" size="40" /></td>
</tr>
<tr>
<td valign="top">Content :</td>
<td>
<?php
$oFCKeditor = new FCKeditor('texte'.$count) ;
$oFCKeditor->BasePath = 'FCKeditor/';
$oFCKeditor->Value = stripslashes($result_select['texte']);
$oFCKeditor->Width = '550' ;
$oFCKeditor->Height = '350' ;
$oFCKeditor->Create() ;
?>
</td>
</tr>
<tr>
<td width="50">Date :</td>
<td width="250">
<select name="jour<?php echo $count; ?>">
<?php
$split = explode("-", $result_show['date']);
$annee = $split[0];
$mois = $split[1];
$jour = $split[2];
$sql = "SELECT * FROM jour";
$query = mysql_query($sql);
while ($result = mysql_fetch_array($query)) {
?>
<option value="<?php echo $result['id_jour']; ?>"
<?php
if ($result['jour']==$jour){
echo "selected";
}
?>
>
<?php echo $result['jour']; ?>
</option>
<?php
}
?>
</select>
<select name="mois<?php echo $count; ?>">
<?php
$sql = "SELECT * FROM mois";
$query = mysql_query($sql);
while ($result = mysql_fetch_array($query)) {
?>
<option value="<?php echo $result['id_mois']; ?>"
<?php
if ($result['mois']==$mois){
echo "selected";
}
?>
>
<?php echo $result['mois']; ?>
</option>
<?php
}
?>
</select>
<select name="annee<?php echo $count; ?>">
<?php
$sql = "SELECT * FROM annee ORDER BY annee DESC";
$query = mysql_query($sql);
while ($result = mysql_fetch_array($query)) {
?>
<option value="<?php echo $result['id_annee']; ?>"
<?php
if ($result['annee']==$annee){
echo "selected";
}
?>
>
<?php echo $result['annee']; ?>
</option>
<?php
}
?>
</select>
</td>
</tr>
<tr>
<td height="30"></td>
<td></td>
</tr>
<?php
$count = $count+1;
}
}
}
?>
<input type="hidden" name="max" value="<?php echo $count-1; ?>" />
<tr>
<td height="60"></td>
<td><input type="submit" name="sub" value="Submit" /></td>
</tr>
</table>
</form>
</div>
<!-- FIN MODULE ARTICLE -->
</div>
</div>
<!-- FIN CONTENU -->
<div class="box-droite-back">
<!-- DEBUT MODULE DOWNLAD -->
<?php
include ("inc_download.php");
?>
<!-- FIN MODULE DOWNLAD -->
<!-- DEBUT MODULE NEWS -->
<?php
//include ("inc_news.php");
?>
<!-- FIN MODULE NEWS -->
</div>
</body>
<?php
}
else {
include ("inc_auth.php");
}
?>
</html>[/php]
