Untitled

<?php
$dbname = "labprog";
$servername = "localhost";
$username = "root";
$password = "";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
?>

<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">
    <title>Exame 2016</title>
</head>
<body>
<form action='index.php' method='post'>
<div class="form-group">
            <br>
            Consultar<br>
            Consultar preços:
            <?php

            $query = $conn->query("select id_bombas, nome, local from combustivel");

            echo "<html>";
            echo "<body>";
            echo "<select name='select'>";
            $varSelect = $_POST['select'];
            while ($row = $query->fetch_assoc()) {

                          unset($id, $name, $local);
                          $id = $row['id_bombas'];
                          $name = $row['nome'];
                          $local = $row['local'];
                          echo '<option value="'.$id.'">Localidade:'.$local.' Nome:'.$name.'</option>';
            }

            echo "</select>";
            ?>
        </div>
        <button type="submit" name="consultar" >Consultar</button>
        <button type="submit" name="todos" >Todos</button>
        <input type="submit" name="reset" value="Reset">
        </form>
<br>
<?php
if (isset($_POST['todos'])){
$result = mysqli_query($conn,"SELECT * FROM combustivel");

echo "<table border='1'>
<tr>
<th>id</th>
<th>nome</th>
<th>preco</th>
<th>local</th>
<th>delete</th>
<th>update</th>
</tr>";

while($row = mysqli_fetch_array($result))
{
    $delete = "index.php?delete="  . $row["id_bombas"];
    $update = "index.php?update="  . $row["id_bombas"];
    echo "<tr>";
    echo "<td>" . $row['id_bombas'] . "</td>";
    echo "<td>" . $row['nome'] . "</td>";
    echo "<td>" . $row['preco'] . "</td>";
    echo "<td>" . $row['local'] . "</td>";
    echo "<td class='info-item'><a href='{$delete}' >Delete</a></td>";
    echo "<td class='info-item'><a href='{$update}' >Update</a></td>";
    echo "</tr>";
}
    echo "</table>";

    mysqli_close($conn);
}
if (isset($_POST['consultar'])){
    $query = mysqli_query($conn,"SELECT * FROM combustivel where id_bombas = '$varSelect'");

    echo "<table border='1'>
    <tr>
    <th>id</th>
    <th>nome</th>
    <th>preco</th>
    <th>local</th>
    <th>delete</th>
    <th>update</th>
    </tr>";

    while($row = mysqli_fetch_array($query))
    {
        echo "<tr>";
        $delete = "index.php?delete="  . $row["id_bombas"];
        $update = "index.php?update="  . $row["id_bombas"];
        echo "<td>" . $row['id_bombas'] . "</td>";
        echo "<td>" . $row['nome'] . "</td>";
        echo "<td>" . $row['preco'] . "</td>";
        echo "<td>" . $row['local'] . "</td>";
        echo "<td class='info-item'><a href='{$delete}' >Delete</a></td>";
        echo "<td class='info-item'><a href='{$update}' >Update</a></td>";
        echo "</tr>";
    }
        echo "</table>";

        mysqli_close($conn);
    }

    if(isset($_GET['delete'])) {
        $id = $_GET['delete'];
        $sql = 'DELETE FROM combustivel WHERE id_bombas = ?';
        $delete = $conn->prepare($sql);
        $delete->bind_param('i', $id);
        $delete->execute();

        if($delete->affected_rows > 0) {
            header('Location: index.php');
        }
    }

?>

<br>
Inserir bomba de gazolina!</br>
<form method="post">
<div class="form-group">
    <select name="insert-select">
        <option value="Sem chumbo 95">Sem chumbo 95</option>
        <option value="Sem chumbo 98">Sem chumbo 98</option>
        <option value="Gasoleo">Gazoleo</option>
    </select>
    Preco:
    <input type="text" name="preco">
    Local:
    <input type="text" name="local">
    <input type="submit" name="insert" value="Inserir Abastecedora">
    <input type="submit" name="reset" value="Reset">
</div>
</form>
<?php
if(isset($_POST['insert'])){
    $query = mysqli_query($conn, "INSERT INTO combustivel (nome, preco, local)
    VALUES ('".$_POST['insert-select']."','".$_POST["preco"]."','".$_POST["local"]."')");
}
?>
<br>
Atualizar bomba de gazolina!</br>
<form method="post">
<div class="form-group">
    <select id="insert-select">
        <option value="95">Sem chumbo 95</option>
        <option value="98">Sem chumbo 98</option>
        <option value="gazoleo">Gazoleo</option>
    </select>
    Preco:
    <input type="text" name="preco">
    Local:
    <input type="text" name="localidade">
    <input type="submit" name="insert" value="Atualizar Abastecedora">
    <input type="submit" name="reset" value="Reset">
</div>
</form>
</body>
</html>