<?php include '../../fungsi/fungsi_thumb.php'; require_once '../../config/dbWeb.php'; $con = new dbWeb(); $ACTION = $_POST['action']; switch ($ACTION) { case "selectSlide": $idWhere = array('row_status' => 1); $dataBalik = $con->selectFrom('m_slide', '*', $idWhere); echo json_encode($dataBalik); break; case "selectEdit": $idSlide = $_POST['id']; $idWhere = array('id_slide' => $idSlide); $dataBalik = $con->selectFrom('m_slide', '*', $idWhere); echo json_encode($dataBalik); break; case "hapusSlide": $idSlide = $_POST['id']; $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}"); /*$fieldValue = array( 'row_status' => '0', );*/ $idWhere = array('id_slide' => $idSlide); //$con->update('m_slide',$fieldValue,$idWhere); $con->delete('m_slide', $idWhere);
public function setMenuKanan() { $whereValue = array('letak_menu' => 'kanan'); $arrMenuKanan = parent::selectFrom('w_menu', 'ALL', $whereValue); $objMenuKanan = $this->arrayToObject($arrMenuKanan); $data = array(); foreach ($objMenuKanan as $menuKanan) { $data[$menuKanan->id_parent][] = $menuKanan; } $htmlMenuKanan = $this->orderMenuKanan($data); return $htmlMenuKanan; }
<?php include '../../fungsi/fungsi_thumb.php'; include '../../fungsi/library.php'; require_once '../../config/dbWeb.php'; $con = new dbWeb(); $ACTION = $_POST['action']; switch ($ACTION) { case "select": $idWhere = array('row_status' => 1); $dataBalik = $con->selectFrom('m_kat_product', '*', $idWhere); echo json_encode($dataBalik); break; case "selectEdit": $id = $_POST['id']; $idWhere = array('id_kat_product' => $id); $dataBalik = $con->selectFrom('m_kat_product', '*', $idWhere); echo json_encode($dataBalik); 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":
<?php require_once '../../config/dbWeb.php'; $con = new dbWeb(); $ACTION = $_POST['action']; switch ($ACTION) { 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'];
<?php //include '../../fungsi/fungsi_thumb.php'; require_once '../../config/dbWeb.php'; $con = new dbWeb(); $ACTION = $_POST['action']; switch ($ACTION) { case "view": $id = $_POST['id']; $idWhere = array('id_informasi' => $id); $dataBalik = $con->selectFrom('m_informasi', '*', $idWhere); echo json_encode($dataBalik); break; default: break; }
<?php //include '../../fungsi/fungsi_thumb.php'; require_once '../../config/dbWeb.php'; $con = new dbWeb(); $ACTION = $_POST['action']; switch ($ACTION) { case "view_berita": $idWhere = array('row_status' => 1); $dataBalik = $con->selectFrom('m_berita', '*', $idWhere); echo json_encode($dataBalik); break; default: break; }
<?php //include '../../fungsi/fungsi_thumb.php'; require_once '../../../config/dbWeb.php'; $con = new dbWeb(); $ACTION = $_POST['action']; switch ($ACTION) { case "view": $idWhere = array('row_status' => 1); $orderby = array('id_berita desc limit 3'); $dataBalik = $con->selectFrom('m_berita', '*', $idWhere, $orderby); echo json_encode($dataBalik); break; case "view_promosi": $idWhere = array('row_status' => 1); $orderby = array('id_pengumuman desc limit 3'); $dataBalik = $con->selectFrom('m_pengumuman', '*', $idWhere, $orderby); echo json_encode($dataBalik); break; default: break; }
<?php session_start(); require_once '../../config/dbWeb.php'; $con = new dbWeb(); $dataWhere = array("username" => $_POST['username'], "password" => md5($_POST['password'])); $pass = md5($_POST['password']); $query = "SELECT * FROM w_user WHERE id_user='******'username']}' AND password='******'"; $data = $con->execQuery($query); $status = false; if (empty($data)) { $status = false; echo json_encode($status); } else { $status = true; $_SESSION['id_user'] = $data[0]['id_user']; $_SESSION['password'] = $data[0]['password']; $_SESSION['nama_user'] = $data[0]['nama_user']; $_SESSION['id_level'] = $data[0]['id_level']; echo json_encode($status); } /* $dataUser = $con->selectFrom("w_user",$dataWhere) $_SESSION['username'] = $dataUser['username']; $_SESSION['nama_user'] = $dataUser['nama_user']; $_SESSION['password'] = $dataUser['password']; $_SESSION['id_level'] = $dataUser['id_level']; $_SESSION['nama_level'] = $dataUser['nama_level']; $_SESSION['id_fakultas'] = $dataUser['id_fakultas']; $_SESSION['id_jurusan'] = $dataUser['id_jurusan'];*/
<?php //include '../../fungsi/fungsi_thumb.php'; require_once '../../config/dbWeb.php'; $con = new dbWeb(); $ACTION = $_POST['action']; switch ($ACTION) { case "view": $idWhere = array('row_status' => 1); $dataBalik = $con->selectFrom('m_pengumuman', '*', $idWhere); echo json_encode($dataBalik); break; default: break; }
<?php //include '../../fungsi/fungsi_thumb.php'; require_once '../../config/dbWeb.php'; $con = new dbWeb(); $ACTION = $_POST['action']; switch ($ACTION) { case "view_gallery": $idWhere = array('row_status' => 1); $dataBalik = $con->selectFrom('m_kat_gallery', '*', $idWhere); echo json_encode($dataBalik); break; case "view_gallery_detil": $idWhere = array('row_status' => 1); $dataBalik = $con->selectFrom('m_gallery', '*', $idWhere); echo json_encode($dataBalik); break; default: break; }