UploadSlide($NewFileName); //move_uploaded_file($_FILES['FileInput']['tmp_name'], "../../../uploads/fotoSlide/".$NewFileName); //Mengupload langsung tanpa di re-Size $foto = $NewFileName; } $idSlide = $_POST['idSlide']; $fieldValue = array('judul' => $_POST['judulSlide'], 'keterangan' => $_POST['ket'], 'gambar' => $foto, 'status' => $_POST['statusSlide'], 'row_status' => 1); if ($idSlide == '') { $con->insert('m_slide', $fieldValue); } else { $idWhere = array('id_slide' => $idSlide); //Jika FIle Foto Diganti Maka File Foto Yang lama Harus Di Unlink if ($foto != "") { $query = "select * from m_slide where id_slide = '{$idSlide}'"; $data = $con->execQuery($query); $gambar = $data[0]['gambar']; unlink("../../../uploads/fotoSlide/{$gambar}"); unlink("../../../uploads/fotoSlide/kecil_{$gambar}"); } $con->update('m_slide', $fieldValue, $idWhere); } $hasil = $con->logQuery(); if ($con->commitQuery()) { $pesan = "Query Berhasil"; } else { $pesan = "Query Gagal"; } echo json_encode($pesan); break; default: break; }
case "hapus": $id = $_POST['id']; $idWhere = array('id_kat_product' => $id); $con->delete('m_kat_product', $idWhere); if ($con->commitQuery()) { $pesan = "Query Berhasil"; } else { $pesan = "Query Gagal"; } echo json_encode($pesan); break; case "commit": $id = $_POST['id']; $fieldValue = array('nama_kat_product' => $_POST['nama_kat'], 'row_status' => 1); if ($id == '') { $con->insert('m_kat_product', $fieldValue); } else { $idWhere = array('id_kat_product' => $id); $con->update('m_kat_product', $fieldValue, $idWhere); } $hasil = $con->logQuery(); if ($con->commitQuery()) { $pesan = "Query Berhasil"; } else { $pesan = "Query Gagal"; } echo json_encode($pesan); break; default: break; }
UploadGallery($NewFileName); //move_uploaded_file($_FILES['FileInput']['tmp_name'], "../../uploads/fotoGallery/".$NewFileName); //Mengupload langsung tanpa di re-Size $foto = $NewFileName; } $idGallery = $_POST['idGallery']; $fieldValue = array('id_kat_gallery' => $_POST['kat_galeri'], 'nama_gallery' => $_POST['nama_gallery'], 'ket_gallery' => $_POST['ket'], 'gambar_gallery' => $foto, 'row_status' => 1); if ($idGallery == '') { $con->insert('m_gallery', $fieldValue); } else { $idWhere = array('id_gallery' => $idGallery); //Jika FIle Foto Diganti Maka File Foto Yang lama Harus Di Unlink if ($foto != "") { $query = "select * from m_gallery where id_gallery = '{$idGallery}'"; $data = $con->execQuery($query); $gambar = $data[0]['gambar_gallery']; unlink("../../../uploads/fotoGallery/{$gambar}"); unlink("../../../uploads/fotoGallery/kecil_{$gambar}"); } $con->update('m_gallery', $fieldValue, $idWhere); } $hasil = $con->logQuery(); if ($con->commitQuery()) { $pesan = "Query Berhasil"; } else { $pesan = "Query Gagal"; } echo json_encode($pesan); break; default: break; }
);*/ $idWhere = array('id_pengumuman' => $idPeng); //$con->update('m_pengumuman',$fieldValue,$idWhere); $con->delete('m_pengumuman', $idWhere); if ($con->commitQuery()) { $pesan = "Query Berhasil"; } else { $pesan = "Query Gagal"; } echo json_encode($pesan); break; case "commit": $idPeng = $_POST['idPengumuman']; $fieldValue = array('judul' => $_POST['judulPeng'], 'isi' => $_POST['isi'], 'jam' => $jam_sekarang, 'hari' => $hari_ini, 'tgl_posting' => $tgl_sekarang, 'row_status' => 1); if ($idPeng == '') { $con->insert('m_pengumuman', $fieldValue); } else { $idWhere = array('id_pengumuman' => $idPeng); $con->update('m_pengumuman', $fieldValue, $idWhere); } $hasil = $con->logQuery(); if ($con->commitQuery()) { $pesan = "Query Berhasil"; } else { $pesan = "Query Gagal"; } echo json_encode($pesan); break; default: break; }
} } else { $msg = "Jenis file tidak sesuai atau ukuran file terlalu besar!"; } echo "<p align=\"center\">{$msg}</p>"; $idVD = $_POST['idVideo']; $fieldValue = array('nama' => $_POST['nama'], 'file' => $nama_file, 'tgl_posting' => $tgl_sekarang, 'row_status' => 1); if ($idVD == '') { $con->insert('m_video', $fieldValue); } else { $idWhere = array('id_video' => $idVD); if ($foto != "") { $query = "select * from m_video where id_video = '{$idVD}'"; $data = $con->execQuery($query); $file = $data[0]['file']; unlink("../../../uploads/fileVideo/{$file}"); unlink("../../../uploads/fileVideo/kecil_{$file}"); } $con->update('m_video', $fieldValue, $idWhere); } $hasil = $con->logQuery(); if ($con->commitQuery()) { $pesan = "Query Berhasil"; } else { $pesan = "Query Gagal"; } echo json_encode($pesan); break; default: break; }
UploadInformasi($NewFileName); //move_uploaded_file($_FILES['FileInput']['tmp_name'], "../../../uploads/fotoInformasi/".$NewFileName); //Mengupload langsung tanpa di re-Size $foto = $NewFileName; } $idIn = $_POST['idInformasi']; $fieldValue = array('judul' => $_POST['judulIn'], 'posisi_foto' => $_POST['pf'], 'isi' => $_POST['isi'], 'gambar' => $foto, 'jam' => $jam_sekarang, 'hari' => $hari_ini, 'tgl_posting' => $tgl_sekarang, 'row_status' => 1); if ($idIn == '') { $con->insert('m_informasi', $fieldValue); } else { $idWhere = array('id_informasi' => $idIn); //Jika FIle Foto Diganti Maka File Foto Yang lama Harus Di Unlink if ($foto != "") { $query = "select * from m_informasi where id_informasi = '{$idIn}'"; $data = $con->execQuery($query); $gambar = $data[0]['gambar']; unlink("../../../uploads/fotoInformasi/{$gambar}"); unlink("../../../uploads/fotoInformasi/kecil_{$gambar}"); } $con->update('m_informasi', $fieldValue, $idWhere); } $hasil = $con->logQuery(); if ($con->commitQuery()) { $pesan = "Query Berhasil"; } else { $pesan = "Query Gagal"; } echo json_encode($pesan); break; default: break; }
case "selectBerita": $idWhere = array('row_status' => 1); $dataBalik = $con->selectFrom('m_berita', '*', $idWhere); echo json_encode($dataBalik); break; case "selectEdit": $idberita = $_POST['id']; $idWhere = array('id_berita' => $idberita); $dataBalik = $con->selectFrom('m_berita', '*', $idWhere); echo json_encode($dataBalik); break; case "hapusFak": $idFak = $_POST['id']; $fieldValue = array('row_status' => '0'); $idWhere = array('id_fakultas' => $idFak); $con->update('m_fakultas', $fieldValue, $idWhere); if ($con->commitQuery()) { $pesan = "Query Berhasil"; } else { $pesan = "Query Gagal"; } echo json_encode($pesan); break; case "commit": $idBerita = $_POST['idBerita']; $fieldValue = array('judul' => $_POST['judulBerita'], 'isi' => $_POST['isi'], 'gambar' => $_POST['gambar'], 'row_status' => 1); if ($idBerita == '') { $con->insert('m_berita', $fieldValue); } else { $idWhere = array('id_berita' => $idBerita); $con->update('m_berita', $fieldValue, $idWhere);
UploadBerita($NewFileName); //move_uploaded_file($_FILES['FileInput']['tmp_name'], "../../../uploads/fotoBerita/".$NewFileName); //Mengupload langsung tanpa di re-Size $foto = $NewFileName; } $idBerita = $_POST['idBerita']; $fieldValue = array('judul' => $_POST['judulBerita'], 'isi' => $_POST['isi'], 'gambar' => $foto, 'jam' => $jam_sekarang, 'hari' => $hari_ini, 'tgl_posting' => $tgl_sekarang, 'row_status' => 1); if ($idBerita == '') { $con->insert('m_berita', $fieldValue); } else { $idWhere = array('id_berita' => $idBerita); //Jika FIle Foto Diganti Maka File Foto Yang lama Harus Di Unlink if ($foto != "") { $query = "select * from m_berita where id_berita = '{$idBerita}'"; $data = $con->execQuery($query); $gambar = $data[0]['gambar']; unlink("../../../uploads/fotoBerita/{$gambar}"); unlink("../../../uploads/fotoBerita/kecil_{$gambar}"); } $con->update('m_berita', $fieldValue, $idWhere); } $hasil = $con->logQuery(); if ($con->commitQuery()) { $pesan = "Query Berhasil"; } else { $pesan = "Query Gagal"; } echo json_encode($pesan); break; default: break; }