<?php

    class conexaoClass {
        var $conn;

        function abrir_conexao() {
            $servername = 'localhost';
            $username = 'root';
            $password = '';
            $dbname = 'test';

            $this -> conn = new mysqli($servername, $username, $password, $dbname);
        }

        function getconn() {
            return $this -> conn;
        }
    }

    $Oconn = new conexaoClass();
    $Oconn -> abrir_conexao();
    $conn = $Oconn -> getconn();


    $NOME = "Macarana";

    //$sql = "SELECT * FROM tabela_teste ORDER by TES_ID";
    //$sql = "INSERT INTO tabela_teste (TES_NOME, TES_EMAIL, TES_TELEFONE) VALUES ('".$NOME."', 'teste2', 'teste3')";
    //$sql = "UPDATE tabela_teste SET TES_NOME='".$NOME."' WHERE TES_TELEFONE = 3";
    //$sql = "DELETE FROM tabela_teste WHERE TES_TELEFONE = 3";

    $sql = "SELECT * FROM tabela_teste WHERE TES_ID > 9";
    $result = $conn->query($sql);
    while($linha = $result->fetch_assoc()) {
        echo $linha["TES_NOME"]."<br>";
    }




?>