I try to show data stored in a db, I am working php as mvc and when I show the screen with the relevant queries it shows me the query and not the data, then I leave a photo.
class.Conexion.php
<?php
class Conexion extends mysqli {
public function __construct(){
parent::__construct('localhost','root','123','nielsendb_temp');
$this->query("SET NAMES utf8;");
$this->connect_errno ? die('ERROR: Datos incorrectos en /core/models/class.Conexion.php'): null;
}
public function rows($x){
return mysqli_num_rows($x);
}
public function recorrer($x){
return msqli_fetch_array($x);
}
public function liberar($x){
return mysqli_free_result($x);
}
public function preparada(){
return mysqli_stmt_init();
}
public function conectar(){
return mysqli_query();
}
}
?>
indexControler.php
<?php
include('core/models/class.Conexion.php');
$template = new Smarty();
$template->display('home/index.tpl');
?>
index.tpl
{include 'overall/header.tpl'}
{include 'overall/menu.php'}
{include 'overall/carrusel.tpl'}
{include 'overall/contenedor.php'}
{include 'overall/footer.tpl'}
menu.php
<body>
<div class="wrapper">
<nav class="navbar navbar-expand-md navbar-dark fixed-top bg-dark">
<ul class="navbar-nav mr-auto">
<img class="navbar-brand" src="/noticias/img/n1.png" style="width: 150px;height: 50px;">
<?php
$db = new Conexion();
alert($db);
$rscons= $db->mysqli_query("Select admin from tblusuario");
$rs=mysqli_fetch_array($rscons);
if ($rs["admin"]==1)
{
$obtenermenu= $db->mysqli_query("Select idopcion,descripcion,glyphicon from tblnoticias_menu order By PosI");
while($menu=mysqli_fetch_array($obtenermenu))
{
$submenu= $db->mysqli_query("Select idsubmenu,url,descripcion,glyphicon from tblsubmenu where idopcion='$menu[idopcion]' and estado=1 Order By PosS");
if(mysqli_num_rows($submenu)>0)
{
?>
<li class="nav-item dropdown">
<a class="nav-link dropdown-toggle" href="#" id="dropdown01" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
<i class="fa <?php echo $menu['glyphicon']; ?>"></i><span><?php echo utf8_encode($menu['descripcion']); ?></span> <i class="fa fa-angle-left pull-right"></i>
</a>
<ul class="dropdown-menu">
<?php
while($row1=mysqli_fetch_array($submenu))
{
?>
<li>
<a href="<?php echo " ../../ ".$row1['url'];?>"><i class="fa fa-circle-o"></i><?php echo utf8_encode($row1['descripcion']); ?></a>
</li>
<?php
}
?>
</ul>
</li>
<?php
}
}
}else{
$obtenermenu= $db->mysqli_query("Select M.idopcion,M.descripcion,glyphicon from tblperfilesuser P inner Join tblmenu M On P.Idopcion=M.IdOpcion Group By M.idopcion,M.descripcion Order By PosI");
while($menu=mysqli_fetch_array($obtenermenu))
{
$submenu= $db->mysqli_query("Select S.idsubmenu,S.url,S.descripcion,glyphicon from tblperfilesuser P inner Join tblsubmenu S On P.idopcion=S.idopcion And P.idSubmenu=S.IdSubMenu where P.idopcion='$menu[idopcion]' And estado=1 Order By PosS");
if(mysqli_num_rows($submenu)>0)
{
?>
<li class="nav-item">
<a href="#">
<i class="fa <?php echo $menu['glyphicon']; ?>"></i><span><?php echo utf8_encode($menu['descripcion']); ?></span> <i class="fa fa-angle-left pull-right"></i>
</a>
<ul class="navbar-nav">
<?php
while($row1=mysqli_fetch_array($submenu))
{
?>
<li>
<a href="<?php echo " ../../ ".$row1['url'];?>"><i class="fa fa-circle-o"></i><?php echo utf8_encode($row1['descripcion']); ?></a>
</li>
<?php
}
?>
</ul>
</li>
<?php
}
}
}
?>
</ul>
</nav>
<?php
$db->close();
?>
</div>