mijn probleem is is dat ik mijn variabele (in het formulier hidden en genaamd id) niet door. als ik de string laat zien krijg ik geen variabele te zien
dit is mijn code:
<?php
session_start();
include("../sql/connect.php");
if( isset( $_SESSION["logged"] ) )
{
if( isset( $_POST["bev"] ) )
{
$begin_datum = $_POST["day"]."-".$_POST["month"]."-".$_POST["year"];
$eind_datum = $_POST["day2"]."-".$_POST["month2"]."-".$_POST["year2"];
$begin_dat = mysql_real_escape_string( $begin_datum );
$eind_dat = mysql_real_escape_string( $eind_datum );
$naam = mysql_real_escape_string( $_POST["naam"] );
$titel = mysql_real_escape_string( $_POST["titel"] );
$omschr = mysql_real_escape_string( $_POST["omschr"] );
$sql = "UPDATE taken SET naam='".$naam."', titel='".$titel."', omschr='".$omschr."', beg_dat='".$begin_dat."', eind_dat='".$eind_dat."', status='".$_POST["stat"]."' WHERE id='".$_POST["id"]."'";
//$result = mysql_query( $sql );
echo( $id );
echo("<br> ");
echo( $_POST["id"] );
echo("<br> ");
echo( $sql );
//if( $SESSION["function"] == "behandelaar" )
//{
// header("location: eigen.php");
//}
//if( $SESSION["function"] == "beheerder" )
//{
// header("location: beheer.php");
//}
}
else
{
$id = $_GET["id"];
$sql = "SELECT * FROM taken WHERE id = '".$id."'";
$result = mysql_query( $sql );
while( $row = mysql_fetch_array( $result ) )
{
$date = $row["beg_dat"];
list( $day, $month, $year ) = explode( '-',$date );
$date2 = $row["eind_dat"];
list( $day2, $month2, $year2 ) = explode( '-',$date2 );
?>
<form name="upd_taak" method="POST" action="<?php echo( $_SERVER["PHP_SELF"] ); ?>">
Naam: <input type="text" name="naam" value="<?php echo( $row["naam"] ); ?>"><br>
Titel: <input type="text" name="titel" value="<?php echo( $row["titel"] ); ?>"><br>
Omschrijving:<br>
<textarea cols="15" rows="4" name="omschr"><?php echo( $row["omschr"] ); ?></textarea><br><br>
Begin datum (dd-mm-yyyy): <input type="text" name="day" value="<?php echo( $day ); ?>" size="2"> - <input type="text" name="month" value="<?php echo( $month ); ?>" size="2"> - <input type="text" name="year" value="<?php echo( $year ); ?>" size="4"><br>
Eind datum (dd-mm-yyyy): <input type="text" name="day2" value="<?php echo( $day2 ); ?>" size="2"> - <input type="text" name="month2" value="<?php echo( $month2 ); ?>" size="2"> - <input type="text" name="year2" value="<?php echo( $year2 ); ?>" size="4"><br><br>
<select name="stat">
<option value="non-actief">Non-Actief</option>
<option value="klaar">Klaar</option>
<option value="bezig">Bezig</option>
</select><br><br>
<input type="hidden" name="bev" value="1"
<input type="hidden" name="id" value="<?php echo( $row["id"] ); ?>">
<input type="submit" name="submit" value="Update"> <input type="reset" name="reset" value="Alles leegmaken"> <input type="button" value="terug" onClick="parent.history.back();">
</form>
<?php
}
}
}
else
{
echo("Eerst inloggen aub.");
}
?>
met vriendelijke groet,
Jasper
dit is mijn code:
<?php
session_start();
include("../sql/connect.php");
if( isset( $_SESSION["logged"] ) )
{
if( isset( $_POST["bev"] ) )
{
$begin_datum = $_POST["day"]."-".$_POST["month"]."-".$_POST["year"];
$eind_datum = $_POST["day2"]."-".$_POST["month2"]."-".$_POST["year2"];
$begin_dat = mysql_real_escape_string( $begin_datum );
$eind_dat = mysql_real_escape_string( $eind_datum );
$naam = mysql_real_escape_string( $_POST["naam"] );
$titel = mysql_real_escape_string( $_POST["titel"] );
$omschr = mysql_real_escape_string( $_POST["omschr"] );
$sql = "UPDATE taken SET naam='".$naam."', titel='".$titel."', omschr='".$omschr."', beg_dat='".$begin_dat."', eind_dat='".$eind_dat."', status='".$_POST["stat"]."' WHERE id='".$_POST["id"]."'";
//$result = mysql_query( $sql );
echo( $id );
echo("<br> ");
echo( $_POST["id"] );
echo("<br> ");
echo( $sql );
//if( $SESSION["function"] == "behandelaar" )
//{
// header("location: eigen.php");
//}
//if( $SESSION["function"] == "beheerder" )
//{
// header("location: beheer.php");
//}
}
else
{
$id = $_GET["id"];
$sql = "SELECT * FROM taken WHERE id = '".$id."'";
$result = mysql_query( $sql );
while( $row = mysql_fetch_array( $result ) )
{
$date = $row["beg_dat"];
list( $day, $month, $year ) = explode( '-',$date );
$date2 = $row["eind_dat"];
list( $day2, $month2, $year2 ) = explode( '-',$date2 );
?>
<form name="upd_taak" method="POST" action="<?php echo( $_SERVER["PHP_SELF"] ); ?>">
Naam: <input type="text" name="naam" value="<?php echo( $row["naam"] ); ?>"><br>
Titel: <input type="text" name="titel" value="<?php echo( $row["titel"] ); ?>"><br>
Omschrijving:<br>
<textarea cols="15" rows="4" name="omschr"><?php echo( $row["omschr"] ); ?></textarea><br><br>
Begin datum (dd-mm-yyyy): <input type="text" name="day" value="<?php echo( $day ); ?>" size="2"> - <input type="text" name="month" value="<?php echo( $month ); ?>" size="2"> - <input type="text" name="year" value="<?php echo( $year ); ?>" size="4"><br>
Eind datum (dd-mm-yyyy): <input type="text" name="day2" value="<?php echo( $day2 ); ?>" size="2"> - <input type="text" name="month2" value="<?php echo( $month2 ); ?>" size="2"> - <input type="text" name="year2" value="<?php echo( $year2 ); ?>" size="4"><br><br>
<select name="stat">
<option value="non-actief">Non-Actief</option>
<option value="klaar">Klaar</option>
<option value="bezig">Bezig</option>
</select><br><br>
<input type="hidden" name="bev" value="1"
<input type="hidden" name="id" value="<?php echo( $row["id"] ); ?>">
<input type="submit" name="submit" value="Update"> <input type="reset" name="reset" value="Alles leegmaken"> <input type="button" value="terug" onClick="parent.history.back();">
</form>
<?php
}
}
}
else
{
echo("Eerst inloggen aub.");
}
?>
met vriendelijke groet,
Jasper