Viewing file:  listaautoresbis.php (6.18 KB) -rw-rw-r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<head>
<meta http-equiv="Content-Type"
content="text/html; charset=iso-8859-1" />
<link rel="stylesheet" type="text/css" href="nuevo.css">
<link rel="STYLESHEET" type="text/css" href="estilo.css">
</head>
<?php
if ($_REQUEST['n']){
include "./indexmenu.php";
if ($_REQUEST["genero"]){
echo "<center><h2>".$_REQUEST['genero']." ".$_REQUEST['subgenero']."</h2></center>";
}else{
echo "<center><h2>Lista de Autores, <b>ordenada alfabeticamente</b></h2></center>";
}
}
include "conn.php";
require "./class.datagrid.php";
echo "<center><h2><b>Selecci�n alfabetica</b></h2>";
$arrayalfabeto=ARRAY("A","B","C","D","E","F","G","H","I","J","K","L","M","N","�","O","P","Q","R","S","T","U","V","W","X","Y","Z");
?><center><table border=0><tr>
<?php foreach ($arrayalfabeto as $key=>$valor){
$valor2=$valor."%";
/*
$valor=strtolower($valor);
?><td><a href="listaautoresbis.php?autor=<?php echo utf8_encode('$valor2');?>" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('<?echo "abecedario_".$valor;?>','','/abecedario/<?echo "abecedario_".$valor.".gif";?>',1)"><img id="<?echo "abecedario_".$valor;?>" class="letra" src="/abecedario/<?echo "abecedario_".$valor.".gif";?>" alt="Orden alfab�tico letra <? echo $valor;?>" /></a></td>
*/?>
<td bgcolor="#DDE0E1"><a href="listaautoresbis.php?autor=
<?php
if (@$_REQUEST['n']){
echo elimina_acentos_mini($valor2)."&n=".$_REQUEST['n'];
}ELSE{
echo elimina_acentos_mini($valor2)."&n=";
}
?>
"><?echo $valor; ?></a>
<?php
}
echo "</tr></table>";
echo "<br>";
echo "<center>Puede ordenar la lista a su gusto, simplemente pulsando en las cabeceras <B>en negrita</B> ( POR DEFECTO, ORDENADO POR TITULO)<BR>";
if (strpos(utf8_decode($_REQUEST['autor']),"%")){
$porautores=true;
}
echo "<h1> Autor:".ereg_replace ("%","",utf8_decode($_REQUEST['autor']))."</h1>";
if (@$porautores){
$query="select distinct(trim(autor)) as 'autores', count(*) as obras from libros where autor like '".trim(utf8_decode($_REQUEST['autor']))."' and inftp=1 group by autor ";
$grid2 = new dataGrid($query,$conn);
// bound the function to the rows
//$grid->setRowActionFunction("action");
$grid2->showColumn("autores");
$grid2->showColumn("obras");
$grid2->setColumnHTMLProperties("autores", "align=center");
$grid2->setDefaultSortColumn("autores");
$grid2->enableSorting("autores") ;
//$grid->setRowActionFunction("titulo","action");
$grid2->unsetActionFunction("autores");
$grid2->unsetActionFunction("obras");
$grid2->setActionFunction("autores","abrir_masiva3");
$grid2->setActionFunction("obras","abrir_masiva3");
}else{
$query='select autor,genero,subgenero as tematica, concat (titulo," <b>",version,"</b>") as titulo ,fecha_subida,tamano,anyo as a�o,sinopsis as sinop,
t1.numero_comentarios as coment,
t1.votos as votos,
t1.puntuacion,
programa as maquetacion,ruta, id from libros as t1 where inftp=1 and autor like "'.trim(utf8_decode($_REQUEST['autor'])).'%"';
$grid2 = new dataGrid($query,$conn);
$grid2->showColumn("autor");
$grid2->showColumn("titulo");
$grid2->showColumn("a�o");
$grid2->showColumn("genero");
$grid2->showColumn("tematica");
$grid2->showColumn("tamano");
//$grid2->showColumn("sinop");
$grid2->showColumn("coment");
$grid2->showColumn("maquetacion");
$grid2->showColumn("votos");
$grid2->showColumn("puntuacion");
$grid2->showColumn("fecha_subida");
$grid2->setColumnHTMLProperties("autor", "align=center");
$grid2->setColumnHTMLProperties("titulo", "align=left");
$grid2->setColumnHTMLProperties("a�o", "align=left");
$grid2->setColumnHTMLProperties("genero", "align=center");
$grid2->setColumnHTMLProperties("tematica", "align=center");
$grid2->setColumnHTMLProperties("tamano", "align=center");
$grid2->setColumnHTMLProperties("sinop", "align=center");
$grid2->setColumnHTMLProperties("coment", "align=center");
$grid2->setColumnHTMLProperties("votos", "align=center");
$grid2->setColumnHTMLProperties("puntuacion", "align=center");
$grid2->setColumnHTMLProperties("fecha_subida", "align=center");
if (!strpos(utf8_decode($_REQUEST['autor']),"%")){
$grid2->setDefaultSortColumn("titulo");
}else{
$grid2->setDefaultSortColumn("autor");
}
$grid2->enableSorting("autor") ;
$grid2->enableSorting("tamano");
$grid2->enableSorting("a�o");
$grid2->enableSorting("votos");
$grid2->enableSorting("puntuacion");
$grid2->enableSorting("fecha_subida");
//$grid->setRowActionFunction("titulo","action");
$grid2->unsetActionFunction("titulo");
$grid2->unsetActionFunction("autor");
$grid2->unsetActionFunction("genero");
$grid2->unsetActionFunction("fecha_subida");
$grid2->setActionFunction("titulo","abrir_masiva2");
$grid2->setActionFunction("autor","abrir_masiva2");
$grid2->setActionFunction("genero","abrir_masiva2");
$grid2->setActionFunction("tamano","abrir_masiva2");
$grid2->setActionFunction("votos","abrir_masiva2");
$grid2->setActionFunction("puntuacion","abrir_masiva2");
$grid2->setActionFunction("fecha_subida","abrir_masiva2");
$grid2->rowsOnPage=100;
}
$grid2->render();
function abrir_masiva2($value_of_clicked_field, $array_with_the_values_of_all_fields_in_clicked_row)
{
@ $RETORNO="&n=".$_REQUEST['n'];
$enlace= $array_with_the_values_of_all_fields_in_clicked_row["ruta"];
return "javascript:document.location.href='enlace.php?enlace=".base64_encode($enlace)."&ID={$array_with_the_values_of_all_fields_in_clicked_row['id']}&$RETORNO'";
//return "javascript:window.open('enlace.php?enlace=".utf8_encode($enlace)."&ID={$array_with_the_values_of_all_fields_in_clicked_row['id']}','',Directories='NO',Menubar='NO',Titlebar='',Toolbar='NO',Location='NO',width=300,height=100,top=85,left=140)";
}
function abrir_masiva3($value_of_clicked_field, $array_with_the_values_of_all_fields_in_clicked_row)
{
@ $enlace="./listaautoresbis.php?autor=". utf8_encode(trim($array_with_the_values_of_all_fields_in_clicked_row['autores']))."&n=".$_REQUEST['n'] ;
// print_r($array_with_the_values_of_all_fields_in_clicked_row);
//$enlace= $array_with_the_values_of_all_fields_in_clicked_row["ruta"];
//return "location.href='".$enlace."'";
return "javascript:document.location.href='$enlace'";
}
?>
|