afficher les modifications

Version imprimable

01/10/2009, 00h36
sbcbc

afficher les modifications

salut tt le monde

j'ai fait une page php qui affiche les des infos sur fonctionnaires que j'ai mis dans ma base de donnée et permet de les modifier
le problème se pose au niveaux de la modification, je m'explique:
lorsque je modifie une information, la mm page s'affiche , MAis je veux que les modifcation que j'ai faites soient prises en considération.

Merci de m'aider à y remédier!

si c pas clair, je suis disponible pour éclaircir davantage.

Merci encore une fois
01/10/2009, 08h11
andry.aime

Bonjour,
Ta base est modifiée->Problème de cache.
Sinon le problème est ailleurs, montres nous les codes pour la modification et l'affichage.
01/10/2009, 09h17
Doksuri

salut,

ca m'est deja arrive (1 fois ou 2) que la page soit 'preparee' plus vite que la modification proprement dite dans la BDD.
si tu attends 1 ou 2 secondes, ca donne quoi ?
01/10/2009, 16h55
spooffi

Montre tes sources!!!

je suis presque sur que ton problème est: le script de modification est saisi au dessous de la partie d'affichage des lignes :)
10/10/2009, 00h05
sbcbc

salut;
Merci pour vos réponse! voici mon code:

Citation:

<?php
if (isset($_POST['valider']))
{

// D'abord, on se connecte à MySQL
$id=mysql_connect("localhost", "root", "");
mysql_select_db("base");

// On utilise les fonctions PHP mysql_real_escape_string et htmlspecialchars pour la sécurité
$ppr = mysql_real_escape_string(htmlspecialchars($_POST['ppr']));

// Ensuite on enregistre le message
$query1=mysql_query("select * from etre_humain where cin=(select cin from fonctionnaire where ppr='$ppr')");
$query=mysql_query("select * from fonctionnaire where ppr='$ppr'");
$query3=mysql_query("SELECT * from entite_travail where ppr='$ppr'");

$SEL1=mysql_fetch_array($query1);
$SEL2=mysql_fetch_array($query);
$SEL3=mysql_fetch_array($query3);
$nb_resultats = mysql_num_rows($query1);
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<SCRIPT LANGUAGE="JavaScript">
function confirmation() {
var msg = "Êtes-vous sûr de vouloir effectuer cette modification?";
if (confirm(msg))
location.href("modifier.php");
}
</SCRIPT>
</head>
<body>
<?php if ($nb_resultats ==0){?>
<script type="text/javascript" language="javascript">
alert("Erreur! La liste est vide Ou aucun fonctionnaire correspondant!")

</script>
<?php }
else {
?>
<form action="conf_mod.php" method="post">
<?php echo "PPR : ";?><pre></pre> <td></td><input type="text" name="ppr" value='<?php echo $ppr; ?>' /> <br/><br/><br/>
<?php echo "CIN : ";?> <pre></pre> <td></td><input type="text" name="cin" value='<?php echo ''.$SEL1['CIN'].''; ?>' /> <br/><br/><br/>
<?php echo "Nom : ";?> <pre></pre> <input type="text" name="nom" value='<?php echo ' '.$SEL1['nom'].' '; ?>' /> <br/><br/><br/>
<?php echo "Prénom : ";?> <pre></pre> <input type="text" name="prenom" value='<?php echo ' '.$SEL1['prenom'].' '; ?>' /> <br/><br/><br/>
<?php echo "Sexe : ";?> <pre></pre> <input type="text" name="sexe" value='<?php echo ' '.$SEL1['sexe'].' '; ?>' /> <br/><br/><br/>
<?php echo "Date de naissance : ";?> <pre></pre> <input type="text" name="date" value='<?php echo ' '.$SEL1['date_de_naissance'].' '; ?>' />
<p><font color="#CC0000"><strong>(YYYY-MM-DD)</strong></font></p>
<br/><br/><br/>
<?php echo "E-mail : ";?> <pre></pre> <input type="text" name="email" value='<?php echo ' '.$SEL1['e_mail'].' '; ?>' /> <br/><br/><br/>
<?php echo "Fonction : ";?> <pre></pre> <input type="text" name="fonction" value='<?php echo ' '.$SEL2['fonction'].' '; ?>' /> <br/><br/><br/>
<?php echo "Grade : ";?> <pre></pre> <td></td><input type="text" name="grade" value='<?php echo ' '.$SEL2['grade'].' '; ?>' /> <br/><br/><br/>
<?php echo "Numéro de bureau : ";?> <pre></pre> <td></td><input type="text" name="num_bur" value='<?php echo ' '.$SEL2['num_bur'].' '; ?>' /> <br/><br/><br/>
<?php echo "Etage : ";?> <pre></pre> <input type="text" name="etage" value='<?php echo ' '.$SEL2['etage'].' '; ?>' /> <br/><br/><br/>
<?php echo "Batiment : ";?> <pre></pre> <input type="text" name="batiment" /> <br/><br/><br/>
<?php echo "Téléphone du poste : ";?> <pre></pre> <input type="text" name="tel_poste" value='<?php echo ' '.$SEL2['tel_post'].' '; ?>' /> <br/><br/><br/>
<?php echo "Id entité de travail : ";?> <pre></pre> <input type="text" name="id_en" value='<?php echo ' '.$SEL3['id_en'].' '; ?>'/> <br/><br/><br/>
<?php echo "Id enitité de travail père : ";?> <pre></pre> <input type="text" name="pid_en" value='<?php echo ' '.$SEL3['id_en_pere'].' '; ?>' /> <br/><br/><br/>
<?php echo "Type : ";?> <pre></pre> <input type="text" name="type" value='<?php echo ' '.$SEL3['type'].' ';?>' /> <br/><br/><br/>
<?php echo "Libellé : ";?> <pre></pre> <input type="text" name="libelle" value='<?php echo ' '.$SEL3['libelle'].' '; ?>' /> <br/><br/><br/>
<?php echo "Abréviation : ";?> <pre></pre> <input type="text" name="abreviation" value='<?php echo ' '.$SEL3['abreviation'].' ';?>' /> <br/><br/><br/>

<INPUT TYPE="submit" onClick='confirmation();' name="valider" VALUE='Modifier'>

<input name="annuler" type="reset" value="Annuler" />

<input type="hidden" name="ok" value="1"/>
</form>
<?php }
if ((isset($_POST['valider']))&&(isset($_POST['ok']))){
// On utilise les fonctions PHP mysql_real_escape_string et htmlspecialchars pour la sécurité
$ppr = mysql_real_escape_string(htmlspecialchars($_POST['ppr']));
$cin = mysql_real_escape_string(htmlspecialchars($_POST['cin']));
$nom= mysql_real_escape_string(htmlspecialchars($_POST['nom']));
$prenom= mysql_real_escape_string(htmlspecialchars($_POST['prenom']));
$sexe= mysql_real_escape_string(htmlspecialchars($_POST['sexe']));
$date= mysql_real_escape_string(htmlspecialchars($_POST['date']));
$email= mysql_real_escape_string(htmlspecialchars($_POST['email']));
$fonction= mysql_real_escape_string(htmlspecialchars($_POST['fonction']));
$grade= mysql_real_escape_string(htmlspecialchars($_POST['grade']));
$num_bur= mysql_real_escape_string(htmlspecialchars($_POST['num_bur']));
$etage= mysql_real_escape_string(htmlspecialchars($_POST['etage']));
$tel_post= mysql_real_escape_string(htmlspecialchars($_POST['tel_poste']));
$id_en= mysql_real_escape_string(htmlspecialchars($_POST['id_en']));
$pid_en= mysql_real_escape_string(htmlspecialchars($_POST['pid_en']));
$type= mysql_real_escape_string(htmlspecialchars($_POST['type']));
$libelle= mysql_real_escape_string(htmlspecialchars($_POST['libelle']));
$abreviation= mysql_real_escape_string(htmlspecialchars($_POST['abreviation']));
$mod1=mysql_query("UPDATE etre_humain SET cin='$cin' , nom='$nom', prenom='$prenom', sexe='$sexe', date_de_naissance='$date', e_mail='$email' WHERE cin=(select cin from fonctionnaire where ppr='$ppr')");
$mod2=mysql_query("UPDATE fonctionnaire SET ppr='$ppr', fonction='$fonction', grade='$grade', num_bur='$num_bur', etage='$etage', tel_post='$tel_post', cin='$cin' WHERE ppr='$ppr'");
$mod3=mysql_query("UPDATE entite_travail SET id_en='$id_en', id_en_pere'$pid_en', type='$type', libelle='$libelle', abreviation='$abreviation', ppr='$ppr' WHERE ppr='$ppr'");
?>
<script> alert('fonctionnaire modifié');
</script>
<?php }
?>

</body>

</html>
<?php // On se déconnecte de MySQL
mysql_close($id);
}

?>

Heu...
Code:

1 2 3 4 5 6 7 8 <SCRIPT LANGUAGE="JavaScript"> function confirmation() { var msg = "Êtes-vous sûr de vouloir effectuer cette modification?"; if (confirm(msg)) location.href("modifier.php"); } </SCRIPT>
Si je ne me trompes le onclick passe avant le submit... Donc vous redirigez le navigateur vers modifier.php - en ne passant aucune variable.

Citation:
Envoyé par sachav
Heu...
Code:

1 2 3 4 5 6 7 8 <SCRIPT LANGUAGE="JavaScript"> function confirmation() { var msg = "Êtes-vous sûr de vouloir effectuer cette modification?"; if (confirm(msg)) location.href("modifier.php"); } </SCRIPT>
Si je ne me trompes le onclick passe avant le submit... Donc vous redirigez le navigateur vers modifier.php - en ne passant aucune variable.
Comment faire alors?!

10/10/2009, 10h04
micetf
Bonjour,

Comme l'a suggéré spooffi,
je "remonterais" toute la partie mise à jour (if ((isset($_POST['valider']))&&(isset($_POST['ok']))){...}) au tout début du script afin que la mise à jour soit faite avant l'affichage.
Ensuite,
pour la remarque de sachav,
je remplacerais cette ligne :

Code:

<INPUT TYPE="submit" onClick='confirmation();' name="valider" VALUE='Modifier'>

par celle-ci

Code:

<INPUT TYPE="button" onClick='confirmation(this);' name="valider" VALUE='Modifier'>

enfin je gèrerais la comfirmation ainsi :
Code:

1 2 3 4 5 6 7 <SCRIPT LANGUAGE="JavaScript"> function confirmation(b) { var msg = "Êtes-vous sûr de vouloir effectuer cette modification?"; if (confirm(msg)) b.form.submit(); } </SCRIPT>
Fred
10/10/2009, 12h32
sbcbc

Citation:

Envoyé par micetf

Comme l'a suggéré spooffi,
je "remonterais" toute la partie mise à jour (if ((isset($_POST['valider']))&&(isset($_POST['ok']))){...}) au tout début du script afin que la mise à jour soit faite avant l'affichage.

Bonjour à tous!
Lorsque je remonte le code en haut, je reçois des messages d'erreurs enfin de modification, Comme quoi les variables n'existent pas. :(
10/10/2009, 12h41
sachav

Pourriez vous faire un copier/coller de ces erreurs ?
10/10/2009, 13h20
sbcbc

Citation:

Envoyé par sachav

Pourriez vous faire un copier/coller de ces erreurs ?

Voilà

Citation:

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'SYSTEM'@'localhost' (using password: NO) in C:\wamp\www\dernier site\conf_mod.php on line 4

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in C:\wamp\www\dernier site\conf_mod.php on line 4

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'SYSTEM'@'localhost' (using password: NO) in C:\wamp\www\dernier site\conf_mod.php on line 5

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in C:\wamp\www\dernier site\conf_mod.php on line 5

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'SYSTEM'@'localhost' (using password: NO) in C:\wamp\www\dernier site\conf_mod.php on line 6

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in C:\wamp\www\dernier site\conf_mod.php on line 6

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'SYSTEM'@'localhost' (using password: NO) in C:\wamp\www\dernier site\conf_mod.php on line 7

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in C:\wamp\www\dernier site\conf_mod.php on line 7

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'SYSTEM'@'localhost' (using password: NO) in C:\wamp\www\dernier site\conf_mod.php on line 8

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in C:\wamp\www\dernier site\conf_mod.php on line 8

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'SYSTEM'@'localhost' (using password: NO) in C:\wamp\www\dernier site\conf_mod.php on line 9

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in C:\wamp\www\dernier site\conf_mod.php on line 9

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'SYSTEM'@'localhost' (using password: NO) in C:\wamp\www\dernier site\conf_mod.php on line 10

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in C:\wamp\www\dernier site\conf_mod.php on line 10

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'SYSTEM'@'localhost' (using password: NO) in C:\wamp\www\dernier site\conf_mod.php on line 11

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in C:\wamp\www\dernier site\conf_mod.php on line 11

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'SYSTEM'@'localhost' (using password: NO) in C:\wamp\www\dernier site\conf_mod.php on line 12

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in C:\wamp\www\dernier site\conf_mod.php on line 12

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'SYSTEM'@'localhost' (using password: NO) in C:\wamp\www\dernier site\conf_mod.php on line 13

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in C:\wamp\www\dernier site\conf_mod.php on line 13

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'SYSTEM'@'localhost' (using password: NO) in C:\wamp\www\dernier site\conf_mod.php on line 14

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in C:\wamp\www\dernier site\conf_mod.php on line 14

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'SYSTEM'@'localhost' (using password: NO) in C:\wamp\www\dernier site\conf_mod.php on line 15

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in C:\wamp\www\dernier site\conf_mod.php on line 15

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'SYSTEM'@'localhost' (using password: NO) in C:\wamp\www\dernier site\conf_mod.php on line 16

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in C:\wamp\www\dernier site\conf_mod.php on line 16

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'SYSTEM'@'localhost' (using password: NO) in C:\wamp\www\dernier site\conf_mod.php on line 17

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in C:\wamp\www\dernier site\conf_mod.php on line 17

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'SYSTEM'@'localhost' (using password: NO) in C:\wamp\www\dernier site\conf_mod.php on line 18

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in C:\wamp\www\dernier site\conf_mod.php on line 18

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'SYSTEM'@'localhost' (using password: NO) in C:\wamp\www\dernier site\conf_mod.php on line 19

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in C:\wamp\www\dernier site\conf_mod.php on line 19

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'SYSTEM'@'localhost' (using password: NO) in C:\wamp\www\dernier site\conf_mod.php on line 20

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in C:\wamp\www\dernier site\conf_mod.php on line 20

Warning: mysql_query() [function.mysql-query]: Access denied for user 'SYSTEM'@'localhost' (using password: NO) in C:\wamp\www\dernier site\conf_mod.php on line 21

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:\wamp\www\dernier site\conf_mod.php on line 21

Warning: mysql_query() [function.mysql-query]: Access denied for user 'SYSTEM'@'localhost' (using password: NO) in C:\wamp\www\dernier site\conf_mod.php on line 22

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:\wamp\www\dernier site\conf_mod.php on line 22

Warning: mysql_query() [function.mysql-query]: Access denied for user 'SYSTEM'@'localhost' (using password: NO) in C:\wamp\www\dernier site\conf_mod.php on line 23

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:\wamp\www\dernier site\conf_mod.php on line 23

enfin , c pas possible d'accéder à la base de donnée ! Est ce qu'il faut faire un mysql_connect_db?!
10/10/2009, 13h36
micetf

Citation:

Est ce qu'il faut faire un mysql_connect_db?!

oui

Fred
10/10/2009, 14h15
sbcbc

Citation:

Envoyé par micetf

oui

Fred

c fait! ça marche très bien! Merci :D