weer sql foutDoor:
Ivo(lid)Datum: 20:21:41 07-07-2005
Stuur prive bericht
Weer op line 1 help me plz!
$query = "UPDATE `index` SET
titel = '". $_POST['titel'] ."',
pagina = '". $_POST['pagina'] ."'
WHERE id=" .$_POST['id'];
Door:
Jacob Slomp (moderator)Datum: 22:23:10 07-07-2005
Stuur prive berichtWat staat er dan bij de foutmelding?
$query = "UPDATE `index` SET
titel = '". $_POST['titel'] ."',
pagina = '". $_POST['pagina'] ."'
WHERE id=" .$_POST['id']."";
Door:
Ivo(lid)Datum: 19:36:43 08-07-2005
Stuur prive berichtok =)
aub :)
<?php
error_reporting(E_ALL);
$database ="valkenswaard";
$server ="localhost";
$user ="valkenswaard1";
$wachtwoord ="valkenswaard2";
mysql_connect("$server","$user", "$wachtwoord");
mysql_select_db("$database");
if(isset($_POST['bevestiging'])){
$query = "UPDATE `index` SET titel = '". $_POST['titel'] ."',pagina = '". $_POST['pagina'] ."' WHERE id='" .$_POST['id']."'";
$result =mysql_query($query) or die(mysql_error());
echo "Opdracht is uitgevoerd.";
if($result){
echo "Deze post is bijgewerkt";
}
}else{
$query = "SELECT * FROM `index` WHERE id=" .$_GET['id'];
$result = mysql_query($query) or die(mysql_error());
?>
<html>
<head>
<title>Bewerk:</title>
</head>
<body>
<?php
while($row = mysql_fetch_array($result)){
$titel = $row['titel'];
$pagina = $row['pagina'];
}
?>
<form action="<?php $PHP_SELF ?>" method="post">
<input type="hidden" name="bevestiging" value="1">
<input type="hidden" name="id" value="<?php echo($_GET['id']);?>">
<table width=250 border="0" cellspacing="0" cellpadding="2" bordercolor="#000000">
<tr><td>Naam:</td></tr>
<tr><td><input type="text" name="naam" value="<?php echo ("$titel"); ?>" size="15"></td></tr><br>
<tr><td>Bericht:</td></tr>
<tr><td><textarea name="bericht" rows="4" cols="40"><?php echo ("$pagina"); ?></textarea></td></tr>
<tr><td><input type="Submit" value="Bijwerken" size="15"></td></tr>
</table>
</form>
<?php } ?>
</body>
</html>
