Include another file in PHP class

Question

I'm sure this has been asked a few times, but I can't seem to find a straight forward or well explained answer. I'm attempting to create a Account Object/Class within PHP, where I can retrieve data from an account. The issue I'm having is that I cannot include my database.php class so I can retrieve all the created accounts.

I'm fairly new with PHP and don't have an expansive knowledge on how a lot of the processes or conventions work. The error/warning I'm running into is this;

Warning: include(../database.php): failed to open stream: No such file or directory in ~/account.php on line 3

Here is my account.php class

<?php

include '../database.php';

class Account {

    protected $username, $email;

    protected function getEmail() {
        return $this->email;
    }

    protected function getUsername() {
        return $this->username;
    }

    public function __construct($username, $email) {
        $this->username = $username;
        $this->email = $email;
    }

    public static function getUser($username) {
        $statement = getConnection()->prepare('SELECT * FROM account WHERE username=?');
        $statement->bindValue(1, $username);

        if ($rows = $statement->fetch()) {
             $account = new Account($rows['username'], $rows['email']);
        }

         return $account;
    }

}

Here is my database.php incase I've done something wrong or may need to change things

<?php

function getConnection() {
    $dbh = new PDO("mysql:host=127.0.0.1;dbname=mcsl;port3306", "root", "");
    $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $dbh->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
    $dbh->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
    return $dbh;
}

Directory Structure:

According to your error, your path for your database.php file is incorrect. — Amous
– Amous, Commented May 30, 2016 at 15:10
@NanaPartykar I thought the same, but I'm using the same include function in another php file in the same directory, and it's working fine. — Jordan
– Jordan, Commented May 30, 2016 at 15:11
Can you please post your directory structure for account.php, database.php page. — Nana Partykar
– Nana Partykar, Commented May 30, 2016 at 15:12

nonybrighto · Accepted Answer · 2016-05-30 15:26:16Z

3

You can use include (dirname(__FILE__)."/../database.php") to access the database.php file in the account.php file

answered May 30, 2016 at 15:26

nonybrighto

9,6336 gold badges49 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Vic Seedoubleyew Over a year ago

There is a troubleshooting checklist for this problem : stackoverflow.com/questions/36577020/…

Álvaro González · Accepted Answer · 2016-05-30 15:16:12Z

0

You currently have a mix of object-oriented and procedural code.

Adding database features to a class is normally accomplished by dependency injection. In other words, you pass the database object as argument to whatever method needs it and use type hinting to enforce it, e.g.:

public static function getUser(MyConnectionClassOrInterface $db, $username) {
}

As about your include, you're using relative paths, which are relative to main script, not current file. You can build absolute paths or use a more elaborate class auto-loader.

answered May 30, 2016 at 15:16

Álvaro González

147k45 gold badges282 silver badges378 bronze badges

1 Comment

Vic Seedoubleyew Over a year ago

There is a troubleshooting checklist for the include problem : stackoverflow.com/questions/36577020/…

Collectives™ on Stack Overflow

Include another file in PHP class

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related