John Doe's questions

I have this categories table:

CREATE TABLE IF NOT EXISTS `categoria` (
`idcategoria` int(5) NOT NULL AUTO_INCREMENT,
`nombrecategoria` varchar(50) NOT NULL,
PRIMARY KEY (`idcategoria`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

And this expenses:

CREATE TABLE IF NOT EXISTS `gastos` (
`idgasto` int(5) NOT NULL AUTO_INCREMENT,
`cantidadgasto` int(50) NOT NULL,
`fecha` date NOT NULL,
`idcategoria` int(5) NOT NULL,
PRIMARY KEY (`idgasto`),
 CONSTRAINT fk_categoria
    FOREIGN KEY (idcategoria) 
        REFERENCES categoria(idcategoria)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

Data:

    insert into categoria (idcategoria,nombrecategoria) values (5, "gasolina");
    insert into categoria (idcategoria,nombrecategoria) values (15, "comida");
    insert into categoria (idcategoria,nombrecategoria) values (25, "ropa");
    insert into categoria (idcategoria,nombrecategoria) values (35, "gimnasio");
    insert into gastos (idgasto,cantidadgasto,fecha,idcategoria) values (100, 25,"2022-03-22",5);
    insert into gastos (idgasto,cantidadgasto,fecha,idcategoria) values (105, 30,"2022-03-23",15);
    insert into gastos (idgasto,cantidadgasto,fecha,idcategoria) values (110, 40,"2022-03-25",25);

Using this select:

SELECT distinct g.cantidadgasto, c.nombrecategoria, g.fecha 
from gastos g, categoria c 
inner join gastos on gastos.idcategoria = c.idcategoria;

And I can't get it to show it to me without repeating, I don't know if the expenses table is wrong or what is wrong is the select, the case is that I want it to show me like this:

Amount Expense || Category Name || Date

I have a form where there is an input to upload images, once I accept through js and php I create the insert to save the data on the server to later display it on another page. I have verified that it saves the image on the server but when I download it directly from the server it has a format that my page cannot interpret since it shows an image error icon.

==================================================== ============== EDIT: With the new changes I get this error whether I choose a photo or not:

Request failed: parsererror

HTML:

<form name="frmAltaNoticia" id="frmAltaNoticia" method="POST" enctype="multipart/form-data">
                <div class="col-xs-3 col-sm-3 col-md-3">
                    <label>IdNoticia: </label>
                    <input type="text" placeholder="A0000"class="form-control" id="txtIdNoticia">
                </div>
                
                <div class="col-xs-3 col-sm-3 col-md-3">
                    <label>Fecha: </label>
                    <input type="date" placeholder="Fecha" class="form-control" name="txtFecha">
                </div>          
                
                <div class="col-xs-6 col-sm-6 col-md-6">
                    <label>Título: </label>
                    <input type="text" placeholder="Título"class="form-control" name="txtTitulo">
                </div>                                      
                    <br>
                        <br>
                            <br>
                <div class="col-xs-3 col-sm-3 col-md-3">
                    <label>Autor: </label>
                    <input type="text" placeholder="Autor"class="form-control" name="txtAutor">
                </div>  
                <div class="col-xs-9 col-sm-9 col-md-9">
                    <label>Descripción:</label>
                    <textarea name="txtDescripcion" placeholder="Descripción" class="form-control" name="txtDescripcion"></textarea>
                </div>
                
                <br>
                <div class="col-xs-5 col-sm-5 col-md-5">
                    <label>Imagen: </label>
                    <input type="file" class="form-control" name="txtImagen">
                </div>  
                
            <br>
                <br>
                    <br>
                         <br>
                        
                <div class="col-md-3">
                <input class="form-check-input" type="checkbox" value="" id="invalidCheck" required>
                <label class="form-check-label" for="invalidCheck">Aceptas los términos</label>
                <div class="invalid-feedback">Debes aceptar los términos y condiciones</div>
                </div>
                    <br>
                         <br>
                         <br>
                         <br>
                <div class="col-xs-3 col-sm-3 col-md-3">
                <input type="button" class="btn btn-dark btn-lg"  onclick="ValidarNoticia()" value="Aceptar"></input>
                </div>  
            </form>

PHP:

        <?php

// Configuración BASE DE DATOS MYSQL
$servidor  = "localhost";
$basedatos = "BDNoticias";
$usuario   = "root";
$password  = "";

# Obtenemos los datos normales con el estilo que usabas
$oNoticia = json_encode($_POST);


// Creamos la conexión al servidor.
$conexion = mysqli_connect($servidor, $usuario, $password,$basedatos);
if (!$conexion) { 
    $respuesta["error"]=1;
    #Considera cambiarlo por un mensaje personalizado en producción
    $respuesta["mensaje"]=mysqli_error($conexion);
} else {
    mysqli_set_charset($conexion,"utf8");
    # Pero como dijimos, la imagen está en otra super global
    $mFile = file_get_contents($_FILES['txtImagen']["tmp_name"]);
    $mBlob=base64_encode($mFile);
    $sql = "INSERT INTO noticias (idnoticia, titulo, descripcion, autor, fecha, imagen) VALUES ('$oNoticia->txtIdNoticia','$oNoticia->txtTitulo','$oNoticia->txtDescripcion','$oNoticia->txtAutor','$oNoticia->txtFecha','$mBlob');";
    $resultado = mysqli_query($conexion,$sql);

    if ($resultado){
        $respuesta["error"] = 0;
        $respuesta["mensaje"] = "Alta realizada"; 
    } else {
        $respuesta["error"] = 1;
        $respuesta["mensaje"] = "Error en el proceso de alta: ".mysqli_error($conexion);
    }
}

echo json_encode($respuesta);
//var_dump($_POST);
var_dump($oNoticia);

mysqli_close($conexion);
?>

JS:

function crearNoticia()  
{
    /* Esta línea basta para recoger todo lo que haya en el 
    formulario*/
    var mData = new FormData(document.getElementById("frmAltaNoticia"));
var mAjax = $.ajax({
    url: "../ApartadosPHP/altanoticias.php",
    method: "POST",
    data: mData,
    processData: false,  
    contentType: false,
    dataType: "json"
});

mAjax.done(function( oDatos ) {
    respuestaAltaNoticia(oDatos);
});

mAjax.fail(function( jqXHR, textStatus ) {
    alert( "Request failed: " + textStatus );
});
};


function respuestaAltaNoticia(oDatos, sStatus, oXHR) {

if (oDatos.error) 
{
    alert(oDatos.mensaje);
} 
else 
{
    alert(oDatos.mensaje);
    frmAltaNoticia.reset();
}
}

var_dump:

    index.js:640 string(117) "{"txtIdNoticia":"G7894","txtFecha":"2021-08-05","txtTitulo":"noticia","txtAutor":"pepe","txtDescripcion":"noticiass"}"
<br />
<b>Notice</b>:  Trying to get property 'txtIdNoticia' of non-object in <b>C:\xampp\htdocs\proyectoFinal\ProyectoSenderismo\ApartadosPHP\altanoticias.php</b> on line <b>24</b><br />
<br />
<b>Notice</b>:  Trying to get property 'txtTitulo' of non-object in <b>C:\xampp\htdocs\proyectoFinal\ProyectoSenderismo\ApartadosPHP\altanoticias.php</b> on line <b>24</b><br />
<br />
<b>Notice</b>:  Trying to get property 'txtDescripcion' of non-object in <b>C:\xampp\htdocs\proyectoFinal\ProyectoSenderismo\ApartadosPHP\altanoticias.php</b> on line <b>24</b><br />
<br />
<b>Notice</b>:  Trying to get property 'txtAutor' of non-object in <b>C:\xampp\htdocs\proyectoFinal\ProyectoSenderismo\ApartadosPHP\altanoticias.php</b> on line <b>24</b><br />
<br />
<b>Notice</b>:  Trying to get property 'txtFecha' of non-object in <b>C:\xampp\htdocs\proyectoFinal\ProyectoSenderismo\ApartadosPHP\altanoticias.php</b> on line <b>24</b><br />
{"error":0,"mensaje":"Alta realizada"}

I am trying to display an image taken from the mysql server to display it on my website by generating an xml and creating a table with javascript.

I have a getNoticia.php where I communicate with the server:

 <?php

// Configuración BASE DE DATOS MYSQL
$servidor  = "localhost";
$basedatos = "BDNoticias";
$usuario   = "root";
$password  = "";

// Creamos la conexión al servidor.
$conexion = mysqli_connect($servidor, $usuario, $password,$basedatos) or die(mysqli_error($conexion));
mysqli_set_charset($conexion,"utf8");

// Consulta SQL para obtener los datos de los centros.
$sql = "SELECT * FROM noticias";
$resultados = mysqli_query($conexion,$sql);

$XML ='<?xml version="1.0" encoding="UTF-8"?>';
$XML .='<datos>';

while ($fila = mysqli_fetch_array($resultados)) {
    $XML .='<documento>';
        $XML .='<idnotici>'.$fila["idnoticia"].'</idnotici>';
        $XML .='<titul>'.$fila["titulo"].'</titul>';
        $XML .='<descripcio>'.$fila["descripcion"].'</descripcio>';
        $XML .='<auto>'.$fila["autor"].'</auto>';
        $XML .='<fech>'.$fila["fecha"].'</fech>';
        $XML .='<img>'.base64_encode($fila["imagen"]).'</img>';
    $XML .='</documento>';
}

$XML .='</datos>';

// Cabecera de respuesta indicando que el contenido de la respuesta es XML
header("Content-Type: text/xml");
// Para que el navegador no haga cache de los datos devueltos por la página PHP.
header('Cache-Control: no-cache, must-revalidate');
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');

echo $XML;

mysqli_close($conexion);
?>

If I remove the base64_encode()from tag I get lots of "?" by console they give me the error and it doesn't show me anything. If I don't remove it, it shows me in the table a very long line of characters that I imagine is the image.

In theory, this line mysqli_set_charset($conexion,"utf8");is fine, so I understand that the problem comes with the encoding of the image.

Without base64_encode():

With base64_encode():

To display the data I use this function in js:

            function construirListado(oXML) 
           {
            // Crear tabla
            var oTabla = document.createElement("table");
            oTabla.border = "3";
            var oTHead = oTabla.createTHead();
            var oFila = oTHead.insertRow(-1);
            
            var oTH = document.createElement("TH");
            oTH.textContent = "IDNoticia";
            oFila.appendChild(oTH);
            
            oTH = document.createElement("TH");
            oTH.textContent = "Título";
            oFila.appendChild(oTH);

            oTH = document.createElement("TH");
            oTH.textContent = "Autor";
            oFila.appendChild(oTH);

            oTH = document.createElement("TH");
            oTH.textContent = "Fecha";
            oFila.appendChild(oTH);
            
            /*
            oFila = oTHead.insertRow(-1);
            oTH = document.createElement("TH");
            oTH.textContent = "Descripción";
            oFila.appendChild(oTH);*/
                        
            var oTBody = oTabla.createTBody();      
            var oPersonas = oXML.querySelectorAll("documento");
            for (var i = 0; i < oPersonas.length; i++) {
                oFila = oTBody.insertRow(-1);

                var oCelda = oFila.insertCell(-1);
                oCelda.textContent = oPersonas[i].querySelector("idnotici").textContent;

                oCelda = oFila.insertCell(-1);
                oCelda.textContent = (oPersonas[i].querySelector("titul").textContent);                            
            
                oCelda = oFila.insertCell(-1);
                oCelda.textContent = (oPersonas[i].querySelector("auto").textContent);

                oCelda = oFila.insertCell(-1);
                oCelda.textContent = (oPersonas[i].querySelector("fech").textContent);
                    
                oFila = oTBody.insertRow(-1);
                oFila = oTBody.insertRow(-1);
                oCelda = oFila.insertCell(-1);
                // Combina para ocupar toda la fila
                oCelda.colspan = 4;             
                oCelda.textContent = (oPersonas[i].querySelector("descripcio").textContent);
                
            
                oCelda = oFila.insertCell(-1);      
                oCelda.textContent = (oPersonas[i].querySelector("img").textContent);
                    
            }
            document.querySelector("#listado").innerHTML = "";
            document.querySelector("#listado").appendChild(oTabla);
        
}

I have this table that shows me the data on the same line:

I'm trying to give it the shape I want but I can't. The idea is to show me the data like this:

The data comes from the mysql server and I create the table like this:

function construirListado(oXML) 
        {

        var oTabla = document.createElement("table");
        oTabla.border = "3";
        var oTHead = oTabla.createTHead();
        var oFila = oTHead.insertRow(-1);
        
        var oTH = document.createElement("TH");
        oTH.textContent = "IDNoticia";
        oFila.appendChild(oTH);
        
        oTH = document.createElement("TH");
        oTH.textContent = "Título";
        oFila.appendChild(oTH);

        oTH = document.createElement("TH");
        oTH.textContent = "Autor";
        oFila.appendChild(oTH);

        oTH = document.createElement("TH");
        oTH.textContent = "Fecha";
        oFila.appendChild(oTH);
                    
        oTH = document.createElement("TH");
        oTH.textContent = "Descripción";
        oFila.appendChild(oTH);
                    
        var oTBody = oTabla.createTBody();      
        var oPersonas = oXML.querySelectorAll("documento");
        for (var i = 0; i < oPersonas.length; i++) {
            oFila = oTBody.insertRow(-1);

            var oCelda = oFila.insertCell(-1);
            oCelda.textContent = oPersonas[i].querySelector("idnotici").textContent;

            oCelda = oFila.insertCell(-1);
            oCelda.textContent = (oPersonas[i].querySelector("titul").textContent);                            
        
            oCelda = oFila.insertCell(-1);
            oCelda.textContent = (oPersonas[i].querySelector("auto").textContent);

            oCelda = oFila.insertCell(-1);
            oCelda.textContent = (oPersonas[i].querySelector("fech").textContent);
            
            oCelda = oFila.insertCell(-1);
            oCelda.textContent = (oPersonas[i].querySelector("descripcio").textContent);
                            
        }
        document.querySelector("#listado").innerHTML = "";
        document.querySelector("#listado").appendChild(oTabla);
    
    }

Data to create the table in the database:

    CREATE DATABASE  IF NOT EXISTS `BdNoticias` /*!40100 DEFAULT CHARACTER SET latin1 */; 
    USE `BdNoticias`;


DROP TABLE IF EXISTS `noticias`;
CREATE TABLE `noticias` (
  `idnoticia` varchar(9) NOT NULL,
  `titulo` varchar(20) NOT NULL,
  `descripcion` longtext NOT NULL,
  `autor` varchar(20) NOT NULL,
  `fecha` date NOT NULL,
  PRIMARY KEY (`idnoticia`)
);

INSERT INTO `noticias` (`idnoticia`, `titulo`, `descripcion`, `autor`, `fecha`) VALUES ('N1234', 'Los Campos', 'En el Bierzo, junto al rio Sil...', 'Victor', '2021-04-06'), ('N4321', 'Selva de Irati', 'En pleno Pirineo Navarro...', 'Eugenio', '2020-08-11');

I know it must be changing them "oTH = document.createElement("TH");" but I can't and it messes up the whole table or it does strange things to me. I am displaying the result in a div with id "list" to show it.

I hope you can help me thanks.

This is the .php getNoticias file where I query the database and create the xml to manage it in the .js:

    <?php

// Configuración BASE DE DATOS MYSQL
$servidor  = "localhost";
$basedatos = "BdNoticias";
$usuario   = "root";
$password  = "";

// Creamos la conexión al servidor.
$conexion = mysqli_connect($servidor, $usuario, $password,$basedatos) or die(mysqli_error($conexion));
mysqli_query($conexion,"utf8");

// Consulta SQL para obtener los datos de los centros.
$sql = "SELECT * FROM noticias";
$resultados = mysqli_query($conexion,$sql);

$XML ='<?xml version="1.0" encoding="UTF-8"?>';
$XML .='<datos>';

while ($fila = mysqli_fetch_array($resultados)) {
    $XML .='<documento>';
        $XML .='<idnotici>'.$fila["idnoticia"].'</idnotici>';
        $XML .='<titul>'.$fila["titulo"].'</titul>';
        $XML .='<descripcio>'.$fila["descripcion"].'</descripcio>';
        $XML .='<auto>'.$fila["autor"].'</auto>';
        $XML .='<fech>'.$fila["fecha"].'</fech>';
    $XML .='</documento>';
}

$XML .='</datos>';

// Cabecera de respuesta indicando que el contenido de la respuesta es XML
header("Content-Type: text/xml");
// Para que el navegador no haga cache de los datos devueltos por la página PHP.
header('Cache-Control: no-cache, must-revalidate');
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');

echo $XML;

mysqli_close($conexion);
?>

The operation would be that when a user logs in through a login, some navbar buttons are enabled. So far so good, but when I enter one of those buttons, the other buttons are disabled and I don't know how to make it read my cookies and keep me logged in. If I hit home, it doesn't keep me in session either and all the buttons are disabled.

This is the function for the login:

     function Comprueba()
{
  var user = document.getElementById("usuario").value;
  var pass = document.getElementById("password").value;
  $.post("conexion.php",{usuario:user,password:pass},function(data)
  {
      if(data!="NO"){ 
        $("#mensaje").html("<span class='verde'>Bienvenido "+ data+ "</span>");     
        
        $("#Noticias").removeClass( "disabled");
        $("#Noticias").addClass( "active");
        
        $("#Rutas").removeClass( "disabled");
        $("#Rutas").addClass( "active");
        
        $("#Inscribirse").removeClass( "disabled");
        $("#Inscribirse").addClass( "active");
        
        $("#Listados").removeClass( "disabled");
        $("#Listados").addClass( "active");

        document.cookie = user=pass;
        var x = document.cookie;
        window.alert(x);

        limpiarFormulario();        
      }
     else
     {  
        $("#mensaje").html("<span class='roja'>Usuario no válido</span>");
     }
  });   
}

With php I would know how to do it because through the post method you receive the two parameters user and pass and save it in the session, you do a check when entering each tab and that's it, but with cookies I have no idea and I don't know if it would be a better option to use localStorage or sessionStorage. I hope you can help me thanks.

I have a website with a navbar and a login where I have several buttons, one activated (register) and the others deactivated. The idea is that when a user registers and logs in, the other buttons that are disabled are activated.

Here I have my navbar:

 <nav class="navbar navbar-expand-lg navbar-light bg-light">
  <div class="container-fluid">
    <a class="navbar-brand" href="login.html">MiWeb.es</a>
    <button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarNav" aria-controls="navbarNav" aria-expanded="false" aria-label="Toggle navigation">
      <span class="navbar-toggler-icon"></span>
    </button>
    <div class="collapse navbar-collapse" id="navbarNav">
      <ul class="navbar-nav">
        <li class="nav-item">
          <a class="nav-link active" aria-current="page" href="#">Alta </a>
        </li>
        <li class="nav-item">
          <a class="nav-link disabled" href="#" tabindex="-1" id ="Noticias" aria-disabled="true">Alta Noticia</a>
        </li>
        <li class="nav-item">
          <a class="nav-link disabled" href="#" tabindex="-1" aria-disabled="true">Alta productos</a>
        </li>
                <li class="nav-item">
          <a class="nav-link disabled" href="#" tabindex="-1" aria-disabled="true">Inscribirse</a>
        </li>
                <li class="nav-item">
          <a class="nav-link disabled" href="#" tabindex="-1" aria-disabled="false">Otros</a>
        </li>
        
        <li class="nav-item dropdown">
        <a class="nav-link dropdown-toggle disabled" data-toggle="dropdown" href="#">Listados</a>        
        <div class="dropdown-menu">
          <a class="dropdown-item" href="#">Listado Clientes</a>
          <a class="dropdown-item" href="#">productos</a>
          <a class="dropdown-item" href="#">etc</a>
        </div>
      </li>
               
    
    <li class="nav-item">       
    <div class="box">
    <input type="text" id="usuario" placeholder="Usuario" />    
    <input type="password" id="password" placeholder="Contraseña" /> 
    <input type="button" value="Iniciar sesión" onclick="Comprueba();"/>     
    </div>  
    <div id="mensaje"></div>   <!-- mensaje de usuario correcto o no   >-->
    </li>
    
      </ul>
    </div>
  </div>
</nav>

My js function for login:

    <script type="text/javascript">  
 function Comprueba(){
  var user = document.getElementById("usuario").value;
  var pass = document.getElementById("password").value;
  $.post("conexion.php",{usuario:user,password:pass},function(data){
      if(data!="NO"){ 
        $("#mensaje").html("<span class='verde'>Bienvenido "+ data+ "</span>"); 
        div = document.getElementById('Noticias'); //mostrar boton noticias.
        //div.style.display = ''; Esto lo tenia así antes y me funcionaba usando Css    

      else{  
        $("#mensaje").html("<span class='roja'>Usuario no válido</span>");
     }
  });   
 }

In my previous version, using css worked for me but using bootstrap and putting disabled I don't know how to access it or how to make it put enabled or directly remove disable to show it. I hope you can help me thanks.

I have a little doubt about how to fill them by obtaining the data from the server.

I have an index.html:

    <form name="frmListadoPiezas3" id="frmListadoPiezas3" class="form-horizontal">
  <fieldset>
    <!-- Form Name -->
    <legend>Listado de piezas de un producto Radio</legend>

    <!-- Select Basic -->
    <div class="form-group">
      <label class="col-md-4 control-label" for="lstProductosListado3">Producto</label>
      <div class="col-md-4">
        <input type="Radio" id="lstProductosListado3" name="lstProductosListado3" class="form-control">


      </div>
    </div>

    <!-- Button -->
    <div class="form-group">
      <label class="col-md-4 control-label" for="btnListar"></label>
      <div class="col-md-4">
        <input type="button" id="btnListar3" name="btnListar3" class="btn btn-success" value="Listar"></input>
      </div>
    </div>

  </fieldset>
</form>

And an index.js:

    function procesarRellenarProductos(listadoProductos)
{
    console.log(listadoProductos);
    $("#lstProductosListado3").empty();
    let sOption="";
    for(let i=0;i<listadoProductos.length;i++)
    {
        sOption += "<option value='"+listadoProductos[i].idproducto+"'>"+listadoProductos[i].nombre+"</option>"
    }

    $("#lstProductosListado").html(sOption);

}

The processFillProducts function as it is right now fills a dropdown that works correctly, but when I want it to fill a radio and a check (using a function for each one) I don't know how I should do it inside the for. I have tried several things and it does not show me anything, only 1 empty radius circle. I do the filling through ajax calling a php file where I have the connection and consult the server.

This is the part not to wear:

sOption += "<option value='"+listadoProductos[i].idproducto+"'>"+listadoProductos[i].nombre+"</option>"

I hope you can help me, thanks.

I add the functions that call the server:

    function rellenarCombosProductos()
{
    var iListaProductos = null;
    if(localStorage["nombreProductos"] != null)
    {
        iListaProductos = JSON.parse(localStorage["nombreProductos"]);
        procesarRellenarComboProductos(iListaProductos);
    }
    else
    {
        let oAjax = instanciarXHR();

        var sURL = "./php/getProductos.php";

        oAjax.open("GET", encodeURI(sURL));

        oAjax.addEventListener("readystatechange", procesarRespuesta);

        oAjax.send();
    }
}

function procesarRespuesta()
{ 
    var oAjax = this;
    //console.log(oAjax.responseText)

    if (oAjax.readyState == 4 && oAjax.status == 200) 
    {
       let listadoProductos =  JSON.parse(oAjax.responseText);
       console.log(listadoProductos)
        procesarRellenarComboProductos(listadoProductos);
        localStorage["nombreProductos"] = JSON.stringify(listadoProductos);

    }
}

    function instanciarXHR() {
    var xhttp = null;

    if (window.XMLHttpRequest) {
        xhttp = new XMLHttpRequest();
    } else // code for IE5 and IE6
    {
        xhttp = new ActiveXObject("Microsoft.XMLHTTP");
    }

    return xhttp;
}

I have a form where I fill in some user data, then when accepting it sends me to the controller where I have to create a candidate object with the received data and then send that object to a function in the model so that it does an insert. This is the form:

    <!DOCTYPE html >
<head>
<meta charset="utf-8">
   <link href=\"miestilo.css\" rel=\"stylesheet\" type=\"text/css\" />

<title>Formulario para añadir datos </title> 
</head> 
<body> 
<center><h2>Formulario de altas<h2></center> 

<form name="altas" method="POST" action="grabar.php"> 
<table bgcolor="#E9FFFF" align=center border=2> 

<td align="right">Escribe tu D.N.I.: </td> 
<td align="left"> <input type="text" name="dni" value="" size=8></td><tr> 
<td align="right">Nombre....: </td> 
<td align="left"> <input type="text" name="nombre" value="" size=20></td><tr> 
<td align="right">Apellidos...: </td> 
<td align="left"> <input type="text" name="apellidos" value="" size=15></td></tr> 
<tr> 
<td align="right">Sexo...:</td> 
<td align="left"> 
<input type="radio" name="sexo" value="m"  > Masculino 
<input type="radio" name="sexo" value="f" > Femenino 
</td>

</select> </tr><tr> 

       


<td align="right">Habla:<br> 
(<i>Si habla varios seleccionarlos<br> 
pulsando con el mouse encima de <br> 
cada uno de ellos con la tecla<br> 
<b>Ctrl</b> presionada</i>)</td> 
<td align="left"> <SELECT MULTIPLE name="idiomas[]" SIZE=9> 

<?php
         foreach($arrayIdiomasPersonas as $idioma)
         {
            echo "<option value='".$idioma["id"]."'>".$idioma["nombre"]."</option>";
         }
         ?>

</select> 
</td><tr> 
    


<!--colocamos los botones de enviar y borrar //--> 


<td align=center><input type=submit name="accion" value="Enviar"></td> 
<td align=center><input type=submit name="accion" value="Cancelar"></td> 
</table> </form>
</body> 
</html> 

And this is the function I have in the model:

public static function insertDatos($candidatoNuevo)
{
   //recibe un objeto candidato e inserta los datos en la tabla
}

And this is the Candidate class:

<?php

class Candidato {
    protected $dni;
    protected $nombre;
    protected $apellidos;
    protected $sexo;
    protected $idiomas;//array de idiomas
      
    public function getDni() {return $this->dni; }
    public function getNombre() {return $this->nombre;}
    public function getApellidos() {return $this->apellidos;}
    public function getSexo() {return $this->sexo;}
    public function getIdiomas() {return $this->idiomas;}

    public function __construct($pdni,$pnombre,$papellidos,$psexo,$pidiomas) 
    {
        $this->dni = $pdni;
        $this->nombre = $pnombre;
        $this->apellidos=$papellidos;
        $this->sexo=$psexo;
        $this->idiomas=$pidiomas;                       
    }
    

}

?>

I have tried several things in the controller, from creating some variables there for each of the attributes through $_POST and sending them to the function through an sql string and even creating a function that receives the parameters, but as the function asks me for a candidate object , I understand that you have to create a new Candidate in the controller. If the function asked me for the 5 attributes, I would understand how to do it, but asking me for an already created object is what shocks me. Let's see if you can help me and I can get to understand how it works, thank you very much.

Edit: I have gotten the function to insert, but it inserts empty data:

insert function:

    public static function insertDatos($candidatoNuevo)
{

$sql5="INSERT INTO candidatos (dni, nombre, apellidos, sexo) 
 VALUES ('".$pdni."','".$pnombre."','".$papellidos."','".$psexo."')";
    return ($resultado=self::ejecutaConsultaAccion($sql5));

}

Save.php in the controller:

    <?php
require_once("../model/base.php");
//si inserta
//header ("Location:index.php");
    
$pdni= $_POST["dni"];
$pnombre = $_POST["nombre"];
$papellidos = $_POST["apellidos"];
$psexo = $_POST["sexo"];
$pidiomas = $_POST["idiomas"];

$existe=ClaseBase::compruebaCandidato($pdni);
    if (!$existe)
    {
        $nuevoUser = new Candidato($pdni,$pnombre,$papellidos,$psexo,$pidiomas);
        //print_r($nuevoUser);
        ClaseBase::insertDatos($nuevoUser);

        echo "<p>El candidato ha sido insertado 
                 correctamente</p>";
    }
    else
        echo "<p>El dni .$pdni ya estaba registrado, inserta 
                 otro.</p>";


//si no
//require_once("../View/resultado.php")
?>

Doing a print_r of $newUser:

Candidato Object ( [dni:protected] => 1111 [nombre:protected] => juan [apellidos:protected] => sanchez [sexo:protected] => m [idiomas:protected] => Array ( [0] => 1 ) )

And these are the errors:

Notice: Undefined variable: pdni in C:\xampp\htdocs\recuPHP\MVC\Final\Model\base.php on line 104

Notice: Undefined variable: pnombre in C:\xampp\htdocs\recuPHP\MVC\Final\Model\base.php on line 105

Notice: Undefined variable: papellidos in C:\xampp\htdocs\recuPHP\MVC\Final\Model\base.php on line 105

Notice: Undefined variable: psexo in C:\xampp\htdocs\recuPHP\MVC\Final\Model\base.php on line 105

For some unknown reason, the variables do not reach the model and I get an error in the insert statement.

I have two functions where I make two queries and what I want is to join both queries but I can't find a way to do it.

I have a getLanguages() function:

    public static function obtieneIdiomas()
{

$sql= "SELECT nombre as idiomas FROM idiomas";
$resultado=self::ejecutaConsulta($sql);
$arrayIdiomas=array();

while ($fila=$resultado->fetch(PDO::FETCH_ASSOC))
             {
                  $arrayIdiomas[]= $fila["idiomas"];                               
             } 
        
         return $arrayIdiomas; 
}

And a getCandidate() function:

public static function obtieneCandidatos()

{    
$sql2= "SELECT distinct c.dni, c.nombre, c.apellidos, c.sexo FROM candidatos c
inner join idiomas_encuesta i on c.dni=i.dni_candidato
inner join idiomas id on i.id_idioma=id.id;";

$resultado2=self::ejecutaConsulta($sql2);
$arrayCandidatos=array();

while ($fila=$resultado2->fetch(PDO::FETCH_ASSOC))
             {
                  $arrayCandidatos[]=new Candidato ($fila);
             }
        
         return $arrayCandidatos; 
}

In the controller I call these two functions to build the arrays:

$arrayDatosPersonas=ClaseBase::obtieneCandidatos();
$arrayIdiomasPersonas=ClaseBase::obtieneIdiomas();

And this is as far as I've been able to get:

This is the query that should output:

But without repeating the personal names, that is, in Miguel's Language field, French and Chinese must appear.

I've thought that maybe we should use the getCandidates function the getLanguages ​​function but I have no idea how to do it. There is a table that shares the key between candidates and languages ​​and I imagine that they will have to be compared in some way.

Let's see if you can give me a hand thanks.

PS: Thinking about it, maybe it's not necessary to use the getLanguages() function, maybe you could do two selects in getCandidate()?

I have a little problem with the constructor of my project and it is that after making a query to the server and returning the number of variables that the constructor asks me for, it tells me that it only sends 1 and that 5 are expected.

Mistake:

Fatal error: Uncaught ArgumentCountError: Too few arguments to function Candidato::__construct(), 1 passed in C:\xampp\htdocs\recuPHP\MVC\Final\Model\base.php on line 65 and exactly 5 expected in C:\xampp\htdocs\recuPHP\MVC\Final\Model\candidato.php:20 Stack trace: #0 C:\xampp\htdocs\recuPHP\MVC\Final\Model\base.php(65): Candidato->__construct(Array) #1 C:\xampp\htdocs\recuPHP\MVC\Final\Controller\index.php(5): ClaseExamen::obtieneCandidatos() #2 {main} thrown in C:\xampp\htdocs\recuPHP\MVC\Final\Model\candidato.php on line 20

I have the Candidate class:

 class Candidato {
    protected $dni;
    protected $nombre;
    protected $apellidos;
    protected $sexo;
    protected $idiomas; //array de idiomas
      
    public function getDni() {return $this->dni; }
    public function getNombre() {return $this->nombre;}
    public function getApellidos() {return $this->apellidos;}
    public function getSexo() {return $this->sexo;}
    public function getIdiomas() {return $this->idiomas;}
    
    public function __construct($pdni,$pnombre,$papellidos,$psexo,$pidiomas) {
        $this->dni = $pdni;
        $this->nombre = $pnombre;
        $this->apellidos=$papellidos;
        $this->sexo=$psexo;
        $this->idiomas=$pidiomas;

And I have the function that performs the query:

    public static function obtieneCandidatos()
{
$sql2= "SELECT c.dni, c.nombre, c.apellidos, c.sexo, id.nombre FROM candidatos c
inner join idiomas_encuesta i on c.dni=i.dni_candidato
inner join idiomas id on i.id_idioma=id.id;";

$resultado2=self::ejecutaConsulta($sql2);
$arrayCandidatos=array();

while ($fila=$resultado2->fetch(PDO::FETCH_ASSOC))
             {
                  $arrayCandidatos[]=new Candidato ($fila);
             }
        
         return $arrayCandidatos; 


}

When I want to call the function from the controller:

$arrayDatosPersonas=ClaseBase::obtieneCandidatos();

It gives me the error, in theory I am sending the 5 attributes but it seems that it does not detect them. In the language table there are several languages ​​and I don't know if that is the problem. I hope you can help me thanks.

I have a little doubt with poo in php and it is that I have 1 class with a repaint() method (to apply a new color to a car) but I want to use that method for another vehicle class and I don't know how to put it, I have tried some things but it doesn't come out.

       class vehiculo
   {
     private $color;
     private $peso;
    
     public function __construct($color, $peso)
     {
        $this->color=$color;
        $this->peso=$peso;
     }
   }

    class coche extends vehiculo
    {
        private $numero_puertas;
        
     public static function repintar($color)
     {
        $this->color = $color;
     }
   }
$vehiculo1= new Vehiculo("Verde", 1500);
$vehiculo1->repintar("Negro"); //error

Thanks. Updated class name.

I have a small program that makes a query to the sql server from which it extracts data, but I can't get it to show me each corresponding data.

The output I get right now is this:

Id Student, Name and phone is fine but the name of the course is the one that I can't make it come out right, the correct output would be:

1. 1, VICTOR, 2212134, FIRST THAT
2. 2, PACO, 984747321, FIRST THAT
3. 3, PEPE, 964321345, SECOND THAT

On the one hand I have a dataStudents.java:

   public class datosAlumnos 
{
Connection miconexion;
String cadsql;

    public datosAlumnos() {
         miconexion=MySQL_Util.Conectar("localhost","root","", "ciclosfp");             
    }
    
    public ResultSet getResultado() {
        
       cadsql ="select a.ID, a.NOMBRE, a.TELEFONO, cursos.NOMBRE from alumnos a, cursos "
               + "where cursos.id = a.CURSO;";
        
        ResultSet rset=
                 MySQL_Util.Sel_Consulta(miconexion, cadsql);
        return rset;
    }
}

And a dataCourses.java:

    public class datosCursos 
{
Connection miconexion;
String cadsql;
private ResultSet rsIDAlum;
private ResultSet rsFCurso;

    public datosCursos() {
         miconexion=MySQL_Util.Conectar("localhost","root","", "ciclosfp");             
    }

       public ResultSet getRsIDAlum() {
        rsIDAlum=MySQL_Util.Sel_Consulta(miconexion, "select * from alumnos");
        return rsIDAlum;
    }

    public void setRsIDAlum(ResultSet rsIDAlum) {
        this.rsIDAlum = rsIDAlum;
    }
    
    
    public ResultSet getRsFCursos() {
        try
        {
        String cadsql2 ="select cursos.nombre from cursos inner join alumnos on cursos.ID=alumnos.ID where alumnos.ID="+rsIDAlum.getString("ID");
            rsFCurso=(MySQL_Util.Sel_Consulta(miconexion, cadsql2));
       
        }
        catch (Exception e)
        {
            rsFCurso=null;
        }
        return rsFCurso;
    }

    public void setRsFCursos(ResultSet rsFCurso) {
        this.rsFCurso = rsFCurso;
    }

}

and the index to display:

    <h1><h:outputText value="Datos de los alumnos:"/></h1>
          
            <h:dataTable border="1" value="#{datosAlumnos.resultado}"
                         var="fila">
                <h:column>
                    <f:facet name="header">
                        <h:outputText value="Id Alumno"/>
                    </f:facet>
                    <h:outputText value="#{fila.ID}"/>
                </h:column>  
                <h:column>
                    <f:facet name="header">
                        <h:outputText value="Nombre Alumno"/>
                    </f:facet>
                    <h:outputText value="#{fila.NOMBRE}"/>
                </h:column>  
                <h:column>
                    <f:facet name="header">
                        <h:outputText value="Telefono"/>
                    </f:facet>
                    <h:outputText value="#{fila.TELEFONO}"/>
                </h:column> 
                     <h:column>
                    <f:facet name="header" >
                        <h:outputText value="Nombre Curso"/>
                    </f:facet>
                    <h:dataTable value="#{datosCursos.rsFCursos}" var="forma" > 
                        <h:column>
                            <h:outputText value="#{forma.nombre}"/>
                        </h:column>                   
                    </h:dataTable>                            
                </h:column>
            </h:dataTable>
        </body>
    </html>
</f:view>

The thing is that the query of the courses shows the result in the 3 tables of the students and I have tried everything and I cannot make it work. I can't find information on whether aliases can be used in jsp for the tables, since there are two tables that have the same name (name[students] and name[courses]) I can't just put row.name because it takes the name of the students twice.

Update: I have modified the DataCurso.java file since I think this is the correct path but now in Course Name it does not show me any data.

I am trying to access the sql server to display "News" in an XML table using ajax, javascript and php. The problem is being given to me in the getNoticias.php file, telling me that it cannot read or that the "noti" tag is a null value.

getNews.php:

  <?php

// Configuración BASE DE DATOS MYSQL
$servidor  = "localhost";
$basedatos = "senderismo";
$usuario   = "root";
$password  = "";

// Creamos la conexión al servidor.
$conexion = mysqli_connect($servidor, $usuario, $password,$basedatos) or die(mysqli_error($conexion));
mysqli_query($conexion,"utf8");

// Consulta SQL para obtener los datos de los centros.
$sql = "SELECT * FROM noticias";
$resultados = mysqli_query($conexion,$sql);

$XML ='<?xml version="1.0" encoding="UTF-8"?>';
$XML .='<datos>';

while ($fila = mysqli_fetch_array($resultados)) {
    $XML .='<noti>';
        $XML .='<idnot>'.$fila["idnoticia"].'</idnot>';
        $XML .='<tit>'.$fila["titulo"].'</tit>';
        $XML .='<descri>'.$fila["descripcion"].'</descri>';
        $XML .='<aut>'.$fila["autor"].'</aut>';
        $XML .='<fech>'.$fila["fecha"].'</fech>';
        $XML .='<image>'.$fila["imagen"].'</image>';
    $XML .='</noti>';
}

$XML .='</datos>';

// Cabecera de respuesta indicando que el contenido de la respuesta es XML
header("Content-Type: text/xml");
// Para que el navegador no haga cache de los datos devueltos por la página PHP.
header('Cache-Control: no-cache, must-revalidate');
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');

echo $XML;

mysqli_close($conexion);
?>

Index.js

    function pedirListado() 
{
            // Instanciar objeto Ajax
            var oAjax = instanciarXHR();

            //Configurar la llamada --> Asincrono por defecto
            oAjax.open("GET", "php/getNoticias.php");

            //Asociar manejador de evento de la respuesta
            oAjax.addEventListener("readystatechange", procesoRespuestalistadoNoticiasXML, false);

            //Hacer la llamada
            oAjax.send(null);
            
}
    
        function procesoRespuestalistadoNoticiasXML() {
            var oAjax = this;

            // Proceso la respuesta cuando llega
            if (oAjax.readyState == 4 && oAjax.status == 200) {
                console.log(oAjax.responseText);
                var oXML = oAjax.responseXML; // Recojo un objeto XML

                construirListado(oXML);
            }
        }
        
            function construirListado(oXML) {
            // Crear tabla
            var oTabla = document.createElement("table");
            oTabla.border = "1";
            var oTHead = oTabla.createTHead();
            var oFila = oTHead.insertRow(-1);
            var oTH = document.createElement("TH");
            oTH.textContent = "idnoti";
            oFila.appendChild(oTH);
            
            oTH = document.createElement("TH");
            oTH.textContent = "tit";
            oFila.appendChild(oTH);

            oTH = document.createElement("TH");
            oTH.textContent = "descri";
            oFila.appendChild(oTH);

            oTH = document.createElement("TH");
            oTH.textContent = "aut";
            oFila.appendChild(oTH);
            
            oTH = document.createElement("TH");
            oTH.textContent = "fech";
            oFila.appendChild(oTH);
            
            oTH = document.createElement("TH");
            oTH.textContent = "image";
            oFila.appendChild(oTH);


            var oTBody = oTabla.createTBody();


            var oNoticias = oXML.querySelectorAll("noti");
            for (var i = 0; i < oNoticias.length; i++) {
                oFila = oTBody.insertRow(-1);

                var oCelda = oFila.insertCell(-1);
                oCelda.textContent = oNoticias[i].querySelector("idnoti").textContent;

                oCelda = oFila.insertCell(-1);
                oCelda.textContent = (oNoticias[i].querySelector("tit").textContent);

                oCelda = oFila.insertCell(-1);
                oCelda.textContent = (oNoticias[i].querySelector("descri").textContent);
            
                oCelda = oFila.insertCell(-1);
                oCelda.textContent = (oNoticias[i].querySelector("aut").textContent);

                oCelda = oFila.insertCell(-1);
                oCelda.textContent = (oNoticias[i].querySelector("fech").textContent);
                
                oCelda = oFila.insertCell(-1);
                oCelda.textContent = (oNoticias[i].querySelector("image").textContent);

            }
            document.querySelector("#listado").innerHTML = "";
            document.querySelector("#listado").appendChild(oTabla);
        }
        
        
        function instanciarXHR() {
            var xhttp = null;

            if (window.XMLHttpRequest) {
                xhttp = new XMLHttpRequest();
            } else // code for IE5 and IE6
            {
                xhttp = new ActiveXObject("Microsoft.XMLHTTP");
            }

            return xhttp;
        }

Apparently I see that the code is correct, in the database I have 6 tables that are the ones that I specify in the php code and then in the index.js I create 6 tables for each of the elements.

But when I press the button it tells me the following error:

        index.js:80 Uncaught TypeError: Cannot read property 'querySelectorAll' of null
at construirListado (index.js:80)
at XMLHttpRequest.procesoRespuestalistadoNoticiasXML (index.js:42)

The names of the tables are fine, in lowercase, the database is well defined and I don't know where to touch it anymore. Let's see if you can help me, thanks.

The data is sent as it appears on the console:

I am trying to save the output that this code shows me on the screen in a .txt keeping the format "name, average grade, approved, failed". Line example in the .txt: Ana,7,5,0 (only the values, the table no.)

    <?php
$notas = array(
'Miguel' => array('Matematicas'=>5, 'Tecnologia'=>5, 'Historia'=>6, 'Ingles'=>8),
'Ana' => array('Matematicas'=>7, 'Ingles'=>8, 'Lengua'=>6,  'Fisica'=>9, 'Historia'=>5),
'Luis' => array('Matematicas'=>4, 'Tecnologia'=>4, 'Lengua'=>5,  'Fisica'=>4, 'Historia'=>7),
'Maria' => array('Matematicas'=>6, 'Tecnologia'=>5, 'Historia'=>6, 'Ingles'=>4),
'Antonio' => array('Matematicas'=>4, 'Tecnologia'=>5, 'Lengua'=>5,  'Fisica'=>4, 'Historia'=>4, 'Ingles'=>6),
'Raul' => array('Matematicas'=>4, 'Tecnologia'=>5, 'Lengua'=>7,  'Fisica'=>5, 'Historia'=>6, 'Ingles'=>8)
);

$arrayFinal=array();

ksort($notas);
echo "<table border='1'><tr><th>Nombre del alumno</th><th>Nota Media</th><th>Aprobados</th><th>Suspensos</th></tr>";
foreach($notas as $nombre=>$array)
{
    
    $aprobados=0;
    $suspensos=0;
    $acumuladorNotas=0;
    $contadorNotas=0;
    $notaMedia=0;
    
    
    
    foreach($array as $asig=>$nota)
    {
    
        $contadorNotas++;
        $acumuladorNotas+=$nota;
        $notaMedia=$acumuladorNotas/$contadorNotas;         
    
        if($nota>=5)
        {
            $aprobados++;
        }
        else
        {
            $suspensos++;
        }
        
        
        $arrayFinal[$nombre]['Media'] = $notaMedia;
        $arrayFinal[$nombre]['aprobados'] = $aprobados;
        $arrayFinal[$nombre]['suspensos'] = $suspensos;
        

        
    }   
        
        echo "<tr><td>".$nombre."</td><td>".number_format($notaMedia,2)."</td><td>".$aprobados."</td><td>".$suspensos."</td></tr>";
        
}
echo "</table>";
//print_r ($arrayFinal);
ksort($arrayFinal);
$ficheroSalida=fopen("salida.txt","a");
foreach($arrayFinal as $nombres=>$array)
{   
    foreach ($array as $indice => $valor)
    {       
        fwrite($ficheroSalida,$nombres.",".$valor.PHP_EOL);
    }
}
fclose($ficheroSalida);





?>

I have tried several things like putting: $arrayFinal["approved"]=$approved; but it only saves it for the first student and in the .txt it doesn't save it, keeping the format. I hope you can help me, thank you.

Screen output:

.txt:

Update: Now it saves all the data fine, but when it creates the .txt file it repeats the values ​​(student name) and puts them one below the other:

I have a two-dimensional array with which I want to create a drop-down select in which, when choosing one of the different options, it returns a table with the data given by the chosen option, like this:

Code:

    <?php

$arrayResultados =  array 
         ('Libre'=>  array('No Presentados'=>12,'Suspenso'=>10,'Aprobado'=>6,'Notable'=>3,'Sobresaliente'=>1),
          'On-line'=> array('Suspenso'=>26,'Aprobado'=>25,'Notable'=>22,'Sobresaliente'=>27),
          'Presencial'=>array  ('Suspenso'=>30,'Aprobado'=>25,'Notable'=>37,'Sobresaliente'=>28,'Matrícula de Honor'=>9)
          );
?>

<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
</head>
<body>

<form method="POST">
        <select name="desplegable">
        <option value="todas" selected="selected">Todas</option>
        
<?php
    foreach ($arrayResultados as $indice => $valor)
    {
        echo "<option value='".$indice."'>".$indice."</option>";
    }
?>      
</select>
<input type="submit" name="envio" value="Aceptar">
    </form>
    

<?php
        if(isset($_POST["envio"]))
        {
            $listaAlum=[];
            foreach ($arrayResultados as $indice => $valor)
            {
                foreach ($valor as $detalles => $numero)
                {               
                        if(isset($indice[$_POST["desplegable"]]))
                        {   
                            $listaAlum[$detalles] = $numero;
                        }
                }       
                    
                        
            }
            
            echo "<h3>Seleccion: ".$_POST["desplegable"]."</h3>";
            echo "<pre>";
            print_r ($listaAlum);
            echo "</pre>";
        }




?>  
</body>
</html>

This part of code: "if(isset($indice[$_POST["desplegable"]]))" doesn't work for me and if I don't remove it from the code it doesn't save anything in the array.

I can't get it to show me all the values ​​when I choose the "all" option, I get several errors (Undefined index:) and it adds the numerical values ​​more times than count. What I do in the following code is an if where if I choose the "all" option, add the sum of the numeric values ​​to the array $listaAlum.

if($_POST["desplegable"]=="todas") //cuando elija la opcion todas
                        {
                            foreach ($arrayResultados as $indice => $valor)
                            {
                                foreach ($valor as $detalles => $numero)
                                {   
                                    $listaAlum[$detalles] = $numero;
                                }
                            }
                        }

  

How should I put it?

When I give all of them this is the result it gives me, I don't understand why it gives me that result (they are the values ​​of the last value of the array) nor why it doesn't save the value "Not presented".

I am trying to create a loop that displays 100 numbers grouped by 5 with a tab between them like this:

I have done this code but I can't get it to work:

    <?php

$max_num = 101;
$contador =0;
for ($x=1;$x<$max_num;$x++) 
{
    $contador++;
 
    if (fmod($contador, 5) == 1)
    {  
    echo "<br>";    
    }
   echo $x. "    ";
}

?>

Thanks.

Edit. With this in the if the numbers work for me: (fmod($counter, 5) == 1). Updated, I'm missing tab detection, \t doesn't detect it.

I have managed to do it but I don't know if it is the most recommended option:

echo $x."&nbsp"."&nbsp"."&nbsp"."&nbsp"."&nbsp";

I have an array with letters of the alphabet and the idea is that through a form where a letter and number are typed, the chosen letter is moved the number of times it is inserted.

This is the php code:

 <?php
$letras = array
(
0 => "a",
1 => "b",
2 => "c",
3 => "d",
4 => "e",
5 => "f",
6 => "g",
7 => "h",
8 => "i",
9 => "j",
10 => "k",
11 => "l",
12 => "m",
13 => "n",
14 => "ñ",
15 => "o",
16 => "p",
17 => "q",
18 => "r",
19 => "s",
20 => "t",
21 => "u",
22 => "v",
23 => "w",
24 => "x",
25 => "y",
26 => "z"
);

$letra = $_POST['letra'];
$numero = $_POST['numero'];

//echo $letra;
//echo $numero;
$var=array_search($letra,$letras);

print_r ($var); 

foreach ($letras as $clave => $valor) 
{
    if ($letra == $valor)
    {
        echo "encontrado";
        
    }
}

echo "<br>";
echo "<br>";
print_r ($letras);
?>

The html is simply to insert the letter and number.

It works like this: Enter letter: a Enter number: 3 this results in: d, since a has moved 3 times.

As it is now when I enter a letter it locates the position but I don't know how to do it so that when I enter the number, it increases the position and shows me the new position. Thanks.