ik heb een bewerk pagina gemaakt
alleen wil hij nix updaten
kan iemand mischien snel zien wat ik hier verkeerd doe:
<?php
mysql_connect("localhost", "marktxxxx", "xxxx");
mysql_select_db("marktalmeloxxxxx");
if (isset($_POST["Submit"])){
$query="UPDATE leden SET
branche= '". $_POST["$branche"] ."',
naam= '". $_POST["$naam"] ."',
bvnaam= '". $_POST["$bvnaam"] ."',
standplaats= '". $_POST["$standplaats"] ."',
mail= '". $_POST["$mail"] ."',
tel= '". $_POST["$tel"] ."',
website= '". $_POST["$website"] ."',
foto_id= '". $_POST["$foto_id"] ."',
text= '". $_POST["$text"] ."',
WHERE id='" .$_POST['id'] ."' " ;
$result = mysql_query($query) or die ("FOUT: " . mysql_error());
echo("De volgende opdracht is uitgevoerd: <b>$query</b><br>\n");
if ($result){
echo ("De gevens zijn succesvol verandert!<br>\n");
echo ("<a href=\"index.php\">Terug naar het overzicht</a>"); }
}
else
{
$query = mysql_query("SELECT * from kooplieden WHERE id = '$_GET[id]'");
while ($obj=mysql_fetch_object($query)) {
$z = $obj ->branche;
$a= $obj ->naam;
$b= $obj ->bvnaam;
$c= $obj ->standplaats;
$d= $obj ->mail;
$e= $obj ->tel;
$f= $obj ->website;
$h= $obj ->foto_id;
$i= $obj ->text;
}
?>
<form action="<?php echo($_SERVER["PHP_SELF"]);?>" method="post">
<input type="hidden" name="bevestiging" value="1">
<input type="hidden" name="id" value="<?php echo($_GET["id"]);?>">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Branche</td>
<td> </td>
</tr>
<tr>
<td><input type="text" name="branche" value="<?php echo($z);?>"></td>
<td> </td>
</tr>
<tr>
<td>Naam</td>
<td>Bvnaam</td>
</tr>
<tr>
<td><input type="text" name="naam" value="<?php echo($a);?>"></td>
<td><input type="text" name="bvnaam" value="<?php echo($b);?>"></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Standplaats</td>
<td>Mail</td>
</tr>
<tr>
<td><input type="text" name="standplaats" value="<?php echo($c);?>">
</td>
<td><input type="text" name="mail" value="<?php echo($d);?>"></td>
</tr>
<tr>
<td>Tel</td>
<td> </td>
</tr>
<tr>
<td width="48%"> <input type="text" name="tel" value="<?php echo($e);?>">
<br> </td>
<td width="52%"> </td>
</tr>
<tr>
<td> </td>
<td>Website</td>
</tr>
<tr>
<td> </td>
<td><input type="text" name="website" value="<?php echo($f);?>"></td>
</tr>
<tr>
<td>foto_id</td>
<td> </td>
</tr>
<tr>
<td><input type="text" name="foto_id" value="<?php echo($h);?>">
</td>
<td>Text</td>
</tr>
<tr>
<td> </td>
<td><textarea name="site" cols="50" rows="5"><?php echo($i);?></textarea></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="2"> <input type="Submit" value="Verzenden"> <input type="Button" value="Terug" onclick="javascript:history.back();">
</td>
</tr>
</table>
</form>
<?php } ?>
1.695 views