/
show.php
91 lines (80 loc) · 2.45 KB
/
show.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
<?php
session_start();
$conn = mysqli_connect("localhost", "root", "DsI6BMQeVzalCuEr", "livrenet");
$conn->query("SET NAMES 'utf8'");
$query = "SELECT * FROM libro";
if($_GET){
if(isset($_GET['nombre']) && isset($_GET['categoria'])){
$nombre = $_GET['nombre'];
$categoria = $_GET['categoria'];
$query .= " WHERE nombre like '$nombre' AND categoria = $categoria";
}else{
if(isset($_GET['nombre'])){
$nombre = $_GET['nombre'];
$query .= " WHERE nombre like '$nombre'";
}
if(isset($_GET['categoria'])){
$categoria = $_GET['categoria'];
$query .= " WHERE categoria=$categoria";
}
}
}
if(!$conn){
die("Error de conexión: ".mysqli_error($conn));
}
$result = $conn->query($query);
?>
<!DOCTYPE html>
<html>
<head>
<title>Mostrar Libros</title>
<meta charset="utf-8">
<link rel="stylesheet" type="text/css" href="css/bootstrap.css">
<link rel="stylesheet" type="text/css" href="css/style.css">
</head>
<body id="ti">
<?php
while($row = mysqli_fetch_array($result)){?>
<div class="container">
<div class="row">
<div class="col-md-3"> </div>
<div class="col-md-6">
<div class="row">
<div class="col-md-12">
<div class="thumbnail">
<img src=".\res\<?php echo $row[8];?>" alt="...">
<div class="caption">
<h4 class="text-center">Nombre: <?php echo $row[2];?></h4>
<p class="text-center">Autor: <?php echo $row[3];?></p>
<p class="text-center">Editorial: <?php echo $row[4];?></p>
<p class="text-center">Categoria: <?php if($row[6] == 1) echo "Académico";if($row[6] == 2) echo "Literatura"; if($row[6] == 3) echo "Filosofía";?></p>
<p class="text-center">Precio: <?php echo $row[9];?></p>
<p><a href="#" class="btn btn-primary center-block" role="button">Comprar</a>
</div>
</div>
</div>
</div>
</div>
<div class="col-md-3"> </div>
</div>
</div>
<?php }
?>
<?php
while($row = mysqli_fetch_array($result)){
//var_dump($row);
echo $row[0]."<br>";
echo $row[1]."<br>";
echo $row[3]."<br>";
echo $row[4]."<br>";
echo $row[5]."<br>";
echo $row[6]."<br>";
echo $row[7]."<br>";
echo $row[8]."<br>";
echo $row[9]."<br>";
//$path = ".'\'res'\'$row[8]'";
//echo '<img src=".res/'.$row[8]'">'; //"<img src=\".res'$row[8]\" alt=\"error\">"."<br><br>";
}
?>
</body>
</html>