include php does not work

Question

I have the following directory tree:

.var
..|--www
......|--site
..........|--index.php
..........|--all
..............|--controller
..................|--conexao.php (classe)
..............|--model
..................|--bo
..................|--vo
..................|--dao
.....................|--prioridade_dao.php (classe)

Pretty extensive beauty, the problem is this: It includes the priority class_dao.php inside index.php (so far so good) if I "NO" put no include in the prioritity_dao.php appear things when viewing the page, now if I put any include in the priority class_dao.php does not appear anything else. I’ve tried to:

include ('../../controller/conexao.php');
include '../../controller/conexao.php';
include ("../../controller/conexao.php");
include "../../controller/conexao.php";
include $_SERVER['DOCUMENT_ROOT']."/all/controller/conexao.php";

Follows priority class_dao.php:

<?php
Class PrioridadeDao{
    error_reporting(-1); 
    ini_set('display_errors', 'On');

    include $_SERVER['DOCUMENT_ROOT']."/all/controller/conexao.php";
    $conexao = new Conexao();       

    public function __construct(){

    }

    public function teste(){
        echo "Chega aqui sim";
    }


    public function selectAll(){
        echo "<br />CHEGA AQUI?";

        if(!$conexao->conecta()){
            exit;
        } else {
            $result = pg_query($conexao->conecta(), "SELECT * FROM prioridade");
            while ($consulta = @pg_fetch_array($result)){
                echo $consulta['nivel']." ".$consulta['nome'];
            }
            $conexaoObj->encerra($conexao->conecta());
        }
    }
}
?>

I have also tried with require, all without success. I did a test calling for direct include to conexao.php in index.php and I did it. I’m using methods __construct() empty in the classes, can that be it? Finally I have researched in a lot of places, tested many things and nothing :( if you can help me I will be very grateful.

Answer 1

Correct in working with OPP, is to set your settings files in a folder called Config, the directory Controller, as its name already says is to send and receive commands to the view or model. And your connection file is in totally wrong place.

Includes with paths relative are problematic

require_once '../../controller/conexao.php'

Use absolute paths, i.e., include the full path of the file, a simple way to do this, is to define this value in a constant and be called by a Bootstrap.

define('CONFIG', dirname(dirname(__FILE__)). 'Config'. DIRECTORY_SEPARATOR);

(PHP 5 => v5.3)

define('CONFIG', dirname(dirname(__DIR__)). 'Config'. DIRECTORY_SEPARATOR);

Then just include the file where you want it.

require_once CONFIG . 'conexao.php';

Answer 2

Put your include out of class, so:

<?php
error_reporting(-1); 
ini_set('display_errors', 'On');

$ds = DIRECTORY_SEPARATOR;

require_once __DIR__."{$ds}..{$ds}..{$ds}controller{$ds}conexao.php";

Class PrioridadeDao{

    private $conexao;

    public function __construct(){
        $this->conexao =  = new Conexao();
    }

    public function teste(){
        echo "Chega aqui sim";
    }


    public function selectAll(){
        echo "<br />CHEGA AQUI?";

        if(!$conexao->conecta()){
            exit;
        } else {
            $result = pg_query($conexao->conecta(), "SELECT * FROM prioridade");
            while ($consulta = @pg_fetch_array($result)){
                echo $consulta['nivel']." ".$consulta['nome'];
            }
            $conexaoObj->encerra($conexao->conecta());
        }
    }
}

The scope of a class must be to create properties (context variables) and methods (class functions). Class requests that will be used by the class in question must be inserted before the class declaration.

Answer 3

If you want to include conexao.php inside prioridade_dao.php would be this way:

require_once '../../controller/conexao.php';

*If unable to include will give error and will be exposed error.

The error in your code is that you are making the inclusion within the test function but it is not called so there is no inclusion (try to have a simpler architecture because it minimizes the chances of getting out of control). make the inclusion directly below the <?php the way I did above.