public static function getNamaKPPN() { $model = new Model(); $kppn = $model->select('SELECT satker FROM kantor'); foreach ($kppn as $data) { $kppn = $data['satker']; } $kppn = (string) $kppn; $len = strlen($kppn); if ($len == 1) { $kppn = '00' . $kppn; } elseif ($len == 2) { $kppn = '0' . $kppn; } $config = array('host' => DB_HOST, 'db_name' => DB_NAME_KPPN, 'pass' => DB_PASS, 'port' => DB_PORT_KPPN, 'user' => DB_USER); $con = new Koneksi(); $sql = "SELECT nmkppn FROM t_kppn WHERE kdkppn=:kdkppn"; $pdo = $con->getConnection($config); $stmt = $pdo->prepare($sql); $stmt->bindValue(':kdkppn', $kppn); $stmt->execute(); $data = $stmt->fetchAll(PDO::FETCH_ASSOC); $nmkppn = 'KANTOR PELAYANAN PERBENDAHARAAN NEGARA '; foreach ($data as $val) { $nmkppn .= strtoupper($val['nmkppn']); } unset($con); unset($model); return $nmkppn; }
function data_asisten($kd_asisten) { $koneksi = new Koneksi(); $koneksi->pilihkonekdb(); $sql = "\r\n\t\t\tSelect\r\n\t\t\tkd_asisten,\r\n\t\t\tnm_asisten,\r\n\t\t\thapeasisten,\r\n\t\t\talamat_asisten,\t\r\n\t\t\tkota_asisten,\t\t\r\n\t\t\ttmpt_lahirasisten,\r\n\t\t\ttgl_lahirasisten,\r\n\t\t\tno_idasisten,\r\n\t\t\tcopy_asisten\r\n\t\t\tFrom\r\n\t\t\tasisten\r\n\t\t\tWhere\r\n\t\t\tkd_asisten = '" . $kd_asisten . "'\r\n\t\t\t"; $list_cari = false; $res = mysql_query($sql); if ($res) { while ($row = mysql_fetch_assoc($res)) { $cari = new birojasa(); $cari->kd_asisten = $row['kd_asisten']; $cari->nm_asisten = $row['nm_asisten']; $cari->hapeasisten = $row['hapeasisten']; $cari->alamat_asisten = $row['alamat_asisten']; $cari->kota_asisten = $row['kota_asisten']; $cari->tmpt_lahirasisten = $row['tmpt_lahirasisten']; $cari->tgl_lahirasisten = $row['tgl_lahirasisten']; $cari->no_idasisten = $row['no_idasisten']; $cari->copy_asisten = $row['copy_asisten']; $list_cari[] = $cari; } } $koneksi->tutupdb(); return $list_cari; }
function addPlan($Nama, $Email, $Telp, $Tgl_Pernikahan, $Tgl_Temu_WP, $Tempat_Temu) { $konek = new Koneksi(); $konek->con(); $query = mysql_query("INSERT INTO `planner` (`Plan_ID`, `Nama`, `Telp`, `Email`, `Tgl_Pernikahan`, `Tgl_Temu_WP`, `Tempat_Temu`) \r\n\t\tVALUES ('', '{$Nama}', '{$Telp}', '{$Email}', '{$Tgl_Pernikahan}', '{$Tgl_Temu_WP}', '{$Tempat_Temu}');"); $plan = $this->viewPlan(); return $plan; }
function addTesti($nama, $email, $isi_testi) { $konek = new Koneksi(); $konek->con(); $query = mysql_query("INSERT INTO `testimoni` (`testi_id`, `nama`, `email`, `isi_testi`) \r\n\t\tVALUES ('', '{$nama}', '{$email}', '{$isi_testi}');"); $testimoni = $this->viewTesti(); return $testimoni; }
function hitungTestimoni() { $koneksi = new Koneksi(); $koneksi->pilihkonekdb(); $sql = "\r\n\t\t\tSELECT \r\n\t\t\tcount(*) as total \r\n\t\t\tFROM \r\n\t\t\ttestimoni\r\n\t\t"; $itung = mysql_query($sql); $jumlah = mysql_fetch_array($itung); return $jumlah['total']; }
function getKodeSatker($data = null) { $config = array('host' => DB_HOST, 'db_name' => DB_NAME_KPPN, 'pass' => DB_PASS, 'port' => DB_PORT_KPPN, 'user' => DB_USER); $con = new Koneksi(); $pdo = $con->getConnection($config); $sql = "SELECT kdsatker,nmsatker FROM t_satker LIMIT 0,30"; $stmt = $pdo->prepare($sql); $stmt->execute(); $data = $stmt->fetchAll(PDO::FETCH_ASSOC); unset($con); return $data; }
function gantiPassword($id_users, $password, $password1, $password2) { $koneksi = new Koneksi(); $koneksi->pilihkonekdb(); $sql = "\r\n\t\t\tselect\r\n\t\t\tpassword\r\n\t\t\tfrom \r\n\t\t\tusers\r\n\t\t\twhere\r\n\t\t\tkd_users='" . $id_user . "';\r\n\t\t"; $hasil = mysql_query($sql); if ($password != $hasil) { echo "Password lama salah"; } if ($password1 != $password2) { echo "Password baru tidak cocok"; } if ($hasil == $password and $password1 == $password2) { $sql = "\r\n\t\t\tupdate\r\n\t\t\tusers\r\n\t\t\tset\r\n\t\t\tpassword='******'\r\n\t\t\twhere\r\n\t\t\tkd_users='" . $id_users . "' \r\n\t\t\t"; mysql_query($sql); } $koneksi->tutupdb(); }
function tampilTransaksi() { $sql = "SELECT * FROM t_transaksi"; return Koneksi::getconn()->query($sql); }
function setBayar($id_cucian) { include "include/db_connect.php"; $sql = "update t_pembayaran set statusPembayaran = 'Lunas' where id_cucian = {$id_cucian}"; return Koneksi::getconn()->query($sql); }
function lamar($kd_lowongan, $kd_asisten) { $koneksi = new Koneksi(); $koneksi->pilihkonekdb(); echo $kd_asisten; echo $kd_lowongan; $sql = "\r\n\t\tINSERT INTO \r\n\t\t`detail_lowongan`\r\n\t\t(`KD_LOWONGAN`, `KD_MEMBER`, `KD_ASISTEN`) \r\n\t\tSELECT \r\n\t\tb.kd_lowongan, a.kd_member, a.kd_asisten \r\n\t\tFROM asisten a \r\n\t\tJOIN lowongan b \r\n\t\tWHERE b.kd_lowongan = '" . $kd_lowongan . "'\r\n\t\tAND\r\n\t\ta.kd_asisten = '" . $kd_asisten . "'\r\n\t\t"; $berhasil = mysql_query($sql) or die(mysql_error()); if ($berhasil) { echo "berhasil"; } else { echo "ngga berhasil :("; } $koneksi->tutupdb(); }
function lookupkab() { //konek db kppn $filter = $_POST['queryString']; $config = array('host' => DB_HOST, 'db_name' => DB_NAME_KPPN, 'pass' => DB_PASS, 'port' => DB_PORT_KPPN, 'user' => DB_USER); $con = new Koneksi(); $pdo = $con->getConnection($config); $stmt = $pdo->prepare("SELECT kdkabkota,nmkabkota FROM t_kabkota WHERE kdlokasi=:kdlok"); $stmt->bindValue(':kdlok', $filter); $stmt->execute(); $data = $stmt->fetchAll(PDO::FETCH_ASSOC); // $sql="SELECT kdkabkota,nmkabkota FROM t_kabkota WHERE kdlokasi=".$filter; // $data = $this->model->select($sql); $no = 1; foreach ($data as $value) { echo "<option value={$value['kdkabkota']}>{$value['nmkabkota']}</option>"; $no++; } }
function editdatalaundy($id_cucian) { include "include/db_connect.php"; $sql = "UPDATE t_cucian SET jenis_cucian ='{$this->jenisCucian}',berat_cucian ='{$this->beratCucian}' WHERE id_cucian = {$id_cucian}"; $result = Koneksi::getconn()->query($sql); }
<!--<div class="pagination pagination-right"> <ul> <li><a href="#">Prev</a></li> <li><a href="#">1</a></li> <li><a href="#">2</a></li> <li><a href="#">3</a></li> <li><a href="#">Next</a></li> </ul> </div>--> <!--daftar testimoni--> <?php //include_once('header.php'); echo "<div class='span8'>"; // connect to the database include '../model/koneksi.php'; $konek = new Koneksi(); $konek->con(); // number of results to show per page $per_page = 3; /* get results from database $result = mysql_query("SELECT * FROM testimoni") or die(mysql_error());*/ // figure out the total pages in the database $result = mysql_query("SELECT * FROM testimoni ORDER BY testi_id DESC"); $total_results = mysql_num_rows($result); $total_pages = ceil($total_results / $per_page); // check if the 'page' variable is set in the URL (ex: view-paginated.php?page=1) if (isset($_GET['page']) && is_numeric($_GET['page'])) { $show_page = $_GET['page']; // make sure the $show_page value is valid if ($show_page > 0 && $show_page <= $total_pages) {
function tentukanPembantu($kd_lowongan, $kd_asisten, $status) { $koneksi = new Koneksi(); $koneksi->pilihkonekdb(); $sql1 = "\r\n\t\t\tUPDATE\r\n\t\t\tlowongan\r\n\t\t\tSET\r\n\t\t\tkd_asisten={$kd_asisten},kd_status=2\r\n\t\t\twhere\r\n\t\t\tkd_lowongan={$kd_lowongan}\r\n\t\t"; $hasil1 = mysql_query($sql1); $sql2 = "\r\n\t\t\tUPDATE\r\n\t\t\tdetail_lowongan\r\n\t\t\tSET\r\n\t\t\tkd_status={$status}\r\n\t\t\twhere\r\n\t\t\tkd_lowongan={$kd_lowongan}\r\n\t\t\tAND\r\n\t\t\tkd_asisten={$kd_asisten}\r\n\t\t"; print_r($sql2); $hasil2 = mysql_query($sql2); $sql3 = "\r\n\t\t\tUPDATE\r\n\t\t\tdetail_lowongan\r\n\t\t\tSET\r\n\t\t\tkd_status=3\r\n\t\t\twhere\r\n\t\t\tkd_lowongan={$kd_lowongan}\r\n\t\t\tAND\r\n\t\t\tkd_asisten!={$kd_asisten}\r\n\t\t"; //print_r($sql3); $hasil3 = mysql_query($sql3); $koneksi->tutupdb(); return true; }
function __construct() { $konek = new Koneksi(); $konek->con(); //return $this->link; }
function editdatapelanggan($id_pelanggan) { $sql = "UPDATE t_pelanggan SET nama_pelanggan ='{$this->namaPelanggan}',alamat_pelanggan ='{$this->alamatPelanggan}',telepon ='{$this->telepon}' WHERE id_pelanggan = {$id_pelanggan}"; $result = Koneksi::getconn()->query($sql); }
public function ubahAlamat($kd, $satker = null) { if (!Auth::isAllow(5, Session::get('role'), 1, Session::get('bagian'))) { header('location:' . URL . 'home'); } if (isset($_POST['submit'])) { if ($this->updateRekamAlamat()) { $this->view->success = "Ubah data berhasil"; } else { $this->view->error = "Ubah alamat gagal! alamat satker ini telah ada."; } } $alamat = $this->model->getAlamat($kd); foreach ($alamat as $value) { $this->view->id = $value['id_alamat']; $tmp = explode('.', $value['kode_satker']); $this->view->tipe = $tmp[0]; $this->view->kode_satker = $tmp[1]; $this->view->nama_satker = $value['nama_satker']; $this->view->jabatan = $value['jabatan']; $this->view->alamat = $value['alamat']; $this->view->telepon = $value['telepon']; $this->view->email = $value['email']; } //var_dump($this->view->id); if (!is_null($satker)) { $this->view->satker = $satker; $config = array('host' => DB_HOST, 'db_name' => DB_NAME_KPPN, 'pass' => DB_PASS, 'port' => DB_PORT_KPPN, 'user' => DB_USER); $con = new Koneksi(); $sql = 'SELECT nmsatker FROM t_satker WHERE kdsatker=' . $satker; $pdo = $con->getConnection($config); $stmt = $pdo->prepare($sql); $stmt->execute(); $nm = $stmt->fetchAll(PDO::FETCH_ASSOC); // $nm = $this->model->select('SELECT nmsatker FROM t_satker WHERE kdsatker=' . $satker); foreach ($nm as $value) { $this->view->nm_satker = $value['nmsatker']; } unset($con); } $this->view->data = $this->model->getAlamat(); $this->view->render('admin/alamat/ubahAlamat'); }