function load()
{
include_once $this->dir . 'classes/dataBase.class.php';
$db = new dataBase($this->dir);
global $arrLang;
$sql = "SELECT `idvar`, `descrp` FROM `languajevar` WHERE `module` IN ('GENERIC','MENU','" . $_SESSION['menu'] . "') AND `languaje` = '" . $_SESSION['lang'] . "'";
// echo $sql;
$result = $db->QueryFetchArrayASSOC($sql);
$arrLang = array();
foreach ($result as $value) {
$arrLang[$value['idvar']] = utf8_encode($value['descrp']);
}
// echo "<pre>".print_r($arrLang,true)."</pre>";
}
<?php
error_reporting(E_ALL);
//include_once 'classes/dataBase.class.php';
$db = new dataBase('');
$sql = "SELECT id, descrp FROM slider_categ";
$slider_categ = $db->QueryFetchArrayASSOC($sql);
//echo "<pre>"; print_r($slider_categ);echo "</pre>";die;
$slider = '';
foreach ($slider_categ as $value) {
$sql = "SELECT s.id, l.image, l.sinopsis, l.nombre\n\t\t\tFROM slider_mae AS s\n\t\t\tINNER JOIN libro l ON s.id_libro = l.id \n\t\t\tWHERE categoria = '" . $value['id'] . "' \n\t\t\tORDER BY posicion ASC";
$slider_mae = $db->QueryFetchArrayASSOC($sql);
//echo "<pre>"; print_r($slider_mae);echo "</pre>";
$slider .= '
<li>
<table cellpadding="50">
<tr><td colspan = 3><center><h1>' . $value['descrp'] . '</h1></center></td></tr>
<tr>';
foreach ($slider_mae as $value2) {
$slider .= '
<td>
<center>
<a href="#" onclick = "abrirfancy(\'' . $value2['id'] . '\', \'vistalibro\')" name="1"><img src="' . $value2['image'] . '"></a><br/><p style="width: 90%"><b style="font-weight: bold;">' . $value2['nombre'] . ': </b>' . $value2['sinopsis'] . '</p>
</center>
</td>';
}
$slider .= '
</tr>
</table>
</li>';
}
<tr>
<td>
<img src="' . $value['contenido_0']['img'] . '"><br/><p>' . $value['contenido_0']['txt'] . '</p>
</td>
<td>
<img src="' . $value['contenido_1']['img'] . '"><br/><p>' . $value['contenido_1']['txt'] . '</p>
</td>
<td>
<img src="' . $value['contenido_2']['img'] . '"><br/><p>' . $value['contenido_2']['txt'] . '</p>
</td>
</tr>
</table>
</li>';
}
$sql = "SELECT nombre FROM libro";
$misTrabajosArr = $db->QueryFetchArrayASSOC($sql);
$misTrabajos = '<ul style = "list-style-type: circle;">';
foreach ($misTrabajosArr as $key => $value) {
$misTrabajos .= '
<li>
<a href="#">' . $value['nombre'] . '</a>
</li>';
}
$misTrabajos .= '</ul>';
//echo "<pre>"; print_r($misTrabajosArr);echo "</pre>";
?>
<!--
Author: W3layouts
Author URL: http://w3layouts.com
License: Creative Commons Attribution 3.0 Unported
if ($password == "") {
$passErr = "Password is required";
$error = 1;
}
// else {
// $pass = test_input($_POST["password"]);
//}
if ($error == 0) {
//----------------- VERIFICACION DE USUARIO Y CREACION DE SESION-----------------
//$conn = mysql_connect("localhost","root","");
//mysql_select_db("librofinal",$conn);
$sql = "SELECT nombre, id, admin FROM usuario WHERE mail ='{$usuario}' and password='******'";
//$result=mysql_query($sql,$conn);
//$row=mysql_fetch_array($result);
//$count=mysql_num_rows($result);
$arrUsuario = $db->QueryFetchArrayASSOC($sql);
//si count es 1 el usuario existe, error == 0 significa que los campos no estan vacios
if (count($arrUsuario) == 1) {
$usuarioBase = $arrUsuario[0];
session_start();
$_SESSION['login_user'] = $usuarioBase['nombre'];
$_SESSION["idUsuarioLogueado"] = $usuarioBase['id'];
$_SESSION["rolUsuario"] = $usuarioBase['admin'];
//Remember == 1 significa que el checkbox recordarme fue tildado
if ($remember == 1) {
//Creacion de Cookie
setcookie($cookie_user, $usuario, time() + 86400 * 30, "/");
// 86400 = 1 day
header('location: homeframe');
mysql_close($conn);
} else {
<?php
session_start();
//echo "<pre>"; print_r($_SESSION); echo "</pre>";die;
include_once 'versession.php';
//include_once 'classes/dataBase.class.php';
$db = new dataBase('');
$sql = "SELECT l.nombre as nombreLibro ,l.fecha, a.nombre as nombreAutor, g.nombre as nombreGenero\n\t\tFROM libro as l \n\t INNER JOIN autor as a ON l.id_autor = a.id\n\t INNER JOIN genero as g ON l.id_genero = g.id";
$arrlibro = $db->QueryFetchArrayASSOC($sql);
//echo "<pre>"; print_r($arrlibro[0]); echo "</pre>";//die;
$tablaLibros = "<table border = 1>\n\n<tr>\n\t\t<td>Libro</td>\n\t\t<td>Autor</td>\n\t\t<td>Genero</td>\n\t\t<td>Fecha</td>\n\n</tr>";
foreach ($arrlibro as $value) {
$tablaLibros .= "\n\t<tr>\n\t\t<td>" . $value['nombreLibro'] . "</td>\n\t\t<td>" . $value['nombreAutor'] . "</td>\n\t\t<td>" . $value['nombreGenero'] . "</td>\n\t\t<td>" . $value['fecha'] . "</td>\n\t\t\n\t</tr>";
}
$tablaLibros .= "</table>";
//echo $value['nombreAutor'];
?>
<!DOCTYPE HTML>
<html>
<head>
<title>Proyecto lectura</title>
<link href="/proylecturademo/web/css/style.css" rel="stylesheet" type="text/css" media="all" />
<link href='/proylecturademo/web/css/font-Ropa+Sans.css' rel='stylesheet' type='text/css'>
<link rel="stylesheet" href="/proylecturademo/web/css/responsiveslides.css">
<link rel="stylesheet" href="/proylecturademo/web/css/login-style.css">
<script src="/proylecturademo/web/js/jquery.min.js"></script>
<script src="/proylecturademo/web/js/responsiveslides.min.js"></script>
</head>
<body>
<?php
//session_start();
//echo "<pre>"; print_r($_SESSION); echo "</pre>";die;
include_once 'versession.php';
//include_once 'classes/dataBase.class.php';
$db = new dataBase('');
$sql = "SELECT c.descripcion, g.nombre as nombreGenero, u.nombre as nombreUsuario, c.fecha\n\t\tFROM clasificados as c \n\t INNER JOIN usuario as u ON c.id_autor = u.id\n\t INNER JOIN genero as g ON c.id_genero = g.id";
$arrclasificado = $db->QueryFetchArrayASSOC($sql);
//echo "<pre>"; print_r($arrlibro[0]); echo "</pre>";//die;
$tablaClasificados = "<table border = 1>\n\n<tr>\n\t\t<td>Descripcion</td>\n\t\t<td>Usuario</td>\n\t\t<td>Genero</td>\n\t\t<td>Fecha</td>\n\n</tr>";
foreach ($arrclasificado as $value) {
$tablaClasificados .= "\n\t<tr>\n\t\t<td>" . $value['descripcion'] . "</td>\n\t\t<td>" . $value['nombreUsuario'] . "</td>\n\t\t<td>" . $value['nombreGenero'] . "</td>\n\t\t<td>" . $value['fecha'] . "</td>\n\t\t\n\t</tr>";
}
$tablaClasificados .= "</table>";
//echo $value['nombreAutor'];
?>
<!DOCTYPE HTML>
<html>
<head>
<title>Proyecto lectura</title>
<link href="/proylecturademo/web/css/style.css" rel="stylesheet" type="text/css" media="all" />
<link href='/proylecturademo/web/css/font-Ropa+Sans.css' rel='stylesheet' type='text/css'>
<link rel="stylesheet" href="/proylecturademo/web/css/responsiveslides.css">
<link rel="stylesheet" href="/proylecturademo/web/css/login-style.css">
<script src="/proylecturademo/web/js/jquery.min.js"></script>
<script src="/proylecturademo/web/js/responsiveslides.min.js"></script>
</head>
<body>
