/** * * @param resource $conn * @param string $tabla * @param string $param * @param string $SQLserverNameBack * @return array */ function actualizar($conn, $tabla, $param, $where, $SQLserverName) { global $respError; $resultadoUpdate = queryUpdate($conn, $tabla, $param, $where, $SQLserverName); //die(print_r($resultadoUpdate)); if (is_array($resultadoUpdate)) { $resultadoOperacion = array("codigoResultadoOperacion" => $resultadoUpdate[0]["code"], "mensajeResultadoOperacion" => $resultadoUpdate[0]["message"]); return array(__FUNCTION__ . "Result" => array("columnasAfectadas" => 0, "resultadoOperacion" => $resultadoOperacion)); } return array(__FUNCTION__ . "Result" => array("columnasAfectadas" => $resultadoUpdate, "resultadoOperacion" => $respError->sinErrores())); }
function getLogin($username, $password) { $user = null; $user = querySelect('*', 'user', 'username = "******" AND password = "******"', '0,1'); if (sizeof($user) != 0) { $date = date_create(); $date = date_timestamp_get($date); $session = md5($password . $date); $update = queryUpdate('user', 'session = "' . $session . '"', 'username = "******" AND password = "******"'); if (!$update) { $user = null; } else { $user = querySelect('*', 'user', 'session = "' . $session . '"', '0,1'); } } return $user; }
try { $finalImg = ImageHandler::getGalleryPicture($imageName); $insertGallery = queryInsert('galeri (id_masjid, alamat_foto)', $id_masjid . ',"' . $finalImg . '"'); echo "sukses upload"; } catch (Exception $ex) { echo $ex; } } } } $updateFotoGaleri = null; if (isset($_POST['judulGaleri'])) { $judulGaleri = $_POST['judulGaleri']; $idGaleri = $_POST['idGaleri']; for ($j = 0; $j < count($judulGaleri); $j++) { $updateFotoGaleri = queryUpdate('galeri', 'judul_foto="' . $judulGaleri[$j] . '"', 'id_foto=' . $idGaleri[$j]); } } if (isset($_POST['hapusGaleri'])) { $hapusGaleri = $_POST['hapusGaleri']; $nHapusGaleri = count($hapusGaleri); for ($i = 0; $i < $nHapusGaleri; $i++) { queryDelete('galeri', "id_foto='" . $hapusGaleri[$i] . "'"); } } if ($insertGallery = true && ($updateFotoGaleri = true)) { header('location:http://localhost/SIMasjid/view/AdminMasjid/galeri.php?status=true'); } else { if ($insertGallery = true && ($updateFotoGaleri = null)) { header('location:http://localhost/SIMasjid/view/AdminMasjid/galeri.php?status=true'); } else {
$id_masjid = $selectMasjid[0]['id_masjid']; var_dump($selectMasjid); $targetfile = "../../../View/img/Upload/fotoProfil/"; $allowedExts = array("gif", "jpeg", "jpg", "png", "JPG"); $temp = explode(".", $_FILES["uploadfoto"]["name"]); $extension = end($temp); if (($_FILES["uploadfoto"]["type"] == "image/gif" || $_FILES["uploadfoto"]["type"] == "image/jpeg" || $_FILES["uploadfoto"]["type"] == "image/jpg" || $_FILES["uploadfoto"]["type"] == "image/JPG" || $_FILES["uploadfoto"]["type"] == "image/pjpeg" || $_FILES["uploadfoto"]["type"] == "image/x-png" || $_FILES["uploadfoto"]["type"] == "image/png") && $_FILES["uploadfoto"]["size"] < 8000000 && in_array($extension, $allowedExts)) { if ($_FILES["uploadfoto"]["error"] > 0) { echo "Return Code: " . $_FILES["uploadfoto"]["error"] . "<br>"; } else { $mime = explode("/", $_FILES["uploadfoto"]["type"]); $mime = $mime[1]; $imageName = $nama_masjid . $id_masjid . "." . $mime; move_uploaded_file($_FILES["uploadfoto"]["tmp_name"], $targetfile . $imageName); } try { $foto = ImageHandler::getProfilePicture($imageName); echo "sukses upload"; } catch (Exception $ex) { echo $ex; } } $insert_masjid = queryUpdate('masjid', 'foto="' . $foto . '"', 'id_masjid=' . $id_masjid); if ($insert_user && $insert_masjid) { header('location:http://localhost/SIMasjid/view/AdminUtama/tambahAdminMasjid.php?status=true'); } } echo '<br>'; } else { header('location:http://localhost/SIMasjid/view/AdminUtama/tambahAdminMasjid.php?&status=false'); }
$urlFile = split('http://localhost/SIMasjid/', $temp2); echo 'url =' . $urlFile[1]; unlink("../../../" . $urlFile[1]); queryDelete("file", "id_file=" . $listHapusFile[$i]); } } $deleteKegiatanRutin = queryDelete('kegiatan_rutin', 'id_masjid=' . $id_masjid); if (isset($_POST['kegiatanRutin']) && isset($_POST['hari']) && isset($_POST['jamAwal']) && isset($_POST['jamAkhir'])) { $kegiatanRutin = $_POST['kegiatanRutin']; $hari = $_POST['hari']; $jamAwal = $_POST['jamAwal']; $jamAkhir = $_POST['jamAkhir']; for ($i = 0; $i < count($kegiatanRutin); $i++) { $insertKegiatanRutin = queryInsert('kegiatan_rutin (id_masjid, nama, hari, jam_mulai, jam_selesai)', $id_masjid . ',"' . $kegiatanRutin[$i] . '","' . $hari[$i] . '","' . $jamAwal[$i] . '","' . $jamAkhir[$i] . '"'); } } $deleteAngkot = queryDelete('rute_angkot', 'id_masjid=' . $id_masjid); if (isset($_POST['angkot']) && isset($_POST['jalan'])) { $angkot = $_POST['angkot']; $jalan = $_POST['jalan']; for ($i = 0; $i < count($angkot); $i++) { $insertAngkot = queryInsert('rute_angkot (id_masjid, nama_jalan, id_angkot)', $id_masjid . ',"' . $jalan[$i] . '",' . $angkot[$i] . ''); } } $update_masjid = queryUpdate('masjid', 'id_wilayah=' . $wilayah . ', foto="' . $foto . '", nama_masjid="' . $nama_masjid . '", alamat="' . $alamat . '", rt="' . $rt . '", rw="' . $rw . '", kecamatan="' . $kecamatan . '", no_telepon="' . $no_tp . '", email="' . $email . '", peresmian_bangunan="' . $tanggalPeresmian . '", luas_tanah="' . $luasTanah . '", luas_bangunan="' . $luasBangunan . '", daya_tampung_dalam_masjid="' . $dayaTampungDalam . '", daya_tampung_luar_masjid="' . $dayaTampungLuar . '", deskripsi_masjid="' . $deskripsi . '", keunikan="' . $keunikan . '", latitude="' . $latitude . '", longitude="' . $longitude . '", struktur_organisasi="' . $struktur . '"', 'id_masjid= "' . $id_masjid . '"'); if ($update_masjid) { header('location:http://localhost/SIMasjid/view/AdminUtama/isiAturDataMasjid.php?ubah=true&id_user='******'&id_masjid=' . $id_masjid . '&status=true'); } } else { header('location:http://localhost/SIMasjid/view/AdminUtama/isiAturDataMasjid.php?ubah=true&id_user='******'id_user'] . '&id_masjid=' . $_REQUEST['id_masjid'] . '&status=false'); }
try { $gambarBerita = ImageHandler::getFotoBeritaMasjid($imageName); echo "sukses upload"; } catch (Exception $ex) { echo $ex; } } if (isset($_FILES['uploadfile'])) { $files = $_FILES['uploadfile']; $nFile = count($files['name']); $targetDir = '../../../View/img/Upload/fileBerita/'; $temp = explode('.', $files['name']); $mime = end($temp); if (in_array($mime, array('pdf', 'zip')) && ($files['size'] >= 30000 && $files['size'] <= 8000000)) { $fileNameOri = $files['name']; $fileName = "FileBerita_" . $nama . "_" . $id_masjid . "_" . $idberita . "." . $mime; $finalFile = 'http://localhost/SIMasjid/View/img/Upload/fileBerita/' . $fileName; if (move_uploaded_file($files['tmp_name'], $targetDir . $fileName)) { echo 'sukses upload ' . $fileName; } else { echo 'gagal upload ' . $fileName; } } } $updateBerita = queryUpdate('berita_masjid', 'gambar="' . $gambarBerita . '", nama_file="' . $fileNameOri . '", alamat_file="' . $finalFile . '"', 'id_berita_masjid=' . $idberita); if ($insert_berita && $updateBerita) { header('location:http://localhost/SIMasjid/view/AdminUtama/tambahBeritaMasjid.php?status=true'); } } else { header('location:http://localhost/SIMasjid/view/AdminUtama/tambahBeritaMasjid.php?&status=false'); }
<?php session_start(); require_once '../../connectDB.php'; if ($_GET['judulVideoMusik'] != '' && $_GET['penyanyi'] != '' && $_GET['embedVideoMusik'] != '') { $id_video_musik = $_GET['id_video_musik']; $judulVideo = str_replace('"', "''", $_GET['judulVideoMusik']); $penyanyi = mysql_real_escape_string($_GET['penyanyi']); $embedVideoMusik = mysql_real_escape_string($_GET['embedVideoMusik']); $str = explode(" ", $embedVideoMusik); echo $str[3] . '<br>'; $str2 = explode("/", $str[3]); echo $str2[4] . '<br>'; $code = str_replace('\\"', '', $str2[4]); echo $code . '<br>'; $videoImg = "<img src=" . mysql_real_escape_string("https://img.youtube.com/vi/" . $code . "/0.jpg") . ">"; echo $videoImg . '<br>'; $date = date("Y-m-d H:i:s"); echo $id_masjid . '<br>'; echo $id_video_musik . '<br>'; echo $judulVideo . '<br>'; echo $embedVideoMusik . '<br>'; echo $date . '<br>'; $update_video = queryUpdate('video_musik', 'judul="' . $judulVideo . '", penyanyi="' . $penyanyi . '", embed="' . $embedVideoMusik . '", img="' . $videoImg . '", tanggal_upload="' . $date . '"', 'id_video_musik=' . $id_video_musik); if ($update_video) { header('location:http://localhost/SIMasjid/view/AdminUtama/isiAturVideoMusik.php?musik_id=' . $_GET['id_video_musik'] . '&status=true'); } } else { header('location:http://localhost/SIMasjid/view/AdminUtama/isiAturVideoMusik.php?musik_id=' . $_GET['id_video_musik'] . '&status=false'); }
<?php session_start(); require_once '../../connectDB.php'; if ($_GET['judulVideoCeramah'] != '' && $_GET['penceramah'] != '' && $_GET['embedVideoCeramah'] != '') { $id_video_ceramah = $_GET['id_video_ceramah']; $judulVideo = mysql_real_escape_string($_GET['judulVideoCeramah']); $penceramah = $_GET['penceramah']; $embedVideoCeramah = mysql_real_escape_string($_GET['embedVideoCeramah']); $str = explode(" ", $embedVideoCeramah); echo $str[3] . '<br>'; $str2 = explode("/", $str[3]); echo $str2[4] . '<br>'; $code = str_replace('\\"', '', $str2[4]); echo $code . '<br>'; $videoImg = "<img src=" . mysql_real_escape_string("https://img.youtube.com/vi/" . $code . "/0.jpg") . ">"; echo $videoImg . '<br>'; $date = date("Y-m-d H:i:s"); echo $id_masjid . '<br>'; echo $id_video_masjid . '<br>'; echo $judulVideo . '<br>'; echo $embedVideoCeramah . '<br>'; echo $date . '<br>'; $update_video = queryUpdate('video_ceramah', 'judul="' . $judulVideo . '", penceramah="' . $penceramah . '", embed="' . $embedVideoCeramah . '", img="' . $videoImg . '", tanggal_upload="' . $date . '"', 'id_video_ceramah=' . $id_video_ceramah); if ($update_video) { header('location:http://localhost/SIMasjid/view/AdminUtama/isiAturVideoCeramah.php?ceramah_id=' . $_GET['id_video_ceramah'] . '&status=true'); } } else { header('location:http://localhost/SIMasjid/view/AdminUtama/isiAturVideoCeramah.php?ceramah_id=' . $_GET['id_video_ceramah'] . '&status=false'); }
<?php session_start(); require_once '../../connectDB.php'; if ($_GET['judulVideoMasjid'] != '' && $_GET['wilayahMasjid'] != 'Pilih wilayah' && $_GET['embedVideoMasjid'] != '') { $id_masjid = $_GET['id_masjid']; $id_video_masjid = $_GET['id_video_masjid']; $judulVideo = str_replace('"', "''", $_GET['judulVideoMasjid']); $embedVideoMasjid = mysql_real_escape_string($_GET['embedVideoMasjid']); $str = explode(" ", $embedVideoMasjid); echo $str[3] . '<br>'; $str2 = explode("/", $str[3]); echo $str2[4] . '<br>'; $code = str_replace('\\"', '', $str2[4]); echo $code . '<br>'; $videoImg = "<img src=" . mysql_real_escape_string("https://img.youtube.com/vi/" . $code . "/0.jpg") . ">"; echo $videoImg . '<br>'; $date = date("Y-m-d H:i:s"); echo $id_masjid . '<br>'; echo $id_video_masjid . '<br>'; echo $judulVideo . '<br>'; echo $embedVideoMasjid . '<br>'; echo $date . '<br>'; $update_video = queryUpdate('video_informasi_masjid', 'id_masjid=' . $id_masjid . ', jenis_admin="' . $_SESSION['user'][1] . '", judul="' . $judulVideo . '", embed="' . $embedVideoMasjid . '", img="' . $videoImg . '", tanggal_upload="' . $date . '"', 'id_video_masjid=' . $id_video_masjid); if ($update_video) { header('location:http://localhost/SIMasjid/view/AdminUtama/isiAturVideoInformasiMasjid.php?ubah=true&id_masjid=' . $_GET['id_masjid'] . '&id_video_masjid=' . $_GET['id_video_masjid'] . '&status=true'); } } else { header('location:http://localhost/SIMasjid/view/AdminUtama/isiAturVideoInformasiMasjid.php?ubah=true&id_masjid=' . $_GET['id_masjid'] . '&id_video_masjid=' . $_GET['id_video_masjid'] . '&status=false'); }
echo $isiPesan . '<br>'; echo $date . '<br>'; $insert_pesan = queryInsert('pesan (id_user, ke, nama_dari, nama_ke, judul, isi_pesan,status, tanggal_upload)', $dari . ',' . $ke . ',"' . $nama_dari . '","' . $nama_ke . '","' . $judulPesan . '","' . $isiPesan . '","' . $inbox . '","' . $date . '"'); $balas_pesan = queryInsert('pesan (id_user, ke, nama_dari, nama_ke, judul, isi_pesan,status , tanggal_upload)', $dari . ',' . $ke . ',"' . $nama_dari . '","' . $nama_ke . '","' . $judulPesan . '","' . $isiPesan . '","' . $sent . '","' . $date . '"'); $dataPesan = querySelect('*', 'pesan', 'id_user='******' ORDER BY id_pesan DESC', null); $id_pesan = $dataPesan[0]['id_pesan']; if (isset($_FILES['uploadfile'])) { $files = $_FILES['uploadfile']; $nFile = count($files['name']); $targetDir = '../../../View/img/Upload/filePesan/'; $temp = explode('.', $files['name']); $mime = end($temp); if (in_array($mime, array('pdf', 'zip')) && ($files['size'] >= 30000 && $files['size'] <= 8000000)) { $fileNameOri = $files['name']; $fileName = "FilePesan_" . $nama_dari . "_" . $dari . "_" . $id_pesan . "." . $mime; $finalFile = 'http://localhost/SIMasjid/View/img/Upload/filePesan/' . $fileName; if (move_uploaded_file($files['tmp_name'], $targetDir . $fileName)) { echo 'sukses upload ' . $fileName; } else { echo 'gagal upload ' . $fileName; } } } $updatePesan = queryUpdate('pesan', 'nama_file="' . $fileNameOri . '", alamat_file="' . $finalFile . '"', 'id_pesan=' . $id_pesan); if ($insert_pesan) { header('location:http://localhost/SIMasjid/view/AdminMasjid/balasPesan.php?pesan_id=' . $pesan_id . '&status=true'); } echo '<br>'; } else { header('location:http://localhost/SIMasjid/view/AdminMasjid/balasPesan.php?pesan_id=' . $pesan_id . '&status=false'); }
unlink("../" . $urlSerti[1]); unlink("../" . $urlFoto[1]); $b = queryDelete('user', 'id_user='******'id_user']); $c = queryDelete('masjid', 'id_masjid=' . $_GET['masjid_id']); header('location:http://localhost/SIMasjid/view/AdminUtama/konfirmasiMasjid.php'); } } ?> <?php if (isset($_GET['status'])) { if ($_GET['status'] == 'true') { $tempData = querySelect('*', 'masjid', 'id_masjid=' . $_GET['id_masjid'], null); $temp1 = $tempData[0]['sertifikat']; $urlSerti = split('http://localhost/SIMasjid/View/', $temp1); unlink("../" . $urlSerti[1]); $updateValidasi = queryUpdate('masjid', 'validasi=1', 'id_masjid=' . $_GET['id_masjid']); header('location:http://localhost/SIMasjid/view/AdminUtama/konfirmasiMasjid.php'); } } ?> <div class="wrapper"> <div class="col-full"> <div class="header row"> </div> <div class="content row"> <div class="side box span-1-8"> </div> <div class="box span-10-3"> <div class="kotak-tengah box span-12">
$nama_masjid = $_GET['namaMasjid']; $alamat = $_GET['alamat']; $email = $_GET['email']; $rt = $_GET['rt']; $rw = $_GET['rw']; $kecamatan = $_GET['kecamatan']; $no_tp = $_GET['noTelp']; echo $id_masjid . '<br>'; echo $id_user . '<br>'; echo $username . '<br>'; echo $password . '<br>'; echo $wilayah . '<br>'; echo $nama_masjid . '<br>'; echo $alamat . '<br>'; echo $email . '<br>'; echo $rt . '<br>'; echo $rw . '<br>'; echo $kecamatan . '<br>'; echo $no_tp . '<br>'; $update_user = queryUpdate('user', 'password="******",username="******"', 'id_user='******'<br>'; $update_masjid = queryUpdate('masjid', 'id_wilayah=' . $wilayah . ', nama_masjid="' . $nama_masjid . '", alamat="' . $alamat . '", rt="' . $rt . '", rw="' . $rw . '", kecamatan="' . $kecamatan . '", no_telepon="' . $no_tp . '"', 'id_masjid=' . $id_masjid); var_dump($update_user); var_dump($update_masjid); if ($update_user && $update_masjid) { header('location:http://localhost/SIMasjid/view/AdminUtama/isiUbahAdminMasjid.php?id_masjid=' . $_GET['id_masjid'] . '&status=true'); } } else { header('location:http://localhost/SIMasjid/view/AdminUtama/isiUbahAdminMasjid.php?id_masjid=' . $_GET['id_masjid'] . '&status=false'); } }
} } $targetfile = "../../../View/img/Upload/sertifikat/"; $allowedExts = array("gif", "jpeg", "jpg", "png", "JPG"); $temp = explode(".", $_FILES["uploadsertifikat"]["name"]); $extension = end($temp); if (($_FILES["uploadsertifikat"]["type"] == "image/gif" || $_FILES["uploadsertifikat"]["type"] == "image/jpeg" || $_FILES["uploadsertifikat"]["type"] == "image/jpg" || $_FILES["uploadsertifikat"]["type"] == "image/JPG" || $_FILES["uploadsertifikat"]["type"] == "image/pjpeg" || $_FILES["uploadsertifikat"]["type"] == "image/x-png" || $_FILES["uploadsertifikat"]["type"] == "image/png") && $_FILES["uploadsertifikat"]["size"] < 2048000 && in_array($extension, $allowedExts)) { if ($_FILES["uploadsertifikat"]["error"] > 0) { echo "Return Code: " . $_FILES["uploadsertifikat"]["error"] . "<br>"; } else { $mime = explode("/", $_FILES["uploadsertifikat"]["type"]); $mime = $mime[1]; $imageName = $nama_masjid . $id_masjid . "." . $mime; move_uploaded_file($_FILES["uploadsertifikat"]["tmp_name"], $targetfile . $imageName); } try { $sertifikat = ImageHandler::getSertifikat($imageName); echo "sukses upload"; } catch (Exception $ex) { echo $ex; } } $insert_masjid = queryUpdate('masjid', 'foto="' . $foto . '", sertifikat="' . $sertifikat . '"', 'id_masjid=' . $id_masjid); if ($insert_user && $insert_masjid) { header('location:http://localhost/SIMasjid/view/PenggunaUmum/register.php?status=true'); } } echo '<br>'; } else { header('location:http://localhost/SIMasjid/view/PenggunaUmum/register.php?&status=false'); }
$extension = end($temp); if (($_FILES["uploadgambarberita"]["type"] == "image/gif" || $_FILES["uploadgambarberita"]["type"] == "image/jpeg" || $_FILES["uploadgambarberita"]["type"] == "image/jpg" || $_FILES["uploadgambarberita"]["type"] == "image/JPG" || $_FILES["uploadgambarberita"]["type"] == "image/pjpeg" || $_FILES["uploadgambarberita"]["type"] == "image/x-png" || $_FILES["uploadgambarberita"]["type"] == "image/png") && $_FILES["uploadgambarberita"]["size"] < 8000000 && in_array($extension, $allowedExts)) { if ($_FILES["uploadgambarberita"]["error"] > 0) { echo "Return Code: " . $_FILES["uploadgambarberita"]["error"] . "<br>"; } else { $mime = explode("/", $_FILES["uploadgambarberita"]["type"]); $mime = $mime[1]; $imageName = "BeritaUmum_" . $id_berita_umum . "." . $mime; move_uploaded_file($_FILES["uploadgambarberita"]["tmp_name"], $targetfile . $imageName); } try { $gambarBerita = ImageHandler::getFotoBeritaUmum($imageName); echo "sukses upload"; } catch (Exception $ex) { echo $ex; } } } else { $gambarBerita = $statusFoto; } $update_berita = queryUpdate('berita_umum', 'judul="' . $judulBerita . '", gambar="' . $gambarBerita . '", isi_berita="' . $isiBerita . '", editor="' . $editor . '" , sumber="' . $sumber . '", link="' . $link . '" , tanggal_upload="' . $date . '"', 'id_berita_umum=' . $id_berita_umum); var_dump($update_berita); if ($update_berita) { header('location:http://localhost/SIMasjid/view/AdminUtama/isiAturBeritaUmum.php?berita_id=' . $id_berita_umum . '&status=true'); } else { echo 'something'; } echo '<br>'; } else { header('location:http://localhost/SIMasjid/view/AdminUtama/isiAturBeritaUmum.php?berita_id=' . $id_berita_umum . '&status=false'); }
$allowedExts = array("gif", "jpeg", "jpg", "png", "JPG"); $temp = explode(".", $_FILES["uploadgambarberita"]["name"]); $extension = end($temp); if (($_FILES["uploadgambarberita"]["type"] == "image/gif" || $_FILES["uploadgambarberita"]["type"] == "image/jpeg" || $_FILES["uploadgambarberita"]["type"] == "image/jpg" || $_FILES["uploadgambarberita"]["type"] == "image/JPG" || $_FILES["uploadgambarberita"]["type"] == "image/pjpeg" || $_FILES["uploadgambarberita"]["type"] == "image/x-png" || $_FILES["uploadgambarberita"]["type"] == "image/png") && $_FILES["uploadgambarberita"]["size"] < 8000000 && in_array($extension, $allowedExts)) { if ($_FILES["uploadgambarberita"]["error"] > 0) { echo "Return Code: " . $_FILES["uploadgambarberita"]["error"] . "<br>"; } else { $mime = explode("/", $_FILES["uploadgambarberita"]["type"]); $mime = $mime[1]; $imageName = "BeritaUmum_" . $idberita . "." . $mime; move_uploaded_file($_FILES["uploadgambarberita"]["tmp_name"], $targetfile . $imageName); } try { $gambarBerita = ImageHandler::getFotoBeritaUmum($imageName); echo "sukses upload"; } catch (Exception $ex) { echo $ex; } } $updateBerita = queryUpdate('berita_umum', 'gambar="' . $gambarBerita . '"', 'id_berita_umum=' . $idberita); if ($insert_berita && $updateBerita) { header('location:http://localhost/SIMasjid/view/AdminUtama/tambahBeritaUmum.php?status=true'); } } else { header('location:http://localhost/SIMasjid/view/AdminUtama/tambahBeritaUmum.php?&status=false'); } ?>
if ($_GET['username'] != '') { $id_user = $_GET['user_id']; $username = $_GET['username']; echo $id_user . '<br>'; echo $username . '<br>'; $update_user = queryUpdate('user', 'username="******"', 'id_user='******'location:http://localhost/SIMasjid/view/AdminMasjid/setting.php?status=true'); } } else { header('location:http://localhost/SIMasjid/view/AdminMasjid/setting.php?status=false'); } } else { if ($_GET['username'] != '') { $id_user = $_GET['user_id']; $username = $_GET['username']; $password = $_GET['password']; echo $id_user . '<br>'; echo $username . '<br>'; echo $password . '<br>'; $update_user = queryUpdate('user', 'password="******",username="******"', 'id_user='******'location:http://localhost/SIMasjid/view/AdminMasjid/setting.php?status=true'); } } else { header('location:http://localhost/SIMasjid/view/AdminMasjid/setting.php?status=false'); } } }
<?php session_start(); require_once '../../connectDB.php'; $id_masjid = $_POST['id_masjid']; $updateValidasi = queryUpdate('masjid', 'validasi=1', 'id_masjid=' . $id_masjid); if ($updateValidasi) { header('location:http://localhost/SIMasjid/view/AdminUtama/konfirmasiMasjid.php?status=true'); } else { header('location:http://localhost/SIMasjid/view/AdminUtama/konfirmasiMasjid.php?&status=false'); }