function sms() { foreach ($_POST as $key => $value) { if ($key == 'sms') { foreach ($value as $kekunci => $papar) { $data[$kekunci] = bersih($papar); } } } $kawan = $data['kawan']; $papar = sms_kawan($data); //'Successful!!! You have 47 SMS Credit left'; $url = URL . 'kawalan/smskes/' . $kawan . '/SMS BERJAYA DIHANTAR' . "\r" . $papar; //echo '<pre>$_POST->' . print_r($_POST , 1) . '</pre>'; //echo '<pre>$data->' . print_r($data , 1) . '</pre>'; //echo '$url->' . $url; // hantar lokasi asal header('Location:' . $url); }
public function m_ujian() { $this->cek_aktif(); //var def session $a['sess_level'] = $this->session->userdata('admin_level'); $a['sess_user'] = $this->session->userdata('admin_user'); $a['sess_konid'] = $this->session->userdata('admin_konid'); //var def uri segment $uri2 = mysql_real_escape_string($this->uri->segment(2)); $uri3 = mysql_real_escape_string($this->uri->segment(3)); $uri4 = mysql_real_escape_string($this->uri->segment(4)); //var post from json $p = json_decode(file_get_contents('php://input')); //return as json $jeson = array(); $a['data'] = $this->db->query("SELECT tr_guru_tes.*, m_mapel.nama AS mapel FROM tr_guru_tes INNER JOIN m_mapel ON tr_guru_tes.id_mapel = m_mapel.id WHERE tr_guru_tes.id_guru = '" . $a['sess_konid'] . "'")->result(); $a['p_mapel'] = obj_to_array($this->db->query("SELECT * FROM m_mapel WHERE id IN (SELECT id_mapel FROM tr_guru_mapel WHERE id_guru = '" . $a['sess_konid'] . "')")->result(), "id,nama"); if ($uri3 == "det") { $a = $this->db->query("SELECT * FROM tr_guru_tes WHERE id = '{$uri4}'")->row(); $this->j($a); exit; } else { if ($uri3 == "simpan") { $ket = ""; if ($p->id != 0) { $this->db->query("UPDATE tr_guru_tes SET id_mapel = '" . bersih($p, "mapel") . "', \n\t\t\t\t\t\t\t\tnama_ujian = '" . bersih($p, "nama_ujian") . "', jumlah_soal = '" . bersih($p, "jumlah_soal") . "', \n\t\t\t\t\t\t\t\twaktu = '" . bersih($p, "waktu") . "'\n\t\t\t\t\t\t\t\tWHERE id = '" . bersih($p, "id") . "'"); $ket = "edit"; } else { $ket = "tambah"; $this->db->query("INSERT INTO tr_guru_tes VALUES (null, '" . $a['sess_konid'] . "', '" . bersih($p, "mapel") . "',\n\t\t\t\t\t\t\t\t'" . bersih($p, "nama_ujian") . "', '" . bersih($p, "jumlah_soal") . "', '" . bersih($p, "waktu") . "', \n\t\t\t\t\t\t\t\t'acak', '')"); } $ret_arr['status'] = "ok"; $ret_arr['caption'] = $ket . " sukses"; $this->j($ret_arr); exit; } else { if ($uri3 == "hapus") { $this->db->query("DELETE FROM tr_guru_tes WHERE id = '" . $uri4 . "'"); $ret_arr['status'] = "ok"; $ret_arr['caption'] = "hapus sukses"; $this->j($ret_arr); exit; } else { if ($uri3 == "jumlah_soal") { $ambil_data = $this->db->query("SELECT id FROM m_soal WHERE id_mapel = '{$uri4}' AND id_guru = '" . $a['sess_konid'] . "'")->num_rows(); $ret_arr['jumlah'] = $ambil_data; $this->j($ret_arr); exit; } else { $a['p'] = "m_guru_tes"; } } } } $this->load->view('aaa', $a); }
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]; }