All Questions

I have a webpanel in which I select some data in an attempt to send it to a procedure that has as a rule 5 variables that should be sent from the webpanel, in the patterns and entity services part in a transaction that is associated with the webpanel I have created a button with the name of sending and when giving it f4 I have added a code in the event begin code, I have copied this code from the webpanel part because I have activated the multidelete in the transaction and I am using it as an example but I do not want to delete the records I only want to send the selected data to a procedure with the name Deletereceipt, would it be something like this how I should do it? this code gives error does not work for me

    Event 'enviar'
    Do 'LoadSelectedRows'
    If K2BIsAuthorizedActivityName.Udp(!"PEMTN008", !"PEMTN008", K2BStandardActivityType.Delete, !"",!"")
        If &SelectedRows.Count > 0
            &ConfirmMessage = format('¿Está seguro que quiere eliminar %1 número de recibo procesados?', &SelectedRows.Count)
            &ConfirmationSubId = !"Confirm_DoMultipleDelete"
            TableConditionalConfirm.Visible = True
        Else
            msg("K2BT_NoRowsSelectedError")
        EndIf
    EndIf
    EndEvent
    
    Sub 'LoadSelectedRows'
    &SelectedRows = new()
    For Each line In Grid
        If &Selected = True
            &SelectedRow = new()
            &SelectedRow.PemRenIde = PemRenIde
            &SelectedRow.PemRenAnh = PemRenAnh
            &SelectedRow.PemRenMes = PemRenMes
            &SelectedRow.PemRenNro = PemRenNro
            &SelectedRow.PemRenNdc = PemRenNdc
            &SelectedRow.PemRenLot = PemRenLot
            &SelectedRow.PemRenBen = PemRenBen
            &SelectedRow.PemRenLel = PemRenLel
            &SelectedRow.PemRenBel = PemRenBel
            &SelectedRows.Add(&SelectedRow)
        EndIf
    EndFor
EndSub
Sub 'Confirm_DoMultipleDelete'
    Do 'LoadSelectedRows'
    If K2BIsAuthorizedActivityName.Udp(!"PEMTN008", !"PEMTN008", K2BStandardActivityType.Delete, !"",!"")
        If &SelectedRows.Count > 0
            // Code added in [MultipleDelete.BeginCode] --- START
            &DeletedCount = 0
            &ErrorCount = 0
            For &SelectedRow in &SelectedRows
                &MultipleDelete_BC.Load(&SelectedRow.PemRenIde)
                    //&MultipleDelete_BC.Delete()
                &MultipleDelete_BC = Eliminarrecibo.Udp(PemRenAnh,PemRenMes, PemRenLot.ToString(), PemRenNdc.ToString(), PemRenIde)
                If &MultipleDelete_BC.Success()
                    &DeletedCount += 1
                Else
                    &ErrorCount += 1
                    &ErrorMessage = format('Número de recibo procesado "%1" no pudo ser eliminado por causa de estos errores:', &MultipleDelete_BC.PemRenLot)
                    For &Message in &MultipleDelete_BC.GetMessages()
                        &ErrorMessage += newline() + " - " + &Message.Description
                    EndFor
                    msg(&ErrorMessage)
                EndIf
            EndFor
            If &ErrorCount > 0
                Rollback
                msg('Ningún Número de recibo procesado fue eliminado')
            Else
                Commit
                msg(format('%1 número de recibo procesados eliminados', &DeletedCount))
            EndIf
            Grid.Refresh()
            
            // Code added in [MultipleDelete.BeginCode] --- END
        Else
            msg("K2BT_NoRowsSelectedError")
        EndIf
        
    EndIf
EndSub

Well, this code gives an error when compiling, I think it should not be in the event begin code

error src0062: Expecting 'EndSub' command to close subroutine definition. (Web Panel 'PEMTN008WW' Events, Line: 197, Char: 1, Details)
error src0051: Unexpected expression (Web Panel 'PEMTN008WW' Events, Line: 240, Char: 57, Details)
error: Supported grammar:FOR <variable> IN <array|collection>

Very good, so far I am making a simple CRUD , in which I use PDO to use the database. I have built all the activities that the CRUD can do except the update one, since it is giving me problems that I can't find. Until now I have been able to believe that I have a problem with the product id, since I call it by GET from the main page "listado.php" but it does not update it through the form of the product that I want to update, which I use as a POST method.

I leave you here the main page, which as you can see I call the edit button to the product in question of its id, which takes me to another page where the form is found:

!DOCTYPE html>
<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="./css/bootstrap.min.css">
    <link rel="stylesheet" href="./css/style.css">
    <title>Proyecto DSW</title>
</head>

<body>

    <h1>Gestión de productos</h1>

    <div class="d-grid gap-2">
        <a href="crear.php" class="btn btn-success btn-block boton">Crear producto</a>
    </div>


    <table class="table table-striped table-hover">
        <tr class="table-dark">
            <th class="detalle">Detalle</th>
            <th class="codigo">Codigo</th>
            <th>Nombre</th>
            <th>Acciones</th>
        </tr>
        <?php
        include "conexion.php";
        
        $pdo = Conexion::conectar();
        $sql = $pdo->query("SELECT * FROM productos ORDER BY id DESC");
        // $conexion = $sql->fetchAll(PDO::FETCH_OBJ);

        foreach ($sql as $resultado) {
            echo "<tr>";
            echo "<td><a href='detalle.php?id=".$resultado['id']."' class='btn btn-info btn-block botonInfo'>Detalle</a></td>";
            echo "<td class='codigo'><b>".$resultado['id']."</b></td>";
            echo "<td><b>".$resultado['nombre']."<b></td>";
            echo "<td>
                <a href='editar.php?id=".$resultado['id']."' class='btn btn-warning btn-block botonExtra'>Actualizar</a>
                <a href='borrar.php?id=".$resultado['id']."' class='btn btn-danger btn-block botonExtra'>Borrar</a></td>";
            echo "</tr>";
            echo "</table";

        }
        Conexion::desconectar();
        ?>


        <script src="./js/bootstrap.min.js"></script>
</body>

</html>

The other page in question is edit.php , which is where the problems are coming from:

<?php
require "conexion.php";

// $id = null;
if (!empty($_GET['id'])) {
    $id = $_REQUEST['id'];
}

if (!empty($_POST)) {

    $nombre = $_POST['nombre'];
    $nombre_corto = $_POST['nombre_corto'];
    $pvp = $_POST['pvp'];
    $select = $_POST['familia'];
    $descripcion = $_POST['descripcion'];

    $pdo = Conexion::conectar();
    $sql = "UPDATE productos  SET nombre = ?, nombre_corto = ?, descripcion = ?, pvp = ?, familia = ? WHERE id = ?;";
    $conexion = $pdo->prepare($sql);
    // echo "$sql";
    // echo "$conexion";
    $conexion->execute([$nombre, $nombre_corto, $descripcion, $pvp, $select, $id]);
    echo "$conexion";
    $nuevaURL = "listado.php";
    Conexion::desconectar();
    header('Location: ' . $nuevaURL);
    
}
$pdo = Conexion::conectar();
$sql = "SELECT * FROM productos where id = ?;";
$conexion = $pdo->prepare($sql);
$conexion->execute([$id]);
$data = $conexion->fetch(PDO::FETCH_OBJ);
$nombre = $data->nombre;
$nombre_corto = $data->nombre_corto;
$pvp = $data->pvp;
$select = $data->familia;
$descripcion = $data->descripcion;

?>

<!DOCTYPE html>
<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="./css/style2.css">
    <link rel="stylesheet" href="./css/bootstrap.min.css">
    <title>Crear producto</title>
</head>

<body>

    <h1>Actualizar Producto</h1>

    <div class="grid estilodiv">
        <form class="row g-3" method="post" action="editar.php" id="formularioActualizar" autocomplete="off">
            <div class="col-md-6">
                <label class="form-label">Nombre</label>
                <input type="text" class="form-control" name="nombre" placeholder="Nombre" value="<?php echo !empty($nombre) ? $nombre : ''; ?>">

            </div>
            <div class="col-md-6">
                <label class="form-label">Nombre Corto</label>
                <input type="text" class="form-control" name="nombre_corto" placeholder="Nombre Corto" value="<?php echo !empty($nombre_corto) ? $nombre_corto : ''; ?>">

            </div>
            <div class="col-md-6">
                <label class="form-label">Precio (€)</label>
                <input type="number" class="form-control" name="pvp" placeholder="Precio" value="<?php echo !empty($pvp) ? $pvp : ''; ?>">

            </div>
            <div class="col-md-6">
                <label class="form-label">Familia</label>
                <select class="form-control" name="familia">
                    <?php
                    $pdoSelect = Conexion::conectar();
                    $sqlSelect = $pdoSelect->query("SELECT * FROM familias");
                    $sqlSelect->execute();
                    while ($data = $sqlSelect->fetch(PDO::FETCH_OBJ)) {
                        echo '<option value="' . $data->cod . '">' . $data->nombre . '</option>';
                    }
                    Conexion::desconectar();
                    ?>
                </select>
            </div>
            <div class="mb-3">
                <label class="form-label">Descripción</label>
                <textarea class="form-control" name="descripcion" cols="20" rows="10" placeholder="Ingrese una descripción..."><?php echo !empty($descripcion) ? $descripcion : ''; ?></textarea>

            </div>
            <!-- <input type='hidden' name='id' value=$id> -->
            <div class="d-grid gap-2">
                <button type="submit" class="btn btn-primary">Actualizar</button>
            </div>

            <div class="d-grid gap-2">
                <button type="reset" class="btn btn-success">Limpiar</button>
            </div>

            <div class="d-grid gap-2">
                <a href="listado.php" class="btn btn-secondary">Volver</a>
            </div>
        </form>
    </div>

    <script src="./js/bootstrap.min.js"></script>
    <?php
    // Conexion::desconectar();
    ?>
</body>

</html>

It gives me errors that the "id" variable is not defended, but I don't know how to define it, since I try to do it through an input hidden field , but I don't know how to do it. Thank you very much.

I leave you the error that shows me when making echo "$conexion"; the FATAL ERROR, it's simple, it's by using this line of code.

I need help with the bootstrap accordion, somehow when I close all the options, this accordion retracts changing its size and positioning itself to the right side of the screen, my intention is that no matter how much I close all the sections of the accordion, it does not change its size and stay the same length. I tried to remove some things but nothing happens, the bt code I'm using is this.

<div class="accordion" id="accordionExample">
                <div class="accordion-item">
                  <h2 class="accordion-header" id="headingOne">
                    <button class="accordion-button" type="button" data-bs-toggle="collapse" data-bs-target="#collapseOne" aria-expanded="true" aria-controls="collapseOne">
                      Accordion Item #1
                    </button>
                  </h2>
                  <div id="collapseOne" class="accordion-collapse collapse show" aria-labelledby="headingOne" data-bs-parent="#accordionExample">
                    <div class="accordion-body">
                      <strong>This is the first item's accordion body.</strong> It is shown by default, until the collapse plugin adds the appropriate classes that we use to style each element. These classes control the overall appearance, as well as the showing and hiding via CSS transitions. You can modify any of this with custom CSS or overriding our default variables. It's also worth noting that just about any HTML can go within the <code>.accordion-body</code>, though the transition does limit overflow.
                    </div>
                  </div>
                </div>
                <div class="accordion-item">
                  <h2 class="accordion-header" id="headingTwo">
                    <button class="accordion-button collapsed" type="button" data-bs-toggle="collapse" data-bs-target="#collapseTwo" aria-expanded="false" aria-controls="collapseTwo">
                      Accordion Item #2
                    </button>
                  </h2>
                  <div id="collapseTwo" class="accordion-collapse collapse" aria-labelledby="headingTwo" data-bs-parent="#accordionExample">
                    <div class="accordion-body">
                      <strong>This is the second item's accordion body.</strong> It is hidden by default, until the collapse plugin adds the appropriate classes that we use to style each element. These classes control the overall appearance, as well as the showing and hiding via CSS transitions. You can modify any of this with custom CSS or overriding our default variables. It's also worth noting that just about any HTML can go within the <code>.accordion-body</code>, though the transition does limit overflow.
                    </div>
                  </div>
                </div>
                <div class="accordion-item">
                  <h2 class="accordion-header" id="headingThree">
                    <button class="accordion-button collapsed" type="button" data-bs-toggle="collapse" data-bs-target="#collapseThree" aria-expanded="false" aria-controls="collapseThree">
                      Accordion Item #3
                    </button>
                  </h2>
                  <div id="collapseThree" class="accordion-collapse collapse" aria-labelledby="headingThree" data-bs-parent="#accordionExample">
                    <div class="accordion-body">
                      <strong>This is the third item's accordion body.</strong> It is hidden by default, until the collapse plugin adds the appropriate classes that we use to style each element. These classes control the overall appearance, as well as the showing and hiding via CSS transitions. You can modify any of this with custom CSS or overriding our default variables. It's also worth noting that just about any HTML can go within the <code>.accordion-body</code>, though the transition does limit overflow.
                    </div>
                  </div>
                </div>
            </div>

I have tried to pass the entire collection, and if it saves the value, as an array (logical), but what I want is that it only saves the newField and secondField fields with their respective values ​​in the old_user collection of the new_user collection, but I save them as null, this is the code:

db.getCollection("old_user").find()
  .forEach((elm) => {

    let elmId = elm.id

    let new_user = db.getCollection("new_user").find( {id : elmId}).toArray()

      if(new_user) {
        db.getCollection("old_user").updateOne({id: elmId}, {$set: {newfield: new_user.newField, secondfield: new_user.secondField}})
      }
  })

As far as I know, to access an object inside an array it is with the point annotation, if I make a query of the entire collection it returns it to me but if I do a console.log of new_user.newField it returns it to me as null

I appreciate any help!

As they are, I have a list of diseases that is shown in my DropDownList and when selecting it, it is loaded in the textarea, so far without problems; but if I select another disease again, it is replaced in the Textarea and I want the new selected disease to be added, I hope you can help me

$(document).on('change', '#idenfermedad', function (event) {
            $('#diagnos').val($("#idenfermedad option:selected").text());
        });

<div class="form-group col-md-6">
                <label asp-for="diagnostico" class="control-label"></label>                
                @Html.DropDownList("idenfermedad", listaEnfermedad, new { @class = "form form control" })
                <textarea asp-for="diagnostico" class="form-control col-md-12" rows="7" id="diagnos"></textarea>                
</div>