Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

PHP Mysql: Problem to update my database

Status
Not open for further replies.
angediagou

angediagou

MIS
Feb 22, 2005
3
CA
I am a new and am trying to update a database I have created, the script seems to be working fine in all aspects other than it does not actually update the mysql database. There are 2 parts to the script and I have enclosed then below. For security reasons I have XXX'd out the database info however I can confirm that each page is linking to my database OK.

Thanks for any advice given.

Angelo

<?php
session_start();
$codeacces = "";
$motdepasse = "";
$etat ="";
$nom = "";
$prenom = "";
$datenais = "";
$adressepost = "";
$telbureau = "";
$teldomicile = "";
$telcellulaire = "";
$courriel = "";
?>

<html>
<title>Modifier des informations dans la base</title>
<style type="text/css">
</style>
<body>
<?php

//$id =13;
//$codeacces = $HTTP_SESSION_VARS['codeacces'];
$db = mysql_connect("localhost", "devweb","devweb");
mysql_select_db("nsiaweb_DB", $db);

//show user information
$sql = "SELECT * FROM utilisateur WHERE USERNAME = '23456'";
$result = mysql_query($sql);
$ligne = mysql_fetch_array($result);
?>
<form method="post" action="inscript_modif_validate.php">
<table width="764" border="0">
<tr>
<td colspan="2"><div align="left"><img src="../images/groupe200.jpg" width="200" height="99"> </div></td>
</tr>
<tr>
<td colspan="2"><p>
<hr>
</td>
</tr>
<tr>
<td width="230" height="98" valign="top"><table width="184" border="0" align="center">
<tr valign="middle">
<td colspan="2" bgcolor="#FFFFFF"><p align="right" class="style23 style24 style34"><span class="style9"><span class="style21">MON COMPTE</span></span></p></td>
</tr>
<tr valign="middle" bgcolor="#8492BD">
<td height="3" colspan="2"><span class="style35">d</span></td>
</tr>
<tr valign="middle">
<td width="184" height="2" class="style23"><div align="right" class="style34">Modifier ses infos-compte</div></td>
<td width="14" height="2" class="style23"><img src="../images/puce_bleu.gif" width="14" height="14"></td>
</tr>
<tr valign="middle">
<td height="8" class="style23"><div align="right" class="style34"><a href="../login.php">Se connecter</a></div></td>
<td height="8" class="style23"><img src="../images/puce_bleu.gif" width="14" height="14"></td>
</tr>
<tr valign="middle">
<td height="17" class="style23"><div align="right" class="style34">Poster un commentaire </div></td>
<td height="17" class="style23"><img src="../images/puce_bleu.gif" width="14" height="14"></td>
</tr>
<tr valign="middle">
<td colspan="2" class="style23">&nbsp;</td>
</tr>
</table></td>
<td width="524" valign="top"><table width="506" border="0" align="center">
<tr valign="top" bgcolor="#FFFFFF">
<td height="17" class="style32"><span class="style23"><img src="../images/puce_bleu.gif" width="14" height="14"></span> </td>
<td height="17" colspan="2" class="style36">&Eacute;tape1: Informations d'authentification</td>
</tr>
<tr bgcolor="#8492BD">
<td colspan="3" valign="top"><span class="style33">s</span></td>
</tr>
<tr>
<td width="16" valign="middle"><div align="right" class="style2 style21">
<div align="left"></div>
</div></td>
<td width="180" valign="middle" class="style37">Code d'acc&egrave;s :</td>
<td width="296" valign="top"><span class="style34">
<input type="text" name="codeacces" value="<?php echo $ligne["USERNAME"] ?>">
<input type="text" name="codeacces" value="<?php echo $ligne["ID"] ?>">
</span></td>
</tr>
<tr>
<td valign="middle"><div align="right" class="style23">
<div align="left"></div>
</div></td>
<td valign="middle" class="style37">Mot de passe : </td>
<td valign="top"><input name="motdepasse" type="password" value="<?php echo $ligne["PASSWD"] ?>"></td>
</tr>
<tr>
<td valign="middle">&nbsp;</td>
<td valign="middle"><div align="right" class="style37">
<div align="left">Confirmation du mot de passe : </div>
</div></td>
<td valign="top"><input name="confirmation" type="password" id="confirmation"></td>
</tr>
<tr>
<td height="21" colspan="3" valign="top"></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="17" valign="middle">
<div align="left"><span class="style23"><img src="../images/puce_bleu.gif" width="14" height="14"></span></div></td>
<td height="17" colspan="2" valign="middle"><span class="style36">&Eacute;tape 2: Informations personnelles </span></td>
</tr>
<tr bgcolor="#8492BD">
<td colspan="3" valign="top"><span class="style33">s</span></td>
</tr>
<tr>
<td valign="middle" class="style23"><div align="left"></div></td>
<td valign="middle" class="style37">Etat civil :</td>
<td valign="middle" bgcolor="#FFFFFF">
<span class="style34">
<input name="etat" type="text" value="<?php echo $ligne["CIVILITE"] ?>">
<span class="style38">ex: <span class="style39">M., Mlle, Mme</span></span> </span></td>
</tr>
<tr>
<td valign="middle" class="style23"><div align="left"></div></td>
<td valign="middle" class="style37">Nom :</td>
<td valign="middle" bgcolor="#FFFFFF"> <input name="nom" type="text" value="<?php echo $ligne["NOM"] ?>"></td>
</tr>
<tr>
<td valign="middle" class="style23"><div align="left"></div></td>
<td valign="middle" class="style37">Pr&eacute;nom :</td>
<td valign="middle" bgcolor="#FFFFFF"><input name="prenom" type="text" value="<?php echo $ligne["PRENOM"] ?>"></td>
</tr>
<tr>
<td valign="middle" class="style23"><div align="left"></div></td>
<td valign="middle" class="style37">Date de naissance : </td>
<td valign="middle" bgcolor="#FFFFFF"><input name="datenais" type="text" value="<?php echo $ligne["DATENAIS"] ?>"></td>
</tr>
<tr>
<td valign="middle" class="style23"><div align="left"></div></td>
<td valign="middle" class="style37">Adresse postale : </td>
<td valign="top"><input name="adressepost" type="text" value="<?php echo $ligne["ADRESSE"] ?>"></td>
</tr>
<tr>
<td valign="middle" class="style23"><div align="left"></div></td>
<td valign="middle" class="style37">T&eacute;l&eacute;phone Bureau : </td>
<td valign="top"><input name="telbureau" type="text" value="<?php echo $ligne["TELBUREAU"] ?>"></td>
</tr>
<tr>
<td valign="middle" class="style23"><div align="left"></div></td>
<td valign="middle" class="style37">T&eacute;l&eacute;phone domicile :</td>
<td valign="top"><input name="teldomicile" type="text" value="<?php echo $ligne["TELDOMICILE"] ?>"> </td>
</tr>
<tr>
<td valign="middle" class="style23"><div align="left"></div></td>
<td valign="middle" class="style37">T&eacute;l&eacute;phone cellulaire : </td>
<td valign="top"><input name="telcellulaire" type="text" value="<?php echo $ligne["TELCELL"] ?>"> </td>
</tr>
<tr>
<td valign="middle">&nbsp;</td>
<td valign="middle"><span class="style37">Courrier &eacute;lectronique : </span></td>
<td valign="top"><input name="courriel" type="text" value="<?php echo $ligne["COURRIEL"] ?>"> </td>
</tr>
<tr>
<td colspan="3" valign="middle">&nbsp;</td>
</tr>
<tr>
<td valign="middle"><span class="style23"><img src="../images/puce_bleu.gif" width="14" height="14"></span></td>
<td colspan="2" valign="middle"><span class="style36">&Eacute;tape 3: Fin de la modification </span></td>
</tr>
<tr bgcolor="#8492BD">
<td colspan="3" valign="middle"><span class="style33">s</span></td>
</tr>
<tr bgcolor="#FFFFFF">
<td valign="middle" class="style23">&nbsp; </td>
<td valign="middle" class="style37">Pour confirmer, cliquez sur: </td>
<td valign="middle" class="style23"><input name="Submit" type="Submit" value=" S'enregistrer ">
</td>
</tr>
</table></td>
</tr>
<tr>
<td colspan="2" class="style2"><hr></td>
</tr>
<tr>
<td height="31" colspan="2" class="style2">
<table width="738" border="0" align="center">
<tr>
<td height="26"><span class="style17">Emplacement r&eacute;serv&eacute; aux renseignements sur l'auteur du document. <br>
Copyright &copy; 2004 . Tous droits r&eacute;serv&eacute;s. </span></td>
</tr>
</table>
<div align="center"></div></td>
</tr>
</table>
</form>

</body>
</html>
 
Sort by date Sort by votes
Next of first Message

The first file was the form filled by the database
next is the update script

<?php
session_start();

?>
<style type="text/css">

</style>

<form action="inscript_modif.php" method="post" name="inscription" class="style3">
<table width="764" border="0">
<tr>
<td colspan="2"><div align="left"> <img src="../images/groupe200.jpg" width="200" height="99"> </div></td>
</tr>
<tr>
<td colspan="2"><p>
<hr>
</td>
</tr>
<tr>
<td width="230" height="98" valign="top"><table width="184" border="0" align="center">
<tr valign="middle">
<td colspan="2" bgcolor="#FFFFFF"><p align="right" class="style23 style24"><span class="style9">COMPTE<span class="style2">MON COMPTE</span></span><span class="style32"></span></p></td>
</tr>
<tr valign="middle" bgcolor="#8492BD">
<td height="3" colspan="2"><span class="style33">d</span></td>
</tr>
<tr valign="middle">
<td width="184" height="8" class="style23"><div align="right"><a href="../login.php">Se connecter</a></div></td>
<td width="14" height="8" class="style23"><img src="../images/puce_bleu.gif" width="14" height="14"></td>
</tr>
<tr valign="middle">
<td colspan="2" class="style23">&nbsp;</td>
</tr>
</table></td>
<td width="524" valign="top"><table width="506" border="0" align="center">
<tr valign="top" bgcolor="#FFFFFF">
<td height="17" class="style32"><img src="../images/rechercher.gif" width="15" height="14"> </td>
<td height="17" colspan="2" class="style32">Sommaire de l'inscription</td>
</tr>
<tr bgcolor="#8492BD">
<td colspan="3" valign="top"><span class="style33">s</span></td>
</tr>
<tr>
<td width="16" height="32" valign="middle"><div align="right" class="style2 style21">
<div align="left"></div>
</div></td>
<td colspan="2" valign="middle" class="style23"><span class="style34">
</span></td>
</tr>
<tr>
<td valign="middle"><div align="right" class="style23">
<div align="left"></div>
</div></td>
<td colspan="2" valign="middle" class="style23"><div align="justify" class="style2"><span class="style37">
<?

mysql_connect('localhost', 'devweb', 'devweb');
mysql_select_db('nsiaweb_db');



$chaine = "abcdefghijklmnopqrstuvwxyz0123456789";
$tele = str_shuffle($chaine);
$codeacces = htmlentities($_POST['codeacces']);
$motdepasse = htmlentities($_POST['motdepasse']);
$etat = htmlentities($_POST['etat']);
$nom = htmlentities($_POST['nom']);
$prenom = htmlentities($_POST['prenom']);
$datenais = addslashes($_POST['datenais']);
$adressepost = htmlentities($_POST['adressepost']);
$telbureau = htmlentities($_POST['telbureau']);
$teldomicile = htmlentities($_POST['teldomicile']);
$telcellulaire = htmlentities($_POST['telcellulaire']);
$courriel = addslashes($_POST['courriel']);

$HTTP_SESSION_VARS['nom'] = $nom;
$HTTP_SESSION_VARS['prenom'] = $prenom;
$HTTP_SESSION_VARS['codeacces'] = $codeacces;


if (!empty($codeacces) && !empty($motdepasse) && !empty($etat) && !empty($nom) && !empty($prenom) && !empty($datenais) && !empty($adressepost) && !empty($courriel))
{
$lol = mysql_query("UPDATE Utilisateur SET USERNAME='$codeacces', PASSWD='$motdepasse', CIVILITE='$etat', NOM='$nom', PRENOM='$prenom', DATENAIS='$datenais', ADRESSE='$adressepost', TELBUREAU='$telbureau', TELDOMICILE='$teldomicile', TELCELL='$telcellulaire', COURRIEL='$courriel' WHERE USERNAME ='$codeacces'") or die('erreur: '.mysql_error());

if ($lol == FALSE)
{
die ('Could not insert' . mysql_error());
}
echo "Merci, ".$HTTP_SESSION_VARS['prenom'];
echo " ".$nom;
echo ", ";
echo 'vous avez été corerctement enregistrer comme utilisateur de notre espace client. Vous pouvez maintenant vous connecter et profiter des outils mis à votre disposition';

}
else
{
echo 'Vous avez oubli&eacute; de remplir un champ! ';
echo "Merci, ".$HTTP_SESSION_VARS['prenom'];
echo '<br>';
echo 'cliquez <a href="inscription.php">ici</a> pour completer le formulaire<br>';

}
mysql_close();
?>
</span></div></td>
</tr>
<tr>
<td valign="middle">&nbsp;</td>
<td colspan="2" valign="middle" class="style23">&nbsp;</td>
</tr>
<tr bgcolor="#8492BD">
<td colspan="3" valign="middle"><span class="style33">s</span></td>
</tr>
<tr bgcolor="#FFFFFF">
<td valign="middle" class="style23">&nbsp; </td>
<td valign="middle" class="style23">&nbsp;</td>
<td valign="middle" class="style23">&nbsp; </td>
</tr>
</table></td>
</tr>
<tr>
<td colspan="2" class="style33"><hr></td>
</tr>
<tr>
<td height="31" colspan="2" class="style33">
<table width="738" border="0" align="center">
<tr>
<td><span class="style17">Emplacement r&eacute;serv&eacute; aux renseignements sur l'auteur du document. <br>
Copyright &copy; 2004 Groupe NSIA. Tous droits r&eacute;serv&eacute;s. </span></td>
</tr>
</table>
<div align="center"></div></td>
</tr>
</table>
</form>
<p class="style15">&nbsp;</p>
 
Upvote 0 Downvote
please include posted code within
Code:
tags

from a brief look it appears that you have tow input boxes on page 1 with the name 'codeacces'. the first, correctly, has the USERNAME and the second has a field called ID as its value.

php will use the second value.
 
Upvote 0 Downvote
Thanks thanks thanks thanks, I've passed 48 hours on this problem. Thanks, God bless u to answer very quickly to my message.

Once again Thanks u.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

R
  • Locked
  • Question
How Can I Use MySQL To Send Data To An Email
Replies
1
Views
376
Chris Miller
Chris Miller
cdlvj
  • Locked
  • Question
PHP Debugging
Replies
1
Views
279
cdlvj
cdlvj
W
  • Locked
  • Question
how to send checked row data in php
Replies
0
Views
134
wiltang2004
W
SashaBuilder3
  • Locked
  • Question
import CSV file into MySql table in PhpMyAdmin
Replies
0
Views
478
SashaBuilder3
SashaBuilder3
lexer
  • Locked
  • Question
Join two mysql tables for populate datatable
Replies
3
Views
322
spamjim
spamjim

Part and Inventory Search

Sponsor

Back
Top