$File_Ext = substr($File_Name, strrpos($File_Name, '.')); //Mengambil ext. saja (.jpg) $Random_Number = rand(0, 9999999999); //Random number to be added to name. $NewFileName = $_POST['nama_gallery'] . $Random_Number . $File_Ext; //new file name //$FullPath = "uploads/fotoGallery/".$NewFileName; //$NewFileName = $_POST['namaPj'].$File_Ext; //new file name 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";
$File_Ext = substr($File_Name, strrpos($File_Name, '.')); //Mengambil ext. saja (.jpg) $Random_Number = rand(0, 9999999999); //Random number to be added to name. $NewFileName = $Random_Number . $File_Ext; //new file name //$FullPath = "uploads/fotoSlide/".$NewFileName; //$NewFileName = $_POST['namaPj'].$File_Ext; //new file name 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";
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; }
);*/ $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; }
if (file_exists($nama_file_baru)) { $msg = "Nama file {$nama_file} sudah ada!\n"; } else { //pindah file dari temporari ke alamat tujuan if (move_uploaded_file($tmp_name, $nama_file_baru)) { $msg = "File video {$nama_file} berhasil diupload"; } } } 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 {
$File_Ext = substr($File_Name, strrpos($File_Name, '.')); //Mengambil ext. saja (.jpg) $Random_Number = rand(0, 9999999999); //Random number to be added to name. $NewFileName = $Random_Number . $File_Ext; //new file name //$FullPath = "uploads/fotoInformasi/".$NewFileName; //$NewFileName = $_POST['namaPj'].$File_Ext; //new file name 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";
$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); } $hasil = $con->logQuery(); if ($con->commitQuery()) { $pesan = "Query Berhasil"; } else { $pesan = "Query Gagal"; } echo json_encode($pesan); break; default: break; }