PHP dbWeb Examples

Example #1

File: model-slide.php Project: weltesdeveloper/weltesinformationcenter

<?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);

Example #2

File: menuWeb.php Project: weltesdeveloper/weltesinformationcenter

 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;
 }

Example #3

File: model-kat-product.php Project: weltesdeveloper/weltesinformationcenter

<?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":

Example #4

File: model-menu-info.php Project: weltesdeveloper/weltesinformationcenter

<?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'];

Example #5

File: model-informasi.php Project: weltesdeveloper/weltesinformationcenter

<?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;
}

Example #6

File: model-berita.php Project: weltesdeveloper/weltesinformationcenter

<?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;
}

Example #7

File: pengumuman_proses.php Project: weltesdeveloper/weltesinformationcenter

<?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;
}

Example #8

File: model-login.php Project: weltesdeveloper/weltesinformationcenter

<?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'];*/

Example #9

File: model-promosi.php Project: weltesdeveloper/weltesinformationcenter

<?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;
}

Example #10

File: model-galeri.php Project: weltesdeveloper/weltesinformationcenter

<?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;
}