
???? ???? ?? ???
? ???? ?? ???? ??? ???? ??? ??? ? ?? ??? ? ??? ??? ????. ?? ???? ???? ??? ?? ?? ???? ?????. ? ??? ????? JavaScript(jQuery)? ??? ????(PHP)? ??? ???? ?????.
?? ?? ??
? ?? ??????? ? ?? ???? ???? ??? ?? ???? ? ?? ???? ??? ???? ???. ??? ??? ?? ??? ???? ?? ?????.
-
??? ?? ??: ???? ? ?? ???? ???? ?? ??? ???? jQuery ??? ???? ??? ????. ????????. ? ???? $(this).val()? ???? ??? ??? ?? ?????.
-
?? ???: jQuery? AJAX ??? ???? ??? ??? ????? ?????. PHP ????, another_php_file.php. ??? ?? ??? ?? sel_stud? ?? ???? ?????.
-
??? ??: another_php_file.php ????? ??? ???? ???? ??? ?????? ??? ???? ??? ??? ??? ?? ???? ???? ????? ? ?? ????? ?? HTML ???? ??? ??? ?????. box.
-
???? ?? ????: ????? ?? ??? AJAX ?? ??? ??? ?? ?????. ? ?? ???? ??? ?? HTML ???? $('#LaDIV').html(whatigot);.
??? ??? ?
? ???? DOM? ?????.
? ?? ??? ? ?? ???? ??? ???? ?? ??? ???? ??? ?? ??? ?????. ???? ? ?? ???? ??? ?? ??? ???? ?? ??? ?????.
tester.php
<html>
<head>
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
<script type="text/javascript">
$(function() {
$('#stSelect').change(function() {
var sel_stud = $(this).val();
$.ajax({
type: "POST",
url: "another_php_file.php",
data: 'theOption=' + sel_stud,
success: function(whatigot) {
$('#LaDIV').html(whatigot);
}
});
});
});
</script>
</head>
<body>
<select name="students">
another_php_file.php
<?php
// Database Connection
$server = 'localhost';
$login = 'root';
$pword = '';
$dbname = 'test';
mysql_connect($server,$login,$pword) or die($connect_error);
mysql_select_db($dbname) or die($connect_error);
// Get POST Data
$selStudent = $_POST['theOption'];
// Query Database
$query = "SELECT * FROM `class` WHERE `teacher_id` = $selStudent";
$result = mysql_query($query) or die('Fn Error: ' . mysql_error());
$num_rows_returned = mysql_num_rows($result);
// Build Response HTML
$r = '
<select>
';
if ($num_rows_returned > 0) {
while ($row = mysql_fetch_assoc($result)) {
$r = $r . '<option value="' . $row['id'] . '">' . $row['name'] . '</option>';
}
} else {
$r = '<p>No classes taught by this student</p>';
}
// Echo Response
echo $r;
?>
? ??? ???? ? ?? ???? ??? ??? ???? ????? ?????. ??? ??? ?? ???? ???? ???? ??? ?? ???? ??? ???? ?? ??? ?????.
? ??? jQuery? PHP? ???? ? ?? ???? ??? ?? ??? ???? ? ?? ???? ??? ???? ???? ??? ?? ????? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!