function pilih_masa($name, $select, $class)
{
$selectjam = chgdate('h', $select);
$selectminit = chgdate('i', $select);
$selectampm = chgdate('A', $select);
echo "<select name=\"" . $name . "[jam]" . "\" class=\"{$class}\" id=\"" . $name . "[jam]" . "\">";
for ($x = '1'; $x <= '12'; $x++) {
$x = str_pad($x, 2, '0', STR_PAD_LEFT);
if ($selectjam == $x) {
echo "<option selected=\"selected\" value=" . $x . ">" . $x . "</option>";
} else {
echo "<option value=" . $x . ">" . $x . "</option>";
}
}
echo "</select>";
echo "<select name=\"" . $name . "[minit]" . "\" class=\"{$class}\" id=\"" . $name . "[minit]" . "\">";
for ($x = '0'; $x <= '59'; $x++) {
$x = str_pad($x, 2, '0', STR_PAD_LEFT);
if ($selectminit == $x) {
echo "<option selected=\"selected\" value=" . $x . ">" . $x . "</option>";
} else {
echo "<option value=" . $x . ">" . $x . "</option>";
}
}
echo "</select>";
echo "<select name=\"" . $name . "[ampm]" . "\" class=\"{$class}\" id=\"" . $name . "[ampm]" . "\">";
if (strcmp(trim($selectampm), 'AM') == 0) {
$selectedam = "selected";
} elseif (strcmp(trim($selectampm), 'PM') == 0) {
$selectedpm = "selected";
}
echo "<option " . chk($selectedam) . " value=\"AM\">AM</option>";
echo "<option " . chk($selectedpm) . " value=\"PM\">PM</option>";
echo "</select>";
}
public static function table_update_all($table, $data, $condition, $dbg = 'N')
{
global $url;
$sts = '';
$darimana = $_SERVER['HTTP_REFERER'];
$url = str_replace('http://', '', $url);
$pos = strpos($darimana, $url);
if ($pos !== false) {
list($sqlfield, $stssql) = Db::query("SELECT * FROM {$table}");
$arrfield = array();
$i = Db::num_fields($sqlfield);
for ($j = 0; $j < $i; $j++) {
$fieldname = Db::field_name($sqlfield, $j);
$fieldtype[$fieldname] = Db::field_type($sqlfield, $j);
$fieldtype = array_change_key_case($fieldtype, CASE_LOWER);
array_push($arrfield, strtolower($fieldname));
}
$data = array_change_key_case($data, CASE_LOWER);
$fields = '';
foreach ($data as $field => $value) {
$value = bersih($value);
if (is_int(array_search($field, $arrfield))) {
if ($fieldtype[$field] == 'timestamp') {
if ($value != '') {
$value = chgdate('Y-m-d H:i:s', $value);
$fields = $fields . $field . "='{$value}',";
}
} elseif ($fieldtype[$field] == 'int2' or $fieldtype[$field] == 'int4' or $fieldtype[$field] == 'int8') {
if ($value != '') {
$fields = $fields . $field . "='{$value}',";
}
} else {
if ($value == '') {
$fields = $fields . $field . "=NULL,";
} else {
$fields = $fields . $field . "='{$value}',";
}
}
}
}
$fields = substr($fields, 0, -1);
$sql = "UPDATE {$table} SET {$fields} WHERE {$condition}";
if ($dbg == 'Y') {
echo "<br>DEBUG : " . $sql . "<br>";
}
$sts = Db::query($sql);
if ($sts[1] == 1) {
Db::audit_trail($sql);
}
} else {
$sts = 'Form bukan dari server ini.';
}
return $sts[1];
}
