I just want to show the data of some related tables that would be events-> themes-> speakers two have their id in others and I would like to know how to show the data on the screen nothing else, try it with inner join but it does not work or only shows a single record of each table. here the html code
<?php
require 'funciones.php';
$obj= new funciones();
$publicacion = $obj->getPublicacion($_GET['blog_id']);
//echo '<pre>',print_r($publicaciones),'</pre>';
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<link rel="stylesheet" type="text/css" href="css/style_SE.css">
<link rel="stylesheet" type="text/css" href="css/bootstrap/css/bootstrap-theme.min.css">
<title><?php echo $publicacion['titulo']?></title>
<link rel="shortcut icon" type="text/x-icon" href="img/U.png">
<script src="js/fontawesome-all.min.js"></script>
</head>
<body>
<header>
<div class="logo">
<img src="img/logo.jpg" width="100%" >
</div>
<div class="nave">
<nav>
<ul>
<li><a href="../index.php">Inicio</a></li>
<li><a href="#">constancias</a></li>
<li><a href="#">Contatos</a></li>
<li><a href="https://www.facebook.com/"><i class="fab fa-facebook"></i></a></li>
<li><a href="https://twitter.com/"><i class="fab fa-twitter-square"></i></a></li>
<li><a href="https://www.instagram.com/?hl=es-la"><i class="fab fa-instagram"></i></a></li>
<li><a href="Sistema_Eventos/login.html"><i class="fas fa-sign-in-alt"></i></a></li>
</ul>
</nav>
</div>
</header>
<div class="main">
<div class="artic">
<section ="prin">
<h2><?php echo $publicacion['titulo']?></h2>
<div class="row">
<?php echo $publicacion['fecha']?>
<?php echo $publicacion['tiempo']?>
<?php echo $publicacion['lugar']?>
<?php echo $publicacion['contenido']?>
<?php echo $publicacion['titulo_tema']?>
<?php echo $publicacion['ci']?>
<?php echo $publicacion['nombre']?>
<?php echo $publicacion['apellido']?>
</div>
</section>
</div>
</div>
<aside>
<div class="extra">
</div>
</aside>
<footer>
<div class="pie">
<p>copyright UNERG 2018 / Decoration AzX</p>
</div>
</footer>
<script src="css/bootstrap/js/bootstrap.min.js"></script>
<script src=""></script>
</body>
</html>
the php code
<?php
require 'int.php';
class funciones{
public function getPublicaciones(){
global $link;
$query = $link->prepare("SELECT * FROM eventos ");
$query -> execute();
return $query->fetchAll();
}
public function getPublicacion($id_Eventos){
global $link;
$query = $link->prepare("SELECT * FROM eventos WHERE id_Eventos = :id_Eventos");
$query -> execute(['id_Eventos' => $id_Eventos ]);
return $query->fetch();
}
}
?>
and here the database, I just want to show the information of each table by the id you have of the previous one, an event, 2 topics, 4 ponenets something like that
