如何从扩展类错误“未定义变量：conn in ...”中使用数据库连接

Question

Trying to use one database class file for all db connection, by extend that class how to...

mydb.php

<?php 

class mydb{
    public static $conn;
    public  function __construct(){
        $this->conn=new mysqli("localhost","root","","akshaya");
       if(!$this->conn){
           echo "mysql connection error";
       }else{
           return $this->conn;
       }
    }
}

?>

cms.class.php

 <?php 
require_once __DIR__.'\..\mydb.php';
class paginator_vishnukumar extends mydb{ 
    private $_limit,$_page,$_query,$_total;
    public function __construct( $query ) {
        parent::__construct();
    $this->_query = $query;
    $rs= $this->$conn->query( $this->_query );
    $this->_total = $rs->num_rows;  }
    public function getData(  $page = 1,$limit = 10 ) {
    $this->_limit   = $limit;
    $this->_page    = $page;

.........
........... ?>

dashboard.php

<?php 
require 'engine/vishnuHTML.class.php';
require 'engine/admin/cms.class.php';
$html=new vishnuHTML();
$html->head();
$html->navigation();
    $limit      = ( isset( $_GET['limit'] ) ) ? $_GET['limit'] : 25;
    $page       = ( isset( $_GET['page'] ) ) ? $_GET['page'] : 1;
    $links      = ( isset( $_GET['links'] ) ) ? $_GET['links'] : 7;
    $query      = "SELECT * FROM posts";
    $Paginator  = new paginator_vishnukumar( $query );
    $results    = $Paginator->getData( $page, $limit );
?>
<div class="row">
<div class="columns"></div>
</div>

<?php
$html->footer();
?>

when running dashboard.php throws errors:

" Notice: Undefined variable: conn in C:\program data2\xampp\htdocs\engine\admin\cms.class.php on line 8

Fatal error: Cannot access empty property in C:\program data2\xampp\htdocs\engine\admin\cms.class.php on line 8 " 

please tell me the ways how to use mydb class in another php files and class...

Answer 1

You must access with self::$conn its static

with $this-> you access only "none" static variables

Update to:

mydb.php

<?php 

class mydb{
    public static $conn;
    public  function __construct(){
        self::$conn=new mysqli("localhost","root","","akshaya");
       if(!self::$conn){
           echo "mysql connection error";
       }else{
           return self::$conn;
       }
    }
}

?>

cms.class.php

 <?php 
require_once __DIR__.'\..\mydb.php';
class paginator_vishnukumar extends mydb{ 
    private $_limit,$_page,$_query,$_total;
    public function __construct( $query ) {
        parent::__construct();
    $this->_query = $query;
    $rs= self::$conn->query( $this->_query );
    $this->_total = $rs->num_rows;  }
    public function getData(  $page = 1,$limit = 10 ) {
    $this->_limit   = $limit;
    $this->_page    = $page;

.........
........... ?>