All Questions

I have this code in mysql

SELECT * FROM `dev_transacciones` 
WHERE `id_transaccion` IN (SELECT MAX(`id_transaccion`) 
                           FROM `dev_transacciones` 
                           GROUP BY `id_producto`)
                           ORDER BY `id_transaccion` DESC

this displays a table showing the last transaction_id and groups them descending by product_id

And I have this code in php

  $data['inventario'] = $this->transaccionesModel
   ->select('dev_transacciones.*')
   ->where('id_transaccion', 'IN (SELECT MAX(id_transaccion)')
   ->groupBy('dev_transacciones.id_producto')
   ->orderBy('dev_transacciones.id_transaccion desc')
   ->findAll();

When I use it print($data['inventario'])shows an empty array

My doubt is how to do the SQL query in PHP, since the php code shows an empty Array, it does not show it like the second image that I added

The first image is the normal table and the second one is with the sql query

I am a novice, my query is: I bring data from MongoDb in a table and I want the registration number to appear, I know that there is a function and that it is something very simple to do but as I clarified, I am a novice on the subject and I am learning by I ask that the answers be unstructured and simple. Thank you

function pedirUsuarios (req, res){
  req.app.locals.titular=true
      User.find({}, (err, socios)=>{
        if (err){
          res.send (err)
        } else{
          res.render("usuarios", {socios, titular:req.app.locals.titular , usuario: req.session.user})
        }
      }).lean()
     } 

the html of the table:

<table class="table table-hover">
       
  <thead>
    <tr class="table-dark">
      <th scope="col">Nº Orden</th>
      <th scope="col">Apellido</th>
      <th scope="col">Nombre</th>
      <th scope="col">Direccion</th>
      <th scope="col">Altura</th>
      <th scope="col">Ciudad</th>
      <th scope="col">Estado</th>
      <th scope="col">CP</th>
      <th scope="col">Email</th>
    </tr>
  </thead>
  {{#each socios}} 
  <tbody>
    <tr> 
      <th scope="row"></th>
      <td>{{apellidoRegistro}}</td>
      <td>{{nombreRegistro}}</td>
      <td>{{calleRegistro}}</td>
      <td>{{alturaRegistro}}</td>
      <td>{{ciudadRegistro}}</td>
      <td>{{estadoRegistro}}</td>
      <td>{{cpRegistro}}</td>
      <td>{{emailRegistro}}</td>
    </tr>
    {{/each}}
  </tbody>
</table>

and the table:

I want it to appear in order: 1 2 3 4 5

Hello, I am trying to use a logo with redirection to the index, it works, I have the logo centered with 0 auto, but the left and right margins are also taken as part of the link, my question, how to make the link only affect the area from image?

attached code:

.nombre-sitio img{
    margin: 0 auto;
    text-align: center;
}

<header>
        <h1 class="nombre-sitio"><a href="index.html"><img src="img/logo.png" alt="logo"></a></h1> 
</header>

I am doing a scraping project with BeautifulSoup, for which I have created a dictionary within a for loop so that this cycle is repeated for all the containers of the website from which I am scraping them, it prints everything correct in the terminal.

The problem is when I want to display the data from this dictionary in an HTML template, if I use:

{% for b in buscar %} 

And I start calling each of the dictionary values ​​to sort them into a container with

{{ b.nombre }} 

When executing it, it shows me the empty container repeating the number of times as values ​​the dictionary has.

I understand that it is an error in the HTML loop because in the views everything works fine for me. And if I don't put the for loop in HTML it just shows me the last scraped element.

Here I leave the code of views.py

busqueda = dict() 
product_list = soup.find_all('div', attrs= {'class':'grid-item'})
        
        for product in product_list: 
            busqueda['imagen'] = product.find('img', attrs= {'class':'no-js','srcset':True})
            busqueda['nombre'] = product.find('p').text
            busqueda['precio'] = product.find('small', attrs= {'aria-hidden':'true'}).text
            sleep(randint(3, 5))
            print(busqueda)

context = {"buscar": busqueda} 
return render(request, "index.html", context) 

code in html

{% for b in buscar %}
<div class="card" style="width: 18rem; margin-left: 5px; margin-right: 5px;">
   <img src="{{ b.imagen }}" class="card-img-top">
   <div class="card-body">
      <h5 class="card-title">{{ b.nombre }}</h5>
      <p class="card-text">{{ b.precio }}</p>
   </div>
</div>
{% endfor %}

In this case, the .card container would be displayed 3 times for the 3 values ​​that

 tiene el diccionario (imagen, nombre, precio).

I would really appreciate it if you could help me, I've been at this for days.

I'm just starting out with Java and I'm stuck with this problem, for which I can only use For loops and the Math class. The problem is that I can not increase the rate. This is what should appear on the screen:

5 years 250.0(1.0%) 375.0(1.5%) 500.0(2.0%) 625.0(2.5%)
6 years 300.0(1.0%) 450.0(1.5%) 650.0(2.0%) 750.0(2.5%)
7 years 350.0(1.0% ) 525.0(1.5%) 700.0(2.0%) 875.0(2.5%)
8 years 400.0(1.0%) 600.0(1.5%) 800.0(2.0%) 1000.0(2.5%)

and this what I get:

5 years 250.0(1.0%) 250.0(1.5%) 250.0(2.0%) 250.0(2.5%)
6 years 250.0(1.0%) 250.0(1.5%) 250.0(2.0%) 250.0(2.5%)
7 years 250.0(1.0% ) 250.0(1.5%) 250.0(2.0%) 250.0(2.5%)
8 years 250.0(1.0%) 250.0(1.5%) 250.0(2.0%) 250.0(2.5%).

This is the code I have so far:

   double capitalInicial = 5000.0;
   double tasa = 1.0;
   int anios = 5;
   double intereses = capitalInicial * tasa / 100 * anios;
   for(int i = 5; i <= 8; i++) {
   System.out.println(i + " años \t" + intereses + "(1.0%) \t" + intereses + "(1.5%) \t" + intereses + "(2.0%) \t" + intereses + "(2.5%) \t");

I appreciate the help.