-
Notifications
You must be signed in to change notification settings - Fork 0
/
indexWorking.php
109 lines (90 loc) · 4.49 KB
/
indexWorking.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
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
<!DOCTYPE html>
<?php include 'db.php';
//$page = (isset($_GET['page']) ? $_GET['page'] : 1);
//$perPage = (isset($_GET['per-page']) && (
// ($_GET['per-page'] <= 50 ? $_GET['per-page'] : 5)
//));
//$start = ($page > 1) ? ($page * $perPage) - $perPage : 0;
$sql = "select * from task"; //limit ";//.$start.", ".$perPage." ";
//$total = $db->query("select * from task")->num_rows;
//$pages = ceil($total / $perPage);
$rows = $db-> query($sql);
?>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/[email protected]/font/bootstrap-icons.css">
<title>Inicio -Tareas por hacer</title>
</head>
<body>
<div class="container">
<div class="row">
<div class="col-md-10 col-md-offset-2 mb-5 mt-5">
<h2 class="text-center mb-5">TAREAS POR HACER ⛏️ </h2>
<button type="button" class="btn btn-success" data-toggle="modal" data-target="#myModal"><i class="bi bi-shield-fill-plus"></i> Agregar tarea</button>
<button type="button" class="btn btn-secondary float-right"><i class="bi bi-printer"></i> Imprimir</button>
</div>
<div class="col-md-10 col-md-offset-1">
<table class="table table-striped table-hover">
<thead>
<tr>
<th scope="col">N°</th>
<th scope="col">Tarea</th>
<th scope="col"></th>
<th scope="col"></th>
</tr>
</thead>
<tbody>
<tr>
<?php while ($row = $rows ->fetch_assoc()): ?>
<th scope="row"><?php echo $row['id'] ?></th>
<td class="col-md-10"><?php echo $row['name'] ?></td>
<td><a href="update.php?id=<?php echo $row['id'];?>" class="btn btn-success">Editar</a></td>
<td><a href="delete.php?id=<?php echo $row['id'];?>" class="btn btn-danger">Eliminar</a></td>
</tr>
<?php endwhile; ?>
</tbody>
</table>
<!-- <nav aria-label="Page navigation example">
<ul class="pagination">
<?php for ($i = 1; $i <= $pages; $i++): ?>
<li class="page-item"> <a href="?page=<?php echo $i;?>"><?php echo $i; ?></a></li>
<?php endfor; ?>
</ul>
</nav>-->
</div>
</div>
</div>
<!-- Modal -->
<div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModal" aria-hidden="true">
<div class="modal-dialog" role="document">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="myModal">Nueva tarea</h5>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
<form method="post" action="add.php">
<div class="form-group">
<label for="">Nombre Tarea</label>
<input type="text" required name="task" class="form-control">
</div>
<input type="submit" name="send" value="Agregar tarea" class="btn btn-success">
</form>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-dismiss="modal">Cerrar</button>
</div>
</div>
</div>
</div>
</body>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js" integrity="sha384-UO2eT0CpHqdSJQ6hJty5KVphtPhzWj9WO1clHTMGa3JDZwrnQq4sF86dIHNDz0W1" crossorigin="anonymous"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js" integrity="sha384-JjSmVgyd0p3pXB1rRibZUAYoIIy6OrQ6VrjIEaFf/nJGzIxFDsf4x0xIM+B07jRM" crossorigin="anonymous"></script>
</html>