Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Object error: function query on a non-object
- <?php
- class ManageDb{
- public $link;
- function __construct() {
- include_once 'class_database.php';
- $conn = new database;
- $this->link = $conn->connect();
- return $this->link;
- }
- function getData($table_name, $id=null){
- if(isset($id)){
- $query = $this->link->query("SELECT * FROM $table_name WHERE id = '$id' ORDER BY id ASC");
- }else{
- **$query = $this->link->query("SELECT * FROM $table_name ORDER BY id ASC");**
- }
- $rowCount = $query->rowCount();
- if ($rowCount >=1){
- $result = $query->fetchAll();
- }else{
- $result = 0;
- }
- return $result;
- }
- }
- ?>
- <?php
- include_once '../config.php';
- class database {
- protected $db_conn;
- public $db_name = DB_NAME;
- public $db_host = DB_HOST;
- public $db_pass = DB_PASS;
- public $db_user = DB_USER;
- function connect() {
- try {
- $this->db_conn = new PDO("mysql:host = $this->db_host;dbname=$this->db_name", $this->db_user, $this->db_pass);
- } catch (PDOException $e) {
- return $e->getMessage();
- }
- }
- }
- ?>
Add Comment
Please, Sign In to add comment