private function obtenerFestivalInfo($id)
{
$resultado = array();
try {
$comando = "SELECT " . self::ID_FESTIVAL . " as idFestival" . ", " . self::NOMBRE_FESTIVAL . " as nombreFestival" . ", " . self::UBICACION_FESTIVAL . " as ubicacionFestival" . ", " . self::LATITUD_FESTIVAL . " as latitudFestival" . ", " . self::LONGITUD_FESTIVAL . " as longitudFestival" . ", " . self::LOGO_URL . " as logoUrl" . ", " . self::BACK_URL . " as backUrl" . ", " . self::DESCRIPCION_FESTIVAL . " as descripcionFestival" . ", " . self::FACEBOOK_URL . " as facebookUrlFestival" . ", " . self::WEB_URL . " as webUrlFestival" . ", " . self::INSTAGRAM_USER . " as instagramUserFestival" . ", " . self::ENTRADAS_URL . " as entradasUrl" . ", " . self::FECHA_INICIO . " as fechaInicio" . ", " . self::FECHA_FIN . " as fechaFin" . ", " . self::ASISTENTES_FESTIVAL . " as asistentesFestival" . ", " . self::EDICIONES_FESTIVAL . " as edicionesFestival" . " FROM " . self::NOMBRE_TABLA . " WHERE " . self::ID_FESTIVAL . "=? ;";
$sentencia = ConexionBD::obtenerInstancia()->obtenerBD()->prepare($comando);
$sentencia->bindParam(1, $id, PDO::PARAM_INT);
if ($sentencia->execute()) {
$festival = $sentencia->fetchAll(PDO::FETCH_ASSOC);
$artistas = artistas::getArtistaFromFestival($id);
$comentarios = comentarios::obtenerComentariosFestival($id);
http_response_code(200);
return ["estado" => self::ESTADO_EXITO, "mensaje" => "Consulta de festivales exitosa", "festivales" => ["info" => $festival, "artistas" => $artistas, "comentarios" => $comentarios]];
} else {
throw new ExcepcionApi(self::ESTADO_ERROR, "Se ha producido un error");
}
} catch (PDOException $e) {
throw new ExcepcionApi(self::ESTADO_ERROR_BD, $e->getMessage());
}
}
<?php
session_start();
require_once "Conexion.php";
class comentarios extends Conexion
{
private $nombre;
private $email;
private $text;
public function __construct($nombre, $email, $texto)
{
parent::__construct();
$this->nombre = $nombre;
$this->email = $email;
$this->text = $texto;
}
public function Id()
{
$result = $this->_db->query('SELECT idusuario FROM usuarios WHERE nombre="' . $this->nombre . '" and email="' . $this->email . '"');
$usuario = $result->fetch_assoc();
return $usuario;
}
public function Gardar($id)
{
$result = $this->_db->query('INSERT INTO comentarios(id_usuario,comentario) VALUES(' . $id . ',"' . $this->text . '")');
}
}
$com = new comentarios($_POST['nombre'], $_POST['email'], $_POST['texto']);
$Iden = $com->Id();
$com->Gardar($Iden['idusuario']);
header('Location: ../contactanos.php');
</div>
</div>
<div class="col-lg-6">
<!--Contenido central-->
<?php
require_once "php/Conexion.php";
class comentarios extends Conexion
{
public function get_users()
{
$result = $this->_db->query('select usuarios.imagen, usuarios.nombre,usuarios.apellidos, comentarios.comentario from usuarios,comentarios where usuarios.idusuario= comentarios.id_usuario');
$comen = $result->fetch_all(MYSQLI_ASSOC);
return $comen;
}
}
$com = new comentarios();
$come = $com->get_users();
?>
<?php
foreach ($come as $row) {
?>
<div class="panel">
<div class="panel-heading"><?php
echo $row['nombre'];
?>
<?php
echo $row['apellidos'];
?>
</div>
<div class="panel-body">
<div class="row">
