/**
*
* @param resource $conn
* @param string $tabla
* @param string $param
* @param string $SQLserverNameBack
* @return array
*/
function borrar($conn, $tabla, $where, $SQLserverName)
{
global $respError;
$resultadoDelete = queryDelete($conn, $tabla, $where, $SQLserverName);
if (is_array($resultadoDelete)) {
$resultadoOperacion = array("codigoResultadoOperacion" => $resultadoDelete[0]["code"], "mensajeResultadoOperacion" => $resultadoDelete[0]["message"]);
return array(__FUNCTION__ . "Result" => array("columnasAfectadas" => 0, "resultadoOperacion" => $resultadoOperacion));
}
return array(__FUNCTION__ . "Result" => array("columnasAfectadas" => $resultadoDelete, "resultadoOperacion" => $respError->sinErrores()));
}
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<meta name="description" content="">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="shortcut icon" href="../img/SIM/ico.png">
<link rel="stylesheet" href="../css/reset.css">
<link rel="stylesheet" href="../css/AdminUtama/style.css">
<link rel="stylesheet" href="../css/AdminUtama/sidebar.css">
<link rel="stylesheet" href="../css/AdminUtama/aturBeritaMasjid.css">
</head>
<body>
<?php
if (isset($_GET['delete'])) {
if ($_GET['delete'] == 'true') {
$b = queryDelete('berita_masjid', 'id_berita_masjid=' . $_GET['berita_id']);
header('location:http://localhost/SIMasjid/view/AdminUtama/aturBeritaMasjid.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">
}
}
}
$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 {
if ($insertGallery = null && ($updateFotoGaleri = true)) {
header('location:http://localhost/SIMasjid/view/AdminMasjid/galeri.php?status=true');
} else {
if ($insertGallery = null && ($updateFotoGaleri = null)) {
header('location:http://localhost/SIMasjid/view/AdminMasjid/galeri.php?status=false');
}
}
<?php
session_start();
require_once '../../connectDB.php';
if (isset($_POST['adminutama_hapussent_submit'])) {
if (count($_SESSION['pesanSentAU']) > 0) {
if (isset($_POST['msg']) > 0) {
$msglist = $_POST['msg'];
for ($i = 0; $i < count($msglist); $i++) {
queryDelete('pesan', 'id_pesan=' . $msglist[$i]);
echo $msglist[$i];
}
header('location:http://localhost/SIMasjid/view/AdminUtama/sent.php?status=true');
}
} else {
header('location:http://localhost/SIMasjid/view/AdminUtama/sent.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');
}
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<meta name="description" content="">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="shortcut icon" href="../img/SIM/ico.png">
<link rel="stylesheet" href="../css/reset.css">
<link rel="stylesheet" href="../css/AdminUtama/style.css">
<link rel="stylesheet" href="../css/AdminUtama/sidebar.css">
<link rel="stylesheet" href="../css/AdminUtama/aturVideoInformasiMasjid.css">
</head>
<body>
<?php
if (isset($_GET['delete'])) {
if ($_GET['delete'] == 'true') {
$b = queryDelete('video_informasi_masjid', 'id_video_masjid=' . $_GET['id_video_masjid']);
header('location:http://localhost/SIMasjid/view/AdminUtama/aturVideoInformasiMasjid.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">
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<meta name="description" content="">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="shortcut icon" href="../img/SIM/ico.png">
<link rel="stylesheet" href="../css/reset.css">
<link rel="stylesheet" href="../css/AdminUtama/style.css">
<link rel="stylesheet" href="../css/AdminUtama/sidebar.css">
<link rel="stylesheet" href="../css/AdminUtama/aturVideoCeramah.css">
</head>
<body>
<?php
if (isset($_GET['delete'])) {
if ($_GET['delete'] == 'true') {
$b = queryDelete('video_ceramah', 'id_video_ceramah=' . $_GET['id_video_ceramah']);
header('location:http://localhost/SIMasjid/view/AdminUtama/aturVideoCeramah.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">
<body>
<?php
if (isset($_GET['delete'])) {
if ($_GET['delete'] == 'true') {
$tempData = querySelect('*', 'masjid', 'id_masjid=' . $_GET['masjid_id'], null);
$temp2 = $tempData[0]['foto'];
$urlFoto = split('http://localhost/SIMasjid/View/', $temp2);
unlink("../" . $urlFoto[1]);
$tempFile = querySelect('*', 'file', 'id_masjid=' . $_GET['masjid_id'], null);
for ($i = 0; $i < count($tempFile); $i++) {
$temp2 = $tempFile[$i]['lokasi_file'];
$urlFile = split('http://localhost/SIMasjid/View/', $temp2);
unlink("../" . $urlFile[1]);
}
$b = queryDelete('user', 'id_user='******'id_user']);
$c = queryDelete('masjid', 'id_masjid=' . $_GET['masjid_id']);
header('location:http://localhost/SIMasjid/view/AdminUtama/aturDataMasjid.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">
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<meta name="description" content="">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="shortcut icon" href="../img/SIM/ico.png">
<link rel="stylesheet" href="../css/reset.css">
<link rel="stylesheet" href="../css/AdminUtama/style.css">
<link rel="stylesheet" href="../css/AdminUtama/sidebar.css">
<link rel="stylesheet" href="../css/AdminUtama/aturBeritaUmum.css">
</head>
<body>
<?php
if (isset($_GET['delete'])) {
if ($_GET['delete'] == 'true') {
$b = queryDelete('berita_umum', 'id_berita_umum=' . $_GET['id_berita_umum']);
header('location:http://localhost/SIMasjid/view/AdminUtama/aturBeritaUmum.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">
//}
if (isset($_GET['method'])) {
if ($_GET['method'] == 'create' && isset($_GET['name']) && isset($_GET['query0'])) {
queryCreate();
} elseif ($_GET['method'] == 'save' && isset($_GET['name']) && isset($_GET['options']) && isset($_GET['filename'])) {
//querySave($_GET['filename']);
} elseif ($_GET['method'] == 'list') {
queryList();
} elseif ($_GET['method'] == 'shorten' && isset($_GET['uri'])) {
queryShorten($_GET['uri']);
} elseif ($_GET['method'] == 'download') {
queryDownload($_GET['filetype']);
} elseif ($_GET['method'] == 'get' && isset($_GET['filename'])) {
queryGet($_GET['filename']);
} elseif ($_GET['method'] == 'delete' && isset($_GET['filename'])) {
queryDelete($_GET['filename']);
} else {
sendResponse(400, 'method parameters not valid');
}
} else {
//echo 'Function not Found';
sendResponse(400, 'Function not Found');
}
// Helper method to get a string description for an HTTP status code
// From http://www.gen-x-design.com/archives/create-a-rest-api-with-php/
function getStatusCodeMessage($status)
{
// these could be stored in a .ini file and loaded
// via parse_ini_file()... however, this will suffice
// for an example
$codes = array(100 => 'Continue', 101 => 'Switching Protocols', 200 => 'OK', 201 => 'Created', 202 => 'Accepted', 203 => 'Non-Authoritative Information', 204 => 'No Content', 205 => 'Reset Content', 206 => 'Partial Content', 300 => 'Multiple Choices', 301 => 'Moved Permanently', 302 => 'Found', 303 => 'See Other', 304 => 'Not Modified', 305 => 'Use Proxy', 306 => '(Unused)', 307 => 'Temporary Redirect', 400 => 'Bad Request', 401 => 'Unauthorized', 402 => 'Payment Required', 403 => 'Forbidden', 404 => 'Not Found', 405 => 'Method Not Allowed', 406 => 'Not Acceptable', 407 => 'Proxy Authentication Required', 408 => 'Request Timeout', 409 => 'Conflict', 410 => 'Gone', 411 => 'Length Required', 412 => 'Precondition Failed', 413 => 'Request Entity Too Large', 414 => 'Request-URI Too Long', 415 => 'Unsupported Media Type', 416 => 'Requested Range Not Satisfiable', 417 => 'Expectation Failed', 500 => 'Internal Server Error', 501 => 'Not Implemented', 502 => 'Bad Gateway', 503 => 'Service Unavailable', 504 => 'Gateway Timeout', 505 => 'HTTP Version Not Supported');
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<meta name="description" content="">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="shortcut icon" href="../img/SIM/ico.png">
<link rel="stylesheet" href="../css/reset.css">
<link rel="stylesheet" href="../css/AdminUtama/style.css">
<link rel="stylesheet" href="../css/AdminUtama/sidebar.css">
<link rel="stylesheet" href="../css/AdminUtama/aturVideoMusik.css">
</head>
<body>
<?php
if (isset($_GET['delete'])) {
if ($_GET['delete'] == 'true') {
$b = queryDelete('video_musik', 'id_video_musik=' . $_GET['id_video_musik']);
header('location:http://localhost/SIMasjid/view/AdminUtama/aturVideoMusik.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">
