1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36

<?php 
$formid = "Drawing";
require_once "inc/configure.php";

$refid             = filter_var($_REQUEST['refid'], FILTER_SANITIZE_NUMBER_INT);
$finished         = filter_var($_REQUEST['finished'], FILTER_SANITIZE_STRING);
$lastupby        = filter_var($_SESSION['user'], FILTER_SANITIZE_STRING);

if( !empty($refid) ){

    if( $finished==="" ){
        $finished = 1; //hide the record
    }

    $sql = "UPDATE dgn_drawing SET 
                finished = :finished,
                lastupby = :lastupby,
                lastupdate = GETDATE()
            WHERE refid = :refid";    

    $sth = $dbh->prepare($sql);
    $q = $sth->execute( array(':finished' => $finished,
                                ':lastupby' => $lastupby,
                                ':refid' => $refid) );
    pdo_showerror($sth, $q);

    header("Location: dgn_drawing_modifyform.php?edit=1&refid=$refid&msg=Saved."); 
    print "Saved.";
    exit;
    
    
}
myerror("Invalid Request");


?>