CODEWITHSUNDEEP
phphtmlxampp
Jhon Papi Namahh
Jhon Papi Namahh

Reputation: 23

does not identify the id in the table

I am making the modification for the query and already add and everything but in modifying it does not work with 'id' that I put after putting the address of the modification page

this is the table 

    <!DOCTYPE html>
    <html>
    <head>
<title> TABLA </title>
    </head>
    <body>
         <center>
      <table bgcolor="#85C1E9" border="3">
        <thead>
            <tr>
              <th colspan="1"><a href="guarda.php">Nuevo</a></th>
              <th colspan="5">Lista de usuarios</th>
            </tr>
        </thead>    
        <tbody>
        <tr>

                <td>Id</td>
                <td>Nombre</td>
                <td>Apellido</td>
                <td>Correo</td>
                <td colspan="2"><center>Operaciones</center></td>

            </tr>
            <?php
            include("conexiones.php");
            $query="SELECT * FROM usuarios";
            $resultado=$conexion->query($query);
            while ($row=$resultado->fetch_assoc()) {

            ?>


            <tr>
                  <td><?php echo $row['id'];?></td>
                  <td><?php echo $row['nombre'];?></td>
                  <td><?php echo $row['apellido'];?></td>
                  <td><?php echo $row['correo'];?></td>
                  <td><a href="modificar.php?id=<?php echo $row['id']; 
             ?>">Modificar</a></td>
                  <td><a href="eliminar.php?id=<?php echo $row['id']; ? 
             >">Eliminar</a></td>                
             </tr>

             <?php 

             }
             ?>
         </tbody>
         </table>
             </center>
             </body>

             </html>

here the modify page

    <!DOCTYPE html>
    <html>
    <head>
<title>Guardar</title>
    </head>
    <body>
    <center>
    <form action="guardar.php" method="POST" name="guardar"><br><br><br>

        <?php

           $id=$_REQUEST['id'];

            include("conexiones.php");
            $query="SELECT * FROM usuarios";
            $resultado=$conexion->query($query);
            $row=$resultado->fetch_assoc();

            ?>

      <input type="text" required="" name="nombre" placeholder="Nombre..." 
      value="<?php echo $row['nombre'];?>"><br><br>
      <input type="text" required="" name="apellido" 
      placeholder="Apellido..." value="<?php echo $row['apellido'];?>"> 
      <br><br>
       <input type="text" required="" name="correo" 
       placeholder="Correo..." value="<?php echo $row['correo'];?>"><br> 
       <br>
       <input type="submit" value="Aceptar">


      </form>
      </center>
      </body>
      </html>

the error is that when I press modify in the query I get like this:

      http://localhost/modificar.php?id=%3C?echo%20$row[%27id%27];?%3E

and the way it should go (for example) is like this:

      http://localhost/modificar.php?id=1

Upvotes: 1

Views: 33

Answers (1)

Serghei Leonenco
Serghei Leonenco

Reputation: 3507

Try this:

<?php
include("conexiones.php");
$query="SELECT * FROM usuarios";
$resultado=$conexion->query($query);
?>
<?php while ($row=$resultado->fetch_assoc()): ?>


            <tr>
                  <td><?= $row['id'] ?></td>
                  <td><?= $row['nombre'] ?></td>
                  <td><?= $row['apellido'] ?></td>
                  <td><?= $row['correo'] ?></td>
                  <td><a href="modificar.php?id=<?= $row['id'] ?>">
                      Modificar</a></td>
                  <td><a href="eliminar.php?id=<?= $row['id'] ?>"> 
                      Eliminar</a></td>                
             </tr>
<?php endwhile; ?>

hope it helps.

Upvotes: 1

Related Questions