Error: Notice: Undefined index || PHP || MYSQL ||

Question

Error: Notice: Undefined index || PHP || MYSQL ||

Navigation

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

0

Hello, I'm developing a filter for an online store and I'm getting this error when I start the page,

ButwhenIclickthecontinuebuttonontheform,allexceptthisonedisappear: Hereistheformcode:

<div class="card-body"> 
<form method="post"> 
Referencia: 
<input type="text" placeholder="&#xF002; Search" name="referencia"style="font-family:Arial, FontAwesome"> 
<br><br> 
<div class="row"> 
Diametro do Aço (d): 
<div class="col-md-4"> 
<input type="text" name="d1" size="6" placeholder="min"> 
<input type="text" name="d2" size="6" placeholder="max"> 
</div> 
Comprimento total (L0): 
<div class="col-md-4"> 
<input type="text" name="comp1" size="6" placeholder="min"> 
<input type="text" name="comp2" size="6" placeholder="max"> 
</div> 
</div> 
<br> 
<div class="row"> 
Diametro Exterior (DE):
<div class="col-md-4"> 
<input type="text" name="de1" size="6" placeholder="min"> 
<input type="text" name="de2" size="6" placeholder="max"> 
</div> 
<br> 
</div>
<br> 
<div class="row"> 
<div class="form-group"> 
<label for="exampleFormControlSelect1">Ordenar por:</label> 
<select class="form-control" name="ordenar" id="ordenar"> 
<option value="referencia">Referencia</option> 
<option value="diametroaco">Diametro do Aço (d)</option> 
<option value="comprimentototal">Comprimento total (L0)</option> 
<option value="diametroexterior">Diametro Exterior (DE)</option> 
<option value="passo">Passo (P)</option> 
</select> 
</div> 
<div class="col-md-9"> 
<div align="right"> 
<img src="imagens/desenho33.png" align="right" height="250" width="350" > 
</div> 
</div> 
</div> 
<br> 
<div align="right"> 
<button type="reset" align="right" class="btn btn-primary">Reset</button> 
<button type="submit" align="right" class="btn btn-primary" value="submit">Continuar</button> 
</div> 
</form>

This is the code that has the errors:

<?php 
if(isset($_POST)&&!empty($_POST)){ 
    if ($_POST["d1"]<>""){
$d1=$_POST["d1"];
    }else{
        $d1="0,200";
    }
    if ($_POST["d2"]<>""){
$d2=$_POST["d2"];
    }else{
        $d2="20";
    }
    if ($_POST["comp1"]<>""){
$comp1=$_POST["comp1"];
    }else{
        $comp1="1";
    } 
    if ($_POST["comp2"]<>""){
$comp2=$_POST["comp2"];
    }else{
        $comp2="10000";
    } 
    if ($_POST["de1"]<>""){
$de1=$_POST["de1"];
    }else{
        $de1="1";
    }
    if ($_POST["de2"]<>""){
$de2=$_POST["de2"];
    }else{
        $de2="200";
    }  
}
$ordenar=$_POST["ordenar"]; 

//if(isset($_POST["getproduct"])){ 
//$ordenar="nome"; 
//} 
switch($ordenar){ 
case "referencia": 
$ordenar_por="order by referencia"; 
break; 
case "diametroaco": 
$ordenar_por="order by diametroaco"; 
break; 
case "comprimentototal": 
$ordenar_por="order by comprimentototal"; 
break; 
case "diametroexterior": 
$ordenar_por="order by diametroexterior"; 
break; 
case "passo": 
$ordenar_por="order by passo"; 
break; 
} 

include ("db.php"); 
// $molcomp_query="SELECT * FROM stock_comp"; 
   //$molcomp_query="SELECT * FROM stock_comp $ordenar_por"; 
$molcomp_query="SELECT * FROM stock_comp WHERE (diametroaco BETWEEN '$d1' and '$d2') AND (comprimentototal BETWEEN '$comp1' AND '$comp2') AND (diametroexterior BETWEEN '$de1' AND '$de2') $ordenar_por"; 

$run_query = mysqli_query($con,$molcomp_query); 
         var_dump($run_query);
if (mysqli_num_rows($run_query) > 0){ 
while($row = mysqli_fetch_array($run_query)){ 
$id_mol_comp=$row['id_mol_comp']; 
$referencia=$row['referencia']; 
$diametroaco=$row['diametroaco']; 
$comprimentototal=$row['comprimentototal']; 
$diametroexterior=$row['diametroexterior']; 
$passo=$row['passo']; 
$preco=$row['preco']; 
echo" 
<div class='card mx-auto w-100'> 
<div class='card-body'> 
<div class='row'> 
<div class='col-md-1'>$referencia</div> 
<div class='col-md-2'>$diametroaco</div> 
<div class='col-md-2'>$comprimentototal</div> 
<div class='col-md-2'>$diametroexterior</div> 
<div class='col-md-1'>$passo</div> 
<div class='col-md-1'>$preco</div> 
<div class='col-md-1'><i style='font-size:30px' class='fa'>&#xf1c1;</i> <i style='font-size:30px' class='fa'>&#xf217;</i> </div> 
</div> 
</div> 
</div> 
<br>"; 
} 
}    
?>

php mysql

asked by anonymous 11.05.2018 / 11:38

2 answers

2

These errors (a large part) are occurring, since the request method is not the same as in if :

if( isset($_POST) && !empty($_POST) ){

You are probably accessing the page directly and not by submitting a form.

Here, your code contains the indexes all within if which requires that the request method be POST and as soon as the method is GET the indexes will be all undefined.

Here you have two options :

1 - Define the indexes previously (before if ) and if the request was with the method POST they would reset them, providing other corrections and validations that are necessary, or;

2 - Bring all code that depends on these indexes into the if block that is processed when the method is POST .

An example, using option 2:

<?php
if( isset($_POST) && !empty($_POST) ){
    if ($_POST["d1"]<>""){
        $d1=$_POST["d1"];
    }else{
        $d1="0,200";
    }
    if ($_POST["d2"]<>""){
        $d2=$_POST["d2"];
    }else{
        $d2="20";
    }
    if ($_POST["comp1"]<>""){
        $comp1=$_POST["comp1"];
    }else{
        $comp1="1";
    } 
    if ($_POST["comp2"]<>""){
        $comp2=$_POST["comp2"];
    }else{
        $comp2="10000";
    } 
    if ($_POST["de1"]<>""){
        $de1=$_POST["de1"];
    }else{
        $de1="1";
    }
    if ($_POST["de2"]<>""){
        $de2=$_POST["de2"];
    }else{
        $de2="200";
    }
    $ordenar = $_POST["ordenar"];

    //if(isset($_POST["getproduct"])){ 
    //$ordenar="nome"; 
    //} 
    switch($ordenar){ 
        case "referencia": 
            $ordenar_por="order by referencia"; 
        break; 
        case "diametroaco": 
            $ordenar_por="order by diametroaco"; 
        break; 
        case "comprimentototal": 
            $ordenar_por="order by comprimentototal"; 
        break; 
        case "diametroexterior": 
            $ordenar_por="order by diametroexterior"; 
        break; 
        case "passo": 
            $ordenar_por="order by passo"; 
        break; 
    } 

    include ("db.php"); 
    // $molcomp_query="SELECT * FROM stock_comp"; 
       //$molcomp_query="SELECT * FROM stock_comp $ordenar_por"; 
    $molcomp_query="SELECT * FROM stock_comp WHERE (diametroaco BETWEEN '$d1' and '$d2') AND (comprimentototal BETWEEN '$comp1' AND '$comp2') AND (diametroexterior BETWEEN '$de1' AND '$de2') $ordenar_por"; 

    $run_query = mysqli_query($con,$molcomp_query); 
             var_dump($run_query);
    if (mysqli_num_rows($run_query) > 0){ 
        while($row = mysqli_fetch_array($run_query)){ 
            $id_mol_comp=$row['id_mol_comp']; 
            $referencia=$row['referencia']; 
            $diametroaco=$row['diametroaco']; 
            $comprimentototal=$row['comprimentototal']; 
            $diametroexterior=$row['diametroexterior']; 
            $passo=$row['passo']; 
            $preco=$row['preco']; 
            echo" 
            <div class='card mx-auto w-100'> 
            <div class='card-body'> 
            <div class='row'> 
            <div class='col-md-1'>$referencia</div> 
            <div class='col-md-2'>$diametroaco</div> 
            <div class='col-md-2'>$comprimentototal</div> 
            <div class='col-md-2'>$diametroexterior</div> 
            <div class='col-md-1'>$passo</div> 
            <div class='col-md-1'>$preco</div> 
            <div class='col-md-1'><i style='font-size:30px' class='fa'>&#xf1c1;</i> <i style='font-size:30px' class='fa'>&#xf217;</i> </div> 
            </div> 
            </div> 
            </div> 
            <br>"; 
        } 
    }   
}
?>

11.05.2018 / 14:21

Select with condition Transform two lists of data into a graph with two parallel lines

score 1 · Accepted Answer

A closing problem in the wrong place, all code should be inside the% check%:

<?php
    if(isset($_POST)&&!empty($_POST)){
        if ($_POST["d1"]<>""){
            $d1=$_POST["d1"];
        }else{
            $d1="0,200";
        }
        if ($_POST["d2"]<>""){
            $d2=$_POST["d2"];
        }else{
            $d2="20";
        }
        if ($_POST["comp1"]<>""){
            $comp1=$_POST["comp1"];
        }else{
            $comp1="1";
        }
        if ($_POST["comp2"]<>""){
            $comp2=$_POST["comp2"];
        }else{
            $comp2="10000";
        }
        if ($_POST["de1"]<>""){
            $de1=$_POST["de1"];
        }else{
            $de1="1";
        }
        if ($_POST["de2"]<>""){
            $de2=$_POST["de2"];
        }else{
            $de2="200";
        } 

        $ordenar=$_POST["ordenar"];

        //if(isset($_POST["getproduct"])){
        //$ordenar="nome";
        //}
        switch($ordenar){
            case "referencia":
                $ordenar_por="ORDER BY referencia";
                break;
            case "diametroaco":
                $ordenar_por="ORDER BY diametroaco";
                break;
            case "comprimentototal":
                $ordenar_por="ORDER BY comprimentototal";
                break;
            case "diametroexterior":
                $ordenar_por="ORDER BY diametroexterior";
                break;
            case "passo":
                $ordenar_por="ORDER BY passo";
                break;
        }

        include ("db.php");
        // $molcomp_query="SELECT * FROM stock_comp";
           //$molcomp_query="SELECT * FROM stock_comp $ordenar_por";
        $molcomp_query="SELECT * FROM stock_comp WHERE (diametroaco BETWEEN '$d1' and '$d2') AND (comprimentototal BETWEEN '$comp1' AND '$comp2') AND (diametroexterior BETWEEN '$de1' AND '$de2') $ordenar_por";

        $run_query = mysqli_query($con,$molcomp_query);
        // var_dump($run_query);
        if (mysqli_num_rows($run_query) > 0){
            while($row = mysqli_fetch_array($run_query)){
                $id_mol_comp=$row['id_mol_comp'];
                $referencia=$row['referencia'];
                $diametroaco=$row['diametroaco'];
                $comprimentototal=$row['comprimentototal'];
                $diametroexterior=$row['diametroexterior'];
                $passo=$row['passo'];
                $preco=$row['preco'];
                echo
                "<div class='card mx-auto w-100'>
                    <div class='card-body'>
                            <div class='row'>
                            <div class='col-md-1'>$referencia</div>
                            <div class='col-md-2'>$diametroaco</div>
                            <div class='col-md-2'>$comprimentototal</div>
                            <div class='col-md-2'>$diametroexterior</div>
                            <div class='col-md-1'>$passo</div>
                            <div class='col-md-1'>$preco</div>
                            <div class='col-md-1'><i style='font-size:30px' class='fa'>&#xf1c1;</i> <i style='font-size:30px' class='fa'>&#xf217;</i> </div>
                        </div>
                    </div>
                </div>
                <br>";
           }
        }
    }
?>