Viewing file:  editar_libro.php (1.6 KB) -rw-rw-r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
include ("../frames/conn.php");
if ($_REQUEST['limit']){
$limit="LIMIT ".$_REQUEST['limit'];
}else{
$limit="";
}
if ($_REQUEST['id']>''){
$query="select id, autor, titulo,anyo from libros where id={$_REQUEST['id']} order by id desc ".$limit;
}else{
$query="select id, autor, titulo,anyo from libros where inftp=1 order by id desc ".$limit;
}
ECHO $query;
//$query="select t1.id, t1.autor, t1.titulo, t2.id_book as id2 from libros as t1, sinopsis as t2 order by t1.id asc";
$res=mysql_query($query,$conn);
echo mysql_error();
?><table border=1><tr><?php
while ($row=mysql_fetch_array($res)){
$encriptor=new encriptor;
$id=$encriptor->encrypt($row['id']);
echo "<tr><td bgcolor='$color'><a href='./libro_editado.php?ID={$id}'>".$row['id']."</a><td bgcolor='$color'>".$row['autor']."<td bgcolor='$color'>".$row['titulo']."<td bgcolor='$color'>".$row['anyo']."<td bgcolor='$color'>".$row2['id']."</tr>";
unset($encriptor);
}
echo "</table>";
// aprovechamos para borrar las sinopsis y las portadas vacias
/*
$sql="SELECT * FROM `sinopsis` as t1 WHERE t1.id_book not in (select id from libros where id=t1.id_book)";
$res=mysql_query($sql,$conn);
while($row01=mysql_fetch_array($res)){
// borramos la portada, si fuera preciso
if (strlen(trim($row01['imagename']))>0){
echo strlen(trim($row01['imagename']))."---";
echo "../frames/includes/{$row01['imagename']}"."<br>";
$ok=unlink("../frames/includes/{$row01['imagename']}");
echo "resultado=$ok<br>";
$sql01="delete from sinopsis where id_book={$row01['id_book']} ";
$res02=mysql_query($sql01,$conn);
echo mysql_error();
}
}
*/
mysql_close($conn);
|