Display data from Mysql Database Using AngularJS with PHP

Hi friends, In this post we going to see how to display data from Mysql database using AngularJS with PHP. I will share very helpful things with you. Nowadays AngularJS is the best choice to develop the web application. If you are going to begin a new project, then why not choose AngularJS as front-end and PHP as back-end. So in this post, I will show you how to display data from MySQL using AngularJS and PHP.

   

index.php

<!doctype html>
<html>
<head>
<meta charset="UTF-8"> 
<title>softAOX | Display data from Mysql Database Using AngularJS with PHP</title> 
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" />  
<script src="http://ajax.googleapis.com/ajax/libs/angularjs/1.4.8/angular.min.js"></script>
</head>  
<body>  
<div class="container">
	<h3 align="center">Display data from Mysql Database Using AngularJS with PHP</h3>
	<div ng-app="sa_display" ng-controller="controller" ng-init="display_data()">
		<table class="table table-bordered">
			<tr>
				<th>S.No</th>
				<th>Name</th>
				<th>Email</th>
				<th>Age</th>
			</tr>
			<tr ng-repeat="x in names">
				<td>{{x.id}}</td>
				<td>{{x.name}}</td>
				<td>{{x.email}}</td>
				<td>{{x.age}}</td>
			</tr>
		</table>
	</div>
</div>
<!-- Script -->  
<script>
    var app = angular.module("sa_display", []);
    app.controller("controller", function($scope, $http) {
        $scope.display_data = function() {
            $http.get("display.php")
                .success(function(data) {
                    $scope.names = data;
                });
        }
    });
</script> 
</body>  
</html>    
display.php

 <?php  
 $conn = mysqli_connect("localhost", "root", "", "angularjs");  
 $output = array();  
 $query = "SELECT * FROM insert_emp_info";  
 $result = mysqli_query($conn, $query);  
 if(mysqli_num_rows($result) > 0) {  
      while($row = mysqli_fetch_array($result)) {  
           $output[] = $row;  
      }  
      echo json_encode($output);  
 }  
 ?>  

Was this article helpful?

Yes No
×

How can we improve it?

×

We appreciate your helpul feedback!

Your answer will be used to improve our content. The more feedback you give us, the better our pages can be.

Follow us on social media:

Facebook Pinterest
Share via:

Leave a Reply

Your email address will not be published. Required fields are marked *