Home
Add Document
Sign In
Register
No title
Home
No title
...
Author:
Guest
7 downloads
31 Views
533KB Size
Report
DOWNLOAD PDF
Recommend Documents
No title
No title
No title
No title
No title
No title
No title
No title
No title
No title
No title
No title
No title
No title
No title
No title
No title
No title
No title
No title
No title
No title
No title
No title
LAMPIRAN LISTING PROGRAM
nn.php
Rekomendasi Pekerjaan
Nama Pekerjaan
Hasil
Keterangan
Universitas Sumatera Utara
mysql_connect("localhost","root",""); mysql_select_db("rekomendasi"); /****DECISION TREE****/ //echo $userfinal; //memanggil pembanding pencari parameter $query1 = "select * from pelamar where user='$userfinal'"; $result1 = mysql_query($query1) or die(mysql_error()); while($row = mysql_fetch_array($result1)){ $kualf = $row['kualf_pend']; $jenis = $row['jen_pend']; $fresh = $row['fresh_graduate']; } //Mencari parameter $que=mysql_query("select * from dt_pendidikan where kualf_pend='$kualf' and jur_pend='$jenis'"); $res=mysql_num_rows($que); for($i=1;$i<=$res;$i++) { $e=mysql_fetch_array($que); $par = $e['parameter']; } /****NEAREST NEIGHBOUR****/ $que=mysql_query("select * from job_list_campur "); $numrow = mysql_num_rows($que); //echo $numrow; $query1 = "select * from pelamar"; $result1 = mysql_query($query1) or die(mysql_error()); while($row = mysql_fetch_array($result1)){ $id_pel = $row['id']; } for($id_job=1;$id_job<=$numrow;$id_job++){ $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("rekomendasi", $con); $query = "select SUM(bobot) from parameter where parameter='$par'"; $result = mysql_query($query) or die(mysql_error()); // sum b+d+f+h while($row = mysql_fetch_array($result)){
Universitas Sumatera Utara
$a = $row['SUM(bobot)']; } //variabel jenis pendidikan //input pembanding nilai1 -> untuk database daftar pekerjaan $query1 = "select * from job_list_campur where id=$id_job"; $result1 = mysql_query($query1) or die(mysql_error()); while($row = mysql_fetch_array($result1)){ $b = $row['jen_pend']; $fresh_job = $row['fresh_graduate']; $para = $row['parameter']; } //input pembanding nilai2 -> untuk pelamar pekerjaan $query1 = "select * from pelamar where user='$userfinal'"; $result1 = mysql_query($query1) or die(mysql_error()); while($row = mysql_fetch_array($result1)){ $c = $row['jen_pend']; } //Mencari bobot dengan membandingkan nilai1 dan nilai2 $que=mysql_query("select * from jen_pend where nilai1='$c' and nilai2='$b'"); $res=mysql_num_rows($que); for($i=1;$i<=$res;$i++) { $e=mysql_fetch_array($que); $d = $e['bobot']; //echo "
"; } //variabel kualifikasi pendidikan //input pembanding nilai1 -> untuk database daftar pekerjaan $query1 = "select * from job_list_campur where id=$id_job"; $result1 = mysql_query($query1) or die(mysql_error()); while($row = mysql_fetch_array($result1)){ $b = $row['kualf_pend']; $nama_job = $row['nama_job']; } //input pembanding nilai2 -> untuk pelamar pekerjaan $query1 = "select * from pelamar where user='$userfinal'"; $result1 = mysql_query($query1) or die(mysql_error()); while($row = mysql_fetch_array($result1)){ $c = $row['kualf_pend']; } //Mencari bobot dengan membandingkan nilai1 dan nilai2 $que=mysql_query("select * from pembanding where variabel='kualf_pend' and nilai1='$c' and nilai2='$b'");
Universitas Sumatera Utara
$res=mysql_num_rows($que); for($i=1;$i<=$res;$i++) { $e=mysql_fetch_array($que); $m = $e['bobot']; //echo "
"; } //variabel ip //input pembanding nilai1 -> untuk database daftar pekerjaan $query1 = "select * from job_list_campur where id=$id_job"; $result1 = mysql_query($query1) or die(mysql_error()); while($row = mysql_fetch_array($result1)){ $b = $row['ip']; if($b >=2.75 && $b <= 2.99){ $b = 'c'; } else if($b >=3.00 && $b <= 3.49){ $b = 'b'; } else if($b >=3.5 && $b <= 4.0){ $b = 'a'; }} //input pembanding nilai2 -> untuk pelamar pekerjaan $query1 = "select * from pelamar where user='$userfinal'"; $result1 = mysql_query($query1) or die(mysql_error()); while($row = mysql_fetch_array($result1)){ $c = $row['ip']; if($c >=2.75 && $c <= 2.99){ $c = 'c'; } else if($c >=3.00 && $c <= 3.49){ $c = 'b'; } else if($c >=3.5 && $c <= 4.0){ $c = 'a'; } else{ echo "no"; } } //Mencari bobot dengan membandingkan nilai1 dan nilai2 $que=mysql_query("select * from pembanding where variabel='ip' and nilai1='$c' and nilai2='$b'"); $res=mysql_num_rows($que);
Universitas Sumatera Utara
for($i=1;$i<=$res;$i++) { $e=mysql_fetch_array($que); $n = $e['bobot']; } //variabel kemampuan komputer //input pembanding nilai1 -> untuk database daftar pekerjaan $query1 = "select * from job_list_campur where id=$id_job"; $result1 = mysql_query($query1) or die(mysql_error()); while($row = mysql_fetch_array($result1)){ $b = $row['kem_kom']; } //input pembanding nilai2 -> untuk pelamar pekerjaan $query1 = "select * from pelamar where user='$userfinal'"; $result1 = mysql_query($query1) or die(mysql_error()); while($row = mysql_fetch_array($result1)){ $c = $row['kem_kom']; } //Mencari bobot dengan membandingkan nilai1 dan nilai2 $que=mysql_query("select * from pembanding where variabel='kem_komp' and nilai1='$c' and nilai2='$b'"); $res=mysql_num_rows($que); for($i=1;$i<=$res;$i++) { $e=mysql_fetch_array($que); $o = $e['bobot']; } //variabel fresh graduate //input pembanding nilai1 -> untuk database daftar pekerjaan $query1 = "select * from job_list_campur where id=$id_job"; $result1 = mysql_query($query1) or die(mysql_error()); while($row = mysql_fetch_array($result1)){ $b = $row['fresh_graduate']; } //input pembanding nilai2 -> untuk pelamar pekerjaan $query1 = "select * from pelamar where user='$userfinal'"; $result1 = mysql_query($query1) or die(mysql_error()); while($row = mysql_fetch_array($result1)){ $c = $row['fresh_graduate']; } //Mencari bobot dengan membandingkan nilai1 dan nilai2 $que=mysql_query("select * from pembanding where variabel='fresh_graduate' and nilai1='$c' and nilai2='$b'"); $res=mysql_num_rows($que);
Universitas Sumatera Utara
for($i=1;$i<=$res;$i++) { $e=mysql_fetch_array($que); $fg = $e['bobot']; //echo "
"; } //variabel Pengalaman Kerja //input pembanding nilai1 -> untuk database daftar pekerjaan $query1 = "select * from job_list_campur where id=$id_job"; $result1 = mysql_query($query1) or die(mysql_error()); while($row = mysql_fetch_array($result1)){ $b = $row['peng_kerja']; } //input pembanding nilai2 -> untuk pelamar pekerjaan $query1 = "select * from pelamar where user='$userfinal'"; $result1 = mysql_query($query1) or die(mysql_error()); while($row = mysql_fetch_array($result1)){ $c = $row['peng_kerja']; } //Mencari bobot dengan membandingkan nilai1 dan nilai2 $que=mysql_query("select * from pembanding where variabel='peng_kerja' and nilai1='$c' and nilai2='$b'"); $res=mysql_num_rows($que); for($i=1;$i<=$res;$i++) { $e=mysql_fetch_array($que); $pk = $e['bobot']; //echo "
"; } //variabel gaji //input pembanding nilai1 -> untuk database daftar pekerjaan $query1 = "select * from job_list_campur where id=$id_job"; $result1 = mysql_query($query1) or die(mysql_error()); while($row = mysql_fetch_array($result1)){ $b = $row['gaji']; } //input pembanding nilai2 -> untuk pelamar pekerjaan $query1 = "select * from pelamar where user='$userfinal'"; $result1 = mysql_query($query1) or die(mysql_error()); while($row = mysql_fetch_array($result1)){ $c = $row['gaji']; } //Mencari bobot dengan membandingkan nilai1 dan nilai2 $que=mysql_query("select * from pembanding where variabel='gaji' and nilai1='$c' and nilai2='$b'"); $res=mysql_num_rows($que);
Universitas Sumatera Utara
for($i=1;$i<=$res;$i++) { $e=mysql_fetch_array($que); $gaji = $e['bobot']; //echo "
"; } //variabel tipe pekerjaan //input pembanding nilai1 -> untuk database daftar pekerjaan $query1 = "select * from job_list_campur where id=$id_job"; $result1 = mysql_query($query1) or die(mysql_error()); while($row = mysql_fetch_array($result1)){ $b = $row['tipe_pekerjaan']; } //input pembanding nilai2 -> untuk pelamar pekerjaan $query1 = "select * from pelamar where user='$userfinal'"; $result1 = mysql_query($query1) or die(mysql_error()); while($row = mysql_fetch_array($result1)){ $c = $row['tipe_pekerjaan']; } //Mencari bobot dengan membandingkan nilai1 dan nilai2 $que=mysql_query("select * from pembanding where variabel='tipe_pekerjaan' and nilai1='$c' and nilai2='$b'"); $res=mysql_num_rows($que); for($i=1;$i<=$res;$i++) { $e=mysql_fetch_array($que); $tp = $e['bobot']; } //variabel kemampuan kerjasama //input pembanding nilai1 -> untuk database daftar pekerjaan $query1 = "select * from job_list_campur where id=$id_job"; $result1 = mysql_query($query1) or die(mysql_error()); while($row = mysql_fetch_array($result1)){ $b = $row['kem_kerjasama']; } //input pembanding nilai2 -> untuk pelamar pekerjaan $query1 = "select * from pelamar where user='$userfinal'"; $result1 = mysql_query($query1) or die(mysql_error()); while($row = mysql_fetch_array($result1)){ $c = $row['kem_kerjasama']; } //Mencari bobot dengan membandingkan nilai1 dan nilai2 $que=mysql_query("select * from pembanding where variabel='kem_kerjasama' and nilai1='$c' and nilai2='$b'"); $res=mysql_num_rows($que); for($i=1;$i<=$res;$i++) { $e=mysql_fetch_array($que);
Universitas Sumatera Utara
$kk = $e['bobot']; //echo "
"; } //variabel lokasi //input pembanding nilai1 -> untuk database daftar pekerjaan $query1 = "select * from job_list_campur where id=$id_job"; $result1 = mysql_query($query1) or die(mysql_error()); while($row = mysql_fetch_array($result1)){ $b = $row['lokasi']; } //input pembanding nilai2 -> untuk pelamar pekerjaan $query1 = "select * from pelamar where user='$userfinal'"; $result1 = mysql_query($query1) or die(mysql_error()); while($row = mysql_fetch_array($result1)){ $c = $row['lokasi']; } //Mencari bobot dengan membandingkan nilai1 dan nilai2 if($c=$b){ $loka='1'; } else { $loka='0.5'; } //variabel mutasi //input pembanding nilai1 -> untuk database daftar pekerjaan $query1 = "select * from job_list_campur where id=$id_job"; $result1 = mysql_query($query1) or die(mysql_error()); while($row = mysql_fetch_array($result1)){ $b = $row['mutasi']; } //input pembanding nilai2 -> untuk pelamar pekerjaan $query1 = "select * from pelamar where user='$userfinal'"; $result1 = mysql_query($query1) or die(mysql_error()); while($row = mysql_fetch_array($result1)){ $c = $row['mutasi']; } //Mencari bobot dengan membandingkan nilai1 dan nilai2 $que=mysql_query("select * from pembanding where variabel='mutasi' and nilai1='$c' and nilai2='$b'"); $res=mysql_num_rows($que); for($i=1;$i<=$res;$i++) { $e=mysql_fetch_array($que); $muta = $e['bobot']; } //variabel travelling //input pembanding nilai1 -> untuk database daftar pekerjaan $query1 = "select * from job_list_campur where id=$id_job"; $result1 = mysql_query($query1) or die(mysql_error());
Universitas Sumatera Utara
while($row = mysql_fetch_array($result1)){ $b = $row['travelling']; } //input pembanding nilai2 -> untuk pelamar pekerjaan $query1 = "select * from pelamar where user='$userfinal'"; $result1 = mysql_query($query1) or die(mysql_error()); while($row = mysql_fetch_array($result1)){ $c = $row['travelling']; } //Mencari bobot dengan membandingkan nilai1 dan nilai2 $que=mysql_query("select * from pembanding where variabel='traveling' and nilai1='$c' and nilai2='$b'"); $res=mysql_num_rows($que); for($i=1;$i<=$res;$i++) { $e=mysql_fetch_array($que); $trav = $e['bobot']; } //variabel kem_bahasa_eng //input pembanding nilai1 -> untuk database daftar pekerjaan $query1 = "select * from job_list_campur where id=$id_job"; $result1 = mysql_query($query1) or die(mysql_error()); while($row = mysql_fetch_array($result1)){ $b = $row['kem_bahasa_eng']; } //input pembanding nilai2 -> untuk pelamar pekerjaan $query1 = "select * from pelamar where user='$userfinal'"; $result1 = mysql_query($query1) or die(mysql_error()); while($row = mysql_fetch_array($result1)){ $c = $row['kem_bahasa_eng']; } //Mencari bobot dengan membandingkan nilai1 dan nilai2 $que=mysql_query("select * from pembanding where variabel='kem_bahasa_eng' and nilai1='$c' and nilai2='$b'"); $res=mysql_num_rows($que); for($i=1;$i<=$res;$i++) { $e=mysql_fetch_array($que); $kbe = $e['bobot']; } //variabel kem_bahasa_cina //input pembanding nilai1 -> untuk database daftar pekerjaan $query1 = "select * from job_list_campur where id=$id_job"; $result1 = mysql_query($query1) or die(mysql_error()); while($row = mysql_fetch_array($result1)){ $b = $row['kem_bahasa_cina']; } //input pembanding nilai2 -> untuk pelamar pekerjaan
Universitas Sumatera Utara
$query1 = "select * from pelamar where user='$userfinal'"; $result1 = mysql_query($query1) or die(mysql_error()); while($row = mysql_fetch_array($result1)){ $c = $row['kem_bahasa_cina']; } //Mencari bobot dengan membandingkan nilai1 dan nilai2 $que=mysql_query("select * from pembanding where variabel='kem_bahasa_cina' and nilai1='$c' and nilai2='$b'"); $res=mysql_num_rows($que); for($i=1;$i<=$res;$i++) { $e=mysql_fetch_array($que); $kbc = $e['bobot']; } //array nilai perkalian di parameter teknologi atau nilai dari b+d+f+h if ($par='par_tek'){ $f = array (1,0.75,0.75,1,0.5,0.75,0.5,0.75,0.75,0.75,0.5,0.5,0.75,0.75); } else { echo "error"; } //menghitung simillarity nearest neighbor (formula) $has = (($d*$f[0])+($m*$f[1])+($n*$f[2])+($o*$f[3])+($fg*$f[4])+($pk*$f[5])+($gaji*$f[6] )+($tp*$f[7])+($kk*$f[8])+($loka*$f[9])+($muta*$f[10])+($trav*$f[11])+($kbe*$f[1 2])+($kbc*$f[13]))/$a; if ($fresh_job == 'tidak' && $fresh == 'ya') { $hasil = $has * 0; $ket = "tidak menerima fresh graduate"; } else if ($fresh_job == 'ya' && $fresh == 'ya') { $hasil = $has; $ket = "menerima fresh graduate"; } else if ($fresh_job == 'ya' && $fresh == 'tidak') { $hasil = $has; $ket = "menerima fresh graduate"; } //insert temp untuk sorting mysql_query("insert into tempori(id,nama_job,temp,ket,parameter) values ('$id_pel','$nama_job','$hasil','$ket','$para')"); //mysql_close($con); mysql_query("DELETE FROM tempori where parameter='par_ekonomi'"); mysql_query("DELETE FROM tempori where parameter='par_kedokteran'"); //mysql_close($con);
Universitas Sumatera Utara
} //sorting $query1 = "select * from tempori order by temp desc limit $mulai,$jum_page"; $result1 = mysql_query($query1) or die(mysql_error()); while($row = mysql_fetch_array($result1)){ $c = $row['temp']; $d = $row['nama_job']; $e = $row['ket']; echo "
$d
$c
$e
"; }
?>
Tampil Semua Rekomendasi
|
Pilih Pekerjaan
Universitas Sumatera Utara
×
Report "No title"
Your name
Email
Reason
-Select Reason-
Pornographic
Defamatory
Illegal/Unlawful
Spam
Other Terms Of Service Violation
File a copyright complaint
Description
×
Sign In
Email
Password
Remember me
Forgot password?
Sign In
Our partners will collect data and use cookies for ad personalization and measurement.
Learn how we and our ad partner Google, collect and use data
.
Agree & close