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
37
38
|
<?php
$formid = "Drawing";
require_once "inc/configure.php";
$refid = filter_var($_REQUEST['refid'], FILTER_SANITIZE_NUMBER_INT);
$custcode = filter_var($_REQUEST['custcode'], FILTER_SANITIZE_STRING);
$fmproduct = filter_var($_REQUEST['fmproduct'], FILTER_SANITIZE_STRING);
$productrefid = filter_var($_REQUEST['productrefid'], FILTER_SANITIZE_STRING);
$lastupby = filter_var($_SESSION['user'], FILTER_SANITIZE_STRING);
if( !empty($refid) ){
if( $custcode==="" ){
$custcode = "XXX";
}
$sql = "UPDATE dgn_master_mold SET
drawing_no = :drawing_no,
lastupby = :lastupby,
lastupdate = GETDATE()
WHERE refid = :refid";
$sth = $dbh->prepare($sql);
$q = $sth->execute( array(':drawing_no' => getNewProdDrawingNum($custcode),
':lastupby' => $lastupby,
':refid' => $refid) );
pdo_showerror($sth, $q);
header("Location: dgn_master_modifyform.php?edit=1&refid=$refid&fmproduct=$fmproduct&productrefid=$productrefid&msg=Saved.");
print "Saved.";
exit;
}
myerror("Invalid Request");
?>
|