Luis Jair Juarez Sanchez's questions

I am making a registration form and in one part I request the nationality of the person, which is selected from a table in SQL

    <p style="text-align:center;"><label><select id="lista" name="Nacionalidad">
                <?php
                include 'conexion.php';
                $consulta = "SELECT CveNacion,Nacionalidad FROM catnacion";
                $resultado = $mysqli->query($consulta);
                ?>
                <form action="" method="post" class="form-login">
                    <?php foreach ($resultado as  $opciones) : ?>
                        <option value="<?php echo $opciones['Nacionalidad'] ?>">
                            <?php echo $opciones['CveNacion'].' '.substr($opciones['Nacionalidad'],0,15)  ?>
                        </option>
                    <?php endforeach ?>
            </select></label></p>

The problem is that when performing the $consulta = "SELECT CveNacion,Nacionalidad FROM catnacion";it is displayed as follows:

I would like the first value displayed to be Mexico:

As follows:

I have tried to carry out an ORDER BY starting from the M like this SELECT CveNacion,Nacionalidad FROM catnacion ORDER BY Nacionalidad>"M", but it does not do it as I want, is there any way that from the query it shows me that result first or I can do it directly in the form, thank you very much in advance

Hello everyone I am processing a txt file on the server using PHP

$file = fopen("archivos/llaves/keyusuario.txt", "w");
fwrite($file, 'Tu llave de usuario es: 651651651651651651');
fclose($file);

I am saving the txt in a folder on the server, now I want that txt to be downloaded in the client browser, I have tried the following using the absolute path:

   $rutaArchivo = __DIR__."archivos/llaves/keyusuario.txt";
    $NombreArchivo = basename($rutaArchivo);
    header('Content-Type: application/octet-stream');
    header("Content-Transfer-Encoding: Binary");
    header("Content-disposition: attachment; filename=$nombreArchivo");
    # Leer el archivo y sacarlo al navegador
    readfile($rutaArchivo);

However, at the end of the processing the file is successfully generated in the server folder, but the download is not carried out, I would greatly appreciate your help, thank you very much in advance

Hello, I am generating the reading of a txt file which has a structure like the following

Cabecera
122121215656565
686846846846846
489498498498498
19894984949444
PiePagina

I am interested in recovering line 2122121215656565

I have tried the following:

//Abriendo el archivo
    $arc = fopen('archivos/' . $nombre, "r");
//Obteniendo una linea completa del archivo txt
    $linea = fgets($arc);
//Cerrando el archivo
    fclose($arc);

With this code it returns me Cabecera, how could I tell PHP to only retrieve line 2, thank you very much in advance and I hope I have been clear

I am sending a variable by GET method

while ($row = $resultado->fetch_assoc()) {
    $html .= '<tr>';
    //$html .= '<td>' . $row['Incrementable'] . '</td>';
    $html .= '<td>' . $row['CvePersonal'] . '</td>';
    $html .= '<td>' . $row['CtaBanco'] . '</td>';
    $html .= '<td>' . $row['CveContrato'] . '</td>';
    $html .= '<td>' . $row['TipoEmpleado'] . '</td>';
    $html .= '<td>' . $row['Inicio'] . '</td>';
    $html .= '<td>' . $row['Fin'] . '</td>';
    $html .= '<td>' . $row['UltDia'] . '</td>';
    $html .= '<td>' . $row['CodCategoria'] . '</td>';
    $html .= '<td>' . $row['PrimaVac'] . '</td>';
    $html .= '<td>' . $row['HrsMen'] . '</td>';
    $html .= '<td>' . $row['CostoHra'] . '</td>';

    $clave = $row['Incrementable'];

    $html .= '<td>
    <a href="depurar.php?Incrementable=$clave"><img src="img/expedientes/editar.png" height="40" width="40" /></a>
    </td>';

    $html .= '<td><img src="img/expedientes/eliminar.png" height="40" width="40" title="Eliminar"></td>';
    $html .= '</td>';
}

I need to send the key variable, I know that to send by GET method it is with the syntax that I wrote, the problem is that if I use ''for the variable $claveit sends me a syntax error, as it is written only a text string arrives$clave

I hope I have been clear with my question, first of all, thank you very much

Greetings, I am generating a report with FPDF in PHP

//Solicitando la conexion con la BD
require 'conexion.php';
//Efectuando la consulta de las vista
$consulta = "SELECT * FROM diferencias ORDER BY falla";
//Almaceando el resultado de la consulta en una variable
$resultado = $mysqli->query($consulta);

// Creación del objeto de la clase heredada
$pdf = new PDF('L','mm','A4');//Indicando formato horizontal del reporte
$pdf->AliasNbPages();
$pdf->AddPage();
$pdf->SetFont('Helvetica', '', 8);

//Encabezados de la tabla
$pdf->SetFont('Helvetica', 'B', 8);//Colocando letras en negritas
$pdf->Cell(28, 10, 'Service Tag', 1, 0, 'C', 0);
$pdf->Cell(50, 10, 'Usuario', 1, 0, 'C', 0);
$pdf->Cell(65, 10, 'Diferencia 1', 1, 0, 'C', 0);
$pdf->Cell(65, 10, 'Diferencia 2', 1, 0, 'C', 0);
$pdf->Cell(65, 10, 'Falla', 1, 1, 'C', 0);
$pdf->SetFont('Helvetica', '', 8);//Devolviendo valores de letra

My specific problem is here, some column data fails are too wide, I would like to know if there is a way to adjust the letters to the assigned size of the cell

//Ciclo para recorrer la tabla e insertar registros en la tabla
$a=0;
while ($row = $resultado->fetch_assoc()) {
    //Ancho alto,borde,salto de linea justificacion relleno
    //$pdf->Cell(15,10, utf8_decode($row['consecutivo']), 1, 0, 'C', 0);
    $pdf->Cell(28,10, utf8_decode($row['servicetag']), 1, 0, 'C', 0);
    $pdf->Cell(50,10, utf8_decode($row['usuario']), 1, 0, 'C', 0);
    $pdf->Cell(65,10, utf8_decode($row['dif1']), 1, 0, 'C', 0);
    $pdf->Cell(65,10, utf8_decode($row['dif2']), 1, 0, 'C', 0);
    $pdf->Cell(65,10, utf8_decode($row['falla']), 1, 1, 'C', 0);
    $a=$a+1;

}

Since when you made the report it looks like this

Hello, I have two tables in MySQL inventario1and inventario2both tables in essence should be identical, however, I want to see if there are differences between their records, but I want to do it from MySQL with some query

I have tried this, but it is not the result I expect

SELECT inventario.consecutivo FROM inventario WHERE inventario.consecutivo NOT IN (SELECT DISTINCT inventario2.consecutivo from inventario2)

I would like you to tell me the records where there are differences

Beforehand thank you very much

Hello, I am generating an Excel with PHPSpreadSheet but I cannot get the cell to be generated with vertical borders

$bordes = [
  'borders' => array(
    'outline' => array(
      'borderStyle' => \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN,
      'color' => array('argb' => '000000'),
    ),
  ),
];

When I generate it this way the format it applies to the cell is this

When I would like only the verticals to be painted, thanks in advance

I am doing a function in MySQL however when I try to record it it does not allow me and the error comes out within the following IF.

   /* Verifica que el empleado esté excento */
       IF SELECT Count(*) FROM ExcentosDedApo 
        WHERE(CvePersonal=CvePersonal)AND(Clave=CveDedApo)>0
        THEN
        RETURN 0;
        END IF;

The error message that comes out is

MySQL ha dicho: #1064 - Algo está equivocado en su sintax cerca 'SELECT Count(*) FROM ExcentosDedApo WHERE(CvePersonal=CvePersonal)AND(Clave=C...' en la linea 7

Hello, I am trying to extract information from a txt file with PHP, for example:

Line 1: Luis Juarez

Line 2: Paco Mendoza

Line 3: Pepe Suarez

They helped me before with this sentence

$arc = fopen('archivos/'.$nombre,"r");
while(! feof($arc))  {
    $Nombre = substr(fgets($arc), 0, 4);
    $Apellido = substr(fgets($arc), 6, 10);
      echo $Nombre;
      echo "<brs>";
      echo $Apellido;
      echo "<br>";
}
fclose($arc);

The problem is that every time it is executed fgets()it sends me to the next line and prints Luis Mendoza on the screen when Luis Juarez should print, could someone help me with the solution Thank you very much in advance

Hello, I need to read a txt with PHP line by line obtaining from each line text in specific positions, for example:

Linea 1: Luis Juarez

Linea 2: Paco Mendoza

Linea 3: Pepe Gonzales

I only want to extract the name that is in the first 4 positions Luis would be from position 0 to 3, the same would be with the other two, how do I make it go through the entire file and only show the positions that it requires.

This is the code that I have done, but it only gives me results with line 1, it does not go through the entire content of the file, I would greatly appreciate your collaboration, thanks

<?php 
//Llamar al arcivo
$nombre=$_FILES['archivo']['name'];
$guardado=$_FILES['archivo']['tmp_name'];

if (!file_exists('archivos')) {
    mkdir('archivos',0777,true);
    if (file_exists('archivos')) {
        if(move_uploaded_file($guardado, 'archivos/'.$nombre)){
            echo "";
        }else{
            echo "Ocurrio un error con la carga del archivo";
        }
    }
}else{
    if(move_uploaded_file($guardado, 'archivos/'.$nombre)){
    }else{
        echo "Ocurrio un error con la carga del archivo";
    }
}

// Abrir el archivo en modo de sólo lectura:
$arc = fopen('archivos/'.$nombre,"r");

// Recorremos el archivo mostando el contenido de cada línea:
echo file_get_contents('archivos/'.$nombre,null,null,2,18);

fclose($arc);
?>