I have a mobile app where I make a ng-repeat
to list a photo gallery that well through JSON
php what happens and that I think I have everything but not list me any image I already tested query sql
directly in sql
and it does not give me any error lists as well.
Controller
.controller('VerFotosEstabelecimento', function($scope, $http, $stateParams) {
$http.get("https://www.sabeonde.pt/api/api_ver_fotos_estabelecimento.php?slug="+$stateParams.EstabelecimentoSlug).success(function (data) {
$scope.ver_fotos_estabelecimento = data;
});
})
HTML where the photos are ready
<div class="card">
<div class="item item-text-wrap">
<h2 style="margin:0px 0px 10px 0px;">Fotos</h2>
<div class="row">
<div class="col" ng-repeat="fotos in ver_fotos_estabelecimento">
<img ng-src="https://www.sabeonde.pt/gtm/anexos/fotos/{{fotos.id_anexo}}.{{fotos.tipo}}"/></div></div><divstyle="float: left;" ng-click="fotos()" ng-controller="ModalFotos" class="caixa_limite">+'.$fotos_maior_valida.'</div>
<div style="float: left; margin:0px 0px 20px 5px;" class="caixa_limite"><i style="font-size: xx-large;" class="ion-camera"></i></div>
</div>
</div>
PHP
header('Access-Control-Allow-Origin: *');
header('Access-Control-Allow-Methods: GET, POST');
header("Content-type: application/json");
require_once("../funcoes/funcoes.php");
$result = $conexao->prepare("SELECT * FROM estabelecimentos
INNER JOIN estabelecimentos_anexos ON estabelecimentos_anexos.id_mae = estabelecimentos.id
WHERE estabelecimentos.slug = :slug AND estabelecimentos_anexos.seccao = :seccao LIMIT 9");
$result->bindValue(':slug', $_GET['slug'], PDO::PARAM_STR);
$result->bindValue(':seccao', 'fotos', PDO::PARAM_STR);
$result->execute();
$rows = $result->fetchAll(PDO::FETCH_ASSOC);
echo json_encode($rows);