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...
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;
.........
........... ?>