11. juni 2005 - 22:15
Der er
7 kommentarer og 1 løsning
update fejl values er tomme
ER der ikke en der kan hjælpe denne update virker ikke det er som om den ikke får værdierne med over ... når man trykker på knappen komme man bare til forsiden og values er tomme hvis man echoer dem <?php include(realpath("./include") . "./inc/db.inc"); session_start( ); { if(isset($_POST['rediger'])) $fullname = ($_POST['fullname']); $adresse = ($_POST['adresse']); $phone = ($_POST['phone']); $email = ($_POST['email']); $zipcode = ($_POST['zipcode']); $username = ($_POST['username']); $res = ("UPDATE users set ( fullname, username, password, email, address, zipcode, phone) where username = '$authenticatedUser' VALUES ('$fullname', '$username', '$password', '$email', '$address', '$zipcode', '$phone')") ; echo $res ; mysql_query ($res) or die (mysql_error()); } $res = mysql_query("SELECT * FROM users where username = '$authenticatedUser'") ; $number = @mysql_num_rows($res); $row = @mysql_fetch_assoc($res); $email = $row["email"]; $address = $row["address"]; $navn = $row["fullname"]; $zipcode= $row["zipcode"]; $phone = $row["phone"]; $password= $row["password"]; echo "<form action=\"".$_SERVER['PHP_SELF']."\" method=\"post\">"; echo "<input type=\"text\" name=\"email\" value=\"".$email."\">"; echo "<input type=\"text\" name=\"email\" value=\"".$address."\">"; echo "<input type=\"text\" name=\"email\" value=\"".$navn."\">"; echo "<input type=\"text\" name=\"email\" value=\"".$zipcode."\">"; echo "<input type=\"text\" name=\"email\" value=\"".$phone."\">"; echo "<input type=\"text\" name=\"email\" value=\"".$password."\">"; echo "<input type=\"submit\" name=\"rediger\" value=\"Rediger\">"; echo "</form>";
Annonceindlæg fra itavis
felterne i din form hedder alle det samme..
<?php include(realpath("./include") . "./inc/db.inc"); session_start(); { if (isset($_POST['rediger'])) { $fullname = ($_POST['fullname']); $adresse = ($_POST['adresse']); $phone = ($_POST['phone']); $email = ($_POST['email']); $zipcode = ($_POST['zipcode']); $username = ($_POST['username']); $res = "UPDATE users SET (fullname, username, password, email, address, zipcode, phone) VALUES ('$fullname', '$username', '$password', '$email', '$address', '$zipcode', '$phone') WHERE username = '$authenticatedUser'"; echo $res; mysql_query ($res) or die (mysql_error()); } } $res = mysql_query("SELECT * FROM users WHERE username = '$authenticatedUser'"); $number = @mysql_num_rows($res); $row = @mysql_fetch_assoc($res); $email = $row["email"]; $address = $row["address"]; $fullname = $row["fullname"]; $zipcode= $row["zipcode"]; $phone = $row["phone"]; $password= $row["password"]; echo "<form action=\"" . $_SERVER['PHP_SELF'] . "\" method=\"post\">"; echo "<input type=\"text\" name=\"email\" value=\"" . $email . "\">"; echo "<input type=\"text\" name=\"address\" value=\"" . $address . "\">"; echo "<input type=\"text\" name=\"fullname\" value=\"" . $fullname . "\">"; echo "<input type=\"text\" name=\"zipcode\" value=\"" . $zipcode . "\">"; echo "<input type=\"text\" name=\"phone\" value=\"" . $phone . "\">"; echo "<input type=\"password\" name=\"password\" value=\"" . $password . "\">"; echo "<input type=\"submit\" name=\"rediger\" value=\"Rediger\">"; echo "</form>";
den lister stadig væk tomme værdier nu også i echo "<input type=\"text\" name=\"email\" value=\"" . $email . "\">"; echo "<input type=\"text\" name=\"address\" value=\"" . $address . "\">"; echo "<input type=\"text\" name=\"fullname\" value=\"" . $fullname . "\">"; echo "<input type=\"text\" name=\"zipcode\" value=\"" . $zipcode . "\">"; echo "<input type=\"text\" name=\"phone\" value=\"" . $phone . "\">"; echo "<input type=\"password\" name=\"password\" value=\"" . $password . "\">"; echo "<input type=\"submit\" name=\"rediger\" value=\"Rediger\">";
hele koden <?php include(realpath("./include") . "../inc/db.inc"); session_start(); { if (isset($_POST['rediger'])) { $fullname = ($_POST['fullname']); $adresse = ($_POST['adresse']); $phone = ($_POST['phone']); $email = ($_POST['email']); $zipcode = ($_POST['zipcode']); $username = ($_POST['username']); $res = "UPDATE users set fullname='$fullname', username='$username', password='$password', email='$email', address='$address', zipcode='$zipcode', phone='$phone' where username='$authenticatedUser' "; echo $res; mysql_query ($res) or die (mysql_error()); } } $res = mysql_query("SELECT * FROM users WHERE username = '$authenticatedUser'"); $number = @mysql_num_rows($res); $row = @mysql_fetch_assoc($res); $email = $row["email"]; $address = $row["address"]; $fullname = $row["fullname"]; $zipcode= $row["zipcode"]; $phone = $row["phone"]; $password= $row["password"]; echo "<form action=\"pages/indstillinger_ret.php\" method=\"post\">"; echo "<input type=\"text\" name=\"email\" value=\"" . $email . "\">"; echo "<input type=\"text\" name=\"address\" value=\"" . $address . "\">"; echo "<input type=\"text\" name=\"fullname\" value=\"" . $fullname . "\">"; echo "<input type=\"text\" name=\"zipcode\" value=\"" . $zipcode . "\">"; echo "<input type=\"text\" name=\"phone\" value=\"" . $phone . "\">"; echo "<input type=\"password\" name=\"password\" value=\"" . $password . "\">"; echo "<input type=\"submit\" name=\"rediger\" value=\"Rediger\">"; echo "</form>";
sorry du har ret det virker .. kan du fortælle mig hvad det var der var galt og lige smide et svar
Hvis du kigger nøje efter navnene på input-felterne i din originale form, så vil du se at du har givet allesammen navnet "email" (det var også det som ksoren sagde). Dermed var det kun det ene felt som nogensinde kunne have en værdi. Jeg rettede felterne til og ordnede samtidige en lille håndfuld andre fejl i din kode.
ahh nu ser jeg det takker
Vi tilbyder markedets bedste kurser inden for webudvikling