OneCompiler

Teacher

127

Jsfile

<!DOCTYPEhtml> <html> <head> <title>TeacherDetails</title> <scriptsrc=https://code.jquery.com/jquery-3.6.0.min.js></script> </head> <body> <selectid=”teacher-list”> <optionvalue=””>--SelectTeacher--</option> <optionvalue=”1”>JohnDoe</option> <optionvalue=”2”>JaneSmith</option> <optionvalue=”3”>BobJohnson</option> </select> <buttonid=”submit-btn”>GetDetails</button> <divid=”details”></div> <script> $(document).ready(function(){ $(‘#submit-btn’).click(function(){ Vartno=$(‘#teacher-list’).val(); If(tno==‘’){ Alert(‘Pleaseselectateacher.’); Return; } $.ajax({ url:‘teacherdetails.php’, method:‘POST’, data:{tno:tno}, success:function(response){ $(‘#details’).html(response); }, Error:function(xhr,status,error){ Console.log(xhr.responseText); } }); }); }); </script> </body> </html>

teacherdetails.php

<?php //Connecttodatabase $servername=“localhost”; $username=“username”; $password=“password”; $dbname=“database_name”; $conn=mysqli_connect($servername,$username,$password,$dbname); //Checkconnection If(!$conn){ Die(“Connectionfailed:“.mysqli_connect_error()); } //Retrieveselectedteacherdetails If(isset($_POST[‘tno’])){ $tno=$_POST[‘tno’]; $sql=“SELECT*FROMTEACHERWHEREtno=‘$tno’”; $result=mysqli_query($conn,$sql); If(mysqli_num_rows($result)>0){ $row=mysqli_fetch_assoc($result); Echo“TeacherName:“.$row[‘tname’].“<br>”; Echo“Qualification:“.$row[‘qualification’].“<br>”; Echo“Salary:“.$row[‘salary’].“<br>”; }else{ Echo“Nodatafound.”; } } //Closedatabaseconnection Mysqli_close($conn); ?>