update forum mysql
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
<?
include('../include/config.php');
$query = mysql_query("SELECT * FROM users WHERE id = '".$_SESSION['user_id']."'");
if(!$submit){
while($object = mysql_fetch_object($query)){
?>
<form method="POST" action="<? echo $PHP_SELF ?>">
Naam:<br>
<input type="text" name="name" size="30" value="<? echo $object->username ?>"><br>
Email adres:<br>
<input type="text" name="email" size="30" value="<? echo $object->email ?>"><br>
<? $geb = explode("-",$object->birthdate); ?>
birthdate ( dd-mm-jjjj ):<br>
<input type="text" name="geb1" size="2" maxlength="2" value="<? echo $geb[0] ?>"> -
<input type="text" name="geb2" size="2" maxlength="2" value="<? echo $geb[1] ?>"> -
<input type="text" name="geb3" size="4" maxlength="4" value="<? echo $geb[2] ?>">
<br><br>
Role play description:<br>
<textarea name="descriptionrp" rows="3"><? echo htmlspecialchars($object->descriptionrp); ?></textarea><br>
<br>
<br>
<input type="submit" value="Opslaan"> <input type="reset" value="Reset"></p>
</form>
<?
}
$birthdate = "$geb1-$geb2-$geb3";
}else{
mysql_query("UPDATE users SET username='$username', email='$email', birthdate='$birthdate', descriptionrp='$descriptionrp' WHERE id='".$_SESSION['user_id']."'") or die(mysql_error());
echo "Gegevens zijn succesvol opgeslagen...";
}
?>
include('../include/config.php');
$query = mysql_query("SELECT * FROM users WHERE id = '".$_SESSION['user_id']."'");
if(!$submit){
while($object = mysql_fetch_object($query)){
?>
<form method="POST" action="<? echo $PHP_SELF ?>">
Naam:<br>
<input type="text" name="name" size="30" value="<? echo $object->username ?>"><br>
Email adres:<br>
<input type="text" name="email" size="30" value="<? echo $object->email ?>"><br>
<? $geb = explode("-",$object->birthdate); ?>
birthdate ( dd-mm-jjjj ):<br>
<input type="text" name="geb1" size="2" maxlength="2" value="<? echo $geb[0] ?>"> -
<input type="text" name="geb2" size="2" maxlength="2" value="<? echo $geb[1] ?>"> -
<input type="text" name="geb3" size="4" maxlength="4" value="<? echo $geb[2] ?>">
<br><br>
Role play description:<br>
<textarea name="descriptionrp" rows="3"><? echo htmlspecialchars($object->descriptionrp); ?></textarea><br>
<br>
<br>
<input type="submit" value="Opslaan"> <input type="reset" value="Reset"></p>
</form>
<?
}
$birthdate = "$geb1-$geb2-$geb3";
}else{
mysql_query("UPDATE users SET username='$username', email='$email', birthdate='$birthdate', descriptionrp='$descriptionrp' WHERE id='".$_SESSION['user_id']."'") or die(mysql_error());
echo "Gegevens zijn succesvol opgeslagen...";
}
?>
Gewijzigd op 01/01/1970 01:00:00 door Marcel Sikkema
Code (php)
1
<?php en ?>
knop om dit te doen.En stel ook een duidelijke vraag,
SanThe.
Gewijzigd op 01/01/1970 01:00:00 door - SanThe -
Het is inmiddels 2009, een jaar of tig na de ontdekking van de superglobals en de gruwelijke veiligheidslekken in PHP. Gooi bovenstaande ellende weg en begin opnieuw, de code is hooooooopeloos verouderd en staat leuk in een museum.
maar update doet die ook niet, hij haald de gegevens wel op maar verder doet die er niets mee
Volgens mij was strict o.a voor functies (functionaliteit) die verwijderd worden in een nieuwe versie van PHP.
Gewijzigd op 01/01/1970 01:00:00 door Martijn B
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
<?
$result_profile = mysql_query("SELECT * FROM users WHERE id='".$_SESSION['user_id']."'") or die (mysql_error());
while($profile = mysql_fetch_assoc($result_profile))
{
$name = $profile["username"];
$email = $profile["email"];
$rp = $profile["descriptionrp"];
$birthdate = $profile["birthdate"];
}
?>
<form method="POST">
Naam:<br>
<input type="text" name="name" size="30" value="<? echo $name ?>"><br>
Email adres:<br>
<input type="text" name="email" size="30" value="<? echo $email ?>"><br>
<? $geb = explode("-",$birthdate); ?>
birthdate ( dd-mm-jjjj ):<br>
<input type="text" name="geb1" size="2" maxlength="2" value="<? echo $geb[0] ?>"> -
<input type="text" name="geb2" size="2" maxlength="2" value="<? echo $geb[1] ?>"> -
<input type="text" name="geb3" size="4" maxlength="4" value="<? echo $geb[2] ?>">
<br><br>
Role play description:<br>
<textarea name="rp" cols="30" rows="5"><? echo htmlspecialchars($rp); ?></textarea>
<br>
<br>
<br>
<input name="submit" type="submit" id="submit" value="submit">
<input type="reset" value="Reset"></p>
</form>
<?
if (isset($_POST["submit"])){
$p_name = $_POST['name'];
$p_email = $_POST["email"];
$p_birthdate = $_POST['geb1'] . '-' .$_POST['geb2'] . '-' .$_POST['geb3'];
$p_rp = $_POST["rp"];
$result = mysql_query("UPDATE users SET username='$p_name', email='$p_email', birthdate='$p_birthdate', descriptionrp='$p_rp' WHERE id='".$_SESSION['user_id']."'") or die (mysql_error());
echo "<b>Thank you! UPDATED Successfully!<br>";
}
?>
$result_profile = mysql_query("SELECT * FROM users WHERE id='".$_SESSION['user_id']."'") or die (mysql_error());
while($profile = mysql_fetch_assoc($result_profile))
{
$name = $profile["username"];
$email = $profile["email"];
$rp = $profile["descriptionrp"];
$birthdate = $profile["birthdate"];
}
?>
<form method="POST">
Naam:<br>
<input type="text" name="name" size="30" value="<? echo $name ?>"><br>
Email adres:<br>
<input type="text" name="email" size="30" value="<? echo $email ?>"><br>
<? $geb = explode("-",$birthdate); ?>
birthdate ( dd-mm-jjjj ):<br>
<input type="text" name="geb1" size="2" maxlength="2" value="<? echo $geb[0] ?>"> -
<input type="text" name="geb2" size="2" maxlength="2" value="<? echo $geb[1] ?>"> -
<input type="text" name="geb3" size="4" maxlength="4" value="<? echo $geb[2] ?>">
<br><br>
Role play description:<br>
<textarea name="rp" cols="30" rows="5"><? echo htmlspecialchars($rp); ?></textarea>
<br>
<br>
<br>
<input name="submit" type="submit" id="submit" value="submit">
<input type="reset" value="Reset"></p>
</form>
<?
if (isset($_POST["submit"])){
$p_name = $_POST['name'];
$p_email = $_POST["email"];
$p_birthdate = $_POST['geb1'] . '-' .$_POST['geb2'] . '-' .$_POST['geb3'];
$p_rp = $_POST["rp"];
$result = mysql_query("UPDATE users SET username='$p_name', email='$p_email', birthdate='$p_birthdate', descriptionrp='$p_rp' WHERE id='".$_SESSION['user_id']."'") or die (mysql_error());
echo "<b>Thank you! UPDATED Successfully!<br>";
}
?>
Heb het aan gepast, krijg nu alleen na de submit de oude data te zien.
pas na het herladen van de pagina laat die de geupdate info zien.
wat kan ik daar aan doen ?
Gewijzigd op 01/01/1970 01:00:00 door Marcel Sikkema
Kortom, zorg voor de juiste volgorde.