-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathlistcoment.php
More file actions
28 lines (27 loc) · 863 Bytes
/
listcoment.php
File metadata and controls
28 lines (27 loc) · 863 Bytes
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
<?php
require_once('connection/connection.php');
$qComentarios = "SELECT comentario,nome FROM comentarios WHERE idArtigo=? ORDER BY data DESC";
$stmtComentarios = $conn->prepare($qComentarios);
if ($stmtComentarios === FALSE) {
die("Erro no SQL: " . $qComentarios . " Error: " . $conn->error);
}
if (isset($_GET['idArtigo']) && $_GET['idArtigo'] != "") {
$idArtigo = $_GET['idArtigo'];
} else {
$idArtigo = 0;
}
$stmtComentarios->bind_param('i',$idArtigo);
$stmtComentarios->execute();
//$stmtComentarios->store_result();
//$totalArtigos = $stmtComentarios->num_rows;
$stmtComentarios->bind_result($comentario,$nome);
$resposta = array();
$i=0;
while ($stmtComentarios->fetch()) {
//echo $comentario;
$resposta[$i++]=array('comentario'=>$comentario,'nome'=>$nome);
}
$stmtComentarios->close();
$conn->close();
echo json_encode($resposta);
?>