Untitled

<!DOCTYPE html>
<html>
<head>
    <title>Exemplo</title>
    <style type="text/css">
        #geral{
            margin: auto;
            background-color: lightblue;
            color: white;
            width: 400px;
            height: auto;
            border:1px solid black;
            border-radius: 15px;
        }
        .ger{
            margin: auto;
            background-color: lightblue;
            color: white;
            width: 400px;
            height: auto;
            border:1px solid black;
            border-radius: 15px;
        }
        p{
            text-align: center;
        }
        #bt1{
            width: 260px;
            height: 30px;
            background-color: lightgrey;
            color: black;
        }
        .alert{
            text-align: center;
            margin: auto;
            background-color: red;
            margin-right: 15px;
            margin-left: 15px;
        }
        .ok{
            text-align: center;
            margin: auto;
            background-color: green;
            margin-right: 15px;
            margin-left: 15px;
        }
        .tbcriada{
            margin: auto;
        }
    </style>
</head>
<body>
    <?php
        $bd_host="localhost";
        $bd_user="root";
        $bd_password="";
        $bd_database="13787_3";
        $msg= "";
        $existe="";
        $num=$idade=$email=$Local="";
        $mq = new mysqli($bd_host,$bd_user,$bd_password,$bd_database);


        if(isset($_POST["submit"])){
            $qr = "INSERT INTO tbl_13787(Numero,Idade,Email,Local) VALUES(?,?,?,?)";
            $st = $mq->prepare($qr);
            $st->bind_param('isss', $_POST["Numero"],
                                    $_POST["Nome"],
                                    $_POST["Email"],
                                    $_POST["Local"]);

        if ($st->execute() && $st->affected_rows>0){
            $msg= "<p class='ok'>Foi inserido/atualizado um registo!</p>";

        }
        else{
                $msg='<p class="alert"> Erro: ('. $mq->errno .') '. $mq->error .'</p>';
                $erro=1;
            }

        $st->close();


        }
        if(isset($_POST["Consulta"])){
            $qr="SELECT * FROM tbl_13787 ORDER BY Numero";

            $results = $mq->query($qr);
            echo "<table class=tbcriada border='1'>";
            echo "<td>Numero</td>";
            echo "<td>Idade</td>";
            echo "<td>Email</td>";
            echo "<td>Local</td>";
                while ($row = $results->fetch_assoc()) {
                    echo "<tr>";
                    echo "<td>".$row["Numero"]."</td>";
                    echo "<td>".$row["Idade"]."</td>";
                    echo "<td>".$row["Email"]."</td>";
                    echo "<td>".$row["Local"]."</td>";
                    echo "</tr>";
                }
            echo "</table>";
        }
        else{

            if(isset($_POST["pesq"])){

                $qr="SELECT * FROM tbl_13787 where Numero=?";
                $st=$mq->prepare($qr);
                $st->bind_param('i', $_POST["Numero"]);
                $st->execute();
                $st->bind_result($num,$idade,$email,$local);
                if($st->fetch()){
                    $existe=true;
                    $msg='<p class="ok" > Registo Encontrado</p>';

                }
                else{
                    $existe=false;
                    $msg='<p class="alert">Registo nao Encontrado</p>';
                }
                $st->close();
            }
            else{
                if(isset($_POST["Altera"])){
                    $qr="UPDATE tbl_13787 SET Idade=?, Email=?, Local=? WHERE Numero=?";
                    $st=$mq->prepare($qr);
                    $st->bind_param('sssi',$_POST["Idade"],$_POST["Email"],$_POST["Local"],$_POST["Numero"]);
                    $st->execute();
                    $st->close();
                }
                else{
                    if(isset($_POST["apaga"])){
                        $qr="DELETE FROM tbl_13787 WHERE Numero= ?";
                        $st=$mq->prepare($qr);
                        $st->bind_param('i',$_POST["Numero"]);
                        $st->execute();
                        $st->close();
                    }
                }
            }
        }


    ?>


            <br>
            <form method="post" action="" id="tb1" class=ger name="tb1">
                <input type="hidden" name="pesq" value="1"/>
            <p>Seleciona: <select name="num" id="num" onChange="document.tb1.submit();">
                <option value="-1">
                    Selecione um registo
                </option>
                    <?php
                    $qrs="SELECT * FROM tbl_13787";
                $st = $mq->query($qrs);
                    $option = '';
                while($row = $st->fetch_assoc())
                        {
                    echo '<option value = "'.$row['num'].'">'.$row['nome'].'</option>';
                    }
                    $st->close();
                    ?>
            </select>
        </form>
            <form method="post" action="" id="geral" class="ger">
            <p>Numero:<input type="number" name="num" value="<?php echo $num ?>"><input type="submit" name="pesq" value="Pesquisa"></p>
            <p>Nome:<input type="text" name="nome" value="<?php echo $idade ?>"></p>
            <p>Email:<input type="text" name="email" value="<?php echo $email ?>"></p>
            <p>Telemovel:<input type="text" name="tele" value="<?php echo $local ?>"></p>
            <p><input type="submit" name="submit" value="insira" id="bt1"></p>
            <p><input type="submit" name="Consulta" value="consulta" id="bt2"></p>
            <?php if ($existe==true) {?>
                <p><input type="submit" name="Altera" value="Alterar" /></p>
                <p><input type="submit" name="apaga" value="Eliminar" /></p>
            <?php }?>
            <p>
                <?php
                    echo $msg;
                    $mq->close();
                ?>
            </p>
        </form>
     </body>
</html>