Hallo Leute,
ich habe ein kleines Problem. ich möchte Daten aus einer Datenbank mit Hilfe eines Formulars UPDATEN. Die Ausgabe der Datensätze ins Formular funktionieren beteits.
Nur wie schreibe ich die aktualisierten Daten zurück in die Datenbank?
--------------Quellcode---------------------
//Connect to the database
$link = mysql_connect($dbhost, $dbuser, $dbpasswd) or die("Keine Verbindung zur Datenbank möglich: " . mysql_error());
mysql_select_db($db, $link) or die ('Datenbank $db kann nicht gefunden werden: ' . mysql_error());
$query = "select * from $authtable where nickname = '$nickname'";
$res = mysql_query($query);
while ($row = mysql_fetch_array($res))
{
?>
</head>
<body>
<center>
<form name="update" method="post" action="<?php echo $PHP_SELF?>">
<table width="700" border="0" cellpadding="2" cellspacing="0">
<tr>
<td colspan="3" bgcolor="#FFFFFF"><hr></td>
</tr>
<tr>
<td colspan="3" align="left" bgcolor="#FFFFFF"> <font size="3" face="Verdana, Arial, Helvetica, sans-serif">
<p style="text-indent:1cm;">Benutzerprofil bearbeiten.</p>
</font></td>
</tr>
<tr>
<td colspan="3" bgcolor="#FFFFFF"><hr></td>
</tr>
<tr bgcolor="#FFFFFF">
<td rowspan="11" valign="top" bgcolor="#FFFFFF">[img]images/info.gif[/img]</td>
<td bgcolor="#FFFFFF"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">Dein
Nickname:</font></td>
<td bgcolor="#FFFFFF"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">
<?php
echo $nickname;
?>
</font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">Dein
Vorname:</font></td>
<td bgcolor="#FFFFFF"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="vorname" size="30" value="<?php
echo $row['vorname'];
?>">
</font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">Dein
Nachname:</font></td>
<td bgcolor="#FFFFFF"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="nachname" size="30" value="<?php
echo $row['nachname'];
?>">
</font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">Straße
und Hausnummer:</font></td>
<td bgcolor="#FFFFFF"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="strasse" size="30" value="<?php
echo $row['strasse'];
?>">
</font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">Postleitzahl:</font></td>
<td bgcolor="#FFFFFF"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="plz" size="30" value="<?php
echo $row['plz'];
?>">
</font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">Wohnort:</font></td>
<td bgcolor="#FFFFFF"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="ort" size="30"value="<?php
echo $row['ort'];
?>">
</font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">Telefon:</font></td>
<td bgcolor="#FFFFFF"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="telefon" size="30" value="<?php
echo $row['telefon'];
?>">
</font></tr>
<tr bgcolor="#FFFFFF">
<td bgcolor="#FFFFFF"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">Handy:</font></td>
<td bgcolor="#FFFFFF"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="handy" size="30" value="<?php
echo $row['handy'];
?>">
</font></td>
</tr>
<tr bgcolor="#FFFFFF">
<td bgcolor="#FFFFFF"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">Deine
E-Mail:</font></td>
<td bgcolor="#FFFFFF"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="email" size="30"value="<?php
echo $row['email'];
?>">
</font></td>
</tr>
<tr bgcolor="#FFFFFF">
<td></td>
<td><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="submit" name="Submit" value="Aktualisieren">
</font></td>
</tr>
<tr bgcolor="#FFFFFF">
<td colspan="3"> <hr></td>
</tr>
<tr bgcolor="#FFFFFF">
<td colspan="3"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif"></font></td>
</tr>
</table>
</form>
</center>
<?php
if (isset($_POST['vorname'])) {
//gets the variables from the form and inserts them into PHP variables
$vorname = $_POST['vorname'];
$nachname = $_POST['nachname'];
$strasse = $_POST['strasse'];
$plz = $_POST['plz'];
$ort = $_POST['ort'];
$telefon = $_POST['telefon'];
$handy = $_POST['handy'];
$email = $_POST['email'];
$update = "UPDATE `$authtable` where 'nickname' = $nickname (`vorname`, `nachname`, `strasse`, `plz`, `ort`, `email`, `telefon`, `handy`)
VALUES('$vorname', '$nachname', '$strasse', '$plz', '$ort', '$email', '$telefon', '$handy', '$secpw')" ;
mysql_query($update);
}
else
{
?>
<table width="700" border="0" cellpadding="2" cellspacing="0">
<tr>
<td colspan="2" bgcolor="#FFFFFF"><hr></td>
</tr>
<tr>
<td colspan="2" align="left" bgcolor="#FFFFFF"> <font size="3" face="Verdana, Arial, Helvetica, sans-serif"><p style="text-indent:1cm;">
Gästebucheintrag wurde gespeichert.
</p></font></td>
</tr>
<tr>
<td colspan="2" bgcolor="#FFFFFF"><hr></td>
</tr>
<tr>
<td colspan="2" width="100" bgcolor="#FFFFFF"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif"><p style="text-align:left; margin-left:1cm; margin-right:1cm; text-align:justify;">
<?php
echo $thanksgb;
?>
</p></font></td>
</tr>
</table>
<?php
}
}
?>
</body>
</html>
--------------------------------Quellcode Exit --------------------
vielleicht hat mir jemand einen Tipp, wie das gehen könnte
Viele Grüße
Jürgen
ich habe ein kleines Problem. ich möchte Daten aus einer Datenbank mit Hilfe eines Formulars UPDATEN. Die Ausgabe der Datensätze ins Formular funktionieren beteits.
Nur wie schreibe ich die aktualisierten Daten zurück in die Datenbank?
--------------Quellcode---------------------
//Connect to the database
$link = mysql_connect($dbhost, $dbuser, $dbpasswd) or die("Keine Verbindung zur Datenbank möglich: " . mysql_error());
mysql_select_db($db, $link) or die ('Datenbank $db kann nicht gefunden werden: ' . mysql_error());
$query = "select * from $authtable where nickname = '$nickname'";
$res = mysql_query($query);
while ($row = mysql_fetch_array($res))
{
?>
</head>
<body>
<center>
<form name="update" method="post" action="<?php echo $PHP_SELF?>">
<table width="700" border="0" cellpadding="2" cellspacing="0">
<tr>
<td colspan="3" bgcolor="#FFFFFF"><hr></td>
</tr>
<tr>
<td colspan="3" align="left" bgcolor="#FFFFFF"> <font size="3" face="Verdana, Arial, Helvetica, sans-serif">
<p style="text-indent:1cm;">Benutzerprofil bearbeiten.</p>
</font></td>
</tr>
<tr>
<td colspan="3" bgcolor="#FFFFFF"><hr></td>
</tr>
<tr bgcolor="#FFFFFF">
<td rowspan="11" valign="top" bgcolor="#FFFFFF">[img]images/info.gif[/img]</td>
<td bgcolor="#FFFFFF"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">Dein
Nickname:</font></td>
<td bgcolor="#FFFFFF"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">
<?php
echo $nickname;
?>
</font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">Dein
Vorname:</font></td>
<td bgcolor="#FFFFFF"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="vorname" size="30" value="<?php
echo $row['vorname'];
?>">
</font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">Dein
Nachname:</font></td>
<td bgcolor="#FFFFFF"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="nachname" size="30" value="<?php
echo $row['nachname'];
?>">
</font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">Straße
und Hausnummer:</font></td>
<td bgcolor="#FFFFFF"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="strasse" size="30" value="<?php
echo $row['strasse'];
?>">
</font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">Postleitzahl:</font></td>
<td bgcolor="#FFFFFF"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="plz" size="30" value="<?php
echo $row['plz'];
?>">
</font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">Wohnort:</font></td>
<td bgcolor="#FFFFFF"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="ort" size="30"value="<?php
echo $row['ort'];
?>">
</font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">Telefon:</font></td>
<td bgcolor="#FFFFFF"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="telefon" size="30" value="<?php
echo $row['telefon'];
?>">
</font></tr>
<tr bgcolor="#FFFFFF">
<td bgcolor="#FFFFFF"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">Handy:</font></td>
<td bgcolor="#FFFFFF"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="handy" size="30" value="<?php
echo $row['handy'];
?>">
</font></td>
</tr>
<tr bgcolor="#FFFFFF">
<td bgcolor="#FFFFFF"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">Deine
E-Mail:</font></td>
<td bgcolor="#FFFFFF"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="email" size="30"value="<?php
echo $row['email'];
?>">
</font></td>
</tr>
<tr bgcolor="#FFFFFF">
<td></td>
<td><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="submit" name="Submit" value="Aktualisieren">
</font></td>
</tr>
<tr bgcolor="#FFFFFF">
<td colspan="3"> <hr></td>
</tr>
<tr bgcolor="#FFFFFF">
<td colspan="3"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif"></font></td>
</tr>
</table>
</form>
</center>
<?php
if (isset($_POST['vorname'])) {
//gets the variables from the form and inserts them into PHP variables
$vorname = $_POST['vorname'];
$nachname = $_POST['nachname'];
$strasse = $_POST['strasse'];
$plz = $_POST['plz'];
$ort = $_POST['ort'];
$telefon = $_POST['telefon'];
$handy = $_POST['handy'];
$email = $_POST['email'];
$update = "UPDATE `$authtable` where 'nickname' = $nickname (`vorname`, `nachname`, `strasse`, `plz`, `ort`, `email`, `telefon`, `handy`)
VALUES('$vorname', '$nachname', '$strasse', '$plz', '$ort', '$email', '$telefon', '$handy', '$secpw')" ;
mysql_query($update);
}
else
{
?>
<table width="700" border="0" cellpadding="2" cellspacing="0">
<tr>
<td colspan="2" bgcolor="#FFFFFF"><hr></td>
</tr>
<tr>
<td colspan="2" align="left" bgcolor="#FFFFFF"> <font size="3" face="Verdana, Arial, Helvetica, sans-serif"><p style="text-indent:1cm;">
Gästebucheintrag wurde gespeichert.
</p></font></td>
</tr>
<tr>
<td colspan="2" bgcolor="#FFFFFF"><hr></td>
</tr>
<tr>
<td colspan="2" width="100" bgcolor="#FFFFFF"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif"><p style="text-align:left; margin-left:1cm; margin-right:1cm; text-align:justify;">
<?php
echo $thanksgb;
?>
</p></font></td>
</tr>
</table>
<?php
}
}
?>
</body>
</html>
--------------------------------Quellcode Exit --------------------
vielleicht hat mir jemand einen Tipp, wie das gehen könnte
Viele Grüße
Jürgen

Kommentar