How to get the value of the table calling from php?

Question

How to get the value of the table calling from php?

Navigation

#1 by (1 votes)

0

I have a problem with the following code:

<table border=7 ALIGN=CENTER width="70%" bgcolor=#ffffff>

<form role="form" name="registro" enctype="multipart/form-data" action="vehi-consul.php" method="post"> 

    <TR ALIGN=CENTER> 
        <th><label for="descve">Selecci&oacute;n por Nombre: </label></th>
<?php
        $result = $mysqli->query($query);

?>
<td><select>    
    <?php    
    while ( $row = $result->fetch_array() )    
    {   
        ?>  

        <option value=" <?php $row['descve']; ?> " selected>
        <?php echo $row['descve']; ?>
        </option>

        <?php
    }  
    ?> 

</td>

<TD><input type="submit" value="Aceptar"></TD>
</form>
</TR>
</table>

Annex the file vehi-consul.php

<?php

    require('conexion.php');

    $vclave = $_POST['vclave'];

    $query="SELECT vclave, descve, tipove, placasve, anoplacasve, captank, cambioaceite, afinacionve, segurove, vensegurove, fotove, usuario, km1, km2, km1r, km2r, diasrca, diasram, chofer FROM vehiculos WHERE descve LIKE '%$vclave%'";

    $resultado=$mysqli->query($query);

    $rows = $resultado->num_rows;
?> 
<?php  $conexion=mysqli_connect("localhost","xxxxxxxxxxxxxxxx","xxxxxxxxxx","xxxxxxxxxxxxxxxx") or
    die("Problemas con la conexión");

$registros=mysqli_query($conexion,"select vclave, descve, tipove, placasve, anoplacasve, captank, cambioaceite, afinacionve, segurove, vensegurove, fotove, usuario, km1, km2, km1r, km2r, diasrca, diasram, chofer
                        from vehiculos where vclave='$_POST[vclave]' or descve='$_POST[vclave]' or descve='$row[descve]' or descve='$_POST[descve]' ")  or
            die("Problemas en el select:".mysqli_error($conexion));

$cant=0;

while ($reg=mysqli_fetch_array($registros))
{

    echo '<br>Descve REQUEST:', $_REQUEST['descve'];
    echo '<br>Descve POST:', $_POST['descve'];
    echo '<br>Descve GET:', $_GET['descve'];
    echo '<br>Descve:', $descve; 
?>

<table border=7 ALIGN=CENTER width="100%" bgcolor=#ffffff>
<thead ALIGN=CENTER>

<tr>
    <td colspan="3" BGCOLOR="#F0F0F0"><b>   Clave   </b></td>
    <td colspan="4" BGCOLOR="#F0F0F0"><b>   Descripci&oacute;n   </b></td>
    <td colspan="2" BGCOLOR="#F0F0F0"><b>   Tipo de Veh&iacute;culo    </b></td>
    <td colspan="1" BGCOLOR="#F0F0F0"><b>   Chofer    </b></td>
    <td  colspan="1" bgcolor=#0080FF><a href="vehi-elim.php?vclave=<?php echo $reg['vclave'];?>" onclick="return confirm('&#191;Est&aacute;s seguro que deseas eliminar el registro?');">Eliminar</a></td> 
    <td  colspan="1" bgcolor=#0080FF><a href="vehi-mod.php?vclave=<?php echo $reg['vclave'];?>">Modificar</a></td>                  
</tr>

<tr>
    <td colspan="3"><?php echo $reg['vclave'];?></td>
    <td colspan="4"><?php echo $reg['descve'];?></td>
    <td colspan="2"><?php echo $reg['tipove'];?></td>

    <!--LINK PARA CHOFERES--> 
    <td colspan="1">

<form action="../chofconsul.php" method="post">
 <input type="hidden" name="chofer" value="<?php echo $reg['chofer']; ?>" />
 <input type="submit" value="<?php echo $reg['chofer']; ?>" />
</form>

</td>   

    <td colspan="2" rowspan="3" align=center><img width="250" height="200" src="php/images/<?php echo $reg['fotove'];?>" /></td>    
</tr>

<tr BGCOLOR="#F0F0F0">
    <td colspan="3"><b>   Placas   </b></td>
    <td><b>   A&ntilde;o de las placas  </b></td>
    <td><b>   Capacidad del Tanque  </b></td>
    <td colspan="2"><b>   Usuario   </b></td>
    <td colspan="2"><b>   Seguro del Vehiculo  </b></td>
    <td colspan="1"><b>   Vencimiento del seguro   </b></td>
</tr>

<tr>
    <td colspan="3"><?php echo $reg['placasve'];?></td>
    <td><?php echo $reg['anoplacasve'];?></td>
    <td><?php echo $reg['captank'];?></td>
    <td colspan="2"><?php echo $reg['usuario'];?></td>
    <td colspan="2"><?php echo $reg['segurove'];?></td>
    <td colspan="1"><?php
        //formato fecha americana
        $fecha5=$reg['vensegurove'];
        $fecha6=date("d-m-Y",strtotime($fecha5));
        //El nuevo valor de la variable: $fecha2="20-10-2008"
        echo $fecha6;
    ?></td> 
</tr>

</tr>

<tr BGCOLOR="#F0F0F0">
    <td colspan="4"><b>   Cambio de Aceite   </b></td>
    <td colspan="1"><b>   KM del &uacute;ltimo Cambio de Aceite   </b></td>
    <td colspan="2"><b>   Realizar Cambio de Aceite en:  </b></td>
    <td colspan="2"><b>   Afinaci&oacute;n Mayor  </b></td>
    <td><b>   KM de la &uacute;ltima Afinaci&oacute;n Mayor  </b></td>
    <td colspan="2"><b>   Realizar Afinaci&oacute;n Mayor en:  </b></td>
</tr>

<tr>
    <td colspan="4"><?php
        //formato fecha americana
        $fecha1=$reg['cambioaceite'];
        $fecha2=date("d-m-Y",strtotime($fecha1));
        //El nuevo valor de la variable: $fecha2="20-10-2008"
        echo $fecha2;
    ?></td> 
    <td><?php echo $reg['km1'],' Km';?></td>
    <td><?php echo $reg['km1r'],' Km';?></td>
    <td><?php echo $reg['diasrca'],' días';?></td>
    <td colspan="2"><?php
        //formato fecha americana
        $fecha3=$reg['afinacionve'];
        $fecha4=date("d-m-Y",strtotime($fecha3));
        //El nuevo valor de la variable: $fecha2="20-10-2008"
        echo $fecha4;
    ?></td> 

    <td><?php echo $reg['km2'],' Km';?></td>
    <td colspan="1"><?php echo $reg['km2r'],' Km';?></td>
    <td><?php echo $reg['diasram'], ' días';?></td>

<tr>  
    <td  colspan="12" bgcolor=#0080FF></td> 
</tr>

</table>
<br>

<?php

$cant++;

}

if ($cant==0)
{

  echo '<br><h1>',"Clave o Nombre no existente.",'</h1><br>';


  // Se muestra en pantalla las diversas variables que manejo para ver si mustra alguna.
  echo '<br>Descve REQUEST:', $_REQUEST['descve'];
  echo '<br>Descve POST:', $_POST['descve'];
  echo '<br>Descve GET:', $_GET['descve'];
  echo '<br>Descve:', $descve;
}

mysqli_close($conexion);
?>

Shows all the information in the database in the list. When I give it to accept, it sends me to the designated page but it shows me the last file of the table and not the one I asked for.

Could you orient me with this dilemma? Thank you very much

EDIT:

It has been resolved, I leave the code running in case someone comes to serve.

<?php   // Este es el archivo vehi-consul.php

    require('conexion.php');

    $descve = $_POST[descve];

    $query="SELECT vclave, descve, tipove, placasve, anoplacasve, captank, cambioaceite, afinacionve, segurove, vensegurove, fotove, usuario, km1, km2, km1r, km2r, diasrca, diasram, chofer FROM vehiculos WHERE descve LIKE '%$vclave%'";

    $resultado=$mysqli->query($query);

    $rows = $resultado->num_rows;
?>

<?php




$conexion=mysqli_connect("localhost","xxxxxxxxxxxxxxxx","xxxxxxxxxx","xxxxxxxxxxxxxxxx") or
    die("Problemas con la conexión");

$registros=mysqli_query($conexion,"select vclave, descve, tipove, placasve, anoplacasve, captank, cambioaceite, afinacionve, segurove, vensegurove, fotove, usuario, km1, km2, km1r, km2r, diasrca, diasram, chofer
                        from vehiculos where vclave='$vclave' or descve='$_POST[descve]' or descve='$descve' ")  or
            die("Problemas en el select:".mysqli_error($conexion));

$cant=0;


while ($reg=mysqli_fetch_array($registros))
{

//echo '<br>Descve REQUEST:', $_REQUEST['descve'];
//echo '<br>Descve POST:', $_POST['descve'];
//echo '<br>Descve GET:', $_GET['descve'];
//echo '<br>Descve:', $descve;

?>

<table border=7 ALIGN=CENTER width="100%" bgcolor=#ffffff>
<thead ALIGN=CENTER>

<tr>
    <td colspan="3" BGCOLOR="#F0F0F0"><b>   Clave   </b></td>
    <td colspan="4" BGCOLOR="#F0F0F0"><b>   Descripci&oacute;n   </b></td>
    <td colspan="2" BGCOLOR="#F0F0F0"><b>   Tipo de Veh&iacute;culo    </b></td>
    <td colspan="1" BGCOLOR="#F0F0F0"><b>   Chofer    </b></td>
    <td  colspan="1" bgcolor=#0080FF><a href="vehi-elim.php?vclave=<?php echo $reg['vclave'];?>" onclick="return confirm('&#191;Est&aacute;s seguro que deseas eliminar el registro?');">Eliminar</a></td> 
    <td  colspan="1" bgcolor=#0080FF><a href="vehi-mod.php?vclave=<?php echo $reg['vclave'];?>">Modificar</a></td>                  
</tr>

<tr>
    <td colspan="3"><?php echo $reg['vclave'];?></td>
    <td colspan="4"><?php echo $reg['descve'];?></td>
    <td colspan="2"><?php echo $reg['tipove'];?></td>

    <!--LINK PARA CHOFERES--> 
    <td colspan="1">

<form action="../chofconsul.php" method="post">
 <input type="hidden" name="chofer" value="<?php echo $reg['chofer']; ?>" />
 <input type="submit" value="<?php echo $reg['chofer']; ?>" />
</form>

</td>   

    <td colspan="2" rowspan="3" align=center><img width="250" height="200" src="php/images/<?php echo $reg['fotove'];?>" /></td>    
</tr>

<tr BGCOLOR="#F0F0F0">
    <td colspan="3"><b>   Placas   </b></td>
    <td><b>   A&ntilde;o de las placas  </b></td>
    <td><b>   Capacidad del Tanque  </b></td>
    <td colspan="2"><b>   Usuario   </b></td>
    <td colspan="2"><b>   Seguro del Vehiculo  </b></td>
    <td colspan="1"><b>   Vencimiento del seguro   </b></td>
</tr>

<tr>
    <td colspan="3"><?php echo $reg['placasve'];?></td>
    <td><?php echo $reg['anoplacasve'];?></td>
    <td><?php echo $reg['captank'];?></td>
    <td colspan="2"><?php echo $reg['usuario'];?></td>
    <td colspan="2"><?php echo $reg['segurove'];?></td>
    <td colspan="1"><?php
        //formato fecha americana
        $fecha5=$reg['vensegurove'];
        $fecha6=date("d-m-Y",strtotime($fecha5));
        //El nuevo valor de la variable: $fecha2="20-10-2008"
        echo $fecha6;
    ?></td> 
</tr>

</tr>

<tr BGCOLOR="#F0F0F0">
    <td colspan="4"><b>   Cambio de Aceite   </b></td>
    <td colspan="1"><b>   KM del &uacute;ltimo Cambio de Aceite   </b></td>
    <td colspan="2"><b>   Realizar Cambio de Aceite en:  </b></td>
    <td colspan="2"><b>   Afinaci&oacute;n Mayor  </b></td>
    <td><b>   KM de la &uacute;ltima Afinaci&oacute;n Mayor  </b></td>
    <td colspan="2"><b>   Realizar Afinaci&oacute;n Mayor en:  </b></td>
</tr>

<tr>
    <td colspan="4"><?php
        //formato fecha americana
        $fecha1=$reg['cambioaceite'];
        $fecha2=date("d-m-Y",strtotime($fecha1));
        //El nuevo valor de la variable: $fecha2="20-10-2008"
        echo $fecha2;
    ?></td> 
    <td><?php echo $reg['km1'],' Km';?></td>
    <td><?php echo $reg['km1r'],' Km';?></td>
    <td><?php echo $reg['diasrca'],' días';?></td>
    <td colspan="2"><?php
        //formato fecha americana
        $fecha3=$reg['afinacionve'];
        $fecha4=date("d-m-Y",strtotime($fecha3));
        //El nuevo valor de la variable: $fecha2="20-10-2008"
        echo $fecha4;
    ?></td> 

    <td><?php echo $reg['km2'],' Km';?></td>
    <td colspan="1"><?php echo $reg['km2r'],' Km';?></td>
    <td><?php echo $reg['diasram'], ' días';?></td>

<tr>  
    <td  colspan="12" bgcolor=#0080FF></td> 
</tr>

</table>
<br>

<?php


$cant++;

}

if ($cant==0)
{

  echo '<br><h1>',"Clave o Nombre no existente.",'</h1><br>';

}

mysqli_close($conexion);
?>



//Codigo de Option Value


<center><h1>Busqueda de Veh&iacute;culo</h1></center>

<table border=7 ALIGN=CENTER width="70%" bgcolor=#ffffff>

<form role="form" name="descve" enctype="multipart/form-data" action="vehi-consul.php" method="POST"> 

    <TR ALIGN=CENTER> 
        <th><label for="descve">Selecci&oacute;n por Nombre: </label></th>
<?php
        $result = $mysqli->query($query);

?>   
<td><select name="descve">    
    <?php    
    while ( $row = $result->fetch_array() )    
    {   
        ?>  

        <option value="<?php echo $row['descve']; ?>" >
        <?php echo $row['descve']; ?>
        </option>

        <?php

    }  
    ?> 



</select>
</td>

<TD><input type="submit" value="Aceptar"></TD>
</form>
</TR>
</table>

sql html php mysqli

asked by Stravos77 21.06.2016 в 18:53

source

1 answer

How can I pass stylus variables from the main file to the imported one? TimeStamp field or Date and Time

score 1 · Accepted Answer

Well, looking at your code I have noticed the following:

You make a query to list all your items (products, cars, whatever) and apparently all this is correct.

When you send your form you are NOT indicating which item you want to choose and then this is where the problem is, that is, assigning a value to your option of the select type menu, but this menu It does NOT have a name for the option variable to be sent.

Solution:

You must assign the variable; vclave to your select type menu. Something like: <select name="vclave"> . Try this and see what happens.