Using Jquery Ajax to retrieve data from Mysql

by

For retrieving data using Ajax + jQuery, you should write the following code: 

 <html>
 <script type="text/javascript" src="https://stackoverflow.com/questions/16707648/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","");

For displaying the data from database, you should write this :

<?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>";
?>

More Related Contents:

  1. How to populate second dropdown based on selection of first dropdown using jQuery/AJAX and PHP/MySQL?
  2. HTML – Change\Update page contents without refreshing\reloading the page
  3. Inserting into MySQL from PHP (jQuery/AJAX)
  4. How to refresh parent page after closing popup window in jQUERY? [duplicate]
  5. How do I post multiple parameters to a URL
  6. Can anyone help me what is wrong in this code ajax using with php? [closed]
  7. Is the following code valid? [closed]
  8. I dont want the users to log in two times from WordPress and cakephp [closed]
  9. PHP display div with select option
  10. jQuery Validate remote method usage to check if username already exists
  11. Laravel csrf token mismatch for ajax POST Request
  12. Form submit with AJAX passing form data to PHP without page refresh [duplicate]
  13. How to upload multiple files using PHP, jQuery and AJAX
  14. Laravel 5.5 ajax call 419 (unknown status)
  15. Sending JSON to PHP using ajax
  16. Ajax LARAVEL 419 POST error
  17. Upload Multiple Files with PHP and JQuery
  18. jQuery ajax request with json response, how to?
  19. Javascript POST not working – Sending Javascript array to PHP
  20. Ajax File Download using Jquery, PHP
  21. Pass data from jQuery to PHP for an ajax post
  22. How do I return a proper success/error message for JQuery .ajax() using PHP?
  23. PHPExcel download using ajax call
  24. Sending HTML Code Through JSON
  25. Dynamic shipping fee based on custom radio buttons in Woocommerce
  26. UTF-8 character encoding battles json_encode() [duplicate]
  27. Call PHP function from jQuery?
  28. Jquery AJAX post to PHP
  29. show progressbar while loading pages using jquery ajax in single page website
  30. How to send the values of an array of checkboxes through Ajax using jQuery?

Leave a Comment