I have problem with setting up ng-repeats in angular when I receive some arrays from php. Can anyone please explain it to me ? I would like to have one div for one position of array. Thanks for kind response and here's the code:
Angular
<div ng-app="ReportRequest" ng-controller="InsertRequest" id="pos">
<div ng-repeat="row in report.articles.rows" class="position articles">
<p ng-bind="row"></p
</div>
Angular ajax request(work's fine)
var RequestApp = angular.module('ReportRequest',[]);
RequestApp.controller('InsertRequest', function ($scope, $http) {
$http.get("functions.php", {
}).then(function success(response) {
$scope.report = response.data.rows;
})
});
PHP (are there any mistakes ?)
<?php
header('Content-Type: application/json');
require_once 'db_connect.php';
function retrieveArticle($conn)
{
$prep_stmt = "SELECT * FROM blog";
$stmt = $conn->prepare($prep_stmt);
if ($stmt) {
$stmt->execute();
$result = $stmt->get_result();
//$num_of_rows = $result->num_rows;
while ($row = $result->fetch_assoc()) {
//$id = $row['id'];
$article[] = $row['article'];
}
}
$stmt->free_result();
$stmt->close();
return $article;
}
$articles = array(retrieveArticle($conn));
$report = array('rows' => $articles);
echo json_encode($report);
Received data: (json format) {"rows":[["Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque hendrerit nec nulla at pretium. Suspendisse viverra tempus malesuada. In at imperdiet ipsum, eu ornare mi. Etiam eget massa ac est dapibus aliquam. Donec pharetra vehicula libero vulputate tristique. Nullam quam est, ultricies et varius pulvinar, hendrerit rhoncus ex. Integer urna leo, pellentesque non sapien ut, scelerisque imperdiet magna.","Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque hendrerit nec nulla at pretium. Suspendisse viverra tempus malesuada. In at imperdiet ipsum, eu ornare mi. Etiam eget massa ac est dapibus aliquam. Donec pharetra vehicula libero vulputate tristique. Nullam quam est, ultricies et varius pulvinar, hendrerit rhoncus ex. Integer urna leo, pellentesque non sapien ut, scelerisque imperdiet magna.","Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque hendrerit nec nulla at pretium. Suspendisse viverra tempus malesuada. In at imperdiet ipsum, eu ornare mi. Etiam eget massa ac est dapibus aliquam. Donec pharetra vehicula libero vulputate tristique. Nullam quam est, ultricies et varius pulvinar, hendrerit rhoncus ex. Integer urna leo, pellentesque non sapien ut, scelerisque imperdiet magna."]]}
>in your code? (<p ng-bind="row"></p)ng-repeat="row in report"? I don't see anyarticleskey in PHP array, and you save therowsdirectly to$scope.reportecho json_encode(array('rows' => retrieveArticle($conn)));(instead of the last 3 lines on your php code), changeng-repeat="row in report.articles.rows"tong-repeat="row in report"and<p ng-bind="row"></pto<p ng-bind="row"></p>- Any change?