$connection=mysql_connect("localhost","root","pass");
mysql_select_db("webdd");
$a = $_POST['login'];
$b = $_POST['passe'];
$c = $_POST['email'];
$d = $_POST['nom'];
$e = $_POST['prenom'];
$f = $_POST['adresse'];
$g = $_POST['ville'];
$h = $_POST['tel'];
mysql_query("UPDATE prestataire SET (login='$a', passe='$b' , email='$c',nom='$d', prenom='$e', adresse='$f', ville='$g', tel='$h' )WHERE login = '$a' )");
mysql_close();
header("location:profile.php");
你的代码
mysql_query("UPDATE prestataire SET (login='$a', passe='$b' , email='$c',nom='$d', prenom='$e', adresse='$f', ville='$g', tel='$h' )WHERE login = '$a' )");
try like this
$sql = "UPDATE prestataire SET (login='$a', passe='$b' , email='$c',nom='$d', prenom='$e', adresse='$f', ville='$g', tel='$h' )";
$request = mysql_query($sql);
更好的方法
$sql = "UPDATE prestataire SET passe='$b' , email='$c',nom='$d', prenom='$e', adresse='$f', ville='$g', tel='$h' WHERE login='$a'";
你在更新中提到两次登录,在WHERE
中提到第二次登录-你不需要提到两次登录
如果仍然没有,则回显$sql
p。