Page request in localhost takes 20 seconds to open

0

I'm trying to show database data in a table.

    <html lang="en">
<head>




   <title>Estoque</title>

<!-- Bootstrap core CSS -->
<link href="bootstrap/css/bootstrap.min.css" rel="stylesheet">
<!-- Bootstrap theme -->
<link href="bootstrap/css/bootstrap-theme.min.css" rel="stylesheet">
<script src="bootstrap/js/bootstrap.min.js" </script>
<script src="jquery-2.1.4.min.js"</script>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script><scriptsrc="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/js/bootstrap.min.js"></script>
</head>
<body>


<div class="container">  
        <table>
            <tr><b>
                <td>Código Produto</td>
                <td>Descrição</td>
                <td>Preço</td>
                <td>Quantidade Estoque</td>
            </tr></b>


<?php
REQUIRE_ONCE "conexao.php";
$sql = "SELECT id, cod_produto, dsc_produto, preco_produto, qtd_estoque, qtd_limitador FROM estoque";
$result = mysqli_query($conexao, $sql);
    while ($row = mysqli_fetch_assoc($result)) 
        { 

?>


            <tr bgcolor="<?php echo $bg ?>">
                <td><?php echo $row[cod_produto] ?></td>
                <td><?php echo $row[dsc_produto] ?></td>
                <td><?php echo $row[preco_produto] ?></td>
                <td><?php echo $row[qtd_estoque] ?></td>
                <td><?php echo $row[qtd_limitador] ?></td>



                <td>
                    <form method="get" action="edit.php">
                        <button type="hidden" name="id" class="btn btn-default" value="<?php echo $row[id]?>"><span class="glyphicon glyphicon-pencil" aria-hidden="true"></span> </button>
                    </form>
                    <form method="POST" action="<?php $_SERVER['PHP_SELF']; ?>">
                    <button type="button" name="botaoDelete" class="btn btn-default" data-toggle="modal" value="<?php echo $row[id] ?>" data-target="#myModal"><span class="glyphicon glyphicon-trash" aria-hidden="true"></span></button>
                    </form>
                </td>
                </tr>



    <!-- Modal -->
    <div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
    <div class="modal-dialog">
    <div class="modal-content">
    <div class="modal-header">
    <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
    <h4 class="modal-title">Excluir produto</h4>
  </div>
  <div class="modal-body">
    <p>Você tem certeza que deseja excluir?</p>

  </div>
  <div class="modal-footer">
    <form method="POST">
    <button type="button" name="botaoConfirma" value="<?php echo $dlt ?>" class="btn btn-danger">Excluir</button>
    <button type="button" class="btn btnn-default" data-dismiss="modal">Fechar</button>
    </form>


<?php      
    if (isset($_POST["botaoDelete"])) {
    $dlt = $_POST["botaoDelete"];
        if (isset($_POST["botaoConfirma"])) {
            $cnf = $_POST["botaoConfirma"];
            $deleteSql = mysqli_query($conexao, "DELETE * FROM estoque WHERE id='".$cnf."'");
        }

}

}   
?> 

  </div>
</div><!-- /.modal-content -->
</div><!-- /.modal-dialog -->
</div><!-- /.modal -->


</tbody>
</div>
</body>

When I call in the browser, it takes around 20s to open. Can anyone help?

    
asked by anonymous 16.09.2015 / 20:20

1 answer

1

Are you using Windows? If so, make sure your server is serving connections via IPv4 only. If so, this may be your problem.

What is happening is that Windows by default directs the address "localhost" to the loopback via IPv6 (address ::1 ). If your server is serving only IPv4, the connection does not close and is waiting for the timeout (which in your case should be those 20s). When it gives the timeout then it tries the IPv4 address ( 127.0.0.1 ), which completes the connection.

If your problem is this (and not something else in PHP), the solution is to configure your server to accept connections in the loopback via IPv6 or configure your client to connect to the address 127.0.0.1 instead of localhost .

    
16.09.2015 / 20:59