相对路径SQLite3与PDO的连接不起作用

Question

I have a Class function in PHP (GetMenuItems.php) that connects to the DB and gets the menu items. This function is called from the Menu.php and MenuAdmin.php files.

The problem is, it works fine on Menu.php and not in MenuAdmin.php.

Folder structure:

• localhost
  • FundosDB.db
  • index.php
  • Menu.php
  • Class
    • GetMenuItems.php
  • Admin
    • Admin.php
    • MenuAdmin.php

Connection: $db = new PDO('sqlite:FundosDB.db');

If I change the connection to: $db = new PDO('sqlite:..\FundosDB.db'); the opposite happens.

How can I make it work for both situations? And, the relative path shouldn't be between the class file where the connection is made and the DB file instead of between the file that calls the function in the class and the DB file? I am confused.

Answer 1

Set a path to your db file using absolute path with $_SERVER['DOCUMENT_ROOT'], something like:

define('DB_PATH', $_SERVER['DOCUMENT_ROOT'] . '/FundosDB.db');

Then use it everywhere:

$db = new PDO('sqlite:' . DB_PATH);