$id);
$sth = pg_exec ($dbh, $query) or die_query("Cannot update the database!", $query);
} else {
- if (!isset($starttime)) {
+ if (!isset($starttime) || !strlen($starttime)) {
$starttime = 'now()';
}
$query = sprintf ("INSERT INTO component (name,serno,starttime,endtime,owner,hwtype,price,status,comment) "
$sth = pg_exec ($dbh, $query) or die_query("Cannot update component history!", $query);
}
} else {
+ if (!isset($starttime) || !strlen($starttime)) {
+ $starttime = 'now()';
+ }
$query = sprintf ("INSERT INTO screw (component,compound,usage,starttime) "
- ."VALUES (%d,%d,'%s',%s)", $id, $compound,
+ ."VALUES (%d,%d,'%s','%s')", $id, $compound,
addslashes ($usage),
- $starttime? "'".$starttime."'" : "now()");
+ addslashes ($starttime));
$sth = pg_exec ($dbh, $query) or die_query("Cannot update component history!", $query);
}
} else {