Formulier wat alles ophaalt en de mogelijkheid geeft gegevens aan te passen...
[code]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://
www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">;
<html xmlns="http://
www.w3.org/1999/xhtml">;
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Notitie aanpassen</title>
<style type="text/css">
#bestellen table {
text-align: center;
}
</style>
<script type="text/javascript">
// Popup window code
function newPopup(url) {
popupWindow = window.open(
url,'popUpWindow','height=500,width=800,left=10,top=10,resizable=yes,scrollbars=yes,toolbar=yes,menubar=no,location=no,directories=no,status=yes')
}
</script>
</head>
<body>
<?php
require_once 'db_config.php';
include 'menu.php';
?>
<br><br><br><br>
WERKT NOG NIET !
<?php
$sql = "
SELECT
*
FROM
pakket
WHERE id= ' ".$_GET['id']." '
";
?>
<br>
<center>
<table border='0'>
<tr>
<td> </td>
<td> </td>
</tr>
<?php
$result = mysql_query($query);
if(!$res = mysql_query($sql))
{
trigger_error(mysql_error().'<br />In query: '.$sql);
}
while($row = mysql_fetch_assoc($res))
{
{
echo "<form action=http://
www.####.nl/slijter/test.php method=opslaan>\n";
echo "<tr>\n";
echo "<td> </td>\n";
echo "<td><a href=JavaScript:newPopup('print.php?id=".$row["id"]."');>Print</a><td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td></td>\n";
echo "<td><input type='hidden' name='id' value=".$row["id"]."></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td>Gemeld:</td>\n";
echo "<td><input type='text' name='datum' value=".$row["datum"]."></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td>Bestelnummer:#</td>\n";
echo "<td><input type='text' name='sku' value=".$row["sku"]."></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td>Naam:</td>\n";
echo "<td><input type='text' name='naam' value=".$row["naam"]."></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td>Optie:</td>\n";
echo "<td><select name=land><option value=".$row["land"]." >".$row["land"]."</option>
<option value=Nederland >Nederland</option>
<option value=Belgie >Belgie</option>
<option value=Duitsland >Duitsland</option>
</select></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td>Reden:</td>\n";
echo "<td><input type='text' name='reden' value=".$row["reden"]."></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td>Afhaal datum:</td>\n";
echo "<td><input type='text' name='afhaal' value=".$row["afhaal"]."></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td>Ontvangen:</td>\n";
echo "<td><input type='text' name='ontvangen' value=".$row["ontvangen"]."></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td>Optie:</td>\n";
echo "<td><select name=optie><option value=".$row["optie"]." >".$row["optie"]."</option>
<option value=juiste >Juiste toezenden</option>
<option value=crediteren >Crediteren</option>
<option value=opgelost >Al opgelost</option>
<option value=Anders >Anders, zie mail</option>
</select></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td>Afgerond:</td>\n";
echo "<td><input type='text' name='afgerond' value=".$row["afgerond"]."></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td>Notitie:</td>\n";
echo "<td><textarea name='note' rows='5' cols='40' value=".$row["note"]."></textarea></td>\n";
echo "</tr>\n";
}
}
?>
</table>
<input type="submit" name="POST" value="opslaan">
</form>
</center>
</body>
</html>
[\code]
Formulier wat het zou moeten aanpassen
[code]
<?php
error_reporting(E_ALL | E_STRICT);
ini_set('display_errors', 1);
include ("db_config.php");
if ($_SERVER['REQUEST_METHOD']=="POST")
{
//alle namen uit de post ophalen en elk in een aparte variable zetten.
$naam = mysql_real_escape_string($_POST['naam']);
$datum = mysql_real_escape_string($_POST['datum']);
$sku = mysql_real_escape_string($_POST['sku']);
$reden = mysql_real_escape_string($_POST['reden']);
$optie = mysql_real_escape_string($_POST['optie']);
$ontvangen = mysql_real_escape_string($_POST['ontvangen']);
$land = mysql_real_escape_string($_POST['land']);
$afhaal = mysql_real_escape_string($_POST['afhaal']);
$afgerond = mysql_real_escape_string($_POST['afgerond']);
$note = mysql_real_escape_string($_POST['note']);
$sql = "UPDATE pakket SET
naam = '$naam',
datum = '$datum',
sku = '$sku',
reden = '$reden',
optie = '$optie',
ontvangen = '$ontvangen',
land = '$land',
afhaal = '$afhaal' ,
afgerond = '$afgerond',
note = '$note'
WHERE
id='".$_GET['id']."'";
$update = mysql_query($sql)or die(mysql_error());
}
?>
<br>
<center>
<form action=" <?=$_SERVER['PHP_SELF']?> " method="POST">
<table border='0'>
<tr>
<td> </td>
<td> </td>
</tr>
<?php
echo "<tr>\n";
echo "<td>Gemeld:</td>\n";
echo "<td>".$_GET["datum"]."</td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td>Bestelnummer:#</td>\n";
echo "<td>".$_GET["sku"]."</td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td>Naam:</td>\n";
echo "<td>".$_GET["naam"]."</td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td>Land:</td>\n";
echo "<td>".$_GET["land"]."</td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td>Reden:</td>\n";
echo "<td>".$_GET["reden"]."</td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td>Afhaal datum:</td>\n";
echo "<td>".$_GET["afhaal"]."</td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td>Ontvangen:</td>\n";
echo "<td>".$_GET["ontvangen"]."</td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td>Keuze:</td>\n";
echo "<td>".$_GET["optie"]."</td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td>Optie:</td>\n";
echo "<td>".$_GET["optie"]."</td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td>Afgerond:</td>\n";
echo "<td>".$_GET["afgerond"]."</td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td>Notitie:</td>\n";
echo "<td>".$_GET["note"]."</td>\n";
echo "</tr>\n";
?>
</table>
<input type="submit" name="POST" value="opslaan">
</form>
</center>
[\code]
