Скачать или смотреть Collecting matching records from MySQL database by passing filter string using load() in JQuery

https://www.plus2net.com/jquery/load-...
https://www.plus2net.com/jquery/basic...
https://www.plus2net.com/sql_tutorial...

In our student table there are 35 records. Each student have one class columns having data from class Three to class Nine.
By using radio buttons we will select one of the available classes and this selection will be collected on change event or on any change in selection of radio buttons.
class1=$("input[name=r1]:checked").val()
This data ( about the class selection by user ) is stored in a variable and same is passed to our backend script loadck.php file using load() function.
$('#d').load('loadck.php?class='+class1);
Here is the complete Jquery code.
$(document).ready(function() {
// Jquery code here ///
$("input[type='radio']").change(function() {
class1=$("input[name=r1]:checked").val()
$('#d').load('loadck.php?class='+class1);
});
///
});
With this code our data in terms of selection of user ( from class three to class nine ) will be passed to backend program script loadck.php. Inside this loadck.php first we will collect the filter data posted from our front end JQuery code.
$class=$_GET['class']; // collect the student class
This variable $class will be used in our PHP script to get the data from MySQL table using PDO database connection. You can download the zip file with full script including the sample table ( sql dump ).