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 lihatTesti($halaman, $limit) { $koneksi = new Koneksi(); $koneksi->pilihkonekdb(); $daftar_testimoni = array(); $sql = "\r\n\t\tselect \r\n\t\t\ta.kd_testi,\r\n\t\t\ta.isi_testi,\r\n\t\t\tb.nm_member\r\n\t\t\t\r\n\t\tfrom\r\n\t\tmembers as b\r\n\t\tJOIN \r\n\t\ttestimoni as a\r\n\t\tWHERE\r\n\t\ta.kd_member=b.kd_member\r\n\t\tLIMIT {$halaman},{$limit}\r\n\t\t"; $testi = mysql_query($sql); if ($testi) { while ($hasil = mysql_fetch_assoc($testi)) { $testimoni = new Testimoni(); $testimoni->kd_testi = $hasil['kd_testi']; $testimoni->kd_member = $hasil['nm_member']; $testimoni->isi_testi = $hasil['isi_testi']; $daftar_testimoni[] = $testimoni; } } $koneksi->tutupdb(); return $daftar_testimoni; }
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; }
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; }