Menentukan Nilai Rating Kecocokan di PHP

Assalamu'alaykum,

Dear Teman2 Sekolah Koding,

mohon bantuannya, saya ada kesulitan untuk menentukan nilai rating kecocokan sesuai dengan kriteria nya.

saya ingin nilai di kotak nomor 1 itu bisa terisi di kotak nomor 2. sesuai judul kriteria nya. saat ini kondisinya masih seperti gambar berikut :gbr nilai kecocokan

terlihat hanya kriteria "Tingkat Sekolah" saja yang sudah sesuai. judul kriteria beserta nilai nya.

adapun script php nya sbb :

// query menampilkan tabel kriteria berdasarkan judul jenis kriteria
$queryjudulkriteria       = "SELECT * FROM tabel_kriteria";
$tampilqueryjudulkriteria = mysqli_query($link,$queryjudulkriteria);

while ($showjudulkriteria = mysqli_fetch_assoc($tampilqueryjudulkriteria)) {
   echo "<th>$showjudulkriteria[ket_kriteria]</th>";
   $no_id = $showjudulkriteria['id_kriteria'];

// query menampilkan tabel kriteria nilai crips
$sqltampilquerycrips = "SELECT * FROM tabel_kriteria_nilai_crips WHERE id_kriteria ='$no_id' ";
$sqltampilkriteriacrips = mysqli_query($link,$sqltampilquerycrips);

     // looping menentukan nilai crips
    while ($showcrips   = mysqli_fetch_assoc($sqltampilkriteriacrips)){
    $validasiidkriteria = $showcrips['id_kriteria'];
    // $tulis = $validasiidkriteria;
    // echo $tulis;

    if ($showjudulkriteria['id_kriteria'] == $validasiidkriteria){
        if (count($showjudulkriteria['id_kriteria']) == count($showcrips['crips2'])){
            $nilaicrips  = $showcrips['crips2'];
            echo $showjudulkriteria['ket_kriteria'] . " - " . $nilaicrips;
            echo "<br>";
        }
    }
    }
}

 // looping menampilkan data query kecocokan sesuai id kriterianya
$no = 1;
while ($showrating_kecocokan = mysqli_fetch_array($tampil_ratingkecocokan)) {

//-- kriteria lokasi (C1) -- //
  if (in_array($showrating_kecocokan['namaprovinsi'], $provinsi_dkijakarta)){
     $loc1 = $nilaicrips;
  }else if (in_array($showrating_kecocokan['namaprovinsi'], $provinsi_banten)){
     $loc1 = $nilaicrips;
  }else if (in_array($showrating_kecocokan['namaprovinsi'], $provinsi_jawabarat)){
     $loc1 = $nilaicrips;
  }else if (in_array($showrating_kecocokan['namaprovinsi'], $provinsi_jawatengah)){
     $loc1 = $nilaicrips;
  }else if (in_array($showrating_kecocokan['namaprovinsi'], $provinsi_jawatimur)){
     $loc1 = $nilaicrips;
  }else{
     $loc1 = 0;
  }

  if (in_array($showrating_kecocokan['namakota'], $kota_dkijakarta)){
     $loc2 = $nilaicrips;
  }else if (in_array($showrating_kecocokan['namakota'], $kota_banten)){
     $loc2 = $nilaicrips;
  }else if (in_array($showrating_kecocokan['namakota'], $kota_jawabarat)){
    $loc2 = $nilaicrips;
  }else{
    $loc2 = 0;
  }

  if (in_array($showrating_kecocokan['namakecamatan'], $kecamatan_dkijakarta)){
      $loc3 = $nilaicrips;
  }else if (in_array($showrating_kecocokan['namakecamatan'], $kecamatan_banten)){
      $loc3 = $nilaicrips;
  }else if (in_array($showrating_kecocokan['namakecamatan'], $kecamatan_jawabarat)){

      $loc3 = $nilaicrips;
  }else{
      $loc3 = 0;
  }

  $totalloc = $loc1;

//-- kriteria Fasilitas (C2) -- //

if ($showrating_kecocokan['jumlahmejakursiruangankomputer'] >= 31 && $showrating_kecocokan['jumlahmejakursiruangankomputer'] <= 100){
$fas1 = $nilaicrips;
}else if  ($showrating_kecocokan['jumlahmejakursiruangankomputer'] >= 21 && $showrating_kecocokan['jumlahmejakursiruangankomputer'] <= 30){
$fas1 = $nilaicrips;
}else if  ($showrating_kecocokan['jumlahmejakursiruangankomputer'] >= 11 && $showrating_kecocokan['jumlahmejakursiruangankomputer'] <= 20){
$fas1 = $nilaicrips;
}else if  ($showrating_kecocokan['jumlahmejakursiruangankomputer'] >= 5 && $showrating_kecocokan['jumlahmejakursiruangankomputer'] <= 10){
$fas1 = $nilaicrips;
}else{
$fas1 = 0;
}

if ($showrating_kecocokan['jumlahterminal'] >= 31 && $showrating_kecocokan['jumlahterminal'] <= 100){
$fas2 = $nilaicrips;
}else if  ($showrating_kecocokan['jumlahterminal'] >= 21 && $showrating_kecocokan['jumlahterminal'] <= 30){
$fas2 = $nilaicrips;
}else if  ($showrating_kecocokan['jumlahterminal'] >= 11 && $showrating_kecocokan['jumlahterminal'] <= 20){
$fas2 = $nilaicrips;
}else if  ($showrating_kecocokan['jumlahterminal'] >= 5 && $showrating_kecocokan['jumlahterminal'] <= 10){
$fas2 = $nilaicrips;
}else{
$fas2 = 0;
}

if ($showrating_kecocokan['dayalistrik'] >= 300000 && $showrating_kecocokan['dayalistrik'] <= 10000000){
$fas3 = $nilaicrips;
}else if ($showrating_kecocokan['dayalistrik'] >= 100000 && $showrating_kecocokan['dayalistrik'] <= 299000){
$fas3 = $nilaicrips;
}else if  ($showrating_kecocokan['dayalistrik'] >= 20000 && $showrating_kecocokan['dayalistrik'] <= 99000){
$fas3 = $nilaicrips;
}else if  ($showrating_kecocokan['dayalistrik'] >= 5000 && $showrating_kecocokan['dayalistrik'] <= 19000){
$fas3 = $nilaicrips;
}else if  ($showrating_kecocokan['dayalistrik'] >= 1000 && $showrating_kecocokan['dayalistrik'] <= 4900){
$fas3 = $nilaicrips;
}else{
$fas3 = 0;
}

if ($showrating_kecocokan['ackipasangin'] == "Ya"){
$fas4 = $nilaicrips;
}else if ($showrating_kecocokan['ackipasangin'] == "Tidak"){
$fas4 = $nilaicrips;
}else{
$fas4 = 0;
}

if ($showrating_kecocokan['jendelaruangan'] == "Ya"){
$fas5 = $nilaicrips;
}else if ($showrating_kecocokan['jendelaruangan'] == "Tidak"){
$fas5 = $nilaicrips;
}else{
$fas5 = $nilaicrips;
}

if ($showrating_kecocokan['teralisjendela'] == "Ya"){
$fas6 = $nilaicrips;
}else if ($showrating_kecocokan['teralisjendela'] == "Tidak"){
$fas6 = $nilaicrips;
}else{
$fas6 = $nilaicrips;
}

if ($showrating_kecocokan['teralispintumasuk'] == "Ya"){
$fas7 = $nilaicrips;
}else if ($showrating_kecocokan['teralispintumasuk'] == "Tidak"){
$fas7 = $nilaicrips;
}else{
$fas7 = $nilaicrips;
}

$totalfas = $fas1;

// -- kriteria tingkat sekolah (C3) -- //

if ($showrating_kecocokan['id_sekolah_tabel_sekolah'] == ($showrating_kecocokan['id_sekolah_tabel_sekolah_survey'])){
   $tkskol = $nilaicrips;
}
   $tksekolah = $tkskol;

  echo "<tr>
       <td>$no</td>
       <td>$showrating_kecocokan[namasekolah]</td>
       <td>$totalloc</td>
       <td>$totalfas</td>
       <td>$tksekolah</td>
       ";
  $no++;
  }

mohon pencerahannya.

terima kasih atas bantuan dan kerjasmanya dari teman2.

Wassalamu'alaykum

Permadiopa