Fetching Data Using Ajax and jQuery (FDUAJ)

I have a file, let's say file1.php, it contains a simple ajax code, but I only want to display records from a Mysql database table.

Besides that I also have another file, let's say file2.php, which I use to fetch records from mysql. In the database there are only two columns that I want to display, namely 'Name', 'Address'.

What code should I write to make both files work?

Completion

To fetch data using Ajax + jQuery, you need to write the following code:

<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>

For mysqli connection, write this:

<?php
$con=mysqli_connect("localhost","root","");
if (!$con)
{
    die('Could not connect: ' . mysqli_error());
}
?>

To display data from the database, you can use this, to make it more interesting you can modify it with CSS.

<?php
include("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>";
?>

Just a note: Support for mysql_* functions is officially deprecated , so please update your code with PDO or MySQLi to ensure future functionality of your project.

Fetching Data Using Ajax and jQuery (FDUAJ)

Completion

Post a Comment

نموذج الاتصال