$sql = sprintf('SELECT id,%s FROM %s WHERE id = %d',
implode(',', array_keys($mask['edit'])),
$mask['table'], $_POST['id']);
- error_log($sql);
+
$sth = pg_query($sql);
+ if ($sth === false) return false;
+
+ $row = pg_fetch_assoc($sth);
+
+ foreach ($mask['edit']['list'] as $field => $info)
+ if (array_key_exists('format', $info))
+ $row[$field] = sprintf($info['format'], $row[$field]);
+
+ return $row;
}
function details($mask)
$sql = sprintf('SELECT id,%s FROM %s WHERE id = %d',
implode(',', array_keys($mask['details']['list'])),
$mask['table'], $_POST['id']);
- error_log($sql);
+
$sth = pg_query($sql);
if (!$sth)