Display data from Mysql Database Using AngularJS with PHP

Thursday, 6 April 2017

Display data from Mysql Database Using AngularJS with PHP

Posted By: abhishek verma Thursday, April 06, 2017 Leave a Reply
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
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
<!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
1
2
3
4
5
6
7
8
9
10
11
12
<?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);  
}  
?>  
Did you find apk for android? You can find new Free Android Games and apps.

0 comments: