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>