为了使用Ajax + jQuery检索数据，您应该编写以下代码：
<html> <script type="text/javascript" src="jquery-1.3.2.js"> </script> <script type="text/javascript"> $(document).ready(function() { $("#display").click(function() { $.ajax({ //create an ajax request to display.php type: "GET", url: "display.php", dataType: "html", //expect html to be returned success: function(response){ $("#responsecontainer").html(response); //alert(response); } });});});</script><body><h3 align="center">Manage Student Details</h3><table border="1" align="center"> <tr> <td> <input type="button" id="display" value="Display All Data" /> </td> </tr></table><div id="responsecontainer" align="center"></div></body></html>对于mysqli连接，请编写以下代码：
<?php $con=mysqli_connect("localhost","root","");为了显示数据库中的数据，您应该这样编写：
<?phpinclude("connection.php");mysqli_select_db("samples",$con);$result=mysqli_query("select * from student",$con);echo "<table border='1' ><tr><td align=center> <b>Roll No</b></td><td align=center><b>Name</b></td><td align=center><b>Address</b></td><td align=center><b>Stream</b></td></td><td align=center><b>Status</b></td>";while($data = mysqli_fetch_row($result)){ echo "<tr>"; echo "<td align=center>$data[0]</td>"; echo "<td align=center>$data[1]</td>"; echo "<td align=center>$data[2]</td>"; echo "<td align=center>$data[3]</td>"; echo "<td align=center>$data[4]</td>"; echo "</tr>";}echo "</table>";?>
