PHP,java script and HTML

[hellopo_11]

Sana po matutongan, guto ko lang po makuha yung id ng book gamit ang radio button na ma iistore sya as book id sa database
<div class="section2">
<h1>ISSUE A NEW BOOKS</h1>
<hr>
<div class="disp1">
<h1>ISSUE A NEW BOOK</h1>
<div class="bgtop2"></div>
<form action="toissuebooks.php" method="post">

<div class="addiss">
<label for="iss">Student Id:</label><br>
<input class="inn" type="text" name="stid" placeholder="Student SID" required>
<div class="student-info"></div>
</div>
<div class="addiss">
<label for="issu">ISBN or Bookname:</label><br>
<input class="inn" type="text" name="isbnname" required>
</div>
<div class="book-info"></div>

<button class="addbtn1" type="submit" name="submit" value="add">ADD</button>
<input type="hidden" name="selectedid" id="selectedid" value="">

</form>
</div>
</div>
<script>
$(document).ready(function () {
// Kapag nagbago ang nilalaman ng input
$("input[name='stid']").on('input', function () {
var studentId = $(this).val();
// AJAX request
$.ajax({
type: 'POST',
url: 'showname.php',
data: { stid: studentId },
success: function (data) {
$(".student-info").html(data);
},
error: function () {
console.log('Error in AJAX request.');
}
});
});
$("input[name='isbnname']").on('input', function () {
var isbnOrBookName = $(this).val();
// AJAX request
$.ajax({
type: 'POST',
url: 'showbooks.php',
data: { isbnname: isbnOrBookName },
success: function (data) {
$(".book-info").html(data);
},
error: function () {
console.log('Error in AJAX request.');
}
});
});

// Radio button change event
$('input[name=selectedid]').on('change', function () {
var selectedid = $(this).val();
$('#selectedid').val(selectedid);
console.log("Selected Book ID: " + selectedid); // Add this line for debugging
});
});
</script>

ito yung para ma show kung alin books ang pipiliin
<?php
include "../connet.php";
if (isset($_POST['isbnname'])) {
$isbnOrBookName = mysqli_real_escape_string($db, $_POST['isbnname']);
// Check if the input is not empty
if (!empty($isbnOrBookName)) {
$query = "SELECT * FROM tbbooks WHERE isbn LIKE '%$isbnOrBookName%' OR bookName LIKE '%$isbnOrBookName%'";
$result = mysqli_query($db, $query);
if ($result && mysqli_num_rows($result) > 0) {

while ($row = mysqli_fetch_assoc($result)) {
echo "<div class='search-result'>";
echo "<img src='{$row['bookimg']}' alt='Book Image' style='margin-top: 20px; margin-left: 20px; height: 250px; width: 170px;'>";
echo "<p style='margin-top: 20px; margin-left: 20px;'>Book Name: {$row['bookName']}</p>";
echo "<p style='margin-left: 20px;'>Book Author: {$row['bookAuthors']}</p>";
echo "<input type='radio' name='selectedid' value='{$row['bookName']}' style='margin-left: 20px; height:25px;'>";
echo "</div>";
}
} else {
echo "<p>No books found.</p>";
}
}
} else {
echo "<p>Invalid request.</p>";
}
?>

ito yung pag store sa database
<?php
include "../connet.php";
if (isset($_POST['submit'])) {
if ($_POST['submit'] === 'add') {
$studentId = mysqli_real_escape_string($db, $_POST['stid']);
$bookId = isset($_POST['selectedid']) ? mysqli_real_escape_string($db, $_POST['selectedid']) : '';
// Insert data into the 'issuebook' table
$insertQuery = "INSERT INTO issuebook (studentid, bookid) VALUES ('$studentId', '$bookId')";
$insertResult = mysqli_query($db, $insertQuery);
if ($insertResult) {
echo '<script type="text/javascript">alert("Issued Successfully");</script>';
} else {
echo '<script type="text/javascript">alert("Error issuing the book");</script>';
}
} else {
echo "Invalid request";
}
}
?>

 

[LocalHost 8080]

kapag radio button boss. NAME ang kunin mo. para makuha yung value

example
HTML

<form id="myForm">
    <input type="radio" name="gender" value="Male"> Male
    <input type="radio" name="gender" value="Female"> Female
    <input type="radio" name="gender" value="Other"> Other
</form>

JS

var radios = document.getElementsByName('gender');
var value;

for (var i = 0; i < radios.length; i++) {
    if (radios.checked) {
        value = radios.value;       
        break;
    }
}

alert(value);

 

[hellopo_11]

kapag radio button boss. NAME ang kunin mo. para makuha yung value

example
HTML

<form id="myForm">
    <input type="radio" name="gender" value="Male"> Male
    <input type="radio" name="gender" value="Female"> Female
    <input type="radio" name="gender" value="Other"> Other
</form>

JS

var radios = document.getElementsByName('gender');
var value;

for (var i = 0; i < radios.length; i++) {
    if (radios.checked) {
        value = radios.value;     
        break;
    }
}

alert(value);

Thank you lods

 

[LocalHost 8080]

Thank you lods

welcome. sana nakatulong. feel free to approach kung may tanong pa