No title

LAMPIRAN LISTING PROGRAM

nn.php
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)){


$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'");


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


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


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


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


$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());


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


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


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

?>

Rekomendasi Pekerjaan

Nama Pekerjaan Hasil Keterangan

$d $c $e

Tampil Semua Rekomendasi | Pilih Pekerjaan


Rekomendasi Pekerjaan
Nama Pekerjaan	Hasil	Keterangan
$d	$c	$e
Tampil Semua Rekomendasi \| Pilih Pekerjaan

No title

Recommend Documents