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]; }