In this tutorial I am going to discuss how to show data from database on page load<\/strong>. With the help of AJAX we are going to achieve this. I know AJAX is one of the very hot topic for PHP beginners. Because it is using almost in every site. I will use jQuery<\/a> and its ajax function to trigger ajax. <\/p>\n

Also Read:<\/p>\n

\n
• How to sort html table columns using PHP jQuery and Ajax<\/a><\/li>\n
• Ajax dropdown list from Database using PHP and jQuery<\/a><\/li>\n
• How to Create Simple Contact Form using Ajax, jQuery, Php and Mysql<\/a><\/li>\n<\/ul>\n

  What I am going to do?<\/h3>\n

  I will create a page that shows customer information in a table. I will achieve this with the help of following steps.<\/p>\n

  \n
  • I will trigger ajax on page load (index.php)<\/code>. I will also show a loading bar unless I get the data.<\/li>\n
  • Ajax request will receive by ajax_get_data.php<\/code>. ajax_get_data.php<\/code> fetch records from mysql database using MYSQLi OOP<\/a>.<\/li>\n
  • Then I will create a html table and insert customers record in table column and print table.<\/li>\n
  • Ajax response(table html) will receive on index.php page. Then i will show that response on index.php<\/code> page.<\/li>\n<\/ul>\n
    \n<\/ins>
    \n