I wanted to make some changes in my SQL database (delete) but before the changes can be affective the user schould get a warning... Do You really want to delete this user....
So I made a warning in Javasript... when the user confirms it should do the PHP function else do nothing... This is the code ;
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>MCS lfile opvragen</title>
<link href="styles/style_mcs.css" rel="stylesheet" type="text/css" />
<script language="javascript" src="styles/synforce.js"></script>
</head>
<body>
<script type="text/javascript">
<!--
var var1 = "zeker verwijderen ?"
var var2 = confirm(var1)
document.write(" <br> de waarde in var2 is nu = " + var2 + "<br>");
if (var2){
alert("Het dossier wordt verwijderd");
document.write( "<?php delete_file($file_id) ?>" );
document.write( "<?php echo'test in bevestiging' ?>" );
//hier zit nog iets fout php stuk w uitgevoerd ook als var2 false is
}else{
document.write( "<?php echo'else lus' ?>" );
alert("Uw aanvraag wordt geannuleerd");
}
//-->
</script>
<?php
// delete_file($file_id);
function delete_file($barcode) {
global $db;
connect_with_db();
$barcode= $_GET['bc'];
$sql="DELETE FROM intern_archiefdossier WHERE intern_archiefdossier_barcode = '$barcode'";
printf ("%s\n<br>",$sql);
$result = $db->query($sql);
}
?>
and that is not the idea....
Thx !!
