$kota_id = $form->input('kota_id');
$kecamatan_id = $form->input('kecamatan_id');
$desa_id = $form->input('desa_id');
$hp = $form->input('hp');
$telp_rumah = $form->input('telp_rumah');
$telp_kantor = $form->input('telp_kantor');
$faksimil = $form->input('faksimil');
$email = $form->input('email');
$action = $form->input('action');
$user = $_SESSION['nama'];
$date = date('Y-m-d H:i:s');
// START INSERT DATA ==============================>
if ($action == "insert") {
$foto = $_FILES['foto']['name'];
$id = $number->id('anggota', 5);
$kta_baru = $number->kta($desa_id, $tgl_lahir, $id);
if (empty($foto)) {
$foto = "user.png";
} else {
$source = $_FILES['foto']['tmp_name'];
$image->upload($foto, $source);
$image->thumbnail($foto);
}
$sql = "INSERT INTO anggota\n (id,nama, id_tipe, id_no, jabatan, tempat, tgl_lahir, jns_kelamin, agama,\n pernikahan, pekerjaan_id, pendidikan, alamat, rt, rw, propinsi_id, kota_id, kecamatan_id,\n desa_id, hp, telp_rumah, telp_kantor, faksimil, email, foto, kta_baru, aktif, crt, crt_date) \n VALUES \n ('{$id}','{$nama}','{$id_tipe}','{$id_no}','{$jabatan}','{$tempat}','{$tgl_lahir}','{$jns_kelamin}','{$agama}',\n '{$pernikahan}','{$pekerjaan_id}','{$pendidikan}','{$alamat}','{$rt}','{$rw}','{$propinsi_id}','{$kota_id}','{$kecamatan_id}',\n '{$desa_id}','{$hp}','{$telp_rumah}','{$telp_kantor}','{$faksimil}','{$email}','{$foto}','{$kta_baru}','{$aktif}','{$user}','{$date}')";
if (!$database->query($sql)) {
die($sql);
} else {
$_SESSION['success'] = "<b>Berhasil!</b> Anda telah menambahkan data baru";
header("Location: create.php");
exit;
}
