Untitled

<!DOCTYPE html>
<html>
<?php
$servername = "localhost";
$username = "root";
$password = "";
$db = "belajar";

$conn = new mysqli($servername,$username,$password,$db);

if ($conn->connect_error){
    die ("Connection failed:" .$conn->connect_error);
}

$sql = "SELECT nama_produk, harga FROM produk";

$result = $conn->query($sql);
?>
<head>
    <title>Transaksi</title>
    <h1>Transaksi</h1>
</head>
<p>Nama Produk</p>
<?php
$id=0;
if ($result->num_rows > 0){
    while($data = $result->fetch_assoc()){
        $id++;
  echo    "<input type='radio' name='item' value='{$data['harga']}' id='id$id'>".$data['nama_produk']."</br>";


    }
} else{
    echo "0 results";
}
$query = "SELECT harga from produk WHERE nama_produk = 'value'"
?>

<script src="https://code.jquery.com/jquery-1.12.4.min.js"></script>
<script>
    $(document).ready(function(){
        $("input[type='radio']").click(function(){
            var radioValue = $("input[name='item']:checked").val();
            if(radioValue){
                // alert("Your are a - " + radioValue);
                $('#nilai').val(radioValue);
            }
        });
    });

</script>


<form action="transaksi.php">
    Harga: <input type="text" id="nilai" name="nilai">
    Kuantitas: <input type="text" id="qty" name="qty">
    <script>
    $(document).ready(function(){
        $("input[type='text']").click(function(){
            var radioValue = $("input[name='qty']:checked").val();
            if(radioValue){
                // alert("Your are a - " + radioValue);
                $('#qty').val(radioValue);
            }
        });
    });

</script>
</form>

<?php

$conn->close();

?>
</html>