Error class not found when I extends a class

Question

I've two files in one directory named (classes )which contain classes, first one for main class (Database ) which build to connect to the database. And the second one (Branch ) extends Database class which made to get data from the database.

When I try to run "getBranch" function I got an error says :

Uncaught Error: Class 'Database' not found in C:\xampp\htdocs\branches\classes\branch.php

Please find the codes below and advise what's required.

database.php:

<?php

  class Database {
    private $host;
    private $user;
    private $pwd;
    private $dbName;
    public $conn;

    public function connect() {
      $this->host = "localhost";
      $this->user = "root";
      $this->pwd = "";
      $this->dbName = "branchs";
      //create connection
      $conn = new mysqli($this->host, $this->user, $this->pwd, $this->dbName);
      //chech connection
      if ($conn->connect_error) {
        die("Connection failed :" . $conn->connect_error);
      } else {
        echo "Success";
      }

      return $conn;

    }

  }

?>

branch.php :

<?php

    class Branch extends Database {

      public function getBranch() {

      $sql = "SELECT * FROM branches";
      $result = $this->connect()->query($sql);

      if ($result->num_rows > 0) {
        while ($row = $result->fetch_assoc()) {
          echo "Name :" . $row['brName'] . "City :" . $row['brCity'] . "<br>";
        }
      } else {
        echo "0 results";
      }

      }

    }

?>

How do you _try to run "getBranch" function_??? Do you instantiate an object of `Branch` class? — AbraCadaver, Feb 17 '20 at 15:21
https://www.php.net/manual/en/function.spl-autoload-register.php — AbraCadaver, Feb 17 '20 at 15:23
Something to consider - https://stackoverflow.com/questions/7827713/should-a-php-user-class-extend-a-database-class — Nigel Ren, Feb 17 '20 at 15:24
You are also going to run out of connections fairly quickly using this code. — RiggsFolly, Feb 17 '20 at 15:24
maybe a stupid question, but are you including `database.php` in your `branch.php` file? — mitkosoft, Feb 17 '20 at 15:29
A simple search on the Internet would have most likely avoided the question. — Funk Forty Niner, Feb 17 '20 at 15:31

score 3 · Answer 1 · edited Feb 17 '20 at 15:33

3

You must include "database.php" file into top of "branch.php" file

<?php include 'database.php'; ?>

Also, take a look about autoload concept with php. https://www.php.net/manual/en/language.oop5.autoload.php

edited Feb 17 '20 at 15:33

Lounis

597
7
15

answered Feb 17 '20 at 15:22

damien guesdon

31
4

score 1 · Answer 2 · answered Feb 17 '20 at 15:24

You need to call database.php file in the branch.php (because Branch Class does not know that Database Class exists) by using require() or include() - depends. 2nd option is to use namespaces and 'use' statements for easier further development. https://www.php.net/manual/en/language.namespaces.php

score 0 · Answer 3 · answered Feb 17 '20 at 15:24

0

You should do require_once('database.php');to inherit the class entities from the parent class.

answered Feb 17 '20 at 15:24

Seungju

101
6

Error class not found when I extends a class

3 Answers3