Print button if a value is empty

Question

Print button if a value is empty

Navigation

#1 by (1 votes)
#2 by (1 votes)

0

I have a table that shows the records of orders delivered, and to finish the registration there is a "Add referral" button to save the referral in the database. I want to do that when the table reloads and if the referral has value that does not show the button to attach the referral.

This is my query:

$consulta="SELECT * FROM registros where estado = 'entregado'";
$registros=mysqli_query($conexion,$consulta) or die ("Problemas con la consulta");

And here is where I create the rows of the table with the results of the query:

while ($reg=mysqli_fetch_array($registros))
        {
            $pu = toMoney($reg['pu']);
            $padd = toMoney($reg['padd']);
            $folio= $reg['id'];
            echo "<tr id='head' data-toggle='modal' data-id='$folio' data-target='#orderModal' style='background: #aaffb3; cursor: pointer;'>
                        <td>".$reg['hora']."</td>
                        <td>".$reg['cliente']."</td>
                        <td>".$reg['dir_obra']."<br/>".$reg['indicaciones']."</td>
                        <td>".$reg['fecha_entrega']."</td>
                        <td>".$reg['resistencia']." </td>
                        <td>".$reg['remision']." </td>
                        <td style='display:none;'>".$reg['m3']." </td>
                        <td style='display:none;'>".$reg['id']." </td>
                        <td style='display:none;'>".$reg['metodo_pago']." </td>
                        <td style='display:none;'>".$reg['fecha_registro']." </td>
                        <td style='display:none;'>".$pu." </td>
                        <td style='display:none;'>".$reg['tiro']." </td>
                        <td style='display:none;'>".$reg['ton']." </td>
                        <td style='display:none;'>".$reg['elem_colar']." </td>
                        <td style='display:none;'>".$reg['revenimiento']." </td>
                        <td style='display:none;'>".$reg['adicionales']." </td>
                        <td style='display:none;'>".$padd." </td>
                        <td>
                            <button class='btn btn-success btn-sm btnRemision' aria-label='Left Align' value='$folio'> Agregar remision</button>
                        </td>
                    </tr>";
        }

Thank you in advance for your comments.

mysql html php mysqli

asked by Carlos Roberto Luna Ochoa 19.06.2018 в 17:20

source

2 answers

1

You can try the following, if the variable $ reg ['remission'] is the one you have should not have the value

while ($reg=mysqli_fetch_array($registros))
        {
            $pu = toMoney($reg['pu']);
            $padd = toMoney($reg['padd']);
            $folio= $reg['id'];
            $button = "";
            if (!isset($reg['remision'])){
                $button = "<button class='btn btn-success btn-sm btnRemision' aria-label='Left Align' value='$folio'> Agregar remision</button>";
            }

            echo "<tr id='head' data-toggle='modal' data-id='$folio' data-target='#orderModal' style='background: #aaffb3; cursor: pointer;'>
                        <td>".$reg['hora']."</td>
                        <td>".$reg['cliente']."</td>
                        <td>".$reg['dir_obra']."<br/>".$reg['indicaciones']."</td>
                        <td>".$reg['fecha_entrega']."</td>
                        <td>".$reg['resistencia']." </td>
                        <td>".$reg['remision']." </td>
                        <td style='display:none;'>".$reg['m3']." </td>
                        <td style='display:none;'>".$reg['id']." </td>
                        <td style='display:none;'>".$reg['metodo_pago']." </td>
                        <td style='display:none;'>".$reg['fecha_registro']." </td>
                        <td style='display:none;'>".$pu." </td>
                        <td style='display:none;'>".$reg['tiro']." </td>
                        <td style='display:none;'>".$reg['ton']." </td>
                        <td style='display:none;'>".$reg['elem_colar']." </td>
                        <td style='display:none;'>".$reg['revenimiento']." </td>
                        <td style='display:none;'>".$reg['adicionales']." </td>
                        <td style='display:none;'>".$padd." </td>
                        <td>
                            $button
                        </td>
                    </tr>";
        }

answered by 19.06.2018 в 23:37

How to pass values to a PHP on the same page and keep them selected java does not know how to handle the object

score 1 · Accepted Answer

1

Use the function isset

if (!isset($reg['remision'])){
    echo "<button class='btn btn-success btn-sm btnRemision' aria-label='Left Align' value='$folio'> Agregar remision</button>"
}

answered by 19.06.2018 / 17:22

source