Notice: Undefined variable: query_mysql in [closed]

Question

Notice: Undefined variable: query_mysql in [closed]

Navigation

#1 by (-1 votes)

-1

<?php

include 'connection.php';

//dame tareas para el combobox
function dameproducto(){
    $consulta_mysql="
        SELECT 
            tbproducto.nvchproducto,
            tbproducto.intidproducto,
            tbproducto.nvchcantidad
        from 
        tbproducto
    ";
    $resultado_consulta_mysql=mysqli_query($consulta_mysql);
    while($registro = mysqli_fetch_array($resultado_consulta_mysql)){
        echo "
              <option style='' value='".$registro['intidproducto']."'>
                PROD000".$registro['intidproducto']." - ".$registro['nvchproducto']." - distribuidor: ".$registro['nvchcantidad']."".$registro['inidproducto']."
              </option>
        ";
    }
}

function damelista(){
    $consulta_mysqli="
        SELECT
          tbstock.intidstock,
          tbproducto.intidproducto,
          tbproducto.nvchproducto,
          tbproducto.nvchdescripcion,
          tbproducto.nvchcantidad AS proveedor,
          tbstock.nvchcantidad
        FROM
          tbproducto
        INNER JOIN
          tbstock ON tbstock.inidproducto = tbproducto.intidproducto
    ";

This part is where the error marks me

    $resultado_consulta_mysql=mysqli_query($consulta_mysql);
    while($registro = mysqli_fetch_array($resultado_consulta_mysql)){

        if($registro['nvchcantidad'] < 0){
            $tiporeg = "<span class='label label-danger'>Pedido Producto</span>";
        }else
        if($registro['nvchcantidad'] >= 0){
            $tiporeg = "<span class='label label-success'>Ingreso Producto</span>";
        }

        $tipo = 'UND.';
        echo "
            <tr>
                <td>REG000".$registro['intidstock']."</td>
                <td>".$registro['nvchproducto']."</td>
                <td>".$registro['nvchdescripcion']."</td>
                <td>".$registro['proveedor']."</td>
                <td>".abs($registro['nvchcantidad']).' '.$tipo."</td>
                <td>".$tiporeg."</td>
                <td>
                    <a href='?action=editar&intidstock=".$registro['intidstock']."' style='background-color: green; padding: 5px; border-radius: 5px;color: white; font-size:12px' data-toggle='tooltip' title='Editar Pedido'><span class='glyphicon glyphicon-edit'></span></a>
                    <a href='?action=eliminar&intidstock=".$registro['intidstock']."' style='background-color: red; padding: 5px; border-radius: 5px;color: white; font-size:12px' data-toggle='tooltip' title='Eliminar Pedido'><span class='glyphicon glyphicon-trash'></span></a>
                </td>
            </tr>
        ";
    }
}

function tableprod(){
    $consulta_mysqli="
        SELECT
          tbstock.intidstock,
          tbproducto.intidproducto,
          tbproducto.nvchproducto,
          tbproducto.nvchdescripcion,
          tbproducto.nvchcantidad AS proveedor,
          sum(tbstock.nvchcantidad) as stocktotal
        FROM
          tbproducto
        INNER JOIN
          tbstock ON tbstock.inidproducto = tbproducto.intidproducto
          group by tbproducto.intidproducto
    ";
    $resultado_consulta_mysql=mysqli_query($con,$consulta_mysql);
    while($registro = mysqli_fetch_array($resultado_consulta_mysql)){

    //Estado del producto
    if($registro['stocktotal']<0){
        $cantproducto = '0';
        $nstock = '<span class="label label-danger"><b>'.abs($registro['stocktotal']).' UND.</b> Entregas Pendientes</span> ';

    }else
    if($registro['stocktotal']>=0 && $registro['stocktotal']<=12 ){
        $cantproducto = abs($registro['stocktotal']);
        $nstock = '<span class="label label-warning">Realizar Pedido</span>';
    }else
    if($registro['stocktotal']>=12){
        $cantproducto = abs($registro['stocktotal']);
        $nstock = '<span class="label label-success">STOCK suficiente</span>';
    }

        echo "
            <tr>
                <td> REG000".$registro['intidstock']."</td>
                <td>".$registro['nvchproducto']."</td>
                <td>".$registro['nvchdescripcion']."</td>
                <td>".$registro['proveedor']."</td>
                <td>".$cantproducto." UND.</td>
                <td>".$nstock."</td>
                <!--td>
                    <a href='?action=eliminar&intidstock=".$registro['intidstock']."' style='background-color: red; padding: 5px; border-radius: 5px;color: white; font-size:12px' data-toggle='tooltip' title='Eliminar Ingreso'><span class='glyphicon glyphicon-trash'></span></a>
                </td-->
            </tr>
        ";
    }
}

? >

mysql php

asked by Luis Daniel Esquivel Maldonado 18.04.2018 в 17:17

source

1 answer

Combobox function clean [closed] I do not work Primefaces in eclipse

score -1 · Answer 1

I'll give you an example of how you could do it, you could also check how you are passing the connection to the query:

<?php
/* mi conexion*/
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");

/* VERIFICAR CONEXION */
if (mysqli_connect_errno()) {
    printf("Conxion fallida : %s\n", mysqli_connect_error());
    exit();
}

$query = "SELECT id, nombre, precio FROM productos ORDER by id ";
$result = $mysqli->query($query);

while($row = $result->fetch_array())
{
$rows[] = $row;
}

foreach($rows as $row)
{
echo $row['precio'];
}

/* liberando el result */
$result->close();

/* cerrando mi conexion */
$mysqli->close();
?>