Most Popular Tutorials
-
What is php?
-
How to install php?
-
How to write program in php?
-
what is variable?
-
Variable handling function in php
-
Variable scope
-
PHP Constant
-
DataType
-
PHP Operators
-
PHP Comments
-
php If else statements
-
PHP Loop
-
Continue and Break
-
switch statement
-
Typecasting
-
Types of errors in php
-
Function
-
Date Function
-
Header function
-
php inbuilt function
-
unlink & unset
-
what is filter_var() function in php?
-
ob_start
-
htmlspecialchars() and htmlentities()
-
array
-
Array Short function
-
Array Function
-
String
-
String function
-
Get & Post methods
-
include and require
-
implode and explode function
-
Cookies
-
Session
-
File uploading in php
-
File Handling
-
File Handling Functions
-
Exception
-
PHP GD Library (Images)
-
Curl
-
Encription and Decription
-
SQL injection
-
Security for website
-
Captcha
-
Server variable
-
Insert Data using Ajax
-
View Data Using Ajax
-
Update Data Using Ajax
-
Delete Data Using Ajax
-
serialize method using Ajax
-
Upload Data using Ajax
-
Check username availability using ajax
-
Check duplicate email using ajax
-
Delete multiple data using ajax with checkbox
-
Ckeditor Using Ajax
-
Show loading image using Ajax
-
301 and 302 Redirect Page
-
Number format function
-
url rewriting using htaccess
-
Google map
-
PHP Programs
-
Login, Registration and Logout application
-
CRUD in php
-
CRUD with Procedure
-
Trigger
-
PHP Interview Questions
Most Popular Tutorials :-
Simply Easy Learning at Your Fingertips. Click Tutorials Menu to view More Tutorial List
How to show data using ajax in php?
How to show dynamic data in php using ajax?
Database Connection
File Name : database.php
<?php
$servername = "localhost";
$username = "root";
$password = "";
$db="itechxpert";
$conn = mysqli_connect($servername, $username, $password,$db);
?>
$servername = "localhost";
$username = "root";
$password = "";
$db="itechxpert";
$conn = mysqli_connect($servername, $username, $password,$db);
?>
View Page
File Name : index.php
<!DOCTYPE html>
<html lang="en">
<head>
<title>How to show dynamic data in php using ajax</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js"></script>
</head>
<body>
<div class="container">
<h2>How to show dynamic data in php using ajax</h2>
<table class="table table-bordered table-sm" >
<thead>
<tr>
<th>Name</th>
<th>Email</th>
<th>mobile</th>
<th>City</th>
</tr>
</thead>
<tbody id="view_data">
</tbody>
</table>
</div>
<script>
$(document).ready(function() {
$.ajax({
url: "View_ajax.php",
type: "POST",
cache: false,
success: function(data){
alert(data);
$('#view_data').html(data);
}
});
});
</script>
</body>
</html>
<html lang="en">
<head>
<title>How to show dynamic data in php using ajax</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js"></script>
</head>
<body>
<div class="container">
<h2>How to show dynamic data in php using ajax</h2>
<table class="table table-bordered table-sm" >
<thead>
<tr>
<th>Name</th>
<th>Email</th>
<th>mobile</th>
<th>City</th>
</tr>
</thead>
<tbody id="view_data">
</tbody>
</table>
</div>
<script>
$(document).ready(function() {
$.ajax({
url: "View_ajax.php",
type: "POST",
cache: false,
success: function(data){
alert(data);
$('#view_data').html(data);
}
});
});
</script>
</body>
</html>
Ajax page
File Name : View_ajax.php
<?php
include 'database.php';
$sql = "SELECT * FROM itechxpert";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
?>
<tr>
<td><?=$row['name'];?></td>
<td><?=$row['email'];?></td>
<td><?=$row['mobile'];?></td>
<td><?=$row['city'];?></td>
</tr>
<?php
}
}
else {
echo "0 results";
}
mysqli_close($conn);
?>
include 'database.php';
$sql = "SELECT * FROM itechxpert";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
?>
<tr>
<td><?=$row['name'];?></td>
<td><?=$row['email'];?></td>
<td><?=$row['mobile'];?></td>
<td><?=$row['city'];?></td>
</tr>
<?php
}
}
else {
echo "0 results";
}
mysqli_close($conn);
?>
Previous Next
Trending Tutorials
Review & Rating
0.0 / 5
0 Review
5
(0)
4
(0)
3
(0)
2
(0)
1
(0)
Write Review Here
Most Popular Tutorials
-
PHP Programs
-
PHP Interview Questions
-
How to write program in php?
-
Server variable
-
Variable handling function in php
-
Security for website
-
Header function
-
Types of errors in php
-
array
-
Cookies
-
PHP GD Library (Images)
-
CRUD in php
-
Trigger
-
String function
-
switch statement
-
php If else statements
-
Login, Registration and Logout application
-
php inbuilt function
-
Check username availability using ajax
-
PHP Operators
Important Link
-
How to manage Session in php Tutorials.
More ....... -
upcomming codeigniter and angular js tutorials.
Click here to see More ...
