Hey, ik heb een probleempje met m'n editprofile script.
Waar mense zeg maar een profiel content kunne opmaken zoals leeftijd, content, origin enzoverder.
M'n view profile werkt perfect, die haalt alles van de database... Maar als ik edit profile doe, zegt ie succesvol gewijzigd, maar... er veranderd niks in de database ofzo.
Ik ben al dagen aan het kloten zeg maar... En ik vind het gewoonweg niet.
Hieronder m'n script toegevoegd.
<?php
include("headers.php");
include("menu.php");
?>
<?php
ob_start();
$passwordthatmustbesecret = "*****";
$hostthatmustbesecret = "localhost";
$usernamethatmustbesecret = "*****";
$databasethatmustbesecret = "******";
$tbl = "tz_members";
$data->login = ($_SESSION['usr']);
mysql_query(addslashes("UPDATE tz_members SET url, info, laand, age ={$data->url}, {$data->info}, {$data->laand}, {$data->age} WHERE login={$data->login}"));
print " <tr><td class=\"mainTxt\"><a href=\"profile.php?x={$data->login}\">Look at your profile</a></td></tr>\n";
if(isset($_POST['submit'])) {
$data->login = ($_SESSION['usr']);
$data->url = preg_replace('/\</','<',$_POST['url']);
$data->info = preg_replace('/\</','<',substr($_POST['info'],0,500000));
$data->laand = preg_replace('/\</','<',substr($_POST['laand'],0,36));
$data->age = preg_replace('/\</','<',$_POST['age']);
$data->url = htmlspecialchars($data->url);
$data->laand = htmlspecialchars($data->laand);
$data->age = htmlspecialchars($data->age);
print " <tr><td class=\"mainTxt\">You successfully updated your profile!</td></tr>\n";
exit;
}
$data->url = addslashes($data->url);
$data->info = addslashes($data->info);
$data->info = str_replace("\'","'",$data->info);
$data->laand = addslashes($data->laand);
$data->age = addslashes($data->age);
?>
<tr><td class="mainTxt">
<form method="post"><table align="center">
<tr><td width=100>Country:</td> <td><input type="text" name="{$data->laand}"></td></tr>
<tr><td width=100>Age:</td> <td><input type="text" name="{$data->age}"></td></tr>
<tr><td width=100>Avatar:</td> <td><input type="text" name="{$data->url}"></td></tr>
<tr><td width=100 valign="top">Profile content:<br><br>
<td><textarea name="{$data->info}" cols=30 rows=10></textarea></td></tr>
<tr><td></td> <td align="right"><input type="submit" name="submit" value="Update"></td></tr>
</table></form></td></tr></table>
1.556 views
