php_CRUD_App/index.php at master · HyperCC/php_CRUD_App · GitHub

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
<?php include ("db.php") ?>

<?php include ("includes/header.php") ?>


<div class="container p-4">
    <div class="row">
        <div class="col-md-4">


            <?php if(isset($_SESSION['message'])){ ?>
                <div class="alert alert-<?= $_SESSION['message_type']; ?> alert-dismissible fade show" role="alert">
                <?= $_SESSION['message']?>
                <button type="button" class="close" data-dismiss="alert" aria-label="Close">
                    <span aria-hidden="true">&times;</span>
                </button>
                </div>
            <?php session_unset(); }?>


            <div class="card card-body">
                <form action="sabe_task.php" method="POST">
                    <div class="form-group">
                        <input type="text" name="title" class="form-control"
                        placeholder="Pon tu titulo" autofocus>
                    </div>
                    <div class="form-group">
                        <textarea name="description" rows="2" class="form-control"
                        placeholder="Pon tu tarea"></textarea>
                    </div>
                    <input type="submit" class="btn btn-success btn-block"
                    name="save_task_button" value="Guardar Tarea">
                </form>
            </div>

        </div>

        <div class="col-md-8">
            <table class="table table-bordered">;
                <thead>
                    <tr>
                        <th>Titulo</th>
                        <th>Descripcion</th>
                        <th>Creado a las</th>
                        <th>Acciones</th>
                    </tr>
                </thead>

                <tbody>
                <?php
                $consultas="SELECT*FROM task";
                $resultados=mysqli_query($connectionDB,$consultas);

                while($filas = mysqli_fetch_array($resultados)){ ?>
                    <tr>
                        <td><?=$filas['title'] ?> </td>
                        <td><?php echo $filas['description'] ?> </td>
                        <td> <?php echo $filas['created_at'] ?> </td>
                        <td>
                            <!--consulta con un id-->
                            <a href="edit.php?id=<?=$filas['id'] ?>" class="btn btn-secondary">
                                <i class="fas fa-marker"></i>
                             </a>
                             <a href="delete_task.php?id=<?=$filas['id'] ?>" class="btn btn-danger">
                                <i class="far fa-trash-alt"></i>
                             </a>
                        </td>

                    </tr>

                <?php } ?>
            </tbody>


            </table>


        </div>
    </div>

</div>


<?php include ("includes/footer.php") ?>