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