Ejemplo n.º 1
0
                <a class="navbar-brand" href="#">Start Bootstrap</a>
            </div>
            <!-- Collect the nav links, forms, and other content for toggling -->
            <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
                <ul class="nav navbar-nav">
                    <?php 
$query = "SELECT distinct descripcion FROM categorias";
$miconexion->consulta($query);
$result = mysql_query($query) or die("error" . mysql_error());
echo "<li class='dropdown'><a href='index.php?seleccion='>INICIO</a></li>";
while ($row = mysql_fetch_array($result)) {
    echo "<li><a href='#'>" . $row['descripcion'] . "</a>";
    echo "<ul class='dropdown-menu'>\n                                     <li>";
    $query1 = "SELECT nombre,nombre2 FROM categorias where descripcion='" . $row['descripcion'] . "'";
    $miconexion->consulta($query1);
    $miconexion->verconsulta2();
    echo "</li>\n                                  </ul>\n                              </li>";
}
?>
   

                <?php 
if (@(!$_SESSION['user'])) {
    echo "<li class='nav pull-right'>\n                        <a href='#login-box' class='login-window'>Login / Sign In</a>\n                    </li>";
} else {
    echo "<li class='nav pull-right'>\n                    <a href='static/desconectar_usuario.php'>Cerrar Cesión</a></li>";
    echo "<li class='nav pull-right'>\n                    <a href='#'>" . $_SESSION['user'] . "</a></li>";
}
?>
   
                </ul>
                 <?php 
 $miconexion->consulta("show tables");
 $miconexion->verconsultablas();
 ?>
             </div>
             <div class="col-md-8" >
                 <h4>Datos de las Tablas</h4><br><br>
                    <aside id="modulos">       
                     <section class="cd-gallery" width="100%">                            
                             <?php 
 extract($_GET);
 if (isset($tabla)) {
     echo "<h3 class='section-subheading text-muted'>Tabla: " . $tabla . "</h3>";
     echo "<form method='post'>";
     $miconexion->consulta("select * from " . $tabla);
     $miconexion->verconsulta2($tabla);
     //echo "<a href='administrador.php?tabl=$tabla&edi=3'><button type='submit' class='btn btn-xl'>Nuevo</button></a>";
     echo "<br><button type='submit'  class='btn btn-xl' name='nuevo' value='nuevo'>Nuevos</button><br><br><br>";
 }
 if (isset($id)) {
     if ($edi == 2) {
         $miconexion->consulta("DELETE FROM " . $tabla . " WHERE " . $act . "=" . $id);
         $miconexion->consulta();
     } else {
         if ($edi == 1) {
             if (isset($act)) {
                 echo "<form method='post'>";
                 $query = "SELECT * FROM " . $tabla . " WHERE " . $act . "=" . $id;
                 $result = mysql_query($query) or die("error" . mysql_error());
                 $a = mysql_num_fields($result);
                 while ($row = mysql_fetch_array($result)) {