crudremaster-github/modificar.php at main · albertomaria1999/crudremaster-github · 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
89
<?php
include "modelo/conexion.php";

//OBTENER EL ID A PARTIR DE LA URL
$id = $_GET["id"];

// CONSULTA PARA OBTENER LA INFORMACION A PARTIR DEL ID DEL EMPLEADO
$sqlEmpleado = $conexion->query("SELECT * FROM employees WHERE id = $id");
$empleado = $sqlEmpleado->fetch_object();

// CONSULTA PARA OBTENER LAS NACIONALIDADES
$sqlNacionalidades = $conexion->query("SELECT * FROM nacionalidad");
?>

<!DOCTYPE html>
<html lang="es">

<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">
    <title>CRUD Remaster by Alberto Maria</title>
    <!--BOOSTRAP 5-->>
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.6/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-4Q6Gf2aSP4eDXB8Miphtr37CMZZQ5oXLH2yaXMJ2w8e2ZtHTl7GptT4jmndRuHDT" crossorigin="anonymous">
    <!--FONT AWESOME-->
    <script src="https://kit.fontawesome.com/68f88c6453.js" crossorigin="anonymous"></script>
</head>

<body>
    <form class="col-4 p-3 m-auto" method="POST">
        <h3 class="text-center alert alert-secondary ">Modificar registro de personas</h3>

        <hr><br>
        <?php
        include "controlador/modificar.php";

        ?>
        <!--OBTENER EL ID Y OCULTARLO-->
        <div class="input-group mb-3">
        <span class="input-group-text" id="basic-addon1"><i class="fa-solid fa-id-card"></i></span>
        <input name="id" type="text" class="form-control" aria-describedby="basic-addon1" value="<?= $_GET["id"] ?>" disabled>
        </div>

        <!--CAMPO DE NOMBRE-->
        <div class="mb-3">
            <label class="form-label">Nombre y Apellido <i class="fa-solid fa-circle-user"></i></label>
            <input type="text" class="form-control" name="name" value="<?= htmlspecialchars($empleado->name) ?>">
        </div>

        <!--CAMPO DE DIRECCION-->
        <div class="mb-3">
            <label class="form-label">Direccion <i class="fa-solid fa-map-location"></i></label>
            <input type="text" class="form-control" name="address" value="<?= htmlspecialchars($empleado->address) ?>">
        </div>

        <!--CAMPO DE SUELDO-->
        <div class="mb-3">
            <label class="form-label">Sueldo <i class="fa-solid fa-coins"></i></label>
            <input type="number" class="form-control" name="salary" value="<?= htmlspecialchars($empleado->salary) ?>">
        </div>

        <!--CAMPO DE EDAD-->
        <div class="mb-3">
            <label class="form-label">Edad <i class="fa-solid fa-hashtag"></i></label>
            <input type="number" class="form-control" name="edad" value="<?= htmlspecialchars($empleado->edad) ?>">
        </div>

        <!-- CAMPO DE NACIONALIDAD -->
        <div class="mb-3">
            <label class="form-label">Nacionalidad <i class="fa-solid fa-flag"></i></label>
            <select class="form-select" name="idnacionalidad">
                <?php while ($nac = $sqlNacionalidades->fetch_object()) { ?>
                    <option value="<?= $nac->id ?>"
                        <?= $empleado->idnacionalidad == $nac->id ? 'selected' : '' ?>>
                        <?= htmlspecialchars($nac->nacionalidad) ?>
                    </option>
                <?php } ?>
            </select>

        </div>

        <button type="submit" class="btn btn-primary" name="btnregistrar" value="ok">Enviar</button>
        <a href="index.php" class="btn btn-secondary">Volver</a>
    </form>
    <!--BOOSTRAP 5-->
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.6/dist/js/bootstrap.bundle.min.js" integrity="sha384-j1CDi7MgGQ12Z7Qab0qlWQ/Qqz24Gc6BM0thvEMVjHnfYGF0rmFCozFSxQBxwHKO" crossorigin="anonymous"></script>
    <!--@ryderwoolridge <3 -->
    </body
    </html>