Script sql menyimpan hasil pembagian kedalam tabel didatabase

ini script code untuk tampil data <pre> &lt;?php include "../koneksi.php";

$result1=mysqli_query($con,"SELECT SUM(nilai_bobot) AS tb FROM kriteria") or die(mysqli_error($con)); while ($data = mysqli_fetch_array($result1)) { $tbb = $data['tb']; } ?&gt; &lt;html&gt; &lt;head&gt;

</head>

&lt;body&gt;

&lt;h4 align="center"&gt;Bobot Faktor&lt;/h4&gt;&lt;br /&gt; &lt;h5&gt;Data Bobot Faktor&lt;/h5&gt; &lt;table class="table table-bordered"&gt; &lt;thead&gt; &lt;tr class="success" &gt; &lt;th style="vertical-align:middle; text-align:center;"&gt;No.&lt;/th&gt; &lt;th style="vertical-align:middle; text-align:center;"&gt;Faktor&lt;/th&gt; &lt;th style="vertical-align:middle; text-align:center;"&gt;Nilai Bobot&lt;/th&gt; &lt;th style="vertical-align:middle; text-align:center;"&gt;Normalisasi Bobot&lt;/th&gt; &lt;th style="vertical-align:middle; text-align:center;"&gt;Opsi&lt;/th&gt; &lt;/tr&gt; &lt;/thead&gt; &lt;tbody&gt; &lt;?php $query = mysqli_query($con, "SELECT * FROM kriteria") or die(mysqli_error($con)); $nomor = 1;

while($data = mysqli_fetch_array($query)) {
?>
<tr>
<td align="center"><?php echo $nomor++; ?>.</td>
<td><?php echo $data['kriteria']; ?></td>
<td style="vertical-align:middle; text-align:right;"><?php echo $data['nilai_bobot']; ?></td>
<td style="vertical-align:middle; text-align:right;">
<?php 
$hasil_b = $data['nilai_bobot']/$tbb;
// $insert2 = mysqli_query($con, "UPDATE kriteria SET hasil_bobot=")
echo $hasil_b;
?>
</td> 
<td>
								
</td>
  </tr>
					
<?php
} 
?> 

&lt;/tbody&gt; &lt;tfoot&gt; &lt;th colspan="2"&gt;Total&lt;/th&gt; &lt;th style="text-align: right;"&gt;&lt;?=$tbb;?&gt;&lt;/th&gt; &lt;th&gt;&lt;/th&gt; &lt;/tfoot&gt; &lt;/table&gt;

</pre>

ini script untuk insert data

<pre> &lt;?php include '../koneksi.php';

$nama_kriteria = $_POST['kriteria']; $nilai_bobot = $_POST['nilai_bobot']; $hasil_b = $_POST['hasil_bobot'];

$query = mysqli_query($con, "INSERT INTO kriteria(kriteria,nilai_bobot,hasil_bobot)VALUES ('$nama_kriteria','$nilai_bobot','hasil_b')") or die(mysqli_error($con)); if($query) { echo "&lt;script&gt;alert('Data berhasil ditambahkan!'); window.location='kriteria.php';&lt;/script&gt;"; } else { echo "&lt;script&gt;alert('Data gagal ditambahkan');&lt;/script&gt;"; } </pre> hasil nya : <img src='https://i.imgur.com/hrnvP9v.jpg'> normalisasi bobot(nama field dalam tabel database hasil_bobot)itu sendiri didapat dengan rumus: nilai_bobot dibagi dengan jumlah keseluruhan nilai_bobot. jadi masalah nya normalisasi bobot gk ke insert kedatabase, hasil nya tetap 0 didalam database. saya gak tau gimana cara insert normalisasi bobot kedatabase. saya hanya bisa menampilkan normalisasi bobot. Mohon bantuannya !

variable hasil_b kurang $, ganti jadi <pre> $query = mysqli_query($con, "INSERT INTO kriteria(kriteria,nilai_bobot,hasil_bobot)VALUES ('$nama_kriteria','$nilai_bobot','$hasil_b')"); </pre>

ini script mencari total nilai bobot <pre> $result1=mysqli_query($con,"SELECT SUM(nilai_bobot) AS tb FROM kriteria") or die(mysqli_error($con)); while ($data = mysqli_fetch_array($result1)) { $tbb = $data['tb']; } </pre>

sedangkan ini script mencari hasil_bobot <pre> &lt;td&gt; &lt;?php $hasil_b = $data['nilai_bobot']/$tbb; ?&gt; &lt;/td&gt; </pre> script insert data <pre> $nama_kriteria = $_POST['kriteria']; $nilai_bobot = $_POST['nilai_bobot']; $hasil_b = $_POST['hasil_bobot'];

$query = mysqli_query($con, "INSERT INTO kriteria(kriteria,nilai_bobot,hasil_bobot)VALUES ('$nama_kriteria','$nilai_bobot','$hasil_b')") or die(mysqli_error($con)); if($query) { echo "&lt;script&gt;alert('Data berhasil ditambahkan!'); window.location='kriteria.php';&lt;/script&gt;"; } else { echo "&lt;script&gt;alert('Data gagal ditambahkan');&lt;/script&gt;"; } </pre>