Home / Questions / 183125
Accepted
Javier
Asked: 2020-07-23 10:35:02 +0800 CST 2020-07-23 10:35:02 +0800 CST

Take a row from Mysql with PHP without while

  • 772

Hello if you could help me, I am trying to take a row from a Mysql table, I don't need to go through the table I just want to take a single row.

$consulta_precio_seco="SELECT * FROM secos WHERE codigo=10" ;
$resultados_precio_seco=mysqli_query($conexion,$consulta_precio_seco);
$fila=mysqli_fetch_row($resultados_cargar);
echo $fila[0];

Somebody help me please.

php

2 Answers

  1. mysqli_fetch_rowmust receive as a parameter a result set, which is obtained with mysqli_query.

    In your code that result set is called $resultados_precio_seco, but you are passing another variable that is $resultados_cargar.

    To solve the problem it would be then:

    $fila=mysqli_fetch_row($resultados_precio_seco);
echo $fila[0];

    NOTE ON OPTIMIZATION:

    If you are only interested in one row, you may want to limit the results to one row, so as not to overload the database and the server by fetching unnecessary data. You can therefore write the query like this:SELECT * FROM secos WHERE codigo=10 LIMIT 1

    NOTE ON NAMING CONVENTION

    You might want to use shorter variable names. Although this is not a difficulty for the operation of the code, it is when it comes to reading it, writing it, analyzing it, organizing it, understanding it. Having a named variable is not the same $resultados_precio_secoas calling it, for example , $rsPrecioSecoor having $consulta_precio_secoinstead of $sqlPrecioSeco.

    • 3
  2. Best Answer

    Your query should look like this assuming you only want to get the values ​​of each column but from a single row

    <?php

$consulta_precio_seco="SELECT * FROM mensajes" ;
$resultados_precio_seco=mysqli_query($conexion,$consulta_precio_seco);
$fila=mysqli_fetch_row($resultados_precio_seco);
//así si quieres que los resultados salgan concatenados
echo $fila[0].' '.$fila[1].' '.$fila[2];

    If you want the results to be displayed one per row

      $consulta_precio_seco="SELECT * FROM mensajes" ;
    $resultados_precio_seco=mysqli_query($conexion,$consulta_precio_seco);
    $fila=mysqli_fetch_row($resultados_precio_seco);
    echo $fila[0].PHP_EOL;
    echo $fila[1].PHP_EOL;
    echo $fila[2].PHP_EOL;

    As you can see the changes made are minimal, but they are the following

    1. mysqli_fetch_row()I pass the variable inside the function $resultados_precio_seco, since it is the one that contains the set of results that come directly from your query
    2. The data that is being returned to you comes inside an array so when you do the echo you must indicate the position of the columns you want to read, for example in the table id, name, email id is in position 0, name in the position 1 and email in position 2 (for example only)
    • 1